Urgent requirements for Senior ETL/Database Developer – Contract C2C jobs – Sacramento, CA

Senior ETL/Database Developer – Contract C2C jobs – Sacramento, CA

Senior ETL/Database Developer


Sacramento, CA


Contact

Hybrid role – weekly 3 days onsite   

H1B/H4 EAD/L2 EAD/USC Only

Local to CA Consultant

Requirements:

•                    Senior hands-on ETL/Database Developer with strong communication skills.

•                    Detail oriented ability to independently extract, transform, and load a Oracle ADW data warehouse environment with minimal supervision

•                    Ability to translate business and functional requirements into technical requirements for a Data Warehouse.

•                    Candidate needs to be able to demonstrate, direct hands-on recent practical experience in the areas identified with specific examples.

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

•                    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

Qualifications:

Mandatory:

•                    Staff resource must have a minimum of seven (7) years of verifiable experience in database design, development, and warehouse architecture supportive of key duties/responsibilities identified above in an Oracle environment

•                    At least two (2) years of experience in the last 6 years performing ETL development activities in a Oracle Autonomous Data Warehouse in a Oracle Cloud Infrastructure Environment.

•                    5 years experience performing development in Oracle data warehouses within the last 10 years

•                    Excellent communication and collaboration skills to work effectively with technical stakeholders and team members.

•                    Proficient with various Oracle tools used to perform ETL, performance management, and tuning for an Oracle Data Warehouse and Oracle Cloud Infrastructure Environment.

•                    Strong proficiency in Oracle Database, PL/SQL, and SQL

•                    Experience with Oracle Data Integrator (ODI) or Oracle Golden Gate

•                    Solid understanding of data warehousing concepts and dimensional modeling

•                    Familiarity with Oracle Business Intelligence Enterprise Edition (OBIEE) is a plus

•                    Strong analytical and problem-solving skills

•                    Ability to develop and perform Extract, Transform and Load (ETL) activities using Oracle tools with at least 5 years ETL experience.

Desired:

•                    Certified for “Oracle Autonomous Database Cloud 2021 Certified Specialist” and/or “Oracle Machine Learning using Autonomous Database 2021 Certified Specialist”

•                    Certified on Oracle Cloud infrastructure 2021 certified architect professional

•                    Certified for Oracle data integrator 12C certified implementation specialist

•                    Ability to perform technical leadership of a Oracle data warehouse team including but not limited to data modeling, requirements solicitation, DBA, data warehouse administration, and data analysis on a hands-on basis.

Thanks and Regards,

Parthasarathy T

Team Lead

sarathy@rdsolutionsinc.com

sarathyengg2009@gmail.com

Phone: 732-348-1384

Read more:

Daily Updated top 2000k+ VENDOR LISTS

Top 500+ USA JOBS HOTLIST

top staffing companies in usa

Updated bench sales hotlist

More Corp to corp hotlist

Join linkedin 58000+ US Active recruiters Network

Join No.1 Telegram channel for daily US JOBS and Hotlist Updated

About Author

JOHN KARY graduated from Princeton University in New Jersey and backed by over a decade, I am Digital marketing manager and voyage content writer with publishing and marketing excellency, I specialize in providing a wide range of writing services. My expertise encompasses creating engaging and informative blog posts and articles.
I am committed to delivering high-quality, impactful content that drives results. Let's work together to bring your content vision to life.

Leave a Reply

Your email address will not be published. Required fields are marked *