• 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 :- 18th Apr 2025

· 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

· Develops, tests, and implements 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