US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 17th Apr 2025
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