Senior ETL Informatica Developer

ManTech; Ashburn (VA); On-site; USD 120,000 - 160,000; Full time

Job summary

MANTECH seeks a Senior ETL Informatica Developer to join our team in Ashburn, Virginia. This onsite role supports CBP data integration with Informatica, Databricks, and cloud-native tools, enabling data-driven decisions.

You will design, develop, and optimize ETL pipelines, collaborate with clients, and ensure robust data workflows across databases and cloud platforms. A strong background in CI/CD and data warehousing is required.

Qualifications

• Minimum of 7 years’ experience with ETL programs using Informatica and data integration tools.
• At least 5 years’ experience in large, complex data warehousing architecture and migration.
• Hands-on experience with Databricks.
• Experience with ETL migration initiatives moving Informatica workflows to cloud-native or open-source frameworks.
• Knowledge of relational databases (Oracle, MySQL, Postgres, SQL Server) and cloud platforms (AWS, Azure).
• Knowledge of CI/CD tools and practices.
• Strong communication and ability to work in a team or independently.

Responsibilities

• 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.
• Collaborate with clients to manage data needs for operational analytics.
• Develop and optimize data integration across multiple data sources.
• Manage source code with GitLab.
• Apply understanding of cargo and passenger data to support analytic applications.

Skills

Informatica

ETL

Databricks

CI/CD

GitLab

Cloud AWS

Azure

Education

Bachelor's degree in CS/CE/IS

Tools

Informatica PowerCenter

Databricks

GitLab

Jira

Confluence

Job description

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.

MANTECH International Corporation considers all qualified applicants for employment without regard to disability or veteran status or any other status protected under any federal, state, or local law or regulation.

If you need a reasonable accommodation to apply for a position with MANTECH, please email us at [e-mail] and provide your name and contact information.