Quantiphi Analytics - Technical Lead - SQL/BigQuery (4-10 yrs) Bangalore/Mumbai (Analytics & Data Science)
Quantiphi
Bangalore
6d ago
source : hirist.com

Job Description :

  • Experts in SQL writing and performance optimization on BigQuery.
  • Experience in data validation.
  • Experience in large scale data migration projects - history loads, incremental loads
  • Ability to decipher the logic and identify the inputs and outputs associated with individual queries.
  • Ability to build wrapper scripts to facilitate execution of independent SQLs within BQ for functional testing and benchmarking.
  • Execute individual BQ scripts / procedures to validate functionality and capture performance benchmark.
  • Experience in tuning & optimizing SQL queries within BQ.
  • Strong troubleshooting skills to identify the root cause of performance bottlenecks.
  • Effectively articulate technical issues to Quantiphi tech lead and facilitate resolution.
  • Create scripts and perform data validation / consolidation across systems.
  • Technical skills : -

    Mandatory - Linux shell scripting, Bigquery, Python, (Postgres) SQL

    Nice to have - Connectivity of SAS, MSTR, Tableau to BQ

    Tech Lead :

  • Experienced in leading large teams, delegate tasks, consolidate status, and report back to the client.
  • Participate in daily scrum calls, track and report status, and receive hand-off from US team.
  • Prior knowledge with MPP data warehouse platforms like Teradata, Netezza or similar is a must, in addition to GCP skills.
  • Prior experience in data migration projects is essential. Should be adept in strategizing, executing and validating critical processes like historical loads, incremental loads etc.
  • Coordinate and track work assigned to the individual team members within respective teams,Assist team members with troubleshooting.
  • Ability to decipher the logic and identify the inputs and outputs associated with individual queries.
  • Ability to build wrapper scripts to facilitate execution of independent SQLs within BQ for functional testing and benchmarking.
  • Strong experience in tuning & optimizing SQL queries (partitioning, joins, redundant sqls- ) within BQ.
  • Strong troubleshooting skills to identify the root cause of performance bottlenecks
  • Create DDL script for instantiating BQ schema based on existing definitions in corresponding Netezza and Teradata schemas.
  • Create scripts to perform data validation / consolidation across systems.
  • Ability to oversee and assist client team in incorporating recommended optimization changes in their environment.
  • Technical skills : -

  • Mandatory - GCP certified data engineer, Linux shell scripting, Bigquery, Python, Postgres SQL
  • Nice to have - Connectivity of SAS, MSTR, Tableau to BQ

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form