ETL Engineer (Part Time and Remote)

Overview

Remote
On Site
Hybrid
$40-$100/HR
Contract - Independent
Contract - W2

Skills

Database performance tuning
Health insurance
Extract
transform
load
Business process
Database design
Stored procedures
Performance tuning
Technical analysis
SaaS
Functional requirements
Test cases
Amazon S3
PL/SQL
Oracle
Data domain
Production support
Informatica
Snap Logic
Finance
Migration
Data
Java
Leadership
Evaluation
Interfaces
Design
Workflow
Replication
Amazon Web Services
Cloud computing
Software deployment
Documentation
Collaboration
Specification
Amazon Redshift
SQL

Job Details


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