ETL Developer Job at Openkyber, California

M0U0NnUreVJXWXlhMlpzNnpqcUlvV0cxQUE9PQ==
  • 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

Talent Strategy

Controls Technician Job at Talent Strategy

 ...ladder logic programming. Skilled in creating and interpreting electrical schematics. Strong knowledge and experience with low-voltage systems, including troubleshooting and diagnosis. Competence in operating hand tools, power tools, soldering equipment, and... 

Domino's Franchise

Delivery Driver- - 4510-A Sunset Road -Flexible Schedule Job at Domino's Franchise

 ...who want to join our team. Want to make good money from the seat of your own car AND listen to music? Delivery Drivers are paid cash nightly , which includes tips and mileage reimbursement . Qualifications Drivers License of at least 1 year Must... 

Tidewater Consulting

Entry Level Marketing Job at Tidewater Consulting

 ...our top industry leading clients. Our Business Development team is offering an extraordinary entry level roles for green professionals. We are looking for ambitious and creative forward thinkers, that will engage directly with clients in order to contribute fresh ideas... 

Randstad USA

Associate creative director Job at Randstad USA

 ...Location: Kohler, WisconsinJob Type: ContractCompensation Range: $45 - 50 per hourWe are seeking an Associate Creative Director (ACD) to lead and execute high-impact creative initiatives across all major platforms, including digital, print, experiential, and social media... 

Xtream Adminz

Remote Healthcare Recruiter Job at Xtream Adminz

 ...JOB DESCRIPTION We are looking to add a few new recruiters to our team. Preferably recruiters with a min of 1 year of experience, with...  ...to welcoming new recruiters who may not have experience in healthcare recruiting but have experience in other related fields such as...