Skip to main content

Informatica Developer

Technology
Software Technology
Horsham, United States3 days ago
Service contract

Job 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)
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

Interested in this role?