DWH / Reporting developer
– Working in Informatica PowerCentar (PowerCenter Designer, Workflow Manager, Workflow Monitor, Repository Manager)
– Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
– Involved in extracting the data from the Flat Files and Relational databases into staging area. – Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
– SQL (writing procedures, functions, views)
– Query optimization
– Creating reports (BI) in Cognos Repot Studio (IBM Reporting Tool)
– Data Warehousing
– Mentoring role for ETL, conducting training and monitoring progress for employees.