Job Details

ID #45269813
State California
City Irvine
Job type Permanent
Salary USD BASED ON EXPERIENCE BASED ON EXPERIENCE
Source Platinum Enterprise Solutions
Showed 2022-08-29
Date 2022-08-28
Deadline 2022-10-27
Category Et cetera
Create resume

Senior Data Engineer (Python/Spark)

California, Irvine, 92602 Irvine USA

Vacancy expired!

Data Engineer Full time / Direct HireLocation - !00% Remote Requirements

  • Strong background on database development with a minimum of 5 year experience
  • Understanding OLTP vs OLAP, especially conceptual & logical data modeling on each side, 3NF vs Star Schema and normalization process with Armstrong Axiom's rule (Relational Algebra)
  • Extensive hands-on experience in database performance tuning with execution plan and profiling blocking issue on locks
  • Ability to deal with complex queries, recursion with CTE, Set operators (emphasizing on division operator) and Window Functions
  • Handling with high volume of transaction management with multi-threaded environment;
  • Understanding ACID property correctly and different isolation levels with pessimistic & optimistic locks
  • 2PL Strict or Rigorous Schedule on conventional RDBMS vs MVCC on cloud based database
  • Resolving deadlock issue with the best practice
    • Understanding Row store vs Column store and their pros & cons (NSM, DSM & PAX)
    • Acknowledging Data Warehousing methodology, Inmon, Kimball and Data Vault 2.0 and their pros & cons
    • Trending along with Data Lake, Data Hub, Data Mesh and Lakehouse and their pros & cons
    • Differentiating State Based vs Migration Based database migration approach with full CI/CD automation process
    • Hands-on experience with at least one of the following RDBMS; Oracle, MSSQL, Postgres, MySQL or Sybase
    • Hands-on experience with at least one of the following No-SQLs; HBase, Dynamo, CouchDB, MongoDB, Cassandra or Cosmos
    • Hands-on experience with at least one of the following cloud-native data warehouses; Redshift, BigQuery, Synapse or Snowflake
    • Hands-on experience of building data pipeline on at least one of the following cloud platforms; AWS, Azure or GCP
    • Python is preferable
Applicants must be authorized to work in the U.S.Please apply directly to by clicking 'Click Here to Apply' with your Word resume!Looking forward to receiving your resume and going over the position in more detail with you.The Platinum Team!Platinum is proud to be an Equal Opportunity EmployerPESOL is an EEO employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, pregnancy, national origin, disability, age, genetic information, veteran status, sexual orientation and identity, AIDS/HIV, medical condition, political activities or affiliations, or status as a victim of domestic violence, assault, or stalking.Your Right to Work - In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.Copyright 2006 - 2018. Platinum ESOL, Inc. All rights reserved.

Vacancy expired!

Subscribe Report job