Description

You will design and develop ETL processes within a data warehousing environment. You own the full lifecycle of data ingestion, from source analysis to transformation.

Responsibilities

• Design and implement data ingestion pipelines, including source analysis, mapping, cleansing, and transformation.
• Apply dimensional modeling concepts such as Star Schema, Snowflake Schema, Dimensions, Facts, and Surrogate Keys.
• Perform performance tuning, health checks, and root cause analysis for reported issues.
• Troubleshoot data pipeline issues and perform deep-dive problem solving to ensure data integrity.

Required Skills

• 5+ years of experience in ETL development and design.
• Expertise in T-SQL for MSSQL, PL/SQL, or Oracle environments.
• Strong understanding of Snowflake Schema and dimensional modeling.
• Proven ability in data cleansing and transformation workflows.
• Experience with performance tuning and system health monitoring.
• Analytical skills for requirement analysis and troubleshooting.
• Any Graduate degree.

Preferred Skills

• Experience with MSBI technical stack.
• Spark with Scala stack or Databricks.
• Domain knowledge in Subscription Management.

Key Skills

Education

Any Graduate