Informatica IDMC Developer

Introduction

This position is part of the Frontier Finance team within the Risk and Finance Technology (RFT) organization. The role focuses on hands-on development, enhancement, and migration of the Frontier automated reconciliation platform, emphasizing Informatica PowerCenter to IDMC modernization. The candidate will collaborate with business stakeholders and finance teams to onboard new reconciliations, enhance existing processes, and support critical financial data pipelines. This position requires end-to-end delivery ownership, from requirements through deployment, contributing to the broader cloud-first transformation strategy. This is a 100% hands-on development role with an emphasis on ETL development, database performance, and migration to IDMC.

Required Skills & Qualifications

• Informatica PowerCenter (PC) and IDMC (Intelligent Data Management Cloud)
• Strong ETL design and development experience
• Advanced SQL / PL-SQL development
• Database experience: SQL Server / relational databases
• Autosys scheduling
• Shell scripting
• Strong understanding of data warehousing and data integration concepts
• Experience with database performance tuning and troubleshooting (query plans, indexing, profiling tools)
• Prior work experience at client or in client's Industry

Applicants must be able to work directly for Artech on W2

Preferred Skills & Qualifications

• Python programming (for data processing/automation)
• Experience in application production support
• Familiarity with DevOps tools: Jira, Bitbucket, Jenkins
• Exposure to cloud data platforms / modernization initiatives
• Knowledge of financial systems / reconciliation platforms
• Understanding of data governance and controls in financial systems

Day-to-Day Responsibilities

• Lead PowerCenter to IDMC migration initiatives, including design, development, testing, and deployment
• Perform technical requirement analysis, solution design, and implementation of ETL workflows
• Develop and enhance data pipelines supporting Frontier reconciliation processes
• Partner with business stakeholders and finance users to gather requirements and translate into technical solutions
• Ensure data accuracy, reconciliation integrity, and system reliability
• Troubleshoot and resolve database performance issues (blocking, locking, latency, query optimization)
• Provide end-to-end ownership of assigned deliverables
• Support production releases, defect resolution, and system enhancements
• Mentor junior developers through knowledge sharing, pair programming, and informal coaching
• Contribute to architecture discussions, data modeling, and design reviews
• Follow Agile/Scrum methodologies, including sprint planning, stand-ups, and retrospective sessions
• Implement CI/CD and test-driven development practices

Company Benefits & Culture

• Not specified

For immediate consideration please click APPLY to begin the screening process with Alex.