Description

You will develop and maintain data pipelines using SSIS.

Responsibilities

• Lead developers responsible for ETL development, data pipelines, and data warehouse loads.
• Design, develop, and optimize complex SQL queries, stored procedures, functions, and views.
• Build and maintain workflows for data ingestion, cleansing, transformation, and transfer using SSIS and SQL.
• Analyze problems and communicate with stakeholders to assess needs and determine optimal solutions.
• Work with team members to identify and resolve technical issues in a timely fashion.

Required Skills

• 5+ years of experience in ETL development.
• Expert proficiency in SQL, including writing and troubleshooting T-SQL statements, stored procedures, and views.
• Demonstrated experience with Microsoft SQL Server 2019 and above, including database management.
• Proven experience building and deploying ETL packages using Microsoft SSIS.
• Deep understanding of data warehousing concepts, including normalized, de-normalized, star, and snowflake models.
• Strong experience with data structures and formats like JSON and XML, including SSIS Scripting.
• Experience implementing and utilizing Azure DevOps and CI/CD pipelines for deployments.
• Strong SQL coding experience with performance optimization for data queries.

Key Skills

Education

Any Graduate