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..
<p>Requirement gatherings for Products LAN/SMF/TRM/FLEET/CLAIMS<br>
Design mappings to produce Premium, Instalments, Exception, Overflow flat files for LAN and load data into tables on SQL server<br>
Design mappings to load SQL Server tables for SMF for premium, exceptions, Claims<br>
Documentation of Source to Target Mappings and Live services manuals<br>
Support Live/UAT Environments<br>
Data Ingestion LAN/SMF/TRM/FLEET/CLAIMS flat files into Azure Data Lake using IICS data flows</p>
<p>Requirement gatherings for Phase 1 and 2<br>
ETL design/Framework to cater Target System<br>
Low level and Source to Target Mapping documentations<br>
Informatica code to extract data from Data Warehouse, generate XML files and feed to MQ for Target system to consume</p>
<p>Requirement gathering<br>
Data Extraction using PowerCenter to load Data Lake staging and load control tables<br>
Extraction of MFA adhoc reporting (csv files)<br>
Design ETL load strategy and error handling scenarios<br>
Created data flows using IICS to load Master data from Azure to on premises Oracle database<br>
Created IICS Source connections, Data replication task and Data flows<br>
Generate scripts to make web service calls to trigger Informatica Power Centre workflows<br>
Data Extraction from MFA into DWH Staging using PowerCenter<br>
Power BI reports for Planner</p>
<p>Data Extraction using PowerCenter for Underwriters and claims from Eclipse and SCS<br>
Built Dimensions (Type2) in MSL for Writing Companies, Policy Status, producing offices, Placing Types sourcing from Flat Files, MS SQL server source systems<br>
Data Extraction Budget data using PowerCenter to load Budget Dimensions and Facts</p>
<p>Developed Mappings for Duo compression, to load Trade Facts and Compression Summary, to extract trade data<br>
Developed Reports using ETL to generate opportunity reports for Trades and Compression<br>
Support Integration, system and UAT test environments</p>
<p>Built type 2 dimensions for PAM Tranching rule, PAM Term Groups<br>
Built 2 new reference data tables to extract data from csv and pipe delimited files for PAM Funding prates, Provisional FX rates<br>
Enhancements to current PowerCenter code to cater changes to existing reporting structure<br>
Data Extraction using COBOL data files<br>
Mapping changes to include extract new information from ALM data warehouse (oracle) and update related dimension and fact tables<br>
Built PowerCenter code to cater new reporting requirements on Liquidity reporting<br>
Enhancements to current ILAS source extracts</p>
<p>12AY changes include sourcing coding out year from PAYE system, extending the current warehouse schema to cater new information<br>
Data Extraction from Tax Credit System, high level and low-level design<br>
Built stored procedures to identify Active Account table and back up existing table copy<br>
Extend ER model, update high-level, low-level design documents, developed new Informatica code to stage and store the data in final warehouse tables<br>
Data Extraction using COBOL copy book for COBOL source files</p>
<p>Created mappings for yearly CPM Projections (monthly, 40 years), Control Model results Tacker Extract and Generic Manuals update strategy<br>
Mappings for Release 3 Moses Enhancements</p>
<p>CIT for Self-Assessment monthly changes<br>
Decommission of Child Trust Fund</p>
<p>To Identify data sources, Low level design, build ETL mappings, test and support</p>
<p>To Identify data sources, Low level design, build ETL mappings, test and support SIT and UAT</p>
<p>Developed ETL mapping for Work Package 19.1, 19.2(ADS), 26 (NPS)<br>
Developed SCD type 1 and Type 2 Dimension tables</p>
<p>Migrate data using PowerCenter for esipp clients<br>
Migrate FSA, Reuters, Emx funds, Income Drawdown, Annuities, Pension share, Transfer out, Death, Protection, Assets, Funds, party attributes on to NEWSTAR</p>
<p>Build ETL code to populate Data Marts for Home Insurance, WEBSAVER and ISA Products</p>
<p>Build ETL code for RISK data mart</p>
<p>Developed ETL mappings for Activities and Mas Rate change</p>
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
