Description

Job Description

  • 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

Education

Any Graduate