Required Skills

ETL

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 17th Apr 2025

JOB DETAIL

Remove/unsubscribe  |  Update your contact and subscribed mailing list(s)  |  Subscribe to mailing list(s) to receive requirements & resumes


From:
aftab,
convextech
aftab@convextech.com
Reply to:   aftab@convextech.com
 

 

     Hope you are doing good.

Please let me know if you are interested in the below position.!!

                                                                                                                   

Position : ETL/Database Developer

Location : Sacramento, CA Hybrid

Duration: 6 MOMTHS

Visa         : USC/GC/EAD

Interview mode:: video

 

Job Description

 

Key Duties/Responsibilities:

* Performs ETL and database development activities for the Enterprise Data Warehouse in the Oracle Cloud Infrastructure, Oracle Autonomous Data Warehouse Environment

* Reviews existing architecture and provides solution recommendations where applicable

* Developed tests, and implemented scripts/jobs for data Extract, Transform and Load (ETL) from data source(s) to target(s) in the data warehouse using ODI

* Design, develop, and optimize ETL processes using Oracle tools and technologies

* Create and maintain data pipelines to extract data from various sources, transform it according to business rules, and load it into Oracle data warehouses

* Collaborate with data analysts and business stakeholders to understand data requirements and implement appropriate solutions

* Troubleshoot and resolve data quality issues and performance bottlenecks

* Document ETL processes, data mappings, and data lineage

* Implement data quality checks and validation procedures

* Participate in code reviews and adhere to best practices in ETL development

* Hands-on experience working with and managing Oracle's Autonomous Data Warehouse (ADW) service

* Develops physical data model and/or works with data modeler to develop physical data model

* Develops Testing Approach, Plan, Scripts and Documentation of Results

* Participates in developing Requirements Specifications

* Participates in developing Design Specifications

* Monitors the EDW and responds to incidents

* Provides documentation to support the Kimball Dimensional Data Modeling Framework

* Mentors and educates team members on best practices and industry standards

Company Information