Informatica Developer - Idexcel Inc.
Job Title: Informatica Developer
Location: Bloomington, IL / Remote
Duration: 12+ Months
Description: 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, & IDEM with primary responsibilities including designing solutions, translating business requirements, developing, documenting, testing, troubleshooting the 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.Required 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.
About IDEXCEL, INC Idexcel is an IT services organization, with a mission to bring great people and great organizations together. Our diverse client base represents a wide range of industries, including technology, telecom, insurance, healthcare, manufacturing, banking & financial services, food & commodities trading and federal organizations. Our teams of experienced recruiters directly work with client companies seeking exceptional people to help with their business initiatives. Idexcel, Inc. is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Apply to this job