Data Integration Engineer

Moder Solutions; United States; Remote; USD 95,000 - 140,000; Full time

Job summary

Moder Solutions in the United States is seeking a Data Integration Engineer with strong hands-on expertise in Microsoft SQL Server, SSIS, and data pipelines to design, build, and maintain robust ETL workflows.

You will optimize ingestion, transformation, cleaning, validation, and quality checks across multiple data sources, troubleshoot issues, and collaborate with business and technical teams. Immediate joiners only.

Qualifications

• Strong hands-on experience with Microsoft SQL Server, SSIS, SQL, data pipelines and data cleaning.
• 7–12 years of experience in data integration, ETL development, or data engineering.
• Immediate joiners only.

Responsibilities

• Design, develop, and maintain data integration solutions using MS SQL Server and SSIS.
• Develop, optimize, and troubleshoot complex SQL queries, stored procedures, functions, and views.
• Build and maintain data pipelines for data ingestion, transformation, and loading.
• Perform data cleaning, validation, deduplication, and quality checks to ensure data accuracy.

Skills

SQL

ETL development

Data integration

Data cleansing

Data validation

Troubleshooting

Problem-solving

Data ingestion

Stored procedures

Query optimization

Tools

MS SQL Server

SSIS

Job description

Note: Candidates must have strong hands-on experience in MS SQL Server, SSIS, SQL, data pipelines, data ingestion, and data cleaning. Only immediate joiners will be considered.

Job Description Data Integration Engineer

Role: Data Integration Engineer
Experience: 712 Years
Work Mode: Remote
Notice Period: Immediate Joiners Only

Job Overview

We are looking for an experienced Data Integration Engineer with strong hands-on expertise in Microsoft SQL Server, SSIS, SQL, and data pipeline development. The ideal candidate will be responsible for building, maintaining, and optimizing data integration workflows, ensuring efficient data ingestion, transformation, cleaning, and processing across multiple data sources.

Key Responsibilities

• Design, develop, and maintain data integration solutions using MS SQL Server and SSIS.
• Develop, optimize, and troubleshoot complex SQL queries, stored procedures, functions, and views.
• Build and maintain reliable data pipelines for data ingestion, transformation, and loading.
• Perform data cleaning, validation, deduplication, and quality checks to ensure data accuracy and consistency.
• Develop and manage ETL workflows using SQL Server Integration Services (SSIS).
• Integrate data from multiple sources, including databases, flat files, and other structured data sources.
• Monitor data pipeline performance, troubleshoot failures, and implement corrective actions.
• Optimize SQL queries, ETL packages, and database operations for performance and scalability.
• Collaborate with business and technical teams to understand data requirements and deliver reliable integration solutions.
• Maintain technical documentation for data pipelines, ETL processes, and integration workflows.

Mandatory Skills

• Strong hands-on experience with Microsoft SQL Server.
• Expertise in SQL, complex queries, stored procedures, and query optimization.
• Experience in SSIS (SQL Server Integration Services) and ETL development.
• Strong understanding of data pipelines and ETL/ELT processes.
• Experience in data ingestion, data transformation, and data cleaning.
• Knowledge of data validation, data quality, and error handling.
• Strong troubleshooting and problem-solving skills.

Required Experience

• 7–12 years of overall experience in data integration, ETL development, or data engineering.
• Hands-on experience developing and supporting SQL Server-based data integration solutions.
• Experience managing end-to-end data ingestion and processing workflows.
• Immediate joiners only.