Mid-Level ETL / Data Integration Developer - Informatica

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

Remote / Hybrid | Integrated Data Environment & Global Transportation Network Convergence (IGC) | Secret Clearance Required

If you are passionate about data integration, ETL development, and mission-critical technology and want to help modernize transportation and logistics systems supporting the Department of Defense, we would love to talk.

Why This Role Exists

The work we do has real impact, and the people behind it matter just as much.

D&G Support Services is seeking a Mid-Level ETL / Data Integration Developer to support IGC software modernization, data integration, and cloud-migration activities. In this role, you will develop and sustain Informatica-based ETL workflows, complex SQL, source-to-target mappings, data-quality controls, and enterprise interfaces supporting global transportation and logistics operations.

This position offers the opportunity to deliver hands-on ETL and data-integration solutions within an Agile team while supporting secure cloud modernization and release activities.

What You Will Do

• Design, develop, test, deploy, and maintain Informatica mappings, transformations, workflows, sessions, parameter files, reusable components, and data-integration processes.
• Translate source-to-target requirements and approved business rules into technical mappings, transformation logic, workflow designs, and data structures supporting enterprise data integration.
• Extract, transform, validate, and load data from relational databases, files, APIs, web services, and other approved enterprise interfaces while maintaining data quality, completeness, accuracy, and integrity.
• Develop and optimize complex SQL, views, stored procedures, functions, indexes, and database scripts supporting ETL and data-processing workloads.
• Create and maintain source-to-target mappings, data dictionaries, interface documentation, workflow diagrams, and operational procedures.
• Perform data profiling, validation, cleansing, reconciliation, and root-cause analysis; troubleshoot ETL workflows, database queries, interfaces, batch jobs, rejected records, and production data-processing issues.
• Support ETL performance tuning and modernization of legacy data-integration workloads for approved cloud and database platforms, including Amazon Aurora where implemented.
• Use Git and established GitLab CI/CD processes to version, validate, test, package, and deploy ETL and database changes while supporting Agile ceremonies, testing, release activities, and production support.

Required

What We Are Looking For

• Four or more years of professional experience in ETL development, data integration, database development, software development, or a related technical field.
• Hands-on experience with Informatica PowerCenter or another Informatica enterprise data-integration platform, including mappings, transformations, workflows, sessions, parameter files, and reusable components.
• Strong SQL skills, including complex joins, subqueries, views, stored procedures, functions, indexing, query optimization, and troubleshooting.
• Experience developing source-to-target mappings and implementing data-transformation and business rules.
• Experience with relational databases such as Oracle, PostgreSQL, MySQL, Amazon Aurora/RDS, SQL Server, or comparable technologies.
• Experience with data validation, reconciliation, defect resolution, data-quality controls, and ETL performance optimization.
• Experience using Git and working within established GitLab-based development and deployment processes.
• Experience developing or consuming RESTful APIs, web services, files, or enterprise-system interfaces.
• Working knowledge of Agile development, automated testing, secure software delivery, DevSecOps, and CI/CD practices.
• Bachelor's degree in Computer Science, Cybersecurity, Data Science, Software Engineering, Information Technology, Information Systems, or a related software-engineering discipline; or one current certification from the following: Certified Cloud Security Professional (CCSP), CyberSec First Responder (CFR), Federal IT Security Professional–Manager (FITSP-M), GIAC Security Essentials Certification (GSEC), CompTIA Security+, or Systems Security Certified Practitioner (SSCP).
• Ability to satisfy applicable DoD workforce qualification and certification requirements associated with assigned duties and system privileges.

Preferred

• Experience with Oracle and Oracle PL/SQL in enterprise data-processing environments.
• Experience with Informatica Intelligent Cloud Services (IICS) or Informatica Cloud Data Integration.
• Experience modernizing legacy ETL workflows or migrating data workloads to AWS-based environments.
• Familiarity with Amazon Aurora PostgreSQL or Aurora MySQL, Amazon RDS, and other approved AWS data services.
• Familiarity with Apache Superset or another business-intelligence platform from a data-preparation and integration perspective.
• Familiarity with containerized environments, infrastructure-as-code, and automated cloud deployment practices.
• Experience supporting DoD, USTRANSCOM, transportation, logistics, or other mission-critical data environments.

Clearance and Eligibility

• Active Secret security clearance or the ability to obtain and maintain one, as required by the contract.
• This role is restricted to U.S. person(s) (U.S. citizens, permanent residents, and other protected individuals under 8 U.S.C. 1324b(a)(3)).

Location

• Remote / Hybrid
• Work may be performed remotely or at a contractor facility when authorized.
• Personnel must be available for required on-site meetings, testing, demonstrations, release activities, classified access, or other assigned mission needs at Scott Air Force Base, Illinois.

Who We Are

At D&G Solutions, people come first; our teammates, customers, and the communities we serve. We are one of the fastest growing companies in the Washington, DC area and proud to be recognized nationally as a Best Place to Work. As an 8(a), Service Disabled Veteran Owned, and Women Owned Small Business, we bring ownership, accountability, and care to everything we do. We also deeply believe in giving back and proudly support organizations such as Homes for Our Troops, SemperK9, and Wreaths Across America.

Our teams are welcoming, collaborative, and deeply committed to mission success. We believe great work happens when people feel supported, respected, and trusted, and we work hard to create that environment every day.

What We Offer

• Competitive salary
• Comprehensive benefits
• 401(k)
• Bonus and profit sharing
• Flexible hours
• Education reimbursement
• Generous paid time off

Final Note

If you want to work for a company that cares about its people, contribute to a mission that truly matters, and be part of a team where you are valued for who you are as well as what you do, we would love to hear from you.