SSIS Engineer to join our offshore team. The ideal candidate will have strong expertise in developing and maintaining ETL solutions using SQL Server Integration Services (SSIS), along with solid knowledge of SQL Server and DevOps practices. This role also requires hands-on experience in implementing secure authentication and authorization using Microsoft Entra ID (Azure AD).

Key Responsibilities

Design, develop, and maintain ETL workflows using SSIS. Optimize data integration processes for performance and scalability. Work extensively with SQL Server for data storage, transformation, and querying. Create and maintain Azure DevOps (ADO) pipelines or GitHub Actions for CI/CD automation. Implement secure authentication and authorization using Microsoft Entra ID (Azure AD). Collaborate with cross-functional teams to deliver robust data solutions. Troubleshoot and resolve issues related to ETL processes and deployments.

Must-Have Skills

SSIS (SQL Server Integration Services): Advanced experience in ETL development. SQL Server: Strong skills in queries, stored procedures, and performance tuning. DevOps: Ability to create and maintain ADO pipelines or GitHub Actions. Authentication & Authorization: Hands-on experience with Microsoft Entra ID (Azure AD).

Nice-to-Have Skills

Snowflake: Familiarity with data warehousing and integration. Azure Data Factory (ADF): Experience in building data pipelines.