Informatica Powercenter Developer
Share
Job Location:
Bloomington, IN - USA
Monthly Salary:
Not Disclosed
Posted on:
7 hours ago
Vacancies:
1 Vacancy
Job Summary
Job Summary (List Format):
- Follow the companys software development lifecycle to design code configure test debug and document system and application programs.
- Assist in preparing technical design specifications using functional requirements and analysis documents.
- Review and provide feedback on functional requirements analysis and design documents.
- Participate in architecture design and code reviews.
- Develop and maintain operational and system-level documentation.
- Receive annual secure code training per federal and industry security standards (USDA PCI DSS NYDFS FFIEC CIS NIST OWASP).
- Develop with Informatica PowerCenter including designing and developing workflows and deploying them to production.
- Write scripts to manage move and schedule files for Informatica integration.
- Support Informatica in medium or large operating environments (minimum 5 years experience).
- Develop modify troubleshoot and optimize complex SQL queries and stored procedures (minimum 4 years experience).
- Apply deep understanding of relational/dimensional data modeling data mapping design integration migration and warehousing.
- Design and implement ETL solutions for optimized performance including jobs recovery failover logging and alerting mechanisms.
- (Preferred) Develop with Java J2EE and handle database building SQL scripting and management (DB2 SQL PL/SQL JDBC Mapping and Workflow Tools).
- (Preferred) Develop with Azure Data Factory.
- (Preferred) Bring experience from the banking and insurance industries.
- Follow the companys software development lifecycle to design code configure test debug and document system and application programs.
- Assist in preparing technical design specifications using functional requirements and analysis documents.
- Review and provide feedback on functional requirements analysis and design documents.
- Participate in architecture design and code reviews.
- Develop and maintain operational and system-level documentation.
- Receive annual secure code training per federal and industry security standards (USDA PCI DSS NYDFS FFIEC CIS NIST OWASP).
- Develop with Informatica PowerCenter including designing and developing workflows and deploying them to production.
- Write scripts to manage move and schedule files for Informatica integration.
- Support Informatica in medium or large operating environments (minimum 5 years experience).
- Develop modify troubleshoot and optimize complex SQL queries and stored procedures (minimum 4 years experience).
- Apply deep understanding of relational/dimensional data modeling data mapping design integration migration and warehousing.
- Design and implement ETL solutions for optimized performance including jobs recovery failover logging and alerting mechanisms.
- (Preferred) Develop with Java J2EE and handle database building SQL scripting and management (DB2 SQL PL/SQL JDBC Mapping and Workflow Tools).
- (Preferred) Develop with Azure Data Factory.
- (Preferred) Bring experience from the banking and insurance industries.
