Description
This project is part of Insurance. This provides end-to-end analysis from Policies, Claims, Premium, Loss Ratio and Growth Rate at higher level and in details the project main objective is to create a central database for data and provide a set of standard reports basic Operational Reporting-Strategic Development. The Operational Reporting Strategic Development, from which it is extracting the data through Flat files and Oracle, Transforming and Loading into Oracle target database in a Data warehouse using Informatica, Building Data marts from Data warehouse tables for Generating Reports.
Roles and Responsibilities
Gather and analyze business requirements, supporting all SDLC phases. Design, develop, and optimize IICS and PowerCenter ETL workflows for seamless data integration. Develop mappings using transformations like Expression, Joiner, Lookup, Aggregator, and Router. Migrate PowerCenter code to IICS and deploy across environments. Implement SCD Type 1 & Type 2 for historical data tracking. Perform performance tuning, troubleshooting, and error handling for ETL processes. Manage workflows, scheduling, and system monitoring to ensure data accuracy and efficiency
Technologies: Informatica PowerCenter, IICS (CDI),Azure SQL DW, Oracle, IBM Netezza, Unix shell scripting.
Industry: Data Integration