The Data Integration Lead will engineer ETL processes, develop databases using T-SQL, optimize query performance, and ensure data quality while collaborating with stakeholders.
Job Summary: We are seeking a senior Microsoft BI (SSIS) & SQL Server Database Developer responsible for building robust database structures and high-performance ETL processes. Responsibilities: • ETL Engineering (SSIS): Design and maintain end-to-end data integration packages using Control Flow and Data Flow tasks. Package deployment, configurations and automated scheduling using Autosys. • Database Development: Create and optimize critical database objects, including stored procedures, Functions, Triggers and Views using T-SQL. • Data Modeling: Architect relational schemas (OLTP) and dimensional models (OLAP) including Star and Snowflake schemas for data warehousing. • Troubleshoot and Optimize: Using tools like SQL Profiler , review execution plans to identify bottlenecks and optimize query performance through indexing and partitioning. • Ensure Data Quality and Integrity: Implement data validation, cleansing, transformation and reconciliation processes to ensure data accuracy and consistency throughout the data lifecycle. • Collaborate with Stakeholders: Work closely with IT teams and business stakeholders to gather data requirements and translate them to technical solutions. • Adhere to Best Practices: Participate in code reviews, establish coding standards, and implement CI/CD pipelines for automated testing and deployment. • Expert-level knowledge of SSIS. • Strong hands-on coding proficiency in Visual C# to extend SSIS beyond it’s built-in capabilities. • Experience with Code versioning tools (Bitbucket, Github) • Experience with CI/CD and setting up pipelines. • Solid understanding of database design principles, data modelling, schemas and data warehousing solutions. • Excellent problem-solving and analytical skills to troubleshoot complex data issues independently.
Hexaware Technologies Pune, Mahārāshtra, IND Office
North Block, Plot No. 19, Rajiv Gandhi InfoTech Park, MIDC - SEZ, Phase 3, Hinjawadi, Pune, Maharastra, India, 411057
Similar Jobs
Information Technology • Consulting
The Data Integration Lead will design, develop, and optimize data warehouse solutions, focusing on ETL processes, data integrity, and performance tuning in collaboration with BI teams.
Top Skills:
Ms SqlPython
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Design, implement, test, and deliver scalable application features. Collaborate with product owners on requirements, build reusable clean code, integrate AI into workflows, enhance existing products, and mentor colleagues while enforcing engineering best practices.
Top Skills:
AIAngularJavaJavaScriptReactUnit TestingVueWeb
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Lead customer deployments of Moveworks ServiceNow AI Agents: design, build, integrate, tune, and launch LLM-based solutions; partner with customers, product, and engineering to drive adoption and feed product improvements.
Top Skills:
Aws LambdaAzure FunctionsCommand LineContext EngineeringData ModelingGoJavaScriptJIRALinuxLlmsOktaPrompt EngineeringPythonRest ApisServicenowServicenow Flow DesignerWindowsWorkatoWorkdayZendesk
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
