Hi, We are looking for *Informatica Developer* In *CA*, if you’re interested please respond to this email with your word updated resume and expected pay rate.
*Role : Informatica Developer* *Location : Rancho Cordova, CA* *Duration : 6+ Months Contract* *Need 10+ years experience consultant,* *Need very very strong experience on SQL, PL/SQL, and Teradata Stored Procedural Language (SPL) & Unix and Shell Scripting.* *Only GC’s and US Citizen.* *Job Description: * 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 *Typical Duties: * •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 *Thanks and Regards* *Rishi* *IT Recruiter| Ven Soft LLC* *4221 Walney Road, suite 500, Chantilly, VA 20151* *Office: **703-763-2541 (896) |* *Direct: 571-328-5511* *Fax: 732 875 0535* *Email id:* *ri...@vensoftllc.com <ri...@vensoftllc.com>* *| **www.Vensoftllc.com <http://www.vensoftllc.com/> * *Ven Soft LLC is ranked 616 – on the 2014 Inc. 5000 List and is successfully providing full IT consulting services to Fortune 500 firms with offices all over US and with headquarters in Fairfax, Virginia* -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at https://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
