Informatica Developer
Software TechnologyJob description
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)
- 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
- 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
Interested in this role?