Description

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

This role is on-site.

Responsibilities

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

Required Skills

• 7+ years of experience with Oracle RDBMS 19c.
• 6-7 years of experience with Power BI, IDMC, and BigQuery.
• Expertise in Advanced SQL and PL/SQL, including indexing and query tuning.
• Strong knowledge of IDMC (Informatica) for managing complex mappings and workflows.
• Deep understanding of Data Warehousing, Business Intelligence, and SDLC 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.
• Experience with Star/Snowflake schema design and dimensional data modeling.

Key Skills

Education

Bachelor's Degree