Informatica Developer

Client: United Health Group Title: Informatica Developer Duration: 6 Month Contract to Hire Location: Horsham, PA 19044 2 days' remote; 3 days' on-site (Do not send Remote Only candidates) 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 or related rools. 5 years of Informatica PowerCenter and PowerExchange including some experience with CDC (Oracle/DB2/Mainframe) strong preferred 5 years of ETL experience 3 years of Oracle (PL/SQL) Experience with one of more of the following: Exadata, Teradata or Netezza 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 : Bachelor's Degree in Computer Science or related field of study and 8 years of Data Warehouse experience with Informatica or related rools. 5 years of Informatica PowerCenter and PowerExchange including some experience with CDC (Oracle/DB2/Mainframe) strong preferred 5 years of ETL experience 3 years of Oracle (PL/SQL) Experience with one of more of the following: Exadata, Teradata or Netezza Basic Qualification : HYBRID SCHEDULE 2 Days' Remote 3 Days' On-Site Additional Skills : HYBRID SCHEDULE 2 Days' Remote 3 Days' On-SiteContract to Hire Background Check :Yes Drug Screen :Yes Notes : Selling points for candidate :Contract to Hire Project Verification Info : Candidate must be your W2 Employee :Yes Exclusive to Apex :No Face to face interview required :No Candidate must be local :Yes Candidate must be authorized to work without sponsorship :Yes Interview times set :Yes Type of project :Development/Engineering Master Job Title :Misc: Non-Technical Branch Code :Philadelphia