Technical Skills
• Must have excellent working knowledge and experience of SQL, Oracle PL/SQL, Unix Shell (or Perl or Python) programming languages with minimum 6-7 years of experience
• 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
• Should be flexible to support customer till 12 Noon PST (i.e 12:30 AM IST)