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 Chennai, Tamil Nadu, IND Office
MCN Nagar Ext, MCN Nagar Extension, Thoraipakkam, Chennai, Tamil Nadu, India, 600097
Similar Jobs
Cloud • Information Technology • Productivity • Software • Automation
As a Technical Architect, lead the development of enterprise solution architectures, design integration solutions, and ensure best practices for Boomi products.
Top Skills:
Ai AutomationArchimateAWSAzureBoomi AtomsphereCobitDockerGCPGroovyJavaJavaScriptJSONKubernetesLlmsNoSQLRagRestSafeSoapSQLTogafXMLZachman
Cloud • Information Technology • Productivity • Software • Automation
The Technical Architect leads the development of enterprise solution architecture, evaluating integration requirements, providing infrastructure recommendations, and promoting best practices for Boomi products.
Top Skills:
ArchimateAtomsphere Integration PlatformAWSAzureCobitDockerGCPGroovyJavaJavaScriptJmsKubernetesMdh Master Data ManagementNoSQLSafeSQLTogafZachman
Cloud • Information Technology • Productivity • Software • Automation
The Reporting and Analytics Advisor is responsible for managing reporting, dashboards, and data visualization for internal clients, utilizing Power BI and SQL to create impactful analytics and streamline data processes.
Top Skills:
DaxPower BISnowflake Data CloudSQL
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
