Mid-Level ETL / Data Integration Developer - Informatica

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