PL / SQL Developer

Requirements:

• Must have excellent working knowledge and experience of SQL, Oracle PL/SQL, Unix Shell and Python programming languages.
• Extensive proficiency in the modern RDBMS products - Oracle (latest version). PostgreSQL is a major plus
• Developed Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL
• Experience in using Standard Oracle Packages(UTL_FILE, etc. ), Dynamic SQL, Records, Arrays, PL/SQL tables, and 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, and External tables.
• Solid experience and comfortable with the UNIX/ Linux platform, with sufficient commands.
• Agile working experience with Scrum and SDLC methodologies and the best practices.
• Experience with Atlassian products such as JIRA, Confluence, and Bitbucket.
• Thorough working experience of DevOps, UC4 Maven, Jenkins and CI/CD.
• Experience with the best practices utilising object-oriented analysis and design principles.
• Thorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications
• Experience with Informatica Platform and knowledge of Informatica best practices for Informatica PowerCenter, Data Transformation and Informatica B2B Data Exchange products is a plus.
• ETL and data modelling knowledge and experience are a plus.
• Proficient in creating mappings, workflows and implementing ETL concepts.
• 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 an API gateway (such as Gravitee) is a plus.

Skills

ETL, Linux, Oracle, Oracle PL/SQL, PL/SQL, PostgreSQL, Python, RDBMS, SQL, Shell, Unix