Senior ETL Informatica Developer

MANTECH•Ashburn, VA

3h•$128,800 - $214,500•Hybrid

About The Position

MANTECH is seeking a motivated, career- and customer-oriented Senior ETL Informatica Developer to join its team in Ashburn, Virginia. The position is onsite two days a week. As a trusted mission partner of U.S. Customs and Border Protection (CBP), MANTECH supports data-driven decision making in response to national security threats. The role helps develop solutions that support efficient trade and travel and the legal, safe, and secure movement of people, capital, and products. The developer will build and maintain ETL workflows and scalable data pipelines using Informatica and cloud-native tools, integrate data across sources, and work with clients to manage operational data needs. The role also includes source code control using GitLab and applying practical knowledge of cargo and passenger data and databases to support analytic applications and end-user operations.

Requirements

High school diploma/GED and 20+ years of experience, Associate degree and 18+ years, Bachelor's degree and 12+ years, Master's degree and 9+ years, or Ph.D./Doctorate and 7+ years.
At least 7 years of experience architecting, designing, and developing ETL programs using Informatica data integration tools.
At least 5 years of experience with large (80TB+) and complex data warehousing architecture, design, and implementation or migration.
Hands-on experience with Databricks.
Hands-on experience with ETL migration initiatives, especially migrating 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, or SQL Server, and cloud platforms such as AWS or Microsoft Azure.
Knowledge of Continuous Integration and Continuous Development (CI/CD) tools.
Ability to work effectively both in a team and independently.
Excellent verbal and written communication and problem-solving skills, including communicating with groups with varied technical skill levels.
Must be a U.S. citizen and able to obtain DHS CBP Suitability before starting.

Nice To Haves

Current or active Secret or Top Secret clearance.
Expert knowledge of Informatica PowerCenter version 9 or above.
Experience integrating Databricks with Git-based workflows in controlled network environments.
Background in Oracle database 23ai/26ai, preferably in an Exadata environment, focused on manipulating large-volume data sets.
Experience with Atlassian tools such as Jira and Confluence.

Responsibilities

Develop Informatica ETL workflows 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.
Work closely with clients to manage data needs and support collection of data for operational requirements.
Develop and optimize data integration solutions across multiple data sources.
Manage source code control using GitLab.
Apply practical understanding of cargo and passenger data and databases to support analytic application development, functionality, and targeting end-user (officer) operations.