Oracle Database Developer / ETL Developer Job at Perfict Global, Inc., Pleasanton, CA

THdSY0ZkdXh0RjJNQWtvZ3pIZi9rUWhMSWc9PQ==
  • Perfict Global, Inc.
  • Pleasanton, CA

Job Description

About Us: Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in implementation activities and collaborate in new ways to meet client needs. We provide excellent benefits such as Medical, Dental, Vision ++ a fun company to work!!! 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 6-10 years of IT development experience with
  • BS Computer Science
  • 6 or more years of SQL development
  • Basic and Advanced (tuning, Analytic functions, ability to convert simple PL/SQL logic into SQL)
  • 6 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
  • 6 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
Skills Desired:
  • Health Care domain experience
  • Experience with Oracle configuration to add HS services, to be able to consume Web Services, to send emails.
  • Other programming languages

- T-SQL

  • Java, J2EE, Spring
  • Python, Django
  • Java Script, HTML and CSS
  • JSON, XML experience
  • Data Visualization tools such as Tableau
  • Big Data HDFS, Map/Reduce etc.
  • experience using Machine Learning algorithms Perfict Global, Inc.

Job Tags

Similar Jobs

SNBC(S)

(Chinese speaking) presales technical support Job at SNBC(S)

Connect with customers for product needs and be the contact point for technical requirements and quality issues with internal and external channels.Manage product spare parts.Responsible for remote technical support and on-site business trips within Europe. Communicate...

FedEx Services

Courier/swing drvr/dot-1 Job at FedEx Services

 ...school diploma/GED. Minimum Experience Six (6) months courier experience preferred. Must be able to demonstrate area knowledge...  ...outlined in the federal motor carrier safety regulations. Requires medical exam in accordance with FMCSA or FAA regulations. Note: there... 

The LaSalle Group

Service Desk Technician Job at The LaSalle Group

 ...Network is hiring a Service Desk Specialist for a contract role...  ...everyday tech issues, and helping end users feel like they've got...  ...Help desk or IT support experience (you've done this before)...  ...talent with opportunities, from entry-level positions to the C-suite. With... 

Versiti, Inc.

Investigator - Immunology Job at Versiti, Inc.

 ...improving the lives of patients and helping our healthcare partners thrive. Position Summary: Exciting Opportunities in Immunology Research The Versiti Blood Research Institute (VBRI) is seeking to recruit independent investigators at a level equivalent to... 

Club Z! Tutoring

Reading and Writing Tutor Job at Club Z! Tutoring

 ...Career Advancement Opportunities Great Work Environment Job Summary: We are seeking an energetic and experienced Reading and Writing Tutor to join our team! As a Tutor, you will assist students individually, helping them understand educational concepts,...