• Oracle PL/SQL Developer

Location Karnataka Bangalore
Experience Range 6 - 8 Years
Not active

Skills experience of SQL, Oracle PL/SQL, Unix Shell (or Perl or Python) programming languages
Job Description
About Us
EVRY India and EVRY USA are wholly owned subsidiaries of TietoEVRY, a leading digital services and software company headquartered in Finland with annual revenues of around USD 3.3 billion. TietoEVRY employs around 24,000 experts globally and is recognized as the #1 IT services and #1 financial services company in the Nordics. TietoEVRY serves thousands of enterprises and public sector customers in more than 90 countries. We foster a culture of continuous learning and focus on helping our customers in accelerating their digital journey to scale business advantage. Be it talent, speed to market, innovation, or cross-pollination of ideas across markets, TietoEVRY leverages USA and India operations to compete locally as well as globally.
About EVRY USA
EVRY USA delivers IT services to a wide range of customers in the USA through its global delivery centers and India offices (EVRY India) in Bangalore & Chandigarh, India. We offer a comprehensive IT services portfolio and drive digital transformation across Banking & Financial Services, Insurance, Healthcare, Retail & Logistics, and Energy, Utilities & Manufacturing sectors. EVRY India's process and project maturity is very high — the two offshore development centers in India are appraised at CMMI DEV Maturity Level 5 & CMMI SVC Maturity Level 5 and certified under ISO 9001:2015 & ISO/IEC 27001:2013.
Roles and Responsibility

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)

 

A+| A| A-