Description

You will build and maintain data integration solutions for analytical platforms.

This role is on-site.

Responsibilities

• Develop batch ETL/ELT processes using SQL Server and SSIS to meet pipeline performance standards.
• Design and build complete data pipelines, transforming data for ODS, Staging, Data Warehousing, and Data Marts.
• Implement Data Warehouse solutions using Star Schema or Snowflake Schema for reporting applications.
• Write and optimize complex SQL queries and stored procedures for data processing and analysis.
• Implement audit, balance, and control mechanisms within data solutions.

Required Skills

• 3+ years developing batch ETL/ELT processes using SQL Server and SSIS.
• 3+ years writing and optimizing SQL queries and stored procedures for data processing.
• 3+ years designing and building data pipelines using SQL Server Integration Services or related technologies.
• 3+ years implementing Data Warehouse solutions using SQL Server and SSIS.
• 3+ years experience with large-scale data processing and query optimization using T-SQL.
• Strong understanding of DW concepts, including 3NF and Dimensional data models.
• 2+ years experience implementing audit, balance, and control mechanisms in data solutions.

Key Skills

Education

Any Graduate