Informatica Developer

Informatica Developer

Posted 1 day ago by 1766053427

Apply
Negotiable
Outside
Hybrid
USA
Apply
Amazon Aurora Amazon Web Services (AWS) Business Process Cloud Computing Cloud Technology Database Design Data Domain Data Integration Deployment Support Extract Transform Load (ETL) Financial Information eXchange (FIX) Protocol General Insurance Informatica Performance Tuning Pet Insurance Retirement Planning SnapLogic Software Development SQL (Programming Language) Technical Analysis Workflows

Summary: The Informatica Developer role involves utilizing ETL development best practices to manage and optimize data integration processes, particularly within healthcare and PBM sectors. The position requires collaboration on complex projects, technical analysis, and the development of ETL interfaces using Informatica and SnapLogic. Candidates should have extensive experience in database design and performance tuning, with a focus on AWS data services. The role offers a flexible work environment with opportunities for professional growth.

Key Responsibilities:

  • Promote and apply ETL development best practices.
  • Participate on (and may lead) projects requiring in-depth evaluation of complex business processes and industry standards.
  • Experience with database design, querying, stored procedures, views, joins, performance tuning.
  • Understand client business objectives and perform technical analysis responding to needs.
  • Develop, document, and test ETL interfaces.
  • Design & Develop Workflows, Sessions, Mappings in Informatica & SnapLogic.
  • Develop Data Replication/Synchronization Tasks in AWS Cloud.
  • Post deployment support and defect resolutions.
  • Evaluate functional requirements and perform troubleshooting on development processes.
  • Collaborate with application groups to prepare effective solutions.
  • Document all technical specifications and project deliverables.
  • Design test cases to support systems and perform unit tests.

Key Skills:

  • Informatica is required.
  • Snap Logic is preferred, but can train.
  • Data Integration.
  • SQL.
  • PL/SQL.
  • Healthcare/PBM experience.
  • Integration experience with AWS data services such as RedShift, Aurora, S3.
  • Performance tuning of data jobs and pipelines.
  • Minimum 7-10 years of IT experience in ETL and data domain.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: hybrid

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Skills Required:
? Informatica is Required
? Snap Logic is preferred, but can train
? Data Integration
? SQL
? PL/SQL
? Healthcare/PBM

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.

Technical Expertise
? 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
? Minimum 7-10 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

Apply
Similar Jobs
Loading data...