Azure Cloud Engineer

Role Overview: As a Reporting Engineer, your main responsibility will be to develop and deploy data-oriented solutions in Azure Cloud. You will be working on various activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL 2016/2014/2012. Your expertise in migrating SSIS packages to Azure Data Factory (ADF) will be crucial for this role. Key Responsibilities: - Experience with migrating SSIS packages to Azure Data Factory (ADF). - Expertise in working on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL 2016/2014/2012. - Experienced in creating complex SSIS packages with complicated transformations using SQL Server Integration Services. - Experience in designing and implementing data ingestion to Azure Storage services, including Azure Data Factory, Azure Data Lake Storage, and SQL Database. - Proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models, and ensuring Data integrity and SQL. - Strong problem-solving skills, with the ability to performance tune and optimize queries. - Proficient knowledge in change management, code review, documentation, and testing. Qualifications Required: - Minimum 5 years of developing and deploying data-oriented solutions in Azure Cloud. - 5+ years of strong MS SQL Server Developer experience with expertise in MS SQL Server 2016/2014/2012/2008 suite of products like SSRS, SSAS, and SSIS. - Minimum 3 years of creating data transformations using Azure Data Factory. - Requires 3-4 years of experience with SQL scripting (merge, joins, and stored procedures) and best practices. - Requires 2 years of experience in CI/CD pipelines and creating an automated continuous integration (CI) and continuous delivery (CD). Company Additional Details: The skills to be evaluated for this position are SQL, ADF, SSIS, and T-SQL. Mandatory skills include ADF, SSIS, SQL, and CI/CD.,