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 implement ETL, metadata, and reporting components, including testing and deployment.
• Develop complex Informatica mappings, sessions, and workflows using IDMC.
• Perform root cause analysis and identify BI application performance bottlenecks.
• Produce technical deliverables including design documentation, configuration docs, and unit test plans.
• Translate business processes into BI reporting and analysis solutions.

Required Skills

• 6 to 7 years of experience with Power BI, IDMC, and BigQuery.
• Expertise in Informatica IDMC for mapping and workflow management.
• Advanced SQL and PL/SQL skills, including indexing and query tuning.
• Experience with Oracle RDBMS 19c.
• Strong knowledge of Data Warehousing, Star/Snowflake schema design, and Dimensional Modeling.
• Proficiency with MS Power BI, BigQuery, and Tableau.
• Working knowledge of Unix, Linux, and Windows operating systems.
• Bachelor's degree in Computer Science or a related field.

Preferred Skills

• Working knowledge of Informatica PowerExchange or PowerCenter.
• Experience with multidimensional and OLAP technologies.

Key Skills

Education

Any Graduate