GCP BigQuery Developer

Infosys; Bengaluru; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

Infosys in Bengaluru is looking for a Data Engineer to design, develop, and optimize BigQuery-based data warehouses and ETL/ELT pipelines using GCP services. Candidates should possess a strong background in SQL, data modeling, and good understanding of data warehousing concepts.

The role requires collaboration with data analysts and scientists to ensure data quality and cost efficiency within GCP. Preferred qualifications include a Bachelor's degree in a relevant field and familiarity with core GCP tools.

Qualifications

• Bachelor's degree in Engineering, Computer Science, IT or related field is required.
• GCP certifications (e.g., Professional Data Engineer) are a plus.
• Strong experience with Google BigQuery and data warehousing concepts.

Responsibilities

• Design, develop, and optimize BigQuery-based data warehouses.
• Build and maintain ETL/ELT pipelines using GCP services.
• Write efficient, complex SQL queries for data transformation.

Skills

BigQuery expertise

Advanced SQL proficiency

GCP services knowledge

ETL/ELT pipeline development

Data warehousing concepts

Education

Bachelor of Engineering

Bachelor's degree in Computer Science, IT, or related field

Tools

Google Cloud Platform (GCP)

Cloud Composer (Airflow)

Dataflow

Terraform

Data visualization tools (Looker, Tableau, Power BI)

Job description

Educational Requirements

• Bachelor of Engineering

Service Line

• Data Analytics Unit

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

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
• Bachelors degree in Computer Science, IT, or related field
• GCP certifications (e.g., Professional Data Engineer) are a plus

Technical and Professional Requirements

• 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

Preferred Skills

• Technology->Cloud Platform->GCP