Infosys—GCP BigQuery Developer

Job description

Description: Design, develop, and optimize BigQuery-based data warehouses and data marts Build and maintain ETL/ELT pipelines using GCP services Write efficient, complex SQL queries for data transformation and analysis Work with Cloud Composer (Airflow), Dataflow, or Dataproc for pipeline orchestration Perform data modelling (star/snowflake schema) for analytics use cases Optimize query performance and manage BigQuery cost efficiency Integrate data from various sources (APIs, Cloud Storage, databases, streaming sources) Implement data validation, quality checks, and monitoring mechanisms Collaborate with data analysts, data scientists, and business stakeholders Ensure security and governance best practices within GCP Requirements: We are seeking a skilled GCP BigQuery Developer with 2–3 years of experience in building scalable data solutions on Google Cloud Platform (GCP). The ideal candidate should have strong expertise in BigQuery, SQL, and data pipeline development, with exposure to modern data engineering tools and cloud-based architectures. Responsibilities: Design, develop, and optimize BigQuery-based data warehouses and data marts Build and maintain ETL/ELT pipelines using GCP services Write efficient, complex SQL queries for data transformation and analysis Work with Cloud Composer (Airflow), Dataflow, or Dataproc for pipeline orchestration Perform data modelling (star/snowflake schema) for analytics use cases Optimize query performance and manage BigQuery cost efficiency Integrate data from various sources (APIs, Cloud Storage, databases, streaming sources) Implement data validation, quality checks, and monitoring mechanisms Collaborate with data analysts, data scientists, and business stakeholders Ensure security and governance best practices within GCP Skills: Strong experience with Google BigQuery Advanced proficiency in SQL Hands-on experience with GCP services: BigQuery Cloud Storage Dataflow / Dataproc Cloud Composer (Airflow) Experience in ETL/ELT pipeline development Good understanding of data warehousing concepts Familiarity with Python or PySpark for data processing Experience in performance tuning and query optimization Knowledge of data partitioning and clustering in BigQuery