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

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:

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
  
• 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