← Back to jobsJob ID col-cmv8wo9w508rpmd01t516di0e

D&G SolutionsPosted 30+ days ago

Mid-Level ETL / Data Integration Developer - Informatica

Full-time
Hybrid
4+ years
$110K – $135K/yr
Posted 30+ days ago

D&G Solutions is seeking a Mid-Level ETL / Data Integration Developer to support software modernization, data integration, and cloud-migration activities for Department of Defense transportation and logistics systems. The role develops and sustains Informatica-based ETL workflows, complex SQL, source-to-target mappings, data-quality controls, and enterprise interfaces while supporting Agile development, secure cloud modernization, and release activities.

Posted
30+ Days Ago
Source
recruitingbypaycor.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • 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

Qualifications

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

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

Required skills

ETL DevelopmentInformatica PowerCenterSQLSource-to-Target MappingData Quality ManagementRelational DatabasesGit and GitLab CI/CDAgile DevelopmentDevSecOps and CI/CDSecret Security Clearance

Full job description

D&G Solutions is seeking a Mid-Level ETL / Data Integration Developer to support software modernization, data integration, and cloud-migration activities for Department of Defense transportation and logistics systems. The role develops and sustains Informatica-based ETL workflows, complex SQL, source-to-target mappings, data-quality controls, and enterprise interfaces while supporting Agile development, secure cloud modernization, and release activities.

Responsibilities

  • 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

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
  • Oracle PL/SQL
  • Enterprise data processing
  • Informatica IICS
  • Cloud data integration
  • Legacy ETL modernization
  • Data workload migration
  • AWS environments
  • Amazon Aurora PostgreSQL
  • Aurora MySQL
  • AWS data services
  • Apache Superset
  • Business intelligence
  • Data preparation
  • Containerized environments
  • Infrastructure as code
  • Automated cloud deployment
  • DoD data environments
  • USTRANSCOM support
  • Transportation data environments
  • Logistics data environments
  • Mission-critical data environments

Benefits

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

Company

  • Defense and homeland security logistics, supply chain, and program support
  • Woodbridge, Virginia, USA
  • https://www.dngsolutions.com/
  • Founded in 2007
  • 51-200 employees

Qualifications

  • 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
  • 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))
  • Remote / Hybrid
  • 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
  • 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
  • Four or more years of professional experience in ETL development, data integration, database development, software development, or a related technical field.

Required skills

  • ETL Development, Informatica PowerCenter, SQL, Source-to-Target Mapping, Data Quality Management, Relational Databases, Git and GitLab CI/CD, RESTful APIs and Web Services, Agile Development, DevSecOps and CI/CD, Secret Security Clearance

Experience

  • 4+ years

Job details

Employment type

Full-time

Seniority level

4+ years

Date posted

Oct 14, 2026

Work mode

Hybrid

Job source

recruitingbypaycor.com

Company

D&G Solutions

Information Technology & AI

Defense and homeland security logistics, supply chain, and program support

  • Woodbridge, Virginia, USA
  • Information Technology & AI
  • 51-200 employees
  • Founded 2007
  • dngsolutions.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Belleville

GSK Solutions Inc.

1d ago

New

Data Analyst / ETL Developer (Hybrid Onsite)

TemporaryHybridLansing, MICompetitive

The Office of Retirement Services (ORS) is seeking a contractor to manage and optimize its data infrastructure and support data quality and migration initiatives.

Why similarSame roleData Quality Management

First Citizens Bank

1d ago

New

Senior Data Engineer - ETL/ELT (Remote - NC, AZ, TX, FL)

Full-timeRemoteUnited StatesCompetitive

First Citizens Bank is hiring a Senior Data Engineer to implement, enhance, and support data pipelines and platform capabilities within established architectural patterns.

Why similarSame roleSQLRemote

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleETL DevelopmentRemote

Get new Data Engineer jobs in Belleville by email

Create job alert

Mid-Level ETL / Data Integration Developer - Informatica

D&G Solutions · $110K – $135K/yr

Apply on company site