Designs and maintains data warehouse schemas and database objects, develops complex SQL-based ETL workflows, and optimizes database performance. The role supports production systems, troubleshoots failures, ensures data quality and security, documents workflows, and collaborates with architects, analysts, and BI teams. It also participates in code reviews and improves data development standards.
Years of Exp – 5 - 9 years JD with primary and secondary skills – Datawarehouse Developer with strong ETL and MS SQL skills 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 • 5-9 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
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Lead and grow engineering teams building large-scale AI/ML platform infrastructure (model serving, training, feature stores). Drive technical strategy, deliver complex backend systems to production, partner with product and stakeholders, uphold high engineering and operational standards, and coach engineers for career growth.
Top Skills:
Backend PlatformsDistributed SystemsFeature StoresGpu-Accelerated Model ServingLlmsTraining And Data Access Infrastructure
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Develop and maintain secure, high-performance Android applications used by sales and partner teams. Responsibilities include Kotlin development, Android architecture, testing, performance optimization, backend API integration, troubleshooting, code reviews, mentoring, and technical planning. The role requires collaboration with business and engineering stakeholders and familiarity with Jetpack technologies, Salesforce integrations, and AI-enabled workflow improvements.
Top Skills:
Ai TechnologiesAndroid SdkAndroid StudioClean ArchitectureCoupaEspressoFlowGoogle Play StoreGradleHiltJetpack ComposeJIRAKotlinKotlin CoroutinesLightning Web ComponentsLivedataMaterial DesignMulesoftMviMvvmNavigationRestful ApisRoomSalesforceSalesforce Experience CloudViewmodel
Cloud • Information Technology • Security • Software
Define and drive next-generation platform architecture, embed AI capabilities into identity and device management systems, guide executive technical strategy, design globally scalable cloud systems, mentor engineering teams, evaluate competitors, and adapt architecture to emerging AI, security, and privacy requirements.
Top Skills:
AIAWSAzureCloud-Native ArchitectureData PipelinesDistributed SystemsDockerGCPGoKubernetesPythonRust
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.
