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

ZDVUKzB4TEdXMDdKbkozRm9MaVVxYXVtc3c9PQ==
  • 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, and a fun company to work for! Job Description: We are seeking a senior level highly motivated candidate to take on the 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 requirements. 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 and quality. Works with source control and release processes. Provides production support, works with users, investigates issues, identifies the root cause, finds solutions, and works with other members of the team to implement the solutions. Owns projects, proactively monitors progress, takes accountability, and delivers in a timely manner. Skills Required: A total of 6-10 years of IT development experience. BS in Computer Science. 6 or more years of SQL development. Basic and Advanced SQL skills (tuning, analytic functions, ability to convert simple PL/SQL logic into SQL). 6 or more years of Oracle PL/SQL development. Basic knowledge of stored procedures, packages, functions, ref cursors, dynamic SQL. Advanced skills in 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 experience with 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, consume web services, and send emails. Other programming languages.

T-SQL.

Java, J2EE, Spring. Python, Django. JavaScript, HTML, and CSS. JSON, XML experience. Data visualization tools such as Tableau. Big Data (HDFS, Map/Reduce, etc.). Experience using machine learning algorithms. #J-18808-Ljbffr Perfict Global, Inc.

Job Tags

Similar Jobs

PL ASSOCIATES INC. (PLA)

Civil Engineer - Water, Wastewater, Drainage, hydrology & Civil Site Job at PL ASSOCIATES INC. (PLA)

 ...Job Description Job Description Job Title: Civil Engineer Civil Design (Water, Wastewater, Drainage, Hydrology, and Civil Site) Job Summary: We are seeking a highly motivated and detail-oriented Civil Engineer with experience in civil design, particularly... 

RRA Capital

Summer Analyst - Phoenix Job at RRA Capital

 ...Job Description Job Description Salary: Monthly Stipend Summer Analyst Internship Phoenix, AZ - We are in search of a Summer Analyst to support our small but world-class fund marketing, lending, and asset management teams. Our Leadership Development Program... 

Curam Staffing

Travel Anesthesia Technician - $1,320 per week Job at Curam Staffing

 ...Curam Staffing is seeking a travel Anesthesia Technician for a travel job in Rochester, New York. Job Description & Requirements ~ Specialty: Anesthesia Technician ~ Discipline: Allied Health Professional ~ Start Date: 10/27/2025~ Duration: 13 weeks ~40... 

Stability Healthcare

Local Contract Cath Lab Technician - $74 per hour Job at Stability Healthcare

 ...Healthcare is seeking a local contract Cath Lab Technologist for a local contract job in...  ...technicians are vital team members who assist doctors during invasive cardiovascular procedures...  ..., and electrophysiology. 2 years of experience required *$600 travel bonus *Day 1... 

HNTB

Environmental Planning Intern - Summer 2026 Job at HNTB

 ...limited to Science, Planning, Technology. This position is usually on a part-time, temporary, or co-op basis. Our Raleigh, North Carolina and Charleston, South Carolina Office is seeking Summer 2026 Interns for our Environmental Planning group. This opportunity entails...