Back to search

Application Architect III

Seeking a Senior Informatica ETL Developer with 15+ years of experience in Informatica PowerCenter 10.5, Informatica IDMC, and Oracle PL/SQL. Responsible for developing and enhancing enterprise ETL feeds, mappings, workflows, and data validation processes while providing technical guidance and supporting enterprise initiatives in an Agile environment.

  • Jersey City, New Jersey, United States
  • Full-time
  • On-site
  • Posted Nov 13, 2026
INDUSTRYSoftware & InternetSaaS & Enterprise SoftwareData & Analytics

Responsibilities

  • Design, develop, and enhance Informatica mappings, workflows, and enterprise ETL feeds
  • Support complex ETL enhancements, data transformations, and validation processes
  • Configure Informatica modules and feed setups based on business requirements
  • Act as a subject matter expert throughout the complete Software Development Life Cycle (SDLC)
  • Gather business requirements, perform gap analysis, and translate requirements into technical design specifications
  • Collaborate with product owners, business users, and technical teams to design effective solutions
  • Provide technical guidance and support to team members
  • Participate in Agile ceremonies and contribute to sprint activities
  • Perform debugging, performance tuning, runtime analysis, and workflow monitoring
  • Coordinate with testing teams to plan and support application testing
  • Define testing scenarios, develop test scripts, and support defect resolution
  • Prepare end-user documentation and training materials
  • Advise stakeholders on technical options, risks, and impacts on related applications and processes

Requirements

  • Experience in a Enterprise ETL

Nice to have: Oracle Financials R12, Oracle Financial Cloud integrations, Agile methodologies

Skills

Informatica PowerCenter 10.5Informatica IDMCOracle PL/SQLETL developmentUnix scriptingAutoSysInformatica PowerCenter 10.5Informatica IDMCOracle PL/SQLUnixAutoSys

More jobs nearby

Full description

Job Summary Seeking a Senior Informatica ETL Developer with 15+ years of experience in Informatica PowerCenter 10.5, Informatica IDMC, and Oracle PL/SQL. Responsible for developing and enhancing enterprise ETL feeds, mappings, workflows, and data validation processes while providing technical guidance and supporting enterprise initiatives in an Agile environment. Must Have Experience in Informatica PowerCenter 10.5, including mappings and workflows. Experience in Informatica IDMC (Informatica Intelligent Data Management Cloud). Experience in Oracle PL/SQL programming. Experience in ETL development, debugging, performance tuning, runtime analysis, and system monitoring. Experience in Unix scripting and AutoSys scheduler. Nice to Have Experience with Oracle Financials R12. Experience with Oracle Financial Cloud integrations. Knowledge of Agile methodologies and working in Agile teams. Experience identifying functionality gaps and conducting Proof of Concepts (POCs). Ability to develop technical workarounds and solution designs. Responsibilities Design, develop, and enhance Informatica mappings, workflows, and enterprise ETL feeds. Support complex ETL enhancements, data transformations, and validation processes. Configure Informatica modules and feed setups based on business requirements. Act as a subject matter expert throughout the complete Software Development Life Cycle (SDLC). Gather business requirements, perform gap analysis, and translate requirements into technical design specifications. Collaborate with product owners, business users, and technical teams to design effective solutions. Provide technical guidance and support to team members. Participate in Agile ceremonies and contribute to sprint activities. Perform debugging, performance tuning, runtime analysis, and workflow monitoring. Coordinate with testing teams to plan and support application testing. Define testing scenarios, develop test scripts, and support defect resolution. Prepare end-user documentation and training materials. Advise stakeholders on technical options, risks, and impacts on related applications and processes.

Application Architect III at Artech LLC | Referso Jobs