Overview
On Site
$60 - $65
Contract - Independent
Contract - W2
Contract - 6 Month(s)
Skills
ETL Developer
Oracle database
AWR/ADDM reports
ETL
Data Modeling and Data Migration
Job Details
Title : ETL Developer
Location : San Leandro, 5 days onsite
W2 candidate only - only locals, Onsite interview,
Job Description / Responsibilities
- Responsible for designing and developing complex database and data integration (ETL) code for Customer Relationship View (CRV) application and its databases.
- Leads and/or performs analysis of CRV business requirements, designs and writes technical specifications to design or redesign database solutions.
- Develops complex PL/SQL Procedure, packages, Functions, Triggers, View and Materialized views
- Develops logical partition table design.
- Leads and/or performs data modeling, simulations and analysis efforts for CRV database development
- Performance tunes existing solution and assists with Production support in identifying bottlenecks and issues in current deployed solutions.
- Develops complex ETL code to interface Oracle with other database like SQL Server and text files.
- Builds framework for ETL process.
- Verifies program logic by overseeing the preparation of test data, testing and debugging of programs. Participates in overall systems testing.
- Provides application support for application/SOR data or database code/server related issues.
- Provides technical support for nightly batch and ETL processes through periodic rotation of such responsibility among all team members.
- Develops new documentation, participates in the development of department technical procedures and designs user guides.
- As an escalation point for CRV application support and troubleshooting, provides guidance and direction to less experienced staff in resolution of escalated issues and/or complex production, application or system problems.
- Assures quality, security and compliance requirements are met for CRV database and servers and participates in updating and testing of the business continuation.
- This role will partner with the business team to produce Functional System Design Documents for database projects that requires one and will facilitate meetings to gather information to document software requirements and design and support the QA team in their testing activities.
Minimum Qualification:
- 4+ years hands on Oracle database and hands on experience in Oracle 19c database design and development experience including advanced SQL and PL-SQL development
- 2+ Years of experience in designing development and implementation of ETL, Data Modeling and Data Migration.
- 1+ years' experience administering Oracle databases
- Have knowledge on real time replication.
- Strong experience in translating AWR/ADDM reports for optimization purpose.
- Have strong experience in Database catalogs.
- Knowledge in developing database solutions using Optimized SQL and tuning existing SQLs
- Knowledge on Oracle Table partitioning.
- Experience with data management, versioning of data.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.