PL/SQL Developer(Chennai,Bangalore,Hyderabad)

Tata Consultancy Services Limited

Chennai District

On-site

INR 800,000 - 1,200,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

A leading IT service provider in Chennai is looking for a mid-senior level Talent Acquisition Specialist with expertise in PL/SQL and Unix Shell Scripting. You will be responsible for designing and maintaining PL/SQL procedures, optimizing Unix Shell Scripts, and working on Data Warehouse architecture. The ideal candidate should have 7-10 years of experience and strong collaborative skills to work with stakeholders. This full-time position offers an opportunity to work in a dynamic environment and contribute to significant technical solutions.

Qualifications

  • 7 to 10 years of experience in PL/SQL and Unix Shell Scripting.
  • Strong proficiency in Oracle PL/SQL procedures and performance tuning.
  • Hands-on experience with Unix/Linux environments.

Responsibilities

  • Design and maintain PL/SQL processes for data transformation.
  • Optimize Unix Shell Scripts for automation tasks.
  • Work on Data Warehouse architecture and ETL processes.
  • Monitor production jobs and troubleshoot issues.
  • Collaborate with stakeholders to understand technical requirements.

Skills

Oracle PL/SQL
Unix/Linux Shell Scripting
Data Warehousing concepts
ETL tools
SQL performance optimization
Agile/Scrum environments

Tools

Control-M
Autosys
Cloud Data Platforms
Tableau
Power BI

Job description

Direct message the job poster from Tata Consultancy Services

Talent Acquisition Specialist @ Tata Consultancy Services | HR | TAG - End to end recruitment || Technical Recruiting, HR Professional | Talent…

Skill: PLSQL, Unix Shell Scripting and Data warehouse

Experience Range :7 to 10

Key Responsibilities:

  • Design, develop, and maintain PL/SQL procedures, functions, triggers, and packages for data processing and transformation.
  • Develop and optimize Unix Shell Scripts for automation, scheduling, and data file handling.
  • Work on Data Warehouse architecture, ETL processes, and data integration from multiple sources.
  • Ensure data quality, integrity, and performance tuning of SQL queries and ETL jobs.
  • Collaborate with business analysts and stakeholders to understand requirements and translate them into technical solutions.
  • Monitor and troubleshoot production jobs, ensuring timely resolution of issues.
  • Participate in code reviews, documentation, and deployment activities.

Required Skills:

  • Strong proficiency in Oracle PL/SQL (procedures, functions, packages, performance tuning).
  • Hands-on experience with Unix/Linux Shell Scripting.
  • Good understanding of Data Warehousing concepts (Star Schema, Snowflake Schema, Fact & Dimension tables).
  • Experience with ETL tools (e.g., Informatica, DataStage, or similar) is a plus.
  • Familiarity with job scheduling tools (e.g., Control-M, Autosys).
  • Knowledge of SQL performance optimization and debugging.
  • Ability to work in Agile/Scrum environments.

Nice-to-Have:

  • Exposure to Cloud Data Platforms (AWS Redshift, Azure Synapse, GCP BigQuery).
  • Knowledge of BI tools (Tableau, Power BI).
  • Basic understanding of Python or other scripting languages.
Seniority level
  • Seniority level
    Mid-Senior level
Employment type
  • Employment type
    Full-time
Job function
  • Job function
    Information Technology
  • Industries
    IT Services and IT Consulting

Referrals increase your chances of interviewing at Tata Consultancy Services by 2x

Sign in to set job alerts for “PL/SQL Developer” roles.
Intermediate Applications Developer - ORACLE PLSQL
Intermediate Applications Developer - ORACLE PLSQL
Intermediate Applications Developer - ORACLE PLSQL
SQL Developer Hiring for Chennai/Pune/Kolkata/Hyderabad/Bangalore

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

PL/SQL Developer
PL/SQL Developer

Tata Consultancy Services Limited • Hyderabad

On-site
INR 600,000 - 1,200,000
PL/SQL Developer
PL/SQL Developer

Applicantz • Bengaluru

On-site
INR 800,000 - 1,200,000
Data Engineer
Data Engineer

Tata Consultancy Services Limited • Chennai

On-site
INR 600,000 - 900,000
Oracle PL/SQL Developer
Oracle PL/SQL Developer

Talent Zone Consultant • Bengaluru

On-site
INR 1,200,000 - 1,800,000
Postgres SQL Developer
Postgres SQL Developer

People Prime Worldwide Pvt Ltd. • Chennai

Hybrid
INR 1,200,000 - 2,000,000
SQL Developer
SQL Developer

EverestDX Inc • Hyderabad

On-site
INR 900,000 - 1,200,000
SQL Developer
SQL Developer

People Staffing Solutions • Chennai

On-site
INR 500,000 - 1,200,000
PLSQL Developer
PLSQL Developer

Intellect Design Arena • Chennai District

On-site
INR 700,000 - 1,000,000
PL/SQL Developer
PL/SQL Developer

ORACLE FINANCIAL SERVICES SOFTWARE LIMITED • Bengaluru

On-site
INR 1,000,000 - 1,500,000
Competitive Employee Benefits
Diversity and Inclusion Commitment
Oracle PL/SQL Developer | 5+ Years | Bangalore | Hybrid | SOW 2024 - 2462
Oracle PL/SQL Developer | 5+ Years | Bangalore | Hybrid | SOW 2024 - 2462

PradeepIt Global Consulting Pvt Ltd. • Bengaluru

Hybrid
INR 1,000,000 - 1,500,000