The Job

Senior Oracle PL/SQL Technical Specialist

Technology, Data & Digital · Software & Web Development · Software Engineering · Data Engineering

Join for updates

In short

The Senior Oracle PL/SQL Technical Specialist will be responsible for the technical design, development, and maintenance of Oracle PL/SQL code, ensuring optimal performance and data integrity. This role involves designing and developing Talend ETL/ELT solutions, optimizing SQL queries, and providing production support.

Responsibilities

  • Design, develop, and maintain Talend ETL/ELT solutions integrating data from Oracle, Snowflake, and other sources.
  • Implement efficient data pipelines leveraging Talend and Snowflake for large scale data processing and analytics.
  • Develop and customize Talend jobs using Java and Python for complex transformations and automation.
  • Optimize SQL queries and ETL workflows for performance, scalability, and data quality.
  • Provide production support, troubleshoot issues, and ensure reliable data delivery.
  • Mentor junior developers and enforce best practices and coding standards.
  • Develop and maintain complex oracle pl/sql procedures, functions, packages, and triggers.
  • Collaborate with cross functional teams to analyze requirements and design efficient database solutions.
  • Optimize sql queries and database code for performance improvements.
  • Troubleshoot and resolve database issues in a timely manner.
  • Implement data security protocols and ensure compliance with data protection regulations.
  • Perform database tuning and capacity planning activities.
  • Create technical documentation and provide guidance to junior team members.

Requirements

  • Proficient in oracle pl/sql programming, including stored procedures, functions, and triggers.
  • Strong experience in designing and optimizing oracle databases.
  • Knowledge of performance tuning techniques for sql queries.
  • Familiarity with data security and compliance standards.
  • Excellent problem-solving skills and attention to detail.
  • Good communication and teamwork abilities.
  • Bachelor's degree in computer science, engineering, or a related field.
  • Oracle Certified Professional (OCP) Oracle PL/SQL Developer Certification.

Benefits

  • Supercharge your potential at HCLTech.
  • Find your career at HCLTech.
  • Find your spark at HCLTech.
  • HCLTech is a global technology company, home to more than 223,000 people across 60 countries.
  • Delivering industry-leading capabilities centered around digital, engineering, cloud and AI.
  • Works with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services.
#Oracle#PL/SQL#Talend#ETL#ELT#Snowflake#SQL#Java#Python#Database
HCLTech Logo

Company

HCLTech

Job Posted

1 day ago

Employment Type

Full Time

WorkMode

On Site

Experience Level

Senior

Locations

Hyderabad, India

Qualification

Bachelor

Applicants

Be an early applicant