Description

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

This role is on-site.

Responsibilities

• Design and implement metadata, ETL, and reporting components within IDMC.
• Develop complex Informatica mappings, sessions, and workflows.
• Produce technical deliverables including design documentation, configuration docs, and unit test plans.
• Perform root cause analysis and tune BI application performance bottlenecks.

Required Skills

• 6-7 years of experience with Power BI, IDMC, and BigQuery.
• Expertise in Informatica IDMC for managing complex mappings and workflows.
• Advanced SQL and PL/SQL skills, including indexing and query tuning.
• Experience with Oracle RDBMS 19c.
• Strong knowledge of Data Warehousing concepts (Star/Snowflake schemas, Data Marts, SCDs).
• Proficiency in data and root cause analysis.
• Working knowledge of Unix, Linux, and Windows operating systems.
• Experience following the Software Development Lifecycle (SDLC).

Preferred Skills

• Working knowledge of Informatica PowerExchange or PowerCenter.
• Experience with Tableau or other visualization tools.
• Experience with relational, multidimensional, and OLAP techniques.

Key Skills

Education

Any Graduate