ETL Engineer (Part Time and Remote)
Job Highlights:
- Position: ETL Engineer
- Compensation: a competitive salary
- Company: Workwarp
- Start Date: Immediate openings available
- Location: Remote
Â
Â
Post Date2/13/2024...
Title
ETL Engineer (Part Time and Remote)
Pay Rate
40-100/hr
Length
Location
Description
York Solutions is hiring ETL Engineers to work on behalf of our client on a part-time, remote basis!
Position Overview: These individuals need to be Informatica experts, worked with Oracle, and have been exposed to Snaplogic. Ideal candidates come from the PMB industry but they will also look at candidates from healthcare, insurance and financial industries.
Project Overview: This will be supporting migration efforts bringing MRx data to Prime.
Team: Mix of Fullstack developers (Java) and ETL Developer, working on government programs.
Technical Expertis
 Must have Informatica and Snaplogic
 PLSQL is a plus
 Hands on keyboard midlevel
 Head down role on migration taking things from one area from Magellan moving to prime. Migration effort
Responsibilities:  Promote and apply ETL development best practices  Participates on (and may lead) projects where analysis of systems or data requires an in-depth evaluation of complex business process, system process, and industry standards  Experience with database design, querying, stored procedures, views, joins, performance tuning  Understand Client Business Objectives and performing technical analysis responding to the needs  Develop, document and test ETL interfaces  Design & Develop Workflows, Sessions, Mappings in Informatica & Snaplogic  Develop Data Replication/ Synchronization Tasks in AWS Cloud (Cloud Application Integrations)  Post deployment support and defect resolutions  Evaluate all functional requirements and map documents and perform troubleshoot on all development processes  Collaborate with application groups to prepare effective solutions for all programs  Documents all technical specifications and associate project deliverables  Design all test cases to provide support to all systems and perform unit tests
Technical Skills:
 Informatica and SnapLogic
 Integration experience working with AWS data services such as RedShift, Aurora, S3 etc.
 SQL & PL-SQL expertise working with Oracle database
 Performance tuning of data jobs and pipelines
 Minimum 7-10 years of IT Experience working in ETL and data domain
Qualifications:  Experience working with Informatica and SnapLogic toolset  Understand the existing ETL jobs and mappings, sessions and workflows  Ability to provide sporadic production support if any issues reported  Troubleshoot ETL jobs and fix the issues based the priorities  Analyze and understand the data at source and target system to fix the issues within the specified timelines  Tune the Informatica mappings Apply Job!
Â
Take the Next Step
Are you ready for this challenge? Apply now and let's discuss how you can become a vital part of our success story.
Apply To This Job