Oracle PL/SQL Developer ARA Resources Pvt. Ltd.
ARA Resources Pvt. Ltd.
Office Location
Full Time
Experience: 5 - 5 years required
Pay:
Salary Information not included
Type: Full Time
Location: All India
Skills: SQL, PLSQL, Oracle Performance Tuning, data warehousing, ETL, RDBMS, Oracle SQL Loader, Snowflake Cloud Data Platform
About ARA Resources Pvt. Ltd.
Job Description
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. 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) 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. Qualifications & Experience: Somebody who has at least 7+ years of work experience. Education qualification: Any degree from a reputed college,