Randstad ETL Informatica Developer in Roseville, California
ETL Informatica Developer
Friday, October 7, 2016
Our client has a contract opportunity for an ETL Informatica Developer in Rancho Cordova, CA. This position can also work out of Pontiac, MI or remotely.
Must be a US citizen and have ability to obtain a public trust security clearance.
Specialist level ETL (Informatica) technical developer will work as part of the team that migrates the Health Care Information Warehouse (IW) data structures from the mainframe to a Teradata V15.10 database. The following HNFS Information Warehouse components will be used:
Informatica PowerCenter V10 - Extract Transform Load (ETL) tool
Business Objects XI 4.x- Data Access Reporting tool
Dundas Dashboard - Dashboard tool
SAS 9.4 (Office analytics, Access Interface to Teradata)
Teradata database V 15.10
Microsoft SQL Server database
Create or modify Informatica workflows
Assist development teams to maintain all data sources and data storage options.
Coordinate with application team and develop all ETL processes.
Administer all requests and analyze issues and provide efficient resolution for same.
Design program specifications and perform required tests
Prepare program and system implementation for all Informatica programs.
Evaluate all functional requirements and map documents and perform troubleshoot on development processes.
Collaborate with application groups to prepare effective solutions for all programs.
Documents all technical specifications and associate project deliverables.
Design all test cases to provide support to all systems and perform unit tests.
Skills and Qualifications
Bachelor s degree and 10 or more years of ETL experience with Informatica PowerCenter is required; at least 2 years with version 9.x or 10.
Worked as ETL (Informatica) development on a large scale project for minimum of 5 years.
Strong experience in setup, installation and configuration of ETL (Informatica) tools using Teradata.
Strong experience with SQL and Teradata databases, preferably version 15.10.
Strong UNIX and shell scripting experience is required.
7+ years of experience with SQL, PL/SQL, and Teradata Stored Procedural Language (SPL).
3+ years of experience with Teradata Data Warehouse Architecture.
Knowledge of data warehousing, data governance processes, data quality processes, testing methodologies, reporting tools, application development.
Multi-platform and multi-system integration experience.
Demonstrated record of success with problem-solving skills, creativity, and the ability to manage multiple priorities
Experience with mainframe z/OS (JCL, COBOL, etc) and DB2 is highly desired.
Proficiency with metadata, data modeling and data quality tools an asset.
Working knowledge of Information Management, Business Intelligence, Health Care Analytics a plus.
Experience migrating DB2 mainframe database/data to Teradata database a plus.
Ability to analyze business cases, extract requirements and understand business needs.
Strong analytical, problem solving and communication skills.