SSIS and Azure Data Engineer

Weekday (YC W21); Maharashtra; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Weekday (YC W21) is looking for a Data Engineer with at least 7 years of experience in Enterprise Data Warehousing and Business Intelligence projects. Responsibilities will include designing data pipelines and managing large databases using Microsoft and cloud technologies.

The role demands strong SQL Server and Azure expertise, along with the ability to troubleshoot complex data challenges. Excellent communication skills and a collaborative approach are essential.

Qualifications

• Minimum 7 years of experience as a Data Engineer in DWH and BI projects.
• Proficiency in scripting languages such as Python or C#.
• Experience with cloud (Azure) and on-premises environments.

Responsibilities

• Design, develop, and deploy data pipelines for data movement.
• Build and maintain large-scale databases and data warehouses.
• Collaborate with BI management to address data-related challenges.

Skills

Data Engineering

ETL Development

SQL Server

Microsoft Azure

Data Warehousing

Business Intelligence

Python

Agile Methodologies

Tools

SSIS

Azure Data Factory

Azure Databricks

MS SQL Server

MySQL

Oracle

Synapse

Snowflake

Job description

This role is for one of our clients.

Industry: IT Services and IT Consulting

Seniority level: Mid‑Senior level

Minimum Experience: 5+ years

Location: Bengaluru, Pune, Hyderabad

Job Type: Full‑time

Primary Duties and Responsibilities

• Over 5 years of experience in SQL Server ETL development utilizing SSIS, Azure Data Factory, and Azure Databricks, with strong expertise in ETL, data warehousing, and T‑SQL
• Comprehensive understanding of data warehouse and data mart architectures, including the Kimball methodology
• More than 5 years of practical experience in building large‑scale databases
• Designing, developing, and deploying efficient and reliable data pipelines for data movement and transformation
• Wide‑ranging knowledge and hands‑on experience in data modeling, data management, ETL, and business intelligence (BI)
• Expertise in building enterprise data warehouses incorporating table partitioning, encryption, and data compression techniques
• Experience with cloud migration initiatives
• Conduct ongoing monitoring, automation, and optimization of reports and BI solutions
• Collaborate with BI management to identify and resolve data‑related challenges
• Partner with business units to define and document requirements for new metrics and reports
• Participate in process evaluations and improvements
• Provide analysis and resolve issues reported by business stakeholders
• Engage in the design and delivery of cubes, dashboards, and a variety of self‑service BI solutions

Other Responsibilities

• Ensure adherence to established documentation standards and best practices
• Maintain strong business functional knowledge alongside up‑to‑date expertise in automated technologies and tools
• Comply with all policies and procedures related to confidential information, including internal and restricted data

Qualifications

Required Qualifications

• Minimum 7 years of experience as a Data Engineer on Enterprise Data Warehousing (DWH) and Business Intelligence (BI) projects, both on‑premises and cloud (Azure), with at least 3 years of hands‑on experience using Microsoft technologies such as SQL Server, Synapse, SSIS, Data Factory, and Databricks
• Proficiency in scripting languages such as Python, C#, or their equivalents
• Advanced experience with MS SQL Server, MySQL, or Oracle databases
• Familiarity with Big Data technologies including NoSQL databases, Hive, HBase, Pig, or Spark
• Practical experience in ETL development using SSIS and Data Factory
• In‑depth knowledge of Master Data Management, ETL, data quality, metadata management, data profiling, micro‑batching, and streaming data ingestion
• Experience working with one or more scalable (MPP) relational databases such as Synapse or Snowflake for advanced analytics workloads
• Knowledge of application and system availability, scalability, and distributed data platforms
• Strong background in data warehousing technologies and ETL/ELT implementations
• Familiarity with the full Software Development Life Cycle (SDLC)
• Experience working within Lean or Agile development methodologies
• Proven ability to provide technical leadership and mentor other engineers on best practices within data engineering

Desired Qualifications

• Experience in defining new architectural frameworks and leading independent projects from an architectural perspective
• Familiarity with data modeling and ETL tools such as Erwin and Talend
• Ability to support users by troubleshooting and tuning queries, including partitioning and bucketing recommendations
• Experience designing and implementing ETL/ELT frameworks for complex warehouses and marts, with knowledge of large data sets, performance tuning, and troubleshooting
• A hands‑on development approach with a willingness to address and resolve complex technical issues
• Exposure to Continuous Integration / Continuous Deployment (CI/CD) processes
• Excellent verbal and written communication skills