Senior Data Engineer

Role: Senior Data Engineer

Experience: 8 to 12 Years

Work Mode: Remote

Shift timing: - 12:30 pm to 9:30 pm IST

• Primary Skills: Advanced SQL Server, ETL development using SSIS, Azure Data Factory, and Databricks, Power BI, Data warehousing, Data quality and validation, General Microsoft technology stack

Job Summary:

We are seeking a highly skilled and experienced Senior Data Engineer to join our growing data team. The ideal candidate will have strong expertise in SQL Server, ETL development, and cloud-based data integration tools like Azure Data Factory and Databricks. This role requires a proactive mindset and a willingness to work with legacy SSIS solutions while actively contributing to modern data platform strategies.

Key Responsibilities:

• Design, develop, and maintain robust ETL workflows using SSIS, Azure Data Factory, and Databricks.
• Write complex, optimized SQL Server queries for data transformation, analysis, and reporting.
• Perform data modeling, integration, and warehousing in support of enterprise analytics initiatives.
• Support and enhance existing SSIS packages; troubleshoot and resolve issues related to older ETL pipelines.
• Develop and publish dashboards and reports using Power BI.
• Implement data quality checks and validation routines to ensure the accuracy and consistency of data.
• Collaborate with cross-functional teams including BI developers, analysts, and business stakeholders.
• Contribute to the architecture, design, and implementation of scalable and secure data pipelines.
• Document technical designs, solutions, and processes as per organizational standards.

Required Skills:

• 8–12 years of hands-on experience with Microsoft SQL Server and writing complex T-SQL queries.
• Strong ETL development experience using SSIS and Azure Data Factory.
• Experience with Azure Databricks for big data processing and integration.
• Willingness and capability to work with and improve legacy SSIS-based solutions.
• Strong understanding of Data Warehousing concepts, star/snowflake schema, and dimensional modeling.
• Proficiency in Power BI for data visualization and reporting.
• Strong background in data quality, cleansing, validation, and auditing.
• Experience with the Microsoft technology stack (Azure, SQL Server, SSRS, SSAS, etc.).

Preferred Qualifications:

• Azure Data Engineer certification (e.g., DP-203) is a plus.
• Experience working in Agile/Scrum environments.
• Exposure to DevOps for DataOps pipelines (CI/CD for data).

About IGT Solutions:

IGT Solutions is a next-gen customer experience (CX) company, defining and delivering transformative experiences for the global and most innovative brands using digital technologies. With the combination of Digital and Human Intelligence, IGT becomes the preferred partner for managing end-to-end CX journeys across Travel and High Growth Tech industries. We have a global delivery footprint, spread across 30 delivery centers in China, Colombia, Egypt, India, Indonesia, Malaysia, Philippines, Romania, South Africa, Spain, UAE, the US, and Vietnam, with 25000+ CX and Technology experts from 35+ nationalities.

IGT's Digital team collaborates closely with our customer’s business & technology teams to take solutions faster to market while sustaining quality while focusing on business value and improving overall end-Customer Experience. Our offerings include industry solutions as well as Digital services. We work with leading global enterprise customers to improve synergies between business & technology by enabling rapid business value realization leveraging Digital Technologies. These include lifecycle transformation & rapid development / technology solution delivery services delivered leveraging traditional as well as Digital Technologies, deep functional understanding and software engineering expertise.

IGT is ISO 27001:2013, CMMI SVC Level 5 and ISAE-3402 compliant for IT, and COPC® Certified v6.0, ISO 27001:2013 and PCI DSS 3.2 certified for BPO processes. The organization follows Six Sigma rigor for process improvements.

It is our policy to provide equal employment opportunities to all individuals based on job-related qualifications and ability to perform a job, without regard to age, gender, gender identity, sexual orientation, race, color, religion, creed, national origin, disability, genetic information, veteran status, citizenship or marital status, and to maintain a non-discriminatory environment free from intimidation, harassment or bias based upon these grounds.