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

• Experience working with Informatica and Snap Logic 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

• Informatica and Snap Logic
• Integration experience working with AWS data services such as Red Shift, 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

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