Informatica Developer - Bloomington, IL

AHU Technologies Inc.; United States; Remote; USD 120,000 - 170,000; Full time

Job summary

AHU Technologies Inc. seeks a senior Informatica Developer to join the Application Development Integration Tools team. You will lead ETL development using Informatica IDMC, PowerCenter and related tools, translating requirements into robust data integration solutions.

The role emphasizes design, testing, debugging, and documentation, with emphasis on secure coding practices and SDLC adherence. This is a remote position based in the United States.

Qualifications

• 5+ years in Informatica PowerCenter in enterprise environments.
• 4+ years of SQL experience with complex queries and procedures.
• Strong data modeling and data mapping knowledge.
• ETL design with performance, recovery, logging and alerting focus.
• Java/J2EE, DB2, SQL scripting, JDBC, mapping/workflow tools.
• Azure Data Factory experience preferred.
• Banking/insurance industry experience is a plus.

Responsibilities

• Serve as ETL development SME using Informatica across on‑prem and cloud.
• Design, translate requirements, develop, test, and document ETL solutions.
• Analyze component issues, revise programs, and troubleshoot data environments.
• Follow SDLC; prepare technical design specs, review requirements and designs.
• Participate in architecture, code reviews, and maintain docs.
• Ensure secure coding practices and training per industry standards.

Skills

Informatica PowerCenter

Informatica IDMC

SQL

Data Modeling

Data Mapping

ETL Design

Java

J2EE

DB2

PL/SQL

JDBC

Azure Data Factory

Workflow Tools

Security/Compliance

Job description

Job Description

We are seeking a highly skilled Informatica Developer to join our Application Development Integration Tools team. The team focuses on integrating on‑premise and cloud-based systems which are the core of operations.

This senior developer role will act as an ETL development subject matter expert utilizing Informatica IDMC (CDI and CAI), Power Center, and IDEM, with primary responsibilities including designing solutions, translating business requirements, developing, documenting, testing, troubleshooting data environment using our ETL tool sets. In addition, you will be asked to analyze system components to find causes of errors and revise programs as needed. Follow the company software development lifecycle to design, code, configure, test, debug, and document system and application programs. Assist in preparing technical design specifications based on functional requirements and analysis documents. Review functional requirements, analysis and design documents and provide feedback. Participate in architecture, design and code reviews. Develop and maintain operational and system level documentation. Roles involving code development must receive secure code training each calendar year as required by the US Department Of Agriculture Risk Management Agency, the Payment Card Industry Data Security Standard, the New York Department Of Financial Services CyberSecurity Regulation, the Federal Financial Institutions Examination Council’s IT Examination Handbook, and best practices defined by the Center for Internet Security and the National Institute of Standards and Technology. Such training should be based on an established industry guidelines such as the OWASP Secure Coding Guidelines or cover similar content.

Preferred Qualifications

• Experience developing with Informatica PowerCenter, designing and developing Informatica workflows for enterprise system(s), deployment of Informatica to production environment, and writing scripts to manage/move/schedule files in accordance to Informatica integration.
• Minimum 5 or more years of experience working in a medium or large operating environment supporting Informatica.
• Minimum 4 years of SQL experience (ability to develop, modify, troubleshoot and optimize complex queries and stored procedures).
• Deep understanding of relational/dimensional data modeling and data mapping design, integration, migration/monitoring data etc.
• Design and Implementation of ETL solutions with effective design and optimized performance, ETL Development with industry standard recommendations for jobs recovery, fail over, logging, alerting mechanisms.
• Preferred development background with Java, J2EE, Database building, SQL scripting and Management: DB2, SQL, PL/SQL, JDBC, Mapping and Workflow Tools.
• Preferred experiencing developing with Azure Data Factory.
• Previous experience in the banking and insurance industry preferred.

This is a remote position.