D&G Support Services, LLC - Mid Level ETL / Data Integration Developer Informatica

Data Engineer is needed in Belleville, United States.

Client: D&G Support Services, LLC

Location: Belleville, IL

Job Description

Mid-Level ETL / Data Integration Developer - Informatica
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.

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.

Requirements

What We Are Looking For
Required

• 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.

Company Information

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

Benefits

• 401(k)
• 401(k) matching
• Employee assistance program
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Parental leave
• Professional development assistance
• Referral program
• Retirement plan
• Vision insurance

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.