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.
Similar Jobs
.png){kind=logo}
Artificial Intelligence • Edtech • Mobile • Natural Language Processing • Productivity • Software
Lead and scale Quillbot's data infrastructure, manage engineers, drive architectural decisions, and collaborate with cross-functional teams to enhance usability and performance.
Top Skills:
AWSAzureEltETLGCPJavaScriptNode.jsReactSpark
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
The Associate Manager develops global medical content under supervision, collaborates with teams to ensure quality and compliance, and tracks project progress.
Top Skills:
Generative Ai Technology PlatformsMedical Content ToolsMultimedia
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
The QMS Manager will oversee quality management system development, execution, and maintenance for process improvement toward zero defects while also mentoring the team and liaising with customers and internal departments.
Top Skills:
Aiag 5 Core ToolsControl PlansFmeaPpapQms StandardsSpc
What you need to know about the Delhi Tech Scene
Delhi, India's capital city, is a place where tradition and progress co-exist. While Old Delhi is known for its rich history and bustling markets, New Delhi is defined by its modern architecture. It's clear the region places a strong emphasis on preserving its cultural heritage while embracing technological advancements, particularly in artificial intelligence, which plays a central role in shaping the city's tech landscape, fueled by investments in research and development.
