Experience in Analysis, Design, Development of various business
applications in different platforms using Informatica PowerCenter
10x/9x/8.x/7.x/6.2, Oracle 9i/10g/11g
Experience in Application Design, Data Extracti…
Experience in Analysis, Design, Development of various business
applications in different platforms using Informatica PowerCenter
10x/9x/8.x/7.x/6.2, Oracle 9i/10g/11g
Experience in Application Design, Data Extraction, Development, Implementations and Testing of Data warehousing and Database business systems.
Good Knowledge of Informatica Intelligent Cloud Services (IICS)
Good knowledge of MS Azure.
•Good knowledge of Dimensional data modelling.
Good understanding of Project Life Cycle and gathering requirements for ETL Development.
Experience in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle.
Good analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
Experience in interacting with Business users in analysing the Business requirements.
Good knowledge on Talend Data Studio, Azure Data Lake Gen2 , Data Factory and Power BI
• Requirement gatherings for Products LAN/SMF/TRM/FLEET/CLAIMS
• Design mappings to produce Premium, Instalments, Exception,
Overflow flat files for LAN and Load data into Tables on SQL server.
• Design mappings to Load SQL Server tables for SMF for premium, exceptions, Claims.
• Documentation of Source to Target Mappings and Live services manuals
• Support Live/UAT Environments.
• Data Ingestion LAN/SMF/TRM/FLEET/CLAIMS flat files into Azure Data Lake using IICS data flows..
Requirement gatherings for Products LAN/SMF/TRM/FLEET/CLAIMS
Design mappings to produce Premium, Instalments, Exception, Overflow flat files for LAN and load data into tables on SQL server
Design mappings to load SQL Server tables for SMF for premium, exceptions, Claims
Documentation of Source to Target Mappings and Live services manuals
Support Live/UAT Environments
Data Ingestion LAN/SMF/TRM/FLEET/CLAIMS flat files into Azure Data Lake using IICS data flows
Requirement gatherings for Phase 1 and 2
ETL design/Framework to cater Target System
Low level and Source to Target Mapping documentations
Informatica code to extract data from Data Warehouse, generate XML files and feed to MQ for Target system to consume
Requirement gathering
Data Extraction using PowerCenter to load Data Lake staging and load control tables
Extraction of MFA adhoc reporting (csv files)
Design ETL load strategy and error handling scenarios
Created data flows using IICS to load Master data from Azure to on premises Oracle database
Created IICS Source connections, Data replication task and Data flows
Generate scripts to make web service calls to trigger Informatica Power Centre workflows
Data Extraction from MFA into DWH Staging using PowerCenter
Power BI reports for Planner
Data Extraction using PowerCenter for Underwriters and claims from Eclipse and SCS
Built Dimensions (Type2) in MSL for Writing Companies, Policy Status, producing offices, Placing Types sourcing from Flat Files, MS SQL server source systems
Data Extraction Budget data using PowerCenter to load Budget Dimensions and Facts
Developed Mappings for Duo compression, to load Trade Facts and Compression Summary, to extract trade data
Developed Reports using ETL to generate opportunity reports for Trades and Compression
Support Integration, system and UAT test environments
Built type 2 dimensions for PAM Tranching rule, PAM Term Groups
Built 2 new reference data tables to extract data from csv and pipe delimited files for PAM Funding prates, Provisional FX rates
Enhancements to current PowerCenter code to cater changes to existing reporting structure
Data Extraction using COBOL data files
Mapping changes to include extract new information from ALM data warehouse (oracle) and update related dimension and fact tables
Built PowerCenter code to cater new reporting requirements on Liquidity reporting
Enhancements to current ILAS source extracts
12AY changes include sourcing coding out year from PAYE system, extending the current warehouse schema to cater new information
Data Extraction from Tax Credit System, high level and low-level design
Built stored procedures to identify Active Account table and back up existing table copy
Extend ER model, update high-level, low-level design documents, developed new Informatica code to stage and store the data in final warehouse tables
Data Extraction using COBOL copy book for COBOL source files
Created mappings for yearly CPM Projections (monthly, 40 years), Control Model results Tacker Extract and Generic Manuals update strategy
Mappings for Release 3 Moses Enhancements
CIT for Self-Assessment monthly changes
Decommission of Child Trust Fund
To Identify data sources, Low level design, build ETL mappings, test and support
To Identify data sources, Low level design, build ETL mappings, test and support SIT and UAT
Developed ETL mapping for Work Package 19.1, 19.2(ADS), 26 (NPS)
Developed SCD type 1 and Type 2 Dimension tables
Migrate data using PowerCenter for esipp clients
Migrate FSA, Reuters, Emx funds, Income Drawdown, Annuities, Pension share, Transfer out, Death, Protection, Assets, Funds, party attributes on to NEWSTAR
Build ETL code to populate Data Marts for Home Insurance, WEBSAVER and ISA Products
Build ETL code for RISK data mart
Developed ETL mappings for Activities and Mas Rate change
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
