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.
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 careers@mantech.com and provide your name and contact information.
