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

NXlMS1d5TXJsSU5tNGM5QTFLWUh1d0hxcmc9PQ==
  • Perfict Global
  • 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

Job Tags

Similar Jobs

BeMobile, Inc

Business Systems Developer Job at BeMobile, Inc

 ...BeMobile is proud to be Verizons Mid-Major Agent of the Year for both 2022 and 2023! We are currently seeking a Business Systems Developer to join our team in Peoria, IL. In this role, you will lead and execute technical projects that align with and support strategic... 

DataAnnotation

Data Analyst Job at DataAnnotation

 ...train AI chatbots while gaining the flexibility of remote work and choosing your own schedule. We are looking for a proficient Data Analyst to join our team to train our AI chatbots to code. You will work with the chatbots that we are building in order to measure... 

NOKIA

OptoElectronic Integration Coop (, NJ, United States) Job at NOKIA

 ...circuits Familiarity with photonic circuit design tools Join us in creating technology that helps the world act together. Nokia is committed to innovation and leadership in mobile, fixed, and cloud networks. Your career here will positively impact lives and help... 

Ledgent Technology

MSP L2 Remote Desktop Support Technician (San Jose) Job at Ledgent Technology

 ...Hello, I am reaching out today because we are looking to hire a Remote Tier 2 Helpdesk Support Technician with MSP Support experience. I was wondering if you or someone you know is in the market for a new opportunity. Here is a brief summary of the Job Description... 

Schneider

CDL-A Company Driver - 1-5mo EXP Required - Dedicated - Dry Van - Schneider Job at Schneider

 ...CDL-A - Dedicated truck driver - Coca-Cola. Dedicated truck driver - Coca-Cola Average pay: $1,050-$1,300 weekly Home time...  ...A driving experience. Need CDL training? Explore our company-paid CDL training programs or call us at (***) ***-****, and we...