ETL Developer Job at Openkyber, California

MlAvVGNYUjM5UnkwWFhXdTIwbGNob2FiN1E9PQ==
  • Openkyber
  • California

Job Description

Role: AWS Data Architect

Location : Toorance CA Onsite

Duration: Long Term

Developing CDM (Conceptual Data Model), LDM (Logical Data Model), PDM (Physical Data Model), data modeling, integration, data migration, and ETL development on the AWS platform.

Key skill

The role requires specific skills around developing CDM (Conceptual Data Model), LDM (Logical Data Model), PDM (Physical Data Model), data modeling, integration, data migration, and ETL development on the AWS platform.

Key Responsibilities
  • Architect and implement a scalable data hub solution on AWS using best practices for data ingestion transformation storage and access control
  • Define data models data lineage and data quality standards for the DataHub
  • Select appropriate AWS services S3 Glue Redshift Athena Lambda based on data volume access patterns and performance requirements
  • Design and build data pipelines to extract transform and load data from various sources databases APIs flat files into the DataHub using AWS Glue AWS Batch or custom ETL processes
  • Implement data cleansing and normalization techniques to ensure data quality
  • Manage data ingestion schedules and error handling mechanisms
Required Skills and Experience
  • AWS Expertise Deep understanding of AWS data services including S3 Glue Redshift Athena Lake Formation Sep Functions CloudWatch and EventBridge
  • Data Modeling Proficiency in designing dimensional and snowflake data models for data warehousing and data lakes
  • Data Engineering Skills Experience with ETLELT processes data cleansing data transformation and data quality checks Experience with Informatica IICS and ICDQ is a plus
  • Programming Languages Proficiency in Python SQL and potentially PySpark for data processing and manipulation
  • Data Governance Knowledge of data governance best practices including data classification access control and data lineage tracking

Thanks Ramesh

Job Tags

Similar Jobs

Center For Popular Democracy, Inc.

Development Director: Fundraising & Donor Relations Lead Job at Center For Popular Democracy, Inc.

 ...and collaborating with leadership to enhance funding opportunities. The organization values diversity and encourages applications from individuals who are underrepresented in the nonprofit sector. A competitive salary and benefits package are offered. #J-18808-Ljbffr... 

Social Discovery Group

Lead AI Trainer / Prompt Evaluator Job at Social Discovery Group

 ...( Social Discovery Group ((SDG)is the 3rd largest...  ....com, DateMyAge, Cupid Media, Dil Mil, Kiseki, and others...  ...and digital nomads works all over the world....  ...Lead AI Trainer / Prompt Evaluator tooversee and enhance...  ...equipping the working place at home (desk, chair, Internet,... 

Fairbury Public Schools

Anticipated HS Assistant Principal and Athletic/Activities Director Job at Fairbury Public Schools

 ...anticipated full-time position is designed for an innovative educational leader who is committed to fostering a positive school culture...  ...contracting, budgeting, and compliance with regulations. Coordinate and supervise extracurricular activities, events, and... 

PrepScholar

SAT/ACT Tutor Job at PrepScholar

 ...PrepScholar is looking for talented online tutors to teach the SAT and ACT to students all over the US and the world. If you're an experienced and engaging teacher who has mastered these tests and has at least 20 hours per week to offer, we want you.----- We're Looking... 

AbbVie

Director, U.S Policy, Government Affairs Job at AbbVie

 ...Tik Tok . Job Description The Director, U.S. Policy will support the U.S. Policy & Analytics team, the Federal Government Affairs (FGA) team and the Business...  ...federal legislative and regulatory developments related to commercial insurance and PBM reform. The...