Job Description :

Client: Geisinger Health Group
Title:
ETL (Informatica) Developer
Location: 100% Remote (EST Hours - must live in CST or EST)
Interview Process: IKM Assessment from Apex followed by one and done video I/V with hiring team (We have interview slots already on calendar)
Number of Openings: 3
- 2 Openings are C2H This is a contract to hire role, and the client does not provide any form of visa sponsorship. To qualify, candidates must be eligible to work in US without sponsorship now or in future
- 1 Opening can be Long-Term Contract and we have can work with any type of visa status for this opening.

Required Technologies
Informatica 10x - REQUIRED
PowerCenter - REQUIRED
Informatica Intelligent Cloud Services (ICS or IICS) - REQUIRED
SQL - SSIS (preferred not required)

Apex Systems is seeking an experienced ETL/Informatica Developer for one of our top healthcare/hospital clients. The individual selected for this role will be experienced in Informatica (10x), have solid PowerCenter and possess strong SQL and data warehousing skills as well as be well versed in the Agile SDLC lifecycle processes. The scope of ETL design and development includes but is not limited to data extraction from heterogeneous data sources, data transformation (e.g., data cleansing), database loading, and support to meet the needs of the business. Individual should have experience with various databases platforms including SQL Server.


Essential Functions:

  • Demonstrates expertise in a variety of the field's concepts, practices, and procedures related to ETL/Data design and development.
  • Implementing solutions using Informatica PowerCenter 10x (Designer/Monitor).
  • Develop and recommend strategies and specifications for (technical) data solutions based on the analysis of the business goals, objectives, needs, and existing data systems infrastructure.
  • Data Modeling and experience in developing new logical, conceptual, and physical models for data and system flows
  • Develop technical strategies and architectures for high-performance, scalable and complex enterprise-grade system
  • Work with ETL developers, business analyst, DBAs, system administrators, to architect data model, design and implement database as well as write ETL related programs.
  • Work closely with the team responsible for the maintaining the data model, including data dictionary/metadata registry.
  • Document programming problems and resolutions for future reference.

Experience

  • At least 8 years' experience in a large Data Warehouse environment.
  • 8+ years' experience in Informatica PowerCenter including extensive experience with v10x, focused on utilizing push down optimization, mapplets and worklets. Experience working complex transformations including update strategies, routers, normalizers etc.
  • 2+ years of SQL Server including 5+ years of ETL/SSIS for SQL Server
  • 1+ year/project working with Informatica Intelligent Cloud Services (ICS or IICS).
  • 1+ years of experience with MDM (Master Data Management) including loading data into MDM.
  • Expert SQL writing/tuning
  • Strong understanding of Data Warehouse/MDM concepts (ETL, Star Schema, slowly changing dimensions).
  • Strong knowledge of relational databases, Data Warehouse and business Intelligence solutions
  • Excellent teamwork and collaboration skills.
  • Proficient in shell scripting and performance tuning within a Unix/Linux Environment
  • Excellent written/verbal communications skills.
  • Ability to meet deadlines with attention to detail and accuracy.
  • Ability to handle multiple concurrent tasks/projects according to priorities.
  • Ability to work in a group or team environment

Preferred Skills/Nice to Have

  • Experience with IICS (Informatica Intelligent Cloud Services)
  • Healthcare Experience
  • Familiarity with Salesforce

Required Skills : Informatica 10x - REQUIRED PowerCenter - REQUIRED Informatica Intelligent Cloud Services (ICS or IICS) - REQUIRED SQL - SSIS (preferred not required)
Basic Qualification : Number of Openings: 3 - 2 Openings This is a contract to hire role, and the client does not provide any form of visa sponsorship. To qualify, candidates must be eligible to work in US without sponsorship now or in future - 1 Opening can be Long-Term Contract and we have can work with any type of visa status for this opening.
Additional Skills : Number of Openings: 3 - 2 Openings This is a contract to hire role, and the client does not provide any form of visa sponsorship. To qualify, candidates must be eligible to work in US without sponsorship now or in future - 1 Opening can be Long-Term Contract and we have can work with any type of visa status for this opening.LTC or Right to Hire
Background Check :Yes
Notes :Number of Openings: 3 - 2 Openings are C2H This is a contract to hire role, and the client does not provide any form of visa sponsorship. To qualify, candidates must be eligible to work in US without sponsorship now or in future - 1 Opening can be Long-Term Contract and we have can work with any type of visa status for this opening.
Selling points for candidate :LTC or Right to Hire
Project Verification Info :For the Consulting Role - Client Letter - SOW - Exhibit A
Candidate must be your W2 Employee :No
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 : :No
Type of project :Administration/Support
Master Job Title :Dev: Other
Branch Code :Philadelphia