Description

You will design and implement ETL processes to support enterprise data warehousing requirements.

Responsibilities

• Create ETL mappings, maplets, workflows, and worklets using Informatica PowerCenter 10.x.
• Design integrations for standard data warehousing objects including star schemas, aggregations, and type-2 dimensions.
• Develop stored procedures, database triggers, and optimized SQL queries.
• Collaborate with DBAs and Data Architects to implement data partitioning strategies.
• Perform source system analysis and manage versioning for the ETL repository and code.

Required Skills

• 5+ years of experience with Informatica PowerCenter 10.x.
• Strong proficiency in Oracle SQL.
• Experience with XML, XML Parser, and HTTP transformations.
• Hands-on experience with Java transformations within Informatica.
• Knowledge of ETL design patterns and data warehousing principles.
• Ability to load data from SF Power Exchange to relational databases.
• Experience using Informatica Data Quality (Analyst and Developer).
• Any Graduate degree.

Key Skills

Education

Any Graduate