Reporting Engineer
Job Description
Minimum 5 years of developing and deploying dataoriented solutions in Azure Cloud.
o 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.
o Minimum 3 years of creating data transformations using Azure Data Factory.
o Requires 34 years of experience with SQL scripting (merge joins and stored procedures) and best
practices.
o Requires 2 years of experience in CI/CD pipelines and creating an automated continuous integration (CI)
and continuous delivery (CD
Roles & Responsibilities
o Experience with migrating SSIS packages to Azure Data Factory (ADF).
o Expertise in working on all activities related to the development implementation administration and
support of ETL processes for largescale Data Warehouses using SSIS with MS SQL 2016/2014/2012.
o Experienced in creating complex SSIS packages with complicated transformations using SQL Server
Integration Services.
o Experience in designing and implementing data ingestion to Azure Storage services including Azure Data
Factory Azure Data Lake Storage and SQL Database.
o Proficient in the use of TSQL for developing complex Stored Procedures Triggers Tables Views User
Defined Functions Relational Database models and ensuring Data integrity and SQL.
o Strong problemsolving skills with the ability to performance tune and optimize queries.
o Proficient knowledge in change management code review documentation and testing.
Skills to be evaluated on
SQLADFSSISTsql
Mandatory Skills
ADF SSIS SQL Ci/cd
sql,ssis,cd,ci,sql server,azure,adf,ci/cd,t-sql