Google BigQuery Application Designer

About Accenture: Accenture is a global professional services company with leading capabilities in digital, cloud and security. Combining unmatched experience and specialized skills across more than 40 industries, we offer Strategy and Consulting, Interactive, Technology and Operations services-all powered by the world's largest network of Advanced Technology and Intelligent Operations centers. Our 514,000 people deliver on the promise of technology and human ingenuity every day, serving clients in more than 120 countries. We embrace the power of change to create value and shared success for our clients, people, shareholders, partners and communities. Visit us at www.accenture.com
Accenture | Let there be change
We embrace change to create 360-degree value
www.accenture.com

• 
  
• Project Role :Application Designer
• Project Role Description :Assist in defining requirements and designing applications to meet business process and application requirements.
• Management Level :10
• Work Experience :4-6 years
• Work location :Mumbai
• Must Have Skills :Google BigQuery
• Good To Have Skills :No Technology Specialization
• Job Requirements :
  • 
    
  • Key Responsibilities : 1 Create ETL pipeline using Bigquery, create best performing tables with partitioning/clustering etc enabled keeping best practices in mind 2 Write Complex SQL queries keeping execution cost in mind 3 Load data into BigQuery using files or by streaming one record at a time 4 Create, load, and query partitioned tables for daily time-series data 5 Implement fine-grained access control using roles and authorized views
    
  • Technical Experience : 1 Should have indepth understanding of Bigquery architecture, table partitioning, clustering, best practices, type of tables, best practices etc 2 Should know how to reduce BigQuery costs by reducing the amount of data processed by your queries 3 Should be able to speed up queries by using denormalized data structures, with or without nested repeated fields 4 Exploring and Preparing data using BigQuery 5 Implementing ETL jobs using Bigquery 6 Understanding of Bigquery ML
    
  • Professional Attributes : 1: Should have very good communication skill 2: Should have good analytical skills 3: Proficient in identifying, analyzing and solving problems 4: Good knowledge of any one database

15 years of full time education