Description

You will design, develop, and maintain complex ETL programs for an Enterprise Data Warehouse. You will translate business processes into functional BI reporting and analysis solutions.

Responsibilities

• Design and implement ETL, metadata, and reporting components including testing and deployment.
• Develop and manage complex Informatica mappings, sessions, and workflows.
• 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.
• Expertise in Advanced SQL and PL/SQL.
• Strong experience with Oracle RDBMS 19c and BigQuery.
• Experience with IDMC.
• Deep understanding of Data Warehousing and Business Intelligence methodologies.
• Experience with Star and Snowflake schema design, including Fact and Dimensional modeling.
• Knowledge of Slowly Changing Dimensions (SCD) and Data Marts.
• Proficiency in query tuning, indexing, and relational database management.

Preferred Skills

• Experience with physical and logical data modeling.

Key Skills

Education

Any graduate