ETL/Informatica Developer with Financial & Modeling background | Must work on W2

Role: Senior ETL/Informatica Developer with Financial & Modeling background
Location: Reston, VA 4 days per week onsite, likely will have an onsite interview requested.
Duration: 1 year

Job Description:

• 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. 8-10 years

Role Summary:

• Client is seeking a highly skilled Informatica Developer to join client s 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.

Minimum Required Experience:

• 7 plus years of experience in data engineering or ETL development, with deep expertise 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 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

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

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

--
Asher Williams
Desk: 2o1.497.1o1o X:1o5 | Direct: 551.272.o129
asher (at) pullskill dot com