Oracle PL-SQL Developer (7-14 yrs)

About The Company :

ARA's Client is a leading IT solutions provider, offering Applications, Business Process Outsourcing (BPO) and Infrastructure services globally through a combination of technology knowhow, domain and process expertise. Over the years we have left an indelible impression in the IT solutions domain with an impressive clientele and an extensive global presence. Our integrated solutions offering is aimed at creating value for our customers, helping them in improving their business processes with minimum hassles and capital outlays.

The Role :

We are looking for 7+ Years of database development experience should have min 5+ years of relevant experience. Strong SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions & User defined data types.

Key Responsibilities :

- Looking for 7+ Years of database development experience and should have min 5+ years of relevant experience

- Strong PLSQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions & User defined data types.

- Expertise in using Oracle Performance tuning concepts with Oracle hints and EXPLAIN PLAN tool

- Strong experience using SQL and PL/SQL features like Built In Functions, Analytical Functions, Cursors, Cursor variables, Native dynamic SQL, bulk binding techniques and Packages/Procedures/Functions wherever applicable to process data in an efficient manner

- Strong understanding of Data Warehousing and Extraction Transformation Loading (ETL)

- Sound understanding of RDBMS (Oracle)

- Should have used Oracle SQL Loader/External File Utilities to load files

- Good to have experience with Snowflake cloud data platform including Snowflake utilities like SnowSQL, SnowPipe, data loading within cloud (AWS or Azure)

- Strong written and oral communication skills

- Excellent problem-solving and quantitative skills

- Demonstrated ability to work as part of a team.

- Investment Management experience in the past

Skills Required :

- Ability to evaluate, analyze, design and implement solutions based on technical requirements.

- Develop and peer review of LLD (Initiate/ participate in peer reviews)

- Strong design and technical skills, ability to translate business needs into technical solutions and able to analyze the impact.

Behavioral Skills :

- Resolve technical issues of projects and explore alternate designs.

- Participates as a team member and fosters teamwork by inter-group coordination within the modules of the project.

- Effectively collaborates and communicates with the stakeholders and ensure client satisfaction.

- Train and coach members of project groups to ensure effective knowledge management activity.

Qualifications & Experience :

- Somebody who has at least 7+ years of work experience.

- Education qualification : Any degree from a reputed college