Reporting Engineer

Job Description

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

Roles & 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.
  
  

Skills to be evaluated on

SQLADFSSIST-sql

Mandatory Skills

ADF, SSIS, SQL, Ci/cd

Skills: sql,ssis,cd,ci,sql server,azure,adf,ci/cd,t-sql