Informatica Developer

Duration

09 Months (Possible extensions)

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 Power Center 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.

• 7+ years of experience in data engineering or ETL development, with deep expertise in Informatica Power Center.
• Experience in Informatica Intelligent Data Management Cloud (IDMC).
• Experience in Power Center to IDMC migration is a plus.
• Proven experience in AWS cloud services, including EMR, ECS, Glue, Redshift, SNS, SQS, Lambda, Cloud Watch, 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

• Bachelor’s degree in computer science, Engineering, or related field.
• Experience with Redshift, Postgres, Oracle databases.
• Exposure to CI/CD tools like Jenkins, Git Lab, and build tools such as Maven or Gradle.
• Experience with Git Hub 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.

• Testing: ETL workflow testing, data validation, performance testing, regression testing
• Other Tools:
  Alteryx (plus), Terraform

Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.