Description

Design, develop, and maintain complex ETL programs for the Enterprise Data Warehouse.

Responsibilities

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

Required Skills

• 6 to 7 years of experience with Power BI, IDMC, and BigQuery.
• Expertise in Advanced SQL, PL/SQL, indexing, and query tuning.
• Strong technical knowledge of IDMC (Informatica) mapping and workflow management.
• Experience with Oracle RDBMS 19c.
• Proficiency in Business Intelligence and Data Warehousing methodologies.
• Working knowledge of SDLC processes and project management methodologies.
• Competency with Unix, Linux, or Windows operating systems and Version Control.
• Bachelor's degree in Computer Science or a related field.

Preferred Skills

• Experience with Informatica PowerExchange or PowerCenter.
• Knowledge of Tableau and OLAP techniques.
• Exposure to Star/Snowflake schema design and dimensional data modeling.

Key Skills

Education

Bachelor's degree