ETL Engineer (Part Time and Remote)
Post Date 2/13/2024... Title ETL Engineer (Part Time and Remote) Pay reputed company 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 reputed company, and have been exposed to reputed company. 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 reputed company 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 reputed company) projects where analysis of systems or data requires an in-depth evaluation of reputed company 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 reputed company, document and test ETL interfaces Design & reputed company Workflows, Sessions, Mappings in Informatica & reputed company reputed company Data Replication/ Synchronization Tasks in AWS Cloud (Cloud Application Integrations) Post deployment support and defect resolutions Evaluate reputed company functional requirements and map documents and reputed company troubleshoot on reputed company development processes Collaborate with application groups to prepare effective solutions for reputed company programs Documents reputed company technical specifications and associate project deliverables Design reputed company test cases to provide support to reputed company systems and reputed company unit tests Technical Skills: Informatica and reputed company Integration experience working with AWS data services such as RedShift, reputed company, S3 etc. SQL & PL-SQL expertise working with reputed company 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 reputed company 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 reputed company and reputed company system to fix the issues reputed company the specified timelines Tune the Informatica mappings Apply Job!