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.
Job Summary: We are looking for a skilled Data Warehousing Developer to design, develop, and optimize data warehouse solutions supporting business analytics and reporting needs. The ideal candidate will have a strong background in MS SQL, and data modeling, with experience in building efficient ETL processes and ensuring data integrity across systems. Key Responsibilities • Design, develop, and maintain data warehouse schemas, tables, views, and materialized views. • Write complex MS SQL scripts for data extraction, transformation, and loading (ETL). • Optimize database performance through query tuning, indexing, and partitioning. • Develop and maintain stored procedures, functions, triggers, and packages. • Collaborate with data architects, business analysts, and BI teams to translate business requirements into technical solutions. • Ensure data accuracy, consistency, and security across the warehouse environment. • Support production systems by monitoring jobs, troubleshooting failures, and resolving issues promptly. • Participate in code reviews and contribute to improving data development standards and best practices. • Document ETL workflows, data mappings, and database structures. Required Skills & Qualifications • Bachelor’s degree in Computer Science, Information Technology, or a related field. • 8+ years of hands-on experience in MS SQL Server development. • Solid understanding of data warehouse concepts, star/snowflake schema, and dimensional modeling. • Experience with Python is a plus. • Strong analytical and troubleshooting skills. • Experience in performance tuning and query optimization. • Good communication skills and ability to work collaboratively in a team environment. Preferred Skills (Nice to Have) • Good understanding of Capital Markets domain is a plus.
Hexaware Technologies Navi Mumbai, Maharashtra, IND Office
#1, Sector III, Millennium Business Park,, 'A' Block , TTC Industrial Estate, Mahape, Navi Mumbai, Maharashtra , India, 400710
Similar Jobs
Information Technology • Consulting
Lead design, development, and implementation of OFSAA solutions. Develop and optimize complex SQL and SSIS ETL processes. Manage Control-M job scheduling, write PowerShell and Unix shell scripts, troubleshoot related issues, translate business requirements, mentor developers, and ensure project timelines and deliverables.
Top Skills:
Control-METLOracle OfsaaPowershellShell ScriptingSQLSsisUnix/Linux
.png)
Healthtech • Social Impact • Telehealth
As a Care Coordinator, you will guide older adults and their caregivers through the intake process, providing support and emotional guidance during their journey into care.
Top Skills:
CrmsEhr PlatformsGoogle Workspace
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Lead end-to-end financial management for the Sricity CAPEX program: CAPEX planning, procurement controls, cash and payables, fixed asset lifecycle (CWIP, capitalization, depreciation), contract financial review, and audit readiness. Partner with site, engineering, procurement, cash COE, legal and regional finance to ensure disciplined spend, vendor controls, and capitalization aligned to project milestones.
Top Skills:
DashboardingExcelSAP
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.
