Senior Data Engineer (Python/Spark)

SR. DATA ENGINEER, SNOWFLAKE SCHEMA, AWS, SQL - DB2, SQL DEVELOPER
Full Time
BASED ON EXPERIENCE

Job Description

Data Engineer
Full time / Direct Hire
Location - !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 Employer
PESOL 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.

Dice Id : 90655605
Position Id : 22-00011
Originally Posted : 3 months ago
Have a Job? Post it

Similar Positions

Sr. Data Engineer (Airflow and SparK)
  • Motion Recruitment
  • Irvine, CA, USA
Airflow and Spark, Sr. Data Engineer
  • Motion Recruitment
  • Los Angeles, CA, USA
Senior Data Engineer / Python / PySpark / Kafka
  • Motion Recruitment
  • Los Angeles, CA, USA
Senior Data Engineer
  • Jobot
  • Irvine, CA, USA
Senior Data Engineer
  • Infinity Consulting Solutions
  • Santa Ana, CA, USA
Senior Data Engineer (Airflow and Spark)
  • Motion Recruitment
  • San Diego, CA, USA
Sr ETL Data Engineer
  • Kaygen Inc
  • Costa Mesa, CA, USA
Sr Data Engineer
  • The Walt Disney Company
  • Santa Monica, CA, USA
Sr Data Engineer
  • The Walt Disney Company
  • Santa Monica, CA, USA
Senior Data Engineer
  • The Walt Disney Company
  • Santa Monica, CA, USA