Developer IV - Remote

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Genesis
10, is seeking the following. Apply via Dice today!

Genesis
10 is currently seeking a PL/SQL and ETL Developer - Fully Remote for a 6-month contract role with our healthcare client in Eagan, MN.

Compensation: $53.00 - $56.00 per hour W2, depending on skill and experience level.

• Strong SQL, PL/SQL, and Informatica
• Snap Logic is preferred, but we can train
• Data Integration
• Healthcare/PBM experience is highly desired

• Promote and apply ETL development best practices.
• Participate on (and may lead) projects where analysis of systems or data requires an in-depth evaluation of complex business processes, system processes, and industry standards.
• Experience with database design, querying, stored procedures, views, joins, and performance tuning.
• Understand Client Business Objectives and perform 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.
• Document 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 on 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 with AWS data services such as Red Shift, Aurora, S3, etc.
• SQL & PL/SQL expertise with Oracle database
• Performance tuning of data jobs and pipelines

• Minimum 7-10 years of IT Experience working in ETL and data domain.
• Only candidates available and ready to work directly as Genesis
  10 employees will be considered for this position.

• Access to hundreds of clients, most who have been working with Genesis
  10 for 5-20+ years.
• The opportunity to have a career-home in Genesis
  10; many of our consultants have been working exclusively with Genesis
  10 for years.
• Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)
• Behavioral Health Platform
• 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)

Genesis
10 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.

#DIG
10-MN