Informatica Developer

Job Title: Informatica Developer
Location: Onsite at Bloomington, IL
Visa: No H1B

Candidate must be local to Illinois and DL of Illinois required
Property and casualty Insurance(P&C) exp. required




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 and warehousing.
• 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.