Sr Informatica Developer

Client: United Health Group Title: Senior Informatica Developer Location: Horsham, PA (2 days' on-site is strongly preferred - if they can't find a local candidate they will consider East Coast candidate within 2-3 hours of Horsham, PA who can come in for major milestone meetings) Duration: Long Term Contract (right to hire for candidate who can convert) Responsibilities Informatica PowerCenter development with an emphasis on working with a diverse set of sources and targets, implementing auditing, error trapping/tracking, reusability and restartablilty, and the ability to troubleshoot and performance tune Informatica mappings, sessions and workflows Development of Informatica PowerExchange CDC Data Mappings and workflows to support real time ETL and Reporting. Development of PL/SQL to include execution of a number of queries in one block using single command, provide features to handle exceptions, extensive error checking, and create a PL/SQL unit such as procedures, functions, packages, triggers, and types, which are stored in the database for reuse by applications Design ETL within Data Warehouse and Operational Data Stores that are leveraged across the business to enable data driven decisions Lead team design, solutioning, development and support efforts Provide direction and mentor Team members Day to Day collaboration with Scrum Teams, providing support to our developers and testers Participation in a rotation for operations support, prod and non-prod Participation in software release and deployment activities ETL and Database tuning Provide scalable solutions for handling large data volumes (Terabytes of data) Develop design specifications, unit test plans, and troubleshoot client issues Work within an Agile Methodology environment for delivery Requirements Bachelor's Degree in Computer Science or related field of study and 8 years of Data Warehouse experience with Informatica ETL. 5 years of Informatica PowerCenter and PowerExchange including some experience with CDC (Oracle/DB2/Mainframe) strong preferred 5 years of ETL experience minimum 5 years of Oracle (PL/SQL) including ability to write PL/SQL Stored Procedures. Experience with one of more of the following: Exadata, Teradata or Netezza is a must Deep understanding of Data Warehousing principles with hands on experience with slowly changing dimensions and fact tables Experience with ETL and Database Tuning Understanding of ETL testing is a major plus Healthcare domain is highly preferred but not required Required Skills : Data Warehouse/ETL - 10 years Informatica - 8 years PowerCenter - 5 years Oracle - 5 years PL/SQL - 5 years Strong communication skills Basic Qualification : Additional Skills : LONG TERM CONTRACT Multi-Year Background Check :Yes Drug Screen :Yes Notes : Selling points for candidate :LONG TERM CONTRACT Multi-Year Project Verification Info :SOW/PO (with resource name/vendor on it) Exhibit A Apex Letter Candidate must be your W2 Employee :Yes Exclusive to Apex :No Face to face interview required :No Candidate must be local :No Candidate must be authorized to work without sponsorship ::No Interview times set :Yes Type of project :Development/Engineering Master Job Title :Big Data: Dev Branch Code :Philadelphia