Senior Informatica Developer
Edgematics Technologies LLC
Total years of experience :17 years, 2 Months
As a Senior BI Consultant at KPI Partners Inc., I worked on several data warehouse and BI projects with various clients like EMC, MASCO Cabinetry etc.
As a BI Consultant at KPI Partners Inc., I worked on several data warehouse and BI projects with various clients like EMC, MASCO Cabinetry etc.
ROLE: ETL Developer and Project Coordinator.
Designing and Developing ETL process using Informatica Powercenter for Master Data Management (MDM) Module of Supply Chain Data Hub.
Coordinating with MDM Application Developers for data mapping requirements and changes.
Creating data merge scripts to merge the data in to ODS.
1. Developing ETL mappings using Informatica as of business requirements.
2. Coordinating to business user while gathering requirements and production support.
3. Generating MIS reports on various banking channels through Cognos 8 Report Studio.
As a consultant I am working different development and maintanance / support projects for Emirates Bank Group.
1. ETL jobs service level monitoring
2. ETL production support
As a member of production support my activities including creating informatica mappings to extract log data about file movements from source databases and loading in source log and maintaining load schedule of file movements in database as per required changes from client. Also look at Oracle procedures that process extracted log data to update status on console website