Senior Informatica Developer

KMM Technologies • Reston, VA

18h • Hybrid

About The Position

We are seeking a highly skilled Informatica Developer to join our Enterprise Data team. This role is focused on supporting and enhancing Data Warehouse applications, with Informatica PowerCenter as the core ETL tool. The ideal candidate will also have strong experience in AWS development, Python programming, and containerization using Docker. Familiarity with orchestration tools like Autosys and MWAA (Managed Workflows for Apache Airflow) is expected. This position requires participation in an on-call rotation for production support and strong experience in testing ETL workflows, data validation, and ensuring data quality across large-scale pipelines.

Requirements

• 7+ years of experience in data engineering or ETL development, with deep expertise in Informatica PowerCenter.
• Experience in Informatica Intelligent Data Management Cloud (IDMC).
• Proven experience in AWS cloud services, including EMR, ECS, Glue, Redshift, SNS, SQS, Lambda, CloudWatch, and S3.
• Strong proficiency in Python for data processing and automation.
• Experience supporting Data Warehouse environments and large-scale data pipelines.
• Hands-on experience with Docker for containerized development and deployment.
• Experience in testing ETL workflows, including unit testing, integration testing, regression testing, and data reconciliation.
• Ability to design and execute test cases for data validation, performance testing, and error handling in ETL processes.
• Excellent problem-solving skills and strong verbal & written communication.
• Ability to work independently and collaboratively in a fast-paced environment.
• Experience working in Agile development environments, including participation in sprint planning, daily stand-ups, and retrospectives.
• Willingness to participate in on-call rotation for production support (24/7 for 1 week per month).

Nice To Haves

• Experience in PowerCenter to IDMC migration is a plus.
• Experience with Redshift, Postgres, Oracle databases.
• Exposure to CI/CD tools like Jenkins, GitLab, and build tools such as Maven or Gradle.
• Experience with GitHub Copilot or other GenAI tools (preferred).
• Experience with Alteryx is a plus.
• Experience contributing to Agile ceremonies and using tools like Jira for story tracking and defect management.
• Experience with Redwood orchestration and workflow management is a plus.
• Familiarity with orchestration tools like Autosys and MWAA (Managed Workflows for Apache Airflow) is expected.

Responsibilities

• Develop and maintain financial software applications.
• Work closely with the finance team to understand their needs and translate them into functional software.
• Test software to ensure responsiveness and efficiency.
• Identify, prioritize and execute tasks in the software development life cycle.
• Collaborate with internal teams and vendors to fix and improve products.
• Support and enhance Data Warehouse applications using Informatica PowerCenter.
• Participate in an on-call rotation for production support.
• Test ETL workflows, data validation, and ensure data quality across large-scale pipelines.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree