NCINO. ETL DESIGN& TEST CONSULTANT. BANK

Job Description:

LOCATION: OFF-SITE 

We will look for team ETL consultants remote to execute two projects:

nCino (Nov/22 to Mar/23)

MUSA (Dec/22 to May/23). 

nCino Background

nCino is an underwriting and workflow/approval platform used by more than 1200 banks and credit unions . CIB US is considering implementing nCino given benefits such the ability to aide development of straight through processing, improving timeliness, controls, data quality and document management. 

The objective is these consultants is to build working software including all the objects that are going to communicate from nCino to Integration Layer and vice versa. 

nCino project:

  • 2x ETL Developer – Nov/22 to Mar/23 (may end up needing 3 Developers)
  • 1x ETL Tester  – Nov/22 to Mar/23

MUSA project:

  • 3x ETL Developer – Dec/22 to May/23
  • 1x ETL Tester  – Jan/23 to May/23

Role description

ETL Developer 

  • 5-8 Year of SQL,ETL Development Experience in Large Datawarehouse’s.
  • Should be able to take source to target DDR and be able to develop mappings independently.
  • Should be able to understand the scope of the work and ask clarifications and escalate to the right leads in case of issues/delays
  • Should have advance SQL skills. Including complex PL/SQL coding skills.
  • Should be able to navigate through Flat Files, UNIX Scripts
  • Should have prior experience working with Control-M/PowerCenter.

ETL Tester

  • 5-8 Year of SQL,ETL Testing Experience in Large Datawarehouse’s.
  • Should be able to take source to target DDR and be able to write SQL Test Cases independently.
  • Should be able to navigate through Flat Files, Assist in UAT Testing
  • Should have prior experience working with Control-M/PowerCenter.

ESTIMATED DURATION: ESTABLE. INDEFINIDO