Source description
About the role
Role: Oracle Database Developer
Duration: 12+ month contract with good potential to extend up to 3 years Location: Hybrid in Pleasanton, CA (2-3 days/week onsite) Rate: 50/hr W2
Top Must Haves: Oracle Databases – 4+years SQL AND PL/SQL - 4+ years
Job Description: We are seeking a senior level highly motivated candidate to take ETL/Oracle Database developer position to work on a fast-paced team responsible for creating and maintaining high quality ETL processes to support a large data warehouse and a few dozen data marts, which are in an Oracle database. The person will be working on multiple development projects while providing support to existing processes in production.
Key responsibilities:
- works with users to collect requirement
- creates requirement, technical design and mapping documents
- develops, enhances, tests, and maintains Oracle SQL and PL/SQL code
- involves users and SMEs in validating the data for accuracy/quality
- works with source control and release processes
- provides production support, works with users, investigates issues, identifies the root cause, finds solutions, works with other members of the team to implement the solutions.
- owns his/her projects, proactively monitors the progress, takes accountability, delivers in timely manner
Skills Required: a total of 4+ years of IT development experience with
-
BS Computer Science - 4 or more years of SQL development - Basic and Advanced (tuning, Analytic functions, ability to convert simple PL/SQL logic into SQL) - 4 or more years of Oracle PL/SQL development - Basic (stored procedure, packages, functions, ref cursors, dynamic SQLs etc., dynamic PL/SQL) - Advanced (Table partition management automation, Table functions, Calling external programs, experience with Oracle built in utility programs) - 4 or more years of Data modeling - 4 or more years of ETL development (Using an ETL tool is not mandatory) - 2 or more years of Unix/Windows shell scripting - 4 or more years of Oracle DB client tools like Toad, SQL Plus etc. - Strong analytical and problem-solving skills - Ability to work with end users to troubleshoot production issues - Ability to work independently or in a team environment. - Willingness to learn new skills on the job
-
-- Thanks & Regards, Kalyan Sadanala| Talent acquisition specialist Thoughtwave Software and Solutions 314 N. Lake St, Suite 6, Aurora IL 60506 Desk: 6303132177, EXTN: 148 Text Message: 8722346381 Email: Kalyan@thoughtwavesoft.com Website: www.thoughtwavesoft.com Linked in: https://www.linkedin.com/in/kalyan-sadanala-21b678214/
More at Thoughtwave Software and Solutions