Develop ETL Mappings, Sessions, Workflows to extract data from various data sources (flat files, transactional databases) to enterprise data warehouse.
Performance tuning & optimizations of ETL Sources, Targets, Mappings, Transformations and Sessions for better Performance
Extensively used Transformations like Router, Aggregator, Joiner, Filter, Source Qualifier, Expression, Sequence Generator, Update Strategy and Lookup.
Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
Requirements
Develop ETL Mappings, Sessions, Workflows to extract data from various data sources (flat files, transactional databases) to enterprise data warehouse.
Performance tuning & optimizations of ETL Sources, Targets, Mappings, Transformations and Sessions for better Performance
Extensively used Transformations like Router, Aggregator, Joiner, Filter, Source Qualifier, Expression, Sequence Generator, Update Strategy and Lookup.
Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
Strong hands-on experience (min 5+ years) on SQL & PL-SQL
Should have 5+ years of SQL development experience using tools like Toad, Oracle SQL Developer, or Microsoft SQL Developer