| Oracle PL SQL Developer at Oracle, Arizona, USA |
| Email: [email protected] |
| From: Ravina, Vyze Inc [email protected] Reply to: [email protected] Tittle: Oracle PL/SQL Developer Location: Remote (PST working hours) Visa: USC & GC only Must have active LinkedIn 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. a. Need to know Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL. 2. Experience with Informatica - Informatica handles the data integration and ETL processes. a. 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 Required Technical Skills: 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) is a plus Thorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications Keywords: continuous integration continuous deployment green card procedural language Oracle PL SQL Developer [email protected] |
| [email protected] View all |
| Fri Aug 09 05:23:00 UTC 2024 |