Informatica Developer – Pune Location
Location: Pune
Position: Contractual (3 Month contract may extend depend on project deadline )
Experience : 4- 6 Years
Salary : Best in Industry

Job Description :
Good hold on Informatica ETL development
Implemented Type 1 and Type 2 methodologies in ODS tables loading to keep historical data in data warehouse
Created Worklets, Workflow and Tasks to schedule the loads at required frequency using Workflow Manager
Analyse the Business Requirements and Prepare Detailed Design documents both High Level Document (HLD) and Low-Level Document (LLD).
Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Centre Designer.
Worked on migrating data from on premise databases to Confidential Redshift, RDS and S3.


Source link