ETL Informatica Developer

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.
• 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.

Requirements

• 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.

Qualifications

• 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.