Description

You will design, develop, and maintain complex ETL programs for an Enterprise Data Warehouse.

Responsibilities

• Design and implement ETL mappings, sessions, and workflows using IDMC.
• Transform complex source data into structured formats for data warehouse loading.
• Translate business processes into BI reporting and analytical solutions.
• Perform root cause analysis and tune BI application performance to resolve bottlenecks.
• Produce technical deliverables including design documentation, unit test plans, and configuration guides.

Required Skills

• 7+ years of experience with Power BI, IDMC, and BigQuery.
• Expertise in Advanced SQL and PL/SQL, including indexing and query tuning.
• Strong technical knowledge of Informatica IDMC for complex mapping development.
• Hands-on experience with Oracle RDBMS 19c.
• Proficiency in the Software Development Lifecycle (SDLC) and project management methodologies.
• Experience with data modeling using Star/Snowflake schemas, Fact/Dimensional tables, and Slowly Changing Dimensions.
• Working knowledge of Unix, Linux, or Windows operating systems and Version Control.
• Bachelor's Degree in Computer Science or a related field.

Preferred Skills

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

Key Skills

Education

Bachelor's Degree