Description

You will design, build, and maintain data warehousing solutions using Informatica PowerCenter and Power Exchange. You own the full lifecycle of ETL processes, from requirements to deployment.

Responsibilities

• Develop and optimize complex ETL mappings and workflows in Informatica PowerCenter.
• Integrate data from Oracle and Teradata sources into warehouse environments.
• Manage job scheduling and monitoring using CA7 for mainframe environments.
• Write and execute unit tests to ensure data accuracy and process reliability.
• Document technical designs, workflows, and data lineage for team reference.

Required Skills

• 8-10 years of hands-on experience with Informatica PowerCenter and Power Exchange.
• Expert-level knowledge of data warehousing concepts and ETL best practices.
• Strong proficiency in SQL and database interactions with Oracle or Teradata.
• Experience with mainframe scheduling tools, specifically CA7.
• Ability to write clear technical documentation and communicate effectively.
• Self-motivated with strong problem-solving and analytical skills.

Preferred Skills

• Familiarity with Hadoop Hive and big data ecosystems.
• Experience with self-service BI tools or secondary data platforms.

Key Skills

Education

Any Gradute