Description

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

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