Data Engineer - SQL- SSIS-ETL- databricks

Role: Data Engineer

Designation: Consultant / Senior Consultant
Experience: 5+ Years
Location: Gurugram (Hybrid)

Job Overview

We are looking for a skilled Data Engineer with strong expertise in SQL and SSIS to build, optimize, and manage scalable data pipelines. The role involves working closely with analytics and reporting teams to ensure high-quality, reliable data for business insights.

Key Responsibilities

• Build and optimize scalable ETL/ELT pipelines using SQL and SSIS
• Manage data ingestion, tansformation, and integration workflows
• Perform data modelling, transformations, and performance tuning using SQL (SSMS)
• Support analytics and reporting teams by providing clean and structured data
• Maintain technical documentation and ensure best practices in data engineering

Mandatory Skills

• Strong SQL skills (SSMS) for data modelling and performance optimization
• Hands-on experience with SSIS for ETL/ELT workflows
• Experience working with Visual Studio for SSIS development

Good to Have

• Experience with Power BI for data visualization and reporting
• Exposure to Azure Data Factory for cloud-based data pipelines
• Knowledge of PowerShell for automation

Preferred Profile

• 5+ years of experience in data engineering or related roles
• Strong problem-solving and analytical skills
• Ability to work in a collaborative, fast-paced environment