Oracle Developer | HCLTech
The Digital Path Forward

Oracle Developer

Roles and Responsibilities

  • Experience using bulking techniques, oracle collections
  • Projects must be worthy of being held up as an example for others to follow, in terms of readability, consistency, adherence to standards, and performance tuning
  • Understanding of data warehousing and reporting as well as multitenancy and Oracle Security best practices is plus
  • Read/write .xml and .json files using SQL and PL/SQL
  • Design, build, and maintain efficient, reusable, and reliable code.
  • Create and maintain optimal data pipeline architecture.
  • Assemble large, complex data sets that meet functional / non-functional business requirements.
  • Ensure the best possible performance, quality, and responsiveness of the applications.
  • Identify bottlenecks and bugs, and devise solutions to these problems.
  • Able to tune the slow running application queries, be able to analyze the root cause of slowness.
  • Ready to learn new technologies required in the project.
  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and big data technologies.
  • Be able to propose best practices and standards, handover to the operations
  • Able to interpret AWR, ADDM report, Oracle query running, DBA and Oracle package understanding.
  • Good knowledge on read explain plans and generate SQL advisory reports.
  • Perform the testing of software prototypes and transfer to the operational team.
  • Processing of data using Oracle, Hive, Impala & HBASE.
  • Performing analysis of large data sets and derive insight.

Required Technical and Professional Expertise

  • Development of high quality database solutions
  • Develop, implement and optimize stored procedures and functions using PL/SQL
  • Review and interpret ongoing business report requirements
  • Build appropriate and useful reporting deliverables
  • Analyze existing SQL queries for performance improvements
  • Ability to write new PL/SQL queries for new projects
  • Creating scripts to generate the data for reports developed in Oracle reports as per user requirements.
  • Creating Oracle Database objects based on the new requirement Tables, Indexes, views, partitions, constraints, triggers etc.,)
  • Writing SQL, PL/SQL programs, Packages, Stored procedures, Functions and Triggers to automate the interface processes for daily/incremental loads.
  • Exposure to performance tuning and SQL tuning of large database environments
  • Experience with Oracle 10g, 11g and 12c

Apply Now

File Extension Allowed: Pdf, Doc, Docx | Max File Size: 2MB


Preferences
Preferences
Preferred Communication Mode
Preferred Communication Mode
I have read HCL Technologies’ Privacy Policy and agree to the terms and conditions*

I have read HCL Technologies’ Candidate Data Privacy Policy and agree to the terms and conditions*

Once you submit the form, you'll receive an email verification link to confirm your subscription

Discover Opportunities

Job
Job

Couldn't find the right role?

Leave your resume with us and we'll get back when a suitable role opens up.

Graduate
Graduate

Are you a recent engineering graduate?

Our fresher hiring team is looking for talented engineers just like you.