Senior Technical Architect
Weikfield IT-Citi Infopark, 6t, Maharashtra, IN, Digital An
OBJECTIVE OF ROLE
We are seeking a highly skilled and experienced Senior Technical Architect 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
EXPERIENCE
- 15+ 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.).
QUALIFICATION
• Bachelor's or higher degree
ABILITIES
• Ability to quickly comprehend the functions and capabilities of new technologies • Understanding of system security, including encryption standards, SEIM and network segregation • Willingness to be ‘hands-on’ when needed. • Ability to accurately estimate software development tasks given a set of requirements and assumptions; ability to work with Project Managers to develop task-level project plans and proposals • Ability to develop secure solutions and knowledge of industry best practices regarding information security and defensive development • Understanding of deployment architecture and infrastructure in both on-prem and cloud hosting environments • Excellent oral and written communication with an ability to articulate complex systems to external teams (sales, product, external vendors) • Self-motivation and the ability to work under minimal supervision • Strong understanding of cross-browser compatibility and limitation issues
ABOUT US
IGT Solutions (IGT) is committed to simplifying complex customer interactions while delivering a seamless experience. It provides integrated BPM, Technology and Digital Services & Solutions for clients across industries. 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 Hi-tech industries.
Established in 1998, with 100% focus on customer experience, IGT employs more than 20,000+ customer experience and technology specialists providing services to 75+ marquee customers globally. IGT’s global footprint consists of 23 delivery centers in China, Philippines, Malaysia, India, UAE, Romania, Indonesia, Spain, Colombia and the USA
EQUAL OPPORTUNITY DISCLAIMER
ADDRESS & LOCATION