Description

Design, develop, and maintain complex ETL programs for the Enterprise Data Warehouse, owning the full lifecycle from design to deployment.

Responsibilities

• Build and optimize Informatica mappings, sessions, and workflows within IDMC.
• Translate business processes into actionable BI reporting and analysis solutions.
• Identify and tune performance bottlenecks in BI applications using advanced SQL and PL/SQL.
• Produce technical deliverables including design documentation, configuration docs, and unit test plans.

Required Skills

• 7+ years of experience with Power BI, IDMC, and BigQuery.
• 7 years of experience with relational, multidimensional, and OLAP techniques.
• 6 years of experience with Oracle RDBMS 19c.
• 7 years of experience with OBIEE tools version 12.X.
• Expertise in Advanced SQL, PL/SQL, indexing, and query tuning.
• Strong technical knowledge of Informatica PowerExchange, PowerCenter, and IDMC.
• Bachelor's degree in Computer Science or a related field.

Preferred Skills

• Experience with Tableau and MS Power BI for advanced data visualization.

Key Skills

Education

Bachelor's degree