Description

Design, develop, and maintain complex ETL programs for an Enterprise Data Warehouse.

Responsibilities

• Design and develop complex Informatica mappings, sessions, and workflows within IDMC.
• Transform source data into warehouse-ready formats using advanced SQL and PL/SQL.
• Translate business processes into actionable BI reporting and analysis solutions.
• Identify and tune performance bottlenecks within BI applications.
• Produce technical deliverables including design documentation, configuration guides, and unit test plans.

Required Skills

• 7+ years of experience with Power BI, IDMC, and BigQuery.
• Expertise in IDMC (Informatica) for managing complex mappings and workflows.
• Advanced SQL and PL/SQL skills, including indexing and query tuning.
• Hands-on experience with Oracle RDBMS 19c.
• Strong understanding of ETL, data warehousing, and Business Intelligence methodologies.
• Knowledge of data modeling using Star/Snowflake schemas, Fact, and Dimensional tables.
• Experience with Slowly Changing Dimensions and Data Marts.
• Working knowledge of Unix/Linux/Windows operating systems and version control.
• Degree in Computer Science or a related field.

Preferred Skills

• Experience with Informatica PowerExchange or PowerCenter.
• Knowledge of relational, multidimensional, and OLAP techniques.
• Experience with Tableau.

Key Skills

Education

Any Graduate