Sr InformaticaDeveloper

Role Summary
We are seeking a highly skilled Informatica Developer to join our EnterpriseData team. This role is focused on supporting and enhancing Data Warehouseapplications, with Informatica PowerCenter as the core ETL tool. The idealcandidate will also have strong experience in AWS development, Pythonprogramming, and containerization using Docker. Familiarity with orchestrationtools like Autosys and MWAA (Managed Workflows for Apache Airflow) is expected.This position requires participation in an on-call rotation for productionsupport and strong experience in testing ETL workflows, data validation, andensuring data quality across large-scale pipelines.
________________________________________
Minimum Required Experience
• 7+ years of experience in data engineering or ETL development, with deepexpertise in Informatica PowerCenter.
• Experience in Informatica Intelligent Data Management Cloud (IDMC).
• Experience in PowerCenter to IDMC migration is a plus.
• 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 datapipelines.
• Hands-on experience with Docker for containerized development and deployment.
• Experience in testing ETL workflows, including unit testing, integrationtesting, 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 & writtencommunication.
• Ability to work independently and collaboratively in a fast-pacedenvironment.
• Experience working in Agile development environments, including participationin sprint planning, daily stand-ups, and retrospectives.
• Willingness to participate in on-call rotation for production support. 24/7for 1 week per month
________________________________________
Desired Experience
• Bachelor’s degree in computer science, Engineering, or related field.
• Experience with Redshift, Postgres, Oracle databases.
• Exposure to CI/CD tools like Jenkins, GitLab, and build tools such as Mavenor 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 forstory tracking and defect management.
• Experience with Redwood orchestration and workflow management is a plus.
________________________________________
Technical Skills
• ETL: Informatica PowerCenter, Informatica IDMC
• AWS Services: EMR, ECS, Glue, Redshift, S3, SNS, SQS, Lambda, CloudWatch
• Languages: Python, SQL (Redshift, Postgres, Oracle)
• Orchestration: Autosys, Redwood (Plus)
• CI/CD: Jenkins, GitLab, GitHub, UCD
• Testing: ETL workflow testing, data validation, performance testing,regression testing
• Other Tools: Alteryx (plus), Terraform