Oracle PL/SQL Database developer

1 month ago

Pleasanton, United States Mastech Digital Full time

POSITION: Oracle PL/SQL database developer

LOCATION: Alameda Pleasanton CA 94588 (Partial Remote)

DURATION: 12+ months, with potential to extend.

Pay: $55- 59/hr on W2

We are seeking a mid to senior level higly motivated candidate to take ETL/Oracle DB 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.

Position: "Oracle Database Developer" or "ETL Developer with Oracle SQL and PL/SQL experience"

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

  • ETL Developer w/ Oracle/SQL

    4 weeks ago

    Pleasanton, United States Perfict Full time

    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...

  • ETL Developer w/ Oracle/SQL

    4 weeks ago

    Pleasanton, United States Perfict Full time

    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...

  • ETL Developer w/ Oracle/SQL

    4 weeks ago

    Pleasanton, United States Perfict Full time

    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...

  • PL/SQL Developer

    4 weeks ago

    Pleasanton, United States Perfict Full time

    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...

  • PL/SQL Developer

    4 weeks ago

    Pleasanton, United States Perfict Full time

    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...

  • PL/SQL Developer

    4 weeks ago

    Pleasanton, United States Perfict Full time

    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...

  • SQL Server Database Administrator

    4 weeks ago

    Pleasanton, United States Diverse Lynx Full time

    SQL Server Database Administrator Rate : $65/hr. Day 1 Onsite (Hybrid) and Location we can consider /Pleasanton. RGS ID creation date (dd-mmm-yy) Created Date: 8/16/2023 Job Title SQL Server Database Administrator Relevant Experience (in Yrs) 04 - 05 yrs Technical/Functional Skills Refer Roles tab below Experience Required 08 - 10 yrs Roles &...

  • SQL Server Database Administrator

    1 week ago

    Pleasanton, United States Diverse Lynx Full time

    SQL Server Database Administrator Rate : $65/hr. Day 1 Onsite (Hybrid) and Location we can consider /Pleasanton. RGS ID creation date (dd-mmm-yy) Created Date: 8/16/2023 Job Title SQL Server Database Administrator Relevant Experience (in Yrs) 04 - 05 yrs Technical/Functional Skills Refer Roles tab below Experience Required 08 - 10 yrs Roles &...

  • SQL Server Database Administrator

    2 days ago

    Pleasanton, United States Diverse Lynx Full time

    SQL Server Database Administrator Rate : $65/hr. Day 1 Onsite (Hybrid) and Location we can consider /Pleasanton. RGS ID creation date (dd-mmm-yy) Created Date: 8/16/2023 Job Title SQL Server Database Administrator Relevant Experience (in Yrs) 04 - 05 yrs Technical/Functional Skills Refer Roles tab below Experience Required 08 - 10 yrs Roles &...

  • SQL Database Administrator

    2 days ago

    Pleasanton, United States Pomeroy Full time

    **Title**: SQL DBA **Company**: Pomeroy **Location**:Pleasanton, CA 94588 (Hybrid: 2-3 per MONTH onsite) **Pay Rate**:$45-50/hr **Duration**: 6+ months **Job Summary**: **Responsibilities**: - SQL Server database administration, configuration, load balancing, performance tuning, backup and recovery. - Database sizing and space management, SQL and...

  • Oracle HCM Technofunctional consultant with OIC

    1 week ago

    Pleasanton, United States Avance Consulting Full time

    Job DescriptionJob DescriptionJob DescriptionShould have Core HR expertise as well as experience in one or more of the following: Absence Management, Time and Labor, Benefits, Compensation, Payroll, Talent Management, Learning or Recruiting.Experience with OIC is must.Specifically, they will be responsible for deliverables at every phase of the software...

  • Oracle HCM Technofunctional consultant with OIC

    7 days ago

    Pleasanton, United States Avance Consulting Full time

    Job DescriptionJob DescriptionJob DescriptionShould have Core HR expertise as well as experience in one or more of the following: Absence Management, Time and Labor, Benefits, Compensation, Payroll, Talent Management, Learning or Recruiting.Experience with OIC is must.Specifically, they will be responsible for deliverables at every phase of the software...

  • Oracle HCM Technofunctional consultant with OIC

    7 days ago

    Pleasanton, United States Avance Consulting Full time

    Job DescriptionJob DescriptionJob DescriptionShould have Core HR expertise as well as experience in one or more of the following: Absence Management, Time and Labor, Benefits, Compensation, Payroll, Talent Management, Learning or Recruiting.Experience with OIC is must.Specifically, they will be responsible for deliverables at every phase of the software...

  • Principal Java Developer

    2 weeks ago

    Pleasanton, United States Oracle Full time

    The role is for the Oracle’s Business Intelligence product Oracle Analytics Publisher that provides the industry's most comprehensive reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools.This role is to come up with creative and optimum solutions for issues encountered by the...

  • Principal Java Developer

    2 weeks ago

    Pleasanton, United States Oracle Full time

    The role is for the Oracle’s Business Intelligence product Oracle Analytics Publisher that provides the industry's most comprehensive reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools.This role is to come up with creative and optimum solutions for issues encountered by the...

  • Principal Java Developer

    3 weeks ago

    Pleasanton, United States Oracle Full time

    The role is for the Oracle’s Business Intelligence product Oracle Analytics Publisher that provides the industry's most comprehensive reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools.This role is to come up with creative and optimum solutions for issues encountered by the...

  • Principal Java Developer

    7 days ago

    Pleasanton, United States Oracle Full time

    The role is for the Oracle’s Business Intelligence product Oracle Analytics Publisher that provides the industry's most comprehensive reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools.This role is to come up with creative and optimum solutions for issues encountered by the...

  • Principal Java Developer

    7 days ago

    Pleasanton, United States Oracle Full time

    The role is for the Oracle’s Business Intelligence product Oracle Analytics Publisher that provides the industry's most comprehensive reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools.This role is to come up with creative and optimum solutions for issues encountered by the...

  • Principal (Full Stack) Java SW Developer

    1 week ago

    Pleasanton, United States Oracle Full time

    Business Data Intelligence is one of the fastest growing segments of the software industry. Business Data Intelligence Tools allow analytics and executives to get the information they need to make critical strategic decisions in a fast-paced rapidly changing business world. Our customers are typically users who are unfamiliar with database schema and...

  • Software Developer

    2 months ago

    Pleasanton, United States Oracle Full time

    Our team mission is “Driving for development productivity and operational excellence through AI and Machine learning technologies, we believe the big data inside Oracle can bring big business values to improve customer experience”. We have proven history to build product which brings true value to our customers and we realized there are many known and...