PL/SQL Developer

Position - PL/SQL Developer

Location - San Diego, CA or in Tempe, AZ

Duration - 6 months

Jos Description:

• Must have 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 major plus
• 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
• 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 modeling knowledge and experience are 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, XML, JSON) is a plus

If interested, please send your resume to