ETL Informatica Developer

MANTECH seeks a motivated, career and customer-oriented Senior ETL Informatica Developer to join our team in Ashburn, Virginia. This position is onsite two days a week

Each day U.S. Customs and Border Protection (CBP) oversees the massive flow of people, capital, and products that enter and depart the United States via air, land, sea, and cyberspace. The volume and complexity of both physical and virtual border crossings require the application of solutions to promote efficient trade and travel. Further, effective solutions help CBP ensure the movement of people, capital, and products is legal, safe, and secure. In response to this challenge, ManTech, as a trusted mission partner of CBP, seeks capable, qualified, and versatile Senior ETL Informatica Developers to facilitate data-driven decision making in response to national security threats.

Responsibilities include, but are not limited to:

• Develop ETL workflows using Informatica for periodic data loads from source to target databases.
• Design, develop, and maintain scalable ETL pipelines and data workflows using Informatica and cloud-native tools.
• Working closely with clients to assist in managing data needs and supporting collection of data needed for various operational needs.
• Develop and optimize data integration solutions across multiple data sources.
• Responsible for source code control using GitLab.
• Demonstrate a strong practical understanding of application-relevant cargo and passenger data and databases used to support analytic application development, functionality and targeting end user (officer) operation.

Minimum Qualifications:

• HS Diploma/GED and 20+ years or AS/AA and 18+ years or BS/BA and 12+ years or MS/MA/MBA and 9+ years or PhD/Doctorate and 7+ years
• Minimum of 7 years' experience in the architecture, design and development of ETL programs using Informatica data integration tools; and at least 5 years' experience in large (80TB+) and complex data warehousing architecture, design and implementation/migration.
• Hands-on experience with Databricks.
• Proven hands-on experience with ETL Migration Initiatives, especially moving Informatica workflows to open-source or cloud-native integration frameworks; strong understanding of ETL architecture, data integration patterns and relational data concepts.
• Experience with one or more relational database systems such as Oracle, MySQL, Postgres, SQL server, etc. and experience with cloud platforms like Amazon Web Services (AWS), Microsoft Azure, etc.
• Knowledge of Continuous Integration & Continuous Development tools (CI/CD).
• Must work well in a team environment as well as independently. Excellent verbal/written communication and problem-solving skills; ability to communicate information to a variety of groups at different technical skill levels.

Preferred Qualifications:

• Current/active secret or Top Secret clearance preferred.
• Expert knowledge of Informatica PowerCenter version 9 and above.
• Experience integrating Databricks with Git-based workflows in controlled network environments.
• Solid background in Oracle database 23ai / 26ai preferably in Exadata environment with a focus on manipulating large volume data set.
• Experience with Atlassian suite of tools such as Jira and Confluence.

Clearance Requirements:

• Must be a U.S Citizen with the ability to obtain DHS CBP Suitability prior to starting this position.

Physical Requirements:

• The person in this position needs to occasionally move about inside the office to access file cabinets, office machinery, or to communicate with co-workers, management, and customers, which may involve delivering presentations.