The Data Integration Lead will engineer ETL processes, develop databases using T-SQL, optimize query performance, and ensure data quality while collaborating with stakeholders.
Job Summary: We are seeking a senior Microsoft BI (SSIS) & SQL Server Database Developer responsible for building robust database structures and high-performance ETL processes. Responsibilities: • ETL Engineering (SSIS): Design and maintain end-to-end data integration packages using Control Flow and Data Flow tasks. Package deployment, configurations and automated scheduling using Autosys. • Database Development: Create and optimize critical database objects, including stored procedures, Functions, Triggers and Views using T-SQL. • Data Modeling: Architect relational schemas (OLTP) and dimensional models (OLAP) including Star and Snowflake schemas for data warehousing. • Troubleshoot and Optimize: Using tools like SQL Profiler , review execution plans to identify bottlenecks and optimize query performance through indexing and partitioning. • Ensure Data Quality and Integrity: Implement data validation, cleansing, transformation and reconciliation processes to ensure data accuracy and consistency throughout the data lifecycle. • Collaborate with Stakeholders: Work closely with IT teams and business stakeholders to gather data requirements and translate them to technical solutions. • Adhere to Best Practices: Participate in code reviews, establish coding standards, and implement CI/CD pipelines for automated testing and deployment. • Expert-level knowledge of SSIS. • Strong hands-on coding proficiency in Visual C# to extend SSIS beyond it’s built-in capabilities. • Experience with Code versioning tools (Bitbucket, Github) • Experience with CI/CD and setting up pipelines. • Solid understanding of database design principles, data modelling, schemas and data warehousing solutions. • Excellent problem-solving and analytical skills to troubleshoot complex data issues independently.
Similar Jobs
Information Technology • Consulting
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.
Top Skills:
Ms SqlPython
Artificial Intelligence • Productivity • Software • Automation
The Senior Engineering Manager will lead two engineering teams focused on integrations, drive AI-powered productivity, and enhance team performance while managing local engineering culture in India.
Top Skills:
Ai ToolsCoding AssistantsLlms
Cloud • Information Technology • Productivity • Software • Automation
The Cloud Security Engineer will secure Boomi's multi-cloud environment by designing and implementing security controls, managing CSPM tools, and ensuring compliance with regulations.
Top Skills:
AWSAzureCspmGCPTerraformWaf
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.
