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 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
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Field-based pharmaceutical sales role responsible for achieving territory sales targets through targeted doctor, chemist, hospital and KOL engagement. Plan and execute calls, promotions, CME and awareness programs; perform sales analytics and forecasting; manage inventory and orders; report daily activities; ensure compliance, adverse event reporting and proper use of promotional materials. Coordinate with district management and mentor trainees.
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Operate, maintain, troubleshoot, and improve all ELV systems (CCTV, access control, fire alarms, BMS, SCADA, VESDA, PLC, cabling, network). Develop preventive/predictive maintenance, perform RCA, support commissioning/FAT-SAT, manage vendors, coordinate with Facilities/IT/Security, and ensure uptime and regulatory compliance in critical semiconductor/data center/manufacturing facilities.
Top Skills:
Access ControlAgent BotsBmsBuilding Management SystemCctvCopilotCopilot LibraryData Network InfrastructureFiber OpticsFire Alarm SystemsFmcsGen Ai ToolsPlcPublic Address SystemsScadaSecurity Management SystemsStructured CablingVesdaVisitor Management Systems
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Lead plant automation strategy and deployment to improve efficiency. Install, support, and troubleshoot AMHS, ASRS, robots, cobots, AGV/AMR and manufacturing automation. Collaborate cross-functionally, ensure safety and compliance, mentor the automation team, and implement AI-driven automation sustainability and reporting systems to minimize downtime and costs.
Top Skills:
AgvAmhsAmrArtificial IntelligenceAsrsCobotsRobots
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.
