Epicareer Might not Working Properly
Learn More
G

Oracle PL/SQL Developer||Locals only from San Diego, CA// Tempe, AZ [2 days Onsite]

Salary undisclosed

Apply on

Availability Status

This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.


Original
Simplified

Title : Oracle PL/SQL Developer

Location : San Diego, CA// Tempe, AZ [2 days Onsite] [Locals only]

Type : 6+ month contract

Job Description:

Required Skills:

TECHNICAL

  1. 5+ years of experience in PL/SQL development (mid-senior level) specifically Oracle. PL/SQL is used for in-database processing and automation tasks within the Oracle ecosystem.
  2. Need to know Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
  1. Experience with Informatica- Informatica handles the data integration and ETL processes.
  2. Knowledge of Informatica best practices for Informatica PowerCenter, Data Transformation and Informatica B2B Data Exchange products. Strong in Informatica design concepts
  3. Experience with Shell programming on Linux

Official JD:

  • Excellent working knowledge and experience of SQL, Oracle PL/SQL, Unix Shell (or Perl or Python) programming languages.
  • Extensive proficiency in the modern RDBMS products Oracle (latest version). PostgreSQL is a plus
  • Experience with Informatica Platform and knowledge of Informatica best practices for Informatica PowerCenter, Data Transformation and Informatica B2B Data Exchange products. Strong in Informatica design concepts using its products
  • Strong ETL and data modeling experience. Proficient in creating mappings, workflows and implementing ETL concepts
  • Developed Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL
  • Experience of using Standard Oracle Packages (UTL_FILE etc.), Dynamic SQL, Records, Arrays, PL/SQL tables, File handling
  • Experience in SQL and PL/SQL Performance Tuning, query rewriting, use of Explain Plan and Hints
  • Expertise in Collections, Exception Handling, Partitioning techniques, BULK features, Analytics functions, External tables
  • Solid experience and comfortable with UNIX/ Linux platform and sufficient commands
  • Agile working experience with Scrum and SDLC methodologies and the best practices. Experience with Atlassian products such as JIRA, Confluences, BitBucket.
  • Thorough working experience of DevOps, UC4, Maven, Jenkins, and CI/CD
  • Experience of the best practices utilizing object-oriented analysis and design principles
  • Good knowledge of the recent programming language and framework, such as Java, Angular or React, JPA, Spring Boot, XML and JSON. Knowledge and experience with API gateway (such as Gravitee) are a plus

Thorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications

Regards,

Pranshu Tyagi

Sr. Technical Recruiter| Group Nine LLC

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job