31 Jul
|
Cortex Consultants
|
Bengaluru
31 Jul
Cortex Consultants
Bengaluru
Reporting Engineer
Job Description
Minimum 5 years of developing and deploying data-oriented 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 3-4 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 large-scale 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 T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User
Defined Functions, Relational Database models, and ensuring Data integrity and SQL.
o Robust problem-solving 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
SQLADFSSIST-sql
Mandatory Skills
ADF, SSIS, SQL, Ci/cd
📌 Azure Cloud Engineer-ADF, SSIS, SQL, Ci/cd-6+ Years (Bengaluru)
🏢 Cortex Consultants
📍 Bengaluru