GCP Developer
Infosys · Bengaluru East, Karnataka, India
- On site
- Full-time
- $120,000 / year
- Bengaluru East, Karnataka, India
Job highlights
- Develop and optimize GCP BigQuery data models.
- Write and optimize complex SQL queries.
- Build and maintain ETL/ELT data pipelines.
- Process large-scale structured and semi-structured data.
- Collaborate with business and analytics teams.
About the role
GCP BigQuery Data Engineer
Infosys is seeking a GCP BigQuery Data Engineer with 5-9 years of overall experience in data engineering/analytics engineering and at least 3 years of hands-on experience with GCP BigQuery.
Responsibilities:
- Design, develop, and optimize data models and datasets in Google BigQuery.
- Write and optimize complex SQL queries, views, and stored procedures in BigQuery.
- Build and maintain ETL/ELT pipelines using GCP services.
- Ingest and process large-scale structured and semi-structured data.
- Implement data transformations using BigQuery SQL and cloud-based data processing tools.
- Optimize query performance and cost using partitioning, clustering, and query optimization techniques.
- Integrate data from various sources including cloud storage, databases, APIs, and streaming sources.
- Work with Cloud Storage, Dataflow, Dataproc, or similar services.
- Ensure data quality, consistency, and reliability.
- Collaborate with BI, analytics, and business teams to meet data requirements.
- Support CI/CD, deployment, and monitoring of data pipelines.
Qualifications:
- 5–9 years of overall experience in data engineering / analytics engineering.
- 3+ years of hands-on experience with GCP BigQuery.
- Strong proficiency in SQL (BigQuery dialect preferred).
- Experience with Google Cloud Platform (GCP) services, such as: BigQuery, Cloud Storage.
- Dataflow / Dataproc experience is a plus.
- Solid understanding of data warehousing and analytics concepts.
- Experience with batch and near real-time data processing.
- Familiarity with data modeling techniques and large-scale datasets.
- Experience with Python or Shell scripting is preferred.
- Knowledge of Git and CI/CD practices.
- Strong analytical, debugging, and communication skills.
- GCP certifications (Professional Data Engineer / Associate Data Engineer) are advantageous.
- Experience with Looker, Data Studio, or other BI tools is a plus.
- Agile/Scrum working experience is preferred.
Key skills/competency:
- GCP BigQuery
- Data Engineering
- SQL
- ETL/ELT
- Data Modeling
- Data Warehousing
- Python
- Cloud Storage
- Dataflow
- CI/CD
Skills & topics
- GCP BigQuery
- Data Engineer
- Data Engineering
- SQL
- ETL
- ELT
- Data Modeling
- Data Warehousing
- Google Cloud Platform
- Cloud Storage
- Python
- Shell Scripting
- CI/CD
- Infosys
How to get hired
- Tailor your resume: Highlight your 5-9 years of data engineering experience, focusing on GCP BigQuery and SQL expertise.
- Showcase GCP skills: Emphasize hands-on experience with BigQuery, Cloud Storage, and ideally Dataflow/Dataproc.
- Quantify achievements: Use numbers to demonstrate your impact in optimizing queries, processing data, and building pipelines.
- Address soft skills: Mention your strong analytical, debugging, and communication abilities in your application.
- Prepare for technical interviews: Be ready to discuss data warehousing concepts, data modeling, and scripting.
Technical preparation
Master BigQuery SQL, partitioning, and clustering.,Practice writing complex ETL/ELT pipelines.,Review data modeling for large datasets.,Prepare for Python/Shell scripting challenges.
Behavioral questions
Describe a challenging data quality issue you resolved.,How do you optimize BigQuery query performance?,Explain your experience with CI/CD for data pipelines.,How do you collaborate with business and analytics teams?
Frequently asked questions
- What specific GCP services are most important for this GCP BigQuery Data Engineer role at Infosys?
- The most critical GCP services for this GCP BigQuery Data Engineer role are BigQuery and Cloud Storage. Experience with Dataflow or Dataproc is also highly valued and considered a plus.
- Does Infosys prefer a specific SQL dialect for this GCP BigQuery Data Engineer position?
- Yes, Infosys specifically prefers candidates with a strong proficiency in SQL, with a preference for the BigQuery dialect for this GCP BigQuery Data Engineer role.
- What level of experience is required for the GCP BigQuery Data Engineer role at Infosys?
- Infosys requires 5-9 years of overall experience in data engineering or analytics engineering, with at least 3 years of hands-on experience specifically with GCP BigQuery.
- Are Python or Shell scripting skills mandatory for the GCP BigQuery Data Engineer job?
- While not strictly mandatory, experience with Python or Shell scripting is preferred for this GCP BigQuery Data Engineer position at Infosys, as it aids in pipeline development and automation.
- What are the preferred certifications for the GCP BigQuery Data Engineer role at Infosys?
- While not mandatory, GCP certifications such as Professional Data Engineer or Associate Data Engineer are considered advantageous for this GCP BigQuery Data Engineer role.
- How important is experience with BI tools for this GCP BigQuery Data Engineer position?
- Experience with BI tools like Looker or Data Studio is a plus for this GCP BigQuery Data Engineer role, as it helps in understanding data requirements from BI and analytics teams.
- What is the typical work arrangement for a GCP BigQuery Data Engineer at Infosys?
- While not explicitly stated, roles at large IT service companies like Infosys often involve a hybrid or on-site work arrangement, depending on client and project needs for a GCP BigQuery Data Engineer.
- How does Infosys handle data quality and reliability for their GCP BigQuery Data Engineer projects?
- Infosys emphasizes ensuring data quality, consistency, and reliability through robust design, development, and optimization practices by their GCP BigQuery Data Engineers.