ETL Developer

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.
Qualifications for informatica developer
? 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.

Required Skills:
? Minimum 7-10 years of IT Experience working in ETL and data domain
? Informatica is Required
? Snap Logic is preferred, but can train
? Data Integration
? SQL
? PL/SQL
? Healthcare/PBM

Additional 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


Benefits:

York Solutions Offers a generous benefits package for eligible full-time employees:

• 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 up to 5%
  
• 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