Description

You will design, develop, and maintain complex ETL programs for an Enterprise Data Warehouse, translating business processes into BI reporting solutions.

Responsibilities

• Design and develop complex Informatica mappings, sessions, and workflows.
• Transform source data for loading into the data warehouse using advanced SQL and PL/SQL.
• Identify and tune BI application performance bottlenecks and optimize queries.
• Produce technical deliverables including design documentation, configuration docs, and unit test plans.

Required Skills

• 7+ years of experience with ETL, BI tools, and data warehousing methodologies.
• Expertise in MS Power BI and BigQuery.
• Strong technical knowledge of IDMC (Informatica) for mapping and workflow management.
• Advanced SQL and PL/SQL skills, including indexing and query tuning.
• Experience with Oracle RDBMS 19c.
• Proficiency with Snowflake and Tableau.
• Working knowledge of SDLC processes and project management methodologies.
• Experience with relational, multidimensional, and OLAP techniques.
• Bachelor's degree in Computer Science or a related field.

Preferred Skills

• Working knowledge of Informatica PowerExchange or PowerCenter.

Key Skills

Education

Bachelor's degree