GCP Big Query Datawarehouse Engineer

PB Consulting

Research Triangle Park, NC/ San Jose, CA

Posted On: Nov 07, 2023

Posted On: Nov 07, 2023

Job Overview

Job Type

Contract - Corp-to-Corp, Contract - Independent, Contract - W2

Experience

10 - 12 Years

Salary

$65 Per Hour

Work Arrangement

Remote

Travel Requirement

0%

Required Skills

  • GCP Big Query Datawarehouse
  • SQL
  • Pl/SQL
  • Python/Java
  • CI/CD
  • Data Ingestion
  • Data Migration
Job Description

Responsibilities:

  • At least 5 years of solid experience in Data Migration using GCP Big Query
  • Experienced GCP Big Query Datawarehouse Professionals 
  • Expertise in Data Modeling and Schema Design
  • Need to know Partitioning, Clustering - on GCP 
  • Well versed with Database fundamentals - Inner Joins, Outer Joins, Views, Materialized views, Partitioning, Clustering
  • Proficient in Performance Tuning, writing cost optimized queries.
  • Experience in efficiently converting existing Informatica scripts to modularized GCP Big query code.
  • Well versed in ETL Tools: DBT (Ability to write Modular code)
  • Knowledge of Informatica to understand the existing code.                  
  • Scheduling tools - Control M
  • Data Ingestion – Five Tran, native Workday
  • Experience on working with on RDBMS like MySQL DB or PostgreSQL (Tables handling, SQL queries), Oracle (Database)
  • Onshore-Offshore team handling skills
  • Experience in using CI/CD tools like GIT, Maven, Jenkins

Good to have skills:

  • Capable of conceptualizing latest technology landscape requirement and drives technical solution.
  • Strong understanding of various Technology components and their capabilities
  • Problem solving skills to resolve complicated technical challenges to provide effective solution and trouble shooting.
  • Ability to clearly and effectively communicate design processes, ideas, and solutions to teams and clients.
  • HR Domin & Workday experience is added advantage. 
  • Experience in delivering products through Agile Methodologies
  • Works in a team covering business and technology with representatives from client to produce the overall quality delivery.
  • Strong knowledge on activities of every phase in the delivery from requirement analysis to product release and postproduction support.
  • Ability to prioritize and manage several milestones and projects efficiently

Must Have:

  • Programming skills: GCP Big Query Datawarehouse, SQL, Pl/SQL, Python/Java
  • Data Base: Oracle, MySQL
  • Other Skillset:  ETL, DBT, Informatica
  • Scheduler: Control M
  • Data Ingestion: Five Tran, native Workday
  • CI/CD : Git, Jenkins, Maven or similar tools, Data Base versioning 

 


Job ID: PC230212


Posted By

Naincy

Recruiter