ETL BI SQL Developer (Need to do Coding test)

Incorporan Inc
Mountainview, CA
15 Aug 2024

Vacancy expired!

Job Title:

ETL BI SQL Developer (Need to do Coding Test)

Location:

Mountain View, CA (Onsite)

Duration: 12+ Months

Note: Candidate must do the below coding test for submitting the profile to the client.

Test Link : http://hr.gs/g-backend-test

Job Description:
  • 6+ years of experience in core Java, with 3 or more related areas of:
  • Cloud SQL or MySQL
  • Big Query,
  • BI and analytics, Plx scripts, Workflows,
  • Distributed query engines (similar to Google Dremel/F1),
  • Hybrid database engines (SQL/ NonSQL),
  • Distributed SQL database management (similar to Spanner).
  • 6+ years of hands-on experience in managing data warehouse/data mart/data lakes preferably in cloud
  • Knowledge and experience in 5 or more related areas of:
  • Dimensional Modeling & Data Warehousing
  • Cloud identity and access management
  • Defining fine grained granular/row/column level access policies
  • Monitoring cloud quota policies
  • Synchronous data replication systems and troubleshooting data latency
  • Data filtering views, materialized views
  • Scheduling and troubleshooting of automated jobs/ backups/PubSub (asynchronous event listening) - example BorgCron
  • Defining data schemas/ metadata/ data slices
  • ETL jobs/pipelines in core Java and Python (similar to Clarinet, Replicator)
  • Monitoring of sync services/ events and APIs across multiple systems/
  • Data Security enforcement, provisioning and monitoring services
  • Functional knowledge of Corporate Finance Structure, HR Functional Structure to start with.
  • Experience in working on large user permission management systems across large/diverse data assets/objects and performing authorization/policy checks - (preferred)
  • past google experience is a plus

Thanks & Regards,

Vineeth Akula

Recruitment Lead

239, New Road, Building B, Suite 206,

Parsippany, NJ : 07054

Phone:

E-mail: vineeth@incorporaninc.com

www.incorporaninc.com"This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thanks for your cooperation."
  • ID: #44888235
  • State: California Mountainview 94035 Mountainview USA
  • City: Mountainview
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2022-08-15
  • Deadline: 2022-10-09
  • Category: Et cetera