ETL Informatica Developer

Senior ETL Informatica Developer Unlock the secrets of intelligence with MANTECH! Join a dynamic team at the forefront of national security, providing advanced solutions to government intelligence agencies. Since 1968, we've been solving the toughest challenges with groundbreaking tech. Explore thrilling projects in Digital Transformation, Cybersecurity, IT, Data Analytics and Software Development. Elevate your career and make a difference. Your adventure begins nowunleash your potential with MANTECH! 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 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. The projected compensation range for this position is $128,800.00-$214,500.00. There are differentiating factors that can impact a final salary/hourly rate, including, but not limited to, Contract Wage Determination, relevant work experience, skills and competencies that align to the specified role, geographic location (For Remote Opportunities), education and certifications as well as Federal Government Contract Labor categories. In addition, MANTECH invests in its employees beyond just compensation. MANTECH's benefits offerings include, dependent upon position, Health Insurance, Life Insurance, Paid Time Off, Holiday Pay, short-term and long-term Disability, Retirement and Savings, Learning and Development opportunities, wellness programs as well as other optional benefit elections. MANTECH 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 and provide your name and contact information.