PL/SQL Developer

Position - PL/SQL DeveloperLocation - San Diego, CA or in Tempe, AZDuration - 6 monthsJos 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 plusDeveloped Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQLExperience of using Standard Oracle Packages(UTL_FILE etc.), Dynamic SQL, Records, Arrays, PL/SQL tables, File handlingExperience in SQL and PL/SQL Performance Tuning, query rewriting, use of Explain Plan and HintsExpertise in Collections, Exception Handling, Partitioning techniques, BULK features, Analytics functions, External tablesSolid experience and comfortable with UNIX/ Linux platform and sufficient commandsAgile working experience with Scrum and SDLC methodologies and the best practices. Experience with Atlassian products such as JIRA, Confluences, BitBucketThorough working experience of DevOps, UC4, Maven, Jenkins and CI/CDExperience of the best practices utilizing object-oriented analysis and design principlesThorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applicationsExperience with Informatica Platform and knowledge of Informatica best practices for Informatica PowerCenter, Data Transformation and Informatica B2B Data Exchange products is a plusETL and data modeling knowledge and experience are plus. Proficient in creating mappings, workflows and implementing ETL conceptsGood knowledge of the recent programming language and framework (such as Java, Angular or React, XML, JSON) is a plusIf interested, please send your resume to

harish.gotur@tietoevry.com