Software Engineer (MS SQL, TSQL & ADF)

Gartner for HR

2 - 4 years

4 - 8 Lacs

gurugram

Posted:1 day ago| Platform:

Apply

Skills Required

data dictionary ms sql query optimization coding database design stored procedures troubleshooting analysis services sql recruitment

Work Mode

Work from Office

Job Type

Full Time

Job Description

What you will do:

Collaborate with business stakeholders, design, build advanced analytic solutions for Gartner Conference Technology Business.
Execution of our data strategy through design and development of Data platforms to deliver Reporting, BI and Advanced Analytics solutions.
Design and development of key analytics capabilities using MS SQL Server , Azure SQL Managed Instance , T-SQL ADF on Azure Platform.
Consistently improving and optimizing T-SQL performance across the entire analytics platform.
Create, build, and implement comprehensive data integration solutions utilizing Azure Data Factory.
Analysing and solving complex business problems, breaking down the work into actionable tasks.
Develop, maintain, and document data dictionary and data flow diagrams
Responsible for building and enhancing the regression test suite to monitor nightly ETL jobs and identify data issues.
Work alongside project managers, cross teams to support fast paced Agile/Scrum environment.
Build Optimized solutions and designs to handle Big Data.
Follow coding standards, build appropriate unit tests, integration tests, deployment scripts and review project artifacts created by peers.
Contribute to overall growth by suggesting improvements to the existing software architecture or introducing new technologies.

What you will need :

Strong IT professional with high-end knowledge on Designing and Development of E2E BI Analytics projects in a global enterprise environment. The candidate should have strong qualitative and quantitative problem-solving abilities and is expected to yield ownership and accountability.

Must have:

Strong experience with SQL, including diagnosing and resolving load failures, constructing hierarchical queries, and efficiently analysing existing SQL code to identify and resolve issues, using Microsoft Azure SQL Database, SQL Server, and Azure SQL Managed Instance.
Ability to create and modifying various database objects such as stored procedures, views, tables, triggers, indexes using Microsoft Azure SQL Database, SQL Server, Azure SQL Managed Instance.
Deep understanding in writing Advance SQL code (Analytic functions).
Strong technical experience with Database performance and tuning, troubleshooting and query optimization.
Strong technical experience with Azure Data Factory on Azure Platform.
Create and manage complex ETL pipelines to extract, transform, and load data from various sources using Azure Data Factory.
Monitor and troubleshoot data pipeline issues to ensure data integrity and availability.
Enhance data workflows to improve performance, scalability, and cost-effectiveness.
Establish best practices for data governance and security within data pipelines.
Experience in Cloud Platforms, Azure technologies like Azure Analysis Services, Azure Blob Storage, Azure Data Lake, Azure Delta Lake etc
Experience with data modelling, database design, and data warehousing concepts and Data Lake.
Ensure thorough documentation of data processes, configurations, and operational procedures.

Who you are:

Graduate/Post-graduate in BE/Btech, ME/MTech or MCA is preferred
IT Professional with 2-4 yrs of experience in Data analytics, Cloud technologies and ETL development
Excellent communication and prioritization skills
Able to work independently or within a team proactively in a fast-paced AGILE-SCRUM environment
Strong desire to improve upon their skills in software development, frameworks, and technologies

More Jobs at Gartner for HR

Business Development Executive, MSE, GTS

Gurgaon, Haryana, India

Experience: Not specified

Salary: Not disclosed

Marketing Specialist - Global Technology Sales

Gurgaon, Haryana, India

5 - 8 yrs

Salary: Not disclosed

Account Executive, MSE, GTS

Gurgaon, Haryana, India

Experience: Not specified

Salary: Not disclosed

Assistant Manager, Travel & Expense

Gurgaon, Haryana, India

Experience: Not specified

Salary: Not disclosed

Manager, Team Manager - BR COE (Technology research)

Gurgaon, Haryana, India

2 - 3 yrs

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.