ETL Developer

York Solutions, LLC; South Carolina; Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

BCBS Medical plans

Delta Dental plan

Eye Med Vision plan

Life and Accidental Death Insurance

401(k) Retirement Plan

Voluntary Insurance programs

Flexible work environment

Teamwork culture

Learning and development opportunities

Job summary

A prominent IT solutions company located in South Carolina is seeking an experienced ETL Developer to enhance their data processing capabilities. The role involves designing and developing workflows using Informatica and SnapLogic, troubleshooting ETL jobs, and performing database optimization. Candidates should possess a minimum of 3-5 years in the IT sector focusing on ETL and data. Benefits include comprehensive medical plans, flexible work options, and opportunities for professional development.

Qualifications

• Minimum 3-5 years of IT experience working in ETL and data domain.
• Experience with database design, querying, stored procedures, views, and performance tuning.
• Ability to provide sporadic production support if any issues reported.

Responsibilities

• Promote and apply ETL development best practices.
• Design & develop workflows, sessions, and mappings in Informatica & SnapLogic.
• Evaluate all functional requirements and perform troubleshooting on all development processes.

Skills

Informatica

SnapLogic

SQL & PL-SQL

Performance tuning

Database design

ETL development

Tools

Oracle database

Job description

Description

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

Skills

• 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

Technologies

• Informatica and SanpLogic
• SQL & PL-SQL expertise working with Oracle database
• Performance tuning of data jobs and pipelines

Broad Working Experience

• Minimum 3-5 years of IT Experience working in ETL and data domain

Benefits

• BCBS Medical with 3 Plans to choose from (PPO and High deductible PPO plans with Health Savings Program)
• Delta Dental plan with 2 free cleanings and insurance discounts
• Eye Med Vision with annual check-ups and discounts on lens
• Life and Accidental Death Insurance paid by company
• John Hancock 401(k) Retirement Plan with discretionary company match
• Voluntary Insurance programs such as: Hospital Indemnity, Identity Protection, Legal Insurance, Long Term Care, and Pet Insurance.
• Flexible work environment with some remote working opportunities
• Strong fun and teamwork environment
• Learning, development, and career growth