Description

You will build and manage ETL processes to move data from flat files and transactional databases into an enterprise data warehouse.

This role is on-site.

Responsibilities

• Develop ETL mappings, sessions, and workflows to extract data from diverse sources.
• Tune and optimize ETL sources, targets, mappings, transformations, and sessions for performance.
• Design complex workflows using decision, assignment, event wait, and event raise tasks.
• Schedule and manage jobs using the Informatica scheduler.

Required Skills

• 5+ years of hands-on experience with SQL and PL/SQL.
• Extensive experience with Informatica transformations: Router, Aggregator, Joiner, Filter, Source Qualifier, Expression, Sequence Generator, Update Strategy, and Lookup.
• Proficiency in SQL development using Toad, Oracle SQL Developer, or Microsoft SQL Developer.
• Strong background in performance tuning.
• Experience working with Oracle databases.
• Any Graduate degree.

Key Skills

Education

Any Graduate