GCP BigQuery Professional
Infosys · Bengaluru, Karnataka, India
Infosys · Bengaluru, Karnataka, India
Educational Requirements Bachelor of Engineering,BTech,BCA,BSc,MTech,MSc,MCA Service Line Data Analytics Unit Responsibilities - Data Warehousing BigQuery Development - Design and implement data warehouse solutions using Google BigQuery - Develop, optimize, and maintain complex SQL queries and data models - Create efficient partitioning, clustering, and indexing strategies - Data Pipeline Development - Build scalable data pipelines using GCP services (Dataflow, Dataproc, Cloud Composer) - Perform data ingestion from various sources (APIs, databases, cloud storage) - Ensure data transformation, cleansing, and validation - Performance Optimization - Optimize BigQuery queries for cost and performance - Monitor query execution and tune workloads - Implement best practices for storage and compute efficiency - Integration ETL/ELT - Implement ETL/ELT workflows using BigQuery, Cloud Storage, Pub/Sub - Integrate data from multiple cloud and on-prem systems - Automate workflows and scheduling - Collaboration Reporting - Work closely with data analysts, data scientists, and business teams - Support reporting tools like Looker, Data Studio (Looker Studio), Tableau - Translate business requirements into scalable data solutions Technical and Professional Requirements: Tech-GCP, Big Query Preferred Skills: - Foundational->Development process generic->Big Data Analytics Process->Big Data - Technology->Cloud Platform->GCP Core Services