09 Sep
|
Infosys
|
Bengaluru
Educational Requirements
- Bachelor of Engineering,BTech,BSc,BCA,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
Additional Responsibilities
- Experience with real-time data streaming
- Knowledge of data governance, security, and IAM in GCP
- Familiarity with CI/CD pipelines and DevOps practices
- Certification in Google Cloud (e.g., Data Engineer Associate/Professional)
Technical and Professional Requirements
- Primary skills:Technology- >Cloud Platform- >GCP, BIG QUERY
Required Skills Qualifications
- 35 years of experience in data engineering / BigQuery development
- Solid expertise in SQL (mandatory)
- Hands-on experience with Google BigQuery
- Experience with data modeling (star/snowflake schemas)
- GCP Tools Services
- BigQuery
- Cloud Storage
- Dataflow / Dataproc
- Pub/Sub
- Cloud Composer (Airflow)
- Programming Skills
- Proficiency in Python / SQL scripting
- Experience with Spark (PySpark) is a plus
Preferred Skills
- Technology- >OpenSystem- >Python - OpenSystem
- Technology- >Cloud Platform- >GCP Core Services- >GCP
📌 GCP BigQuery Professional (Bengaluru)
🏢 Infosys
📍 Bengaluru