ETL Developer with Informatica

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.