GCP BigQuery Developer

Infosys; Pune District; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Infosys is seeking a GCP BigQuery Developer with 2-3 years of experience to design, build, and optimize scalable data solutions on Google Cloud Platform. The role focuses on BigQuery, SQL, and ETL/ELT pipelines within modern cloud architectures.

Candidate should be proficient in GCP services such as BigQuery, Cloud Storage, Dataflow/Dataproc, and Cloud Composer, with strong data warehousing knowledge and Python/PySpark experience. Pune-based role requiring on-site collaboration.

Qualifications

• 2-3 years of experience as a GCP BigQuery Developer or similar role.
• Strong expertise in BigQuery, SQL, and data pipeline development.
• 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 SQL queries for data transformation and analytics.
• Work with Airflow (Cloud Composer), Dataflow, or Dataproc for orchestration.
• Perform data modelling (star/snowflake) for analytics use cases.
• Optimize query performance and manage BigQuery costs.
• Integrate data from APIs, Cloud Storage, databases, and streaming sources.
• Implement data validation, quality checks, and monitoring.
• Collaborate with data analysts, data scientists, and business stakeholders.
• Ensure security and governance best practices within GCP.

Skills

BigQuery

SQL

ETL/ELT

Python/PySpark

Airflow / Cloud Composer

Data Warehousing

Data governance

CI/CD tooling

Education

Master of Computer Applications

Master of Technology

Bachelor of Engineering

Bachelor of Technology

Bachelors in CS/IT

Tools

GCP BigQuery

Cloud Storage

Dataflow/Dataproc

Cloud Composer (Airflow)

Terraform

Jenkins / GitHub Actions

Job description

Job Summary

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

Technical Requirements

• Strong experience with Google BigQuery
• Advanced proficiency in SQL
• Hands-on experience with GCP services: BigQuery
• Hands-on experience with GCP services: Cloud Storage
• Hands-on experience with GCP services: Dataflow / Dataproc
• Hands-on experience with GCP services: 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

Additional Responsibilities

• Experience with CI/CD tools (Cloud Build, Jenkins, GitHub Actions)
• Knowledge of data visualization tools (Looker, Tableau, Power BI)
• Familiarity with streaming data pipelines (Pub/Sub)
• Experience with Infrastructure as Code (Terraform)
• Understanding of data governance and access control in GCP
• GCP certifications (e.g., Professional Data Engineer) are a plus

Educational Requirements

• Master of Computer Applications
• Master of Technology
• Bachelor of Engineering
• Bachelor of Technology
• Bachelor's degree in Computer Science, IT, or related field

Preferred Skills

• Technology->Cloud Platform->GCP Core Services
• Technology->Cloud Platform->GCP Database

Service Line

• Data Analytics Unit