Mid-Level Remote ETL & Data Integration Engineer

D&G Solutions; Belleville (IL); Hybrid; USD 90,000 - 140,000; Full time

Benefits offered by this job

Competitive salary

Comprehensive benefits

401(k)

Bonus and profit sharing

Flexible hours

Education reimbursement

Generous paid time off

Job summary

D&G Solutions is seeking a Mid-Level ETL / Data Integration Developer to support IGC modernization, data integration, and cloud-migration efforts. You will build Informatica-based ETL workflows, complex SQL, and enterprise interfaces across global transportation and logistics operations.

The role involves delivering hands-on ETL solutions within an Agile team, ensuring data quality and secure cloud deployment. A Secret clearance and DoD familiarity are preferred.

Qualifications

• Four+ years of professional experience in ETL development, data integration, or related field.
• Hands-on experience with Informatica PowerCenter or similar enterprise data-integration platform.
• Strong SQL skills, including complex joins, views, procedures, functions, indexing, and optimization.
• Experience with source-to-target mappings and data transformation rules.
• Experience with relational databases such as Oracle, PostgreSQL, MySQL, SQL Server, or AWS-based services.
• Experience with Git and GitLab CI/CD processes.
• Experience developing or consuming RESTful APIs or enterprise interfaces.
• Working knowledge of Agile, automated testing, CI/CD, and secure software delivery.
• Bachelor's degree or relevant certification; DoD qualification eligibility.

Responsibilities

• Design, develop, test, deploy, and maintain Informatica mappings, workflows, and data-integration processes.
• Translate requirements into technical mappings, data structures, and workflow designs.
• Extract, transform, validate, and load data from databases, files, and APIs while preserving data quality.
• Develop and optimize SQL, views, stored procedures, and scripts for ETL workloads.
• Create and maintain data dictionaries, mappings, and documentation.
• Profile, cleanse, reconcile, and troubleshoot ETL processes and production data issues.
• Support cloud modernization and CI/CD deployment activities.

Skills

ETL Development

Data Integration

SQL

Informatica PowerCenter

GitLab CI/CD

REST APIs

Education

Bachelor's degree or relevant certification

Tools

Informatica IICS

Oracle PL/SQL

AWS

Job description

D&G Solutions is seeking a Mid-Level ETL / Data Integration Developer to support IGC modernization, data integration, and cloud-migration efforts. You will build Informatica-based ETL workflows, complex SQL, and enterprise interfaces across global transportation and logistics operations.

The role involves delivering hands-on ETL solutions within an Agile team, ensuring data quality and secure cloud deployment. A Secret clearance and DoD familiarity are preferred.