ETL Developer with Informatica

Genesis10; Eagan (MN); Remote; USD 100,000 - 125,000; Full time

Job summary

Genesis10 is seeking an ETL Developer with Informatica for a 6-month remote contract. The role involves promoting ETL best practices, developing and testing ETL interfaces, and collaborating with application groups. Ideal candidates have 7-10 years of experience in the ETL domain.

Benefits

Medical

Dental

Vision

Health Savings Account

401K

Sick Pay

Commuter Benefits

Qualifications

• Minimum 7-10 years of IT Experience working in ETL and data domain.
• Experience working with Informatica and SnapLogic toolset.

Responsibilities

• Promote and apply ETL development best practices.
• Develop, document and test ETL interfaces.
• Collaborate with application groups to prepare effective solutions.

Skills

Informatica

Data Integration

SQL

PL/SQL

Technical Expertise

Tools

SnapLogic

AWS

Job description

Genesis10 is currently seeking an ETL Developer with Informatica for a 6 month contract with our client in Minneapolis, MN. This is a 100% remote role.



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:

• Informatica is Required


• Snap Logic is preferred, but can train


• Data Integration


• SQL


• PL/SQL


• Healthcare/PBM


• 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

Working Experience

Minimum 7-10 years of IT Experience working in ETL and data domain



Compensation:

Hourly W2 pay rate $55.00-60.00/Hr.



We have access to additional contract, contract-to-hire, and direct hire positions with various rate ranges.



If you have the described qualifications and are interested in this exciting opportunity, apply today!



Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and

employees to work across the United States every year-in contract, contract-for-hire, and permanent placement roles. With more than 300

active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum

of industry verticals.



Benefits of Working with Genesis10:

* Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years.

* The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for

years.

* Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)

* Medical, Dental, Vision

* Health Savings Account

* Voluntary Hospital Indemnity (Critical Illness & Accident)

* Voluntary Term Life Insurance

* 401K

* Sick Pay (for applicable states/municipalities)

* Commuter Benefits (Dallas, NYC, SF, and Illinois)

* Remote opportunities available



For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as

a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career

opportunities, please visit us at our website.



Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual

orientation, gender identity, national origin, disability, or status as a protected veteran.