Sr Informatica Developer
Horsham, PA, United States
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