Required Skills

ELT Snowflake Redshift DataStage Informatica Ab-Initio SQL CI/CD pipeline

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 21st Jan 2021

JOB DETAIL

  1. Ability to create DBT projects and DBT common projects
  2. Ability to create DBT standards and best practices
  3. Ability to create macros for common functions
  4. DBT test automation
  5. Ability to leverage DBT out of the box utils and create new packages as needed

 

 

Requirements

  • Bachelor's Degree or master’s degree in Computer Science.
  • 10+ years of hands-on software engineering experience.
  • 2 years of strong ELT experience using Data Build Tool (DBT) loading to Cloud DW Snowflake / Redshift.
  • 3+ years of strong ETL experience on either DataStage, Informatica, Ab-Initio, Talend etc.is plus
  • Experience in designing solutions for multiple large data warehouses with a good understanding of cluster and parallel architecture as well as high-scale or distributed RDBMS
  • Strong database fundamentals including SQL, performance, and schema design.
  • Proficiency in SQL coding
  • Ability to interpret/write Python scripting is a plus.
  • Experience with AWS platform big plus
  • Experience with Git.
  • Experience building CI/CD pipeline is plus
  • To be able to work in a fast-paced agile development environment.

 

Company Information