informatica/etl powercenter developer - Bloomington, United States - Randstad

Description

informatica/etl powercenter developer.

• bloomington , illinois (remote)
• posted 6 days ago

job details

summary

• $50 - $61.50 per hour
• contract
• bachelor degree
• category computer and mathematical occupations
• reference

job details

job summary:

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 Power Center & IDEM with primary responsibilities including designing solutions, translating business requirements, developing, documenting, testing, troubleshooting data environments 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.

Follows company software development lifecycle to design, code, configure, test, debug, and document system and application programs. Assists in preparing technical design specifications based on functional requirements and analysis documents. Reviews functional requirements, analysis and design documents and provides feedback. Participates in architecture, design and code reviews. Develops and maintains 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 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.

location: BLOOMINGTON, Illinois

job type: Contract

salary: $ per hour

work hours: 8am to 4pm

education: Bachelors

responsibilities:

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 Power Center & IDEM with primary responsibilities including designing solutions, translating business requirements, developing, documenting, testing, troubleshooting data environments 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.

Follows company software development lifecycle to design, code, configure, test, debug, and document system and application programs. Assists in preparing technical design specifications based on functional requirements and analysis documents. Reviews functional requirements, analysis and design documents and provides feedback. Participates in architecture, design and code reviews. Develops and maintains 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.

qualifications:

• Experience level: Experienced
• Minimum 5 years of experience
• Education: Bachelors

skills:

• Informatica
• ETL
• Azure Data Factory
• JAVA
• SQLEqual Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).Applications accepted on ongoing basis until filled.