Job Description

Job Title: PL SQL

About Zensar:

Zensar is a digital solutions company helping organizations around the world achieve new thresholds of business performance. We work with clients in banking and financial services, hi-tech and manufacturing, insurance, consumer services, and more. We prepare our clients for sustainable success through experience design, cloud technology, advanced analytics, and business acceleration.

About Job:

We are hiring a talented Java professional to join our team. If you’re excited to be part of a winning team, Zensar is a great place to grow your career. You’ll be glad you make the right choice to join us.

Total working experience: 5 + years.

Ability to effectively communicate and explain technical issues to non-technical individuals.

Apply professional skepticism to identify gaps and opportunities for improvements & generate new ideas

Provide Techno functional support to customer

Co-ordination across stakeholders like Client, Application/Support Team.

Ability to drive assigned activities E2E with complete ownership

Estimates efforts, identify risks & provide technical support whenever needed.

Demonstrates the ability to multitask & re-prioritize responsibilities based on dynamic requirements.

Leading & mentoring small-sized teams

Must Have’s:

Minimum 4 + years of Very strong Experience in Oracle , DML/PL/SQL/ Advance PL SQL

Proficient understanding of code versioning tools, such as Git

Primarily proficient in design solution in Advance PL SQL

Exceptional communication and team working skills.
Database and application development experience using packages, procedures, pipeline functions, materialized views, bulk collection, Objects /Struct. Type
Strong Working experience in PL/SQL stored procedures and functions within packages, triggers and libraries
Experience using IDE program such as Toad, SQL Developer with Unit testing tools - Code tester
Good knowledge in Mongo is added advantage

Well versed in DevOps tools for code versioning and deployment

Organizational Skills

Highest level of integrity, maturity and ethics

Ability to carry out discussions end to end & decision maker

Experience in working with the customer directly.

Prior Experience In Leading/mentoring a Team Is Preferred.

Should possess excellent oral, written, problem-solving and analytical skills.

Must be able to succeed with minimal resources and supervision.

An analytical mind

Good to Have:

Proficiency in Performance tuning (creating an index /Hints/DB analyse /aggregations /Partitions ,Dynamic SQL, ref-cursors, bulk collection, explain plans )
Hadoop /AWS Knowledge is added advantage
Awareness to Open source and Cloud technologies

Primary Location

India-Maharashtra-Pune

Job Posting

Feb 8, 2023

Experience Required (In Years)

5