PL/SQL + Python Developer

Tanisha Systems; Pune District; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Tanisha Systems in Pune, India is seeking a PL/SQL + Python Developer with 7+ years of experience to design, develop, and optimize Oracle PL/SQL procedures and Python data-processing scripts.

You will work with analysts and application teams in the BFSI domain, handle complex SQL, data extraction, validation, and performance tuning, and participate in Agile delivery. Immediate joiners preferred.

Qualifications

• Strong hands-on Oracle PL/SQL development and performance tuning.
• Proficient Python scripting for data processing and automation.
• Solid SQL knowledge, joins, subqueries, and optimization.
• Experience with data validation, reconciliation, and debugging.
• 7+ years of development experience in relevant roles.

Responsibilities

• Design, develop, and maintain Oracle PL/SQL procedures, packages, and queries.
• Develop Python scripts for data processing, automation, and integration.
• Analyse and optimize SQL/PL/SQL for performance and scalability.
• Handle data extraction, transformation, validation, and reconciliation.
• Troubleshoot production issues and perform root-cause analysis.
• Collaborate with analysts, application teams, and QA in Agile delivery.
• Work with large datasets ensuring data integrity and consistency.

Skills

Oracle PL/SQL

Python

SQL & Oracle Database

Data Analysis & Troubleshooting

5+ years

Tools

Git

CI/CD

Jira

Job description

Role & responsibilities

Job Title: PL/SQL + Python Developer

Job Location: Pune - India

Job Type: Full-Time

Experience: 7+Years (Mandatory)

Notice Period: Immediate Joiner/10-15 Days

No Non-Local Profile Needed only Profile with Relevant Skills

Job Description

We are looking for an experienced PL/SQL & Python Developer with 5+ years of hands-on development experience. The candidate should have strong expertise in Oracle PL/SQL and Python development, with experience in database programming, data processing, automation, troubleshooting, and performance optimization.

The resource will work closely with business analysts, application teams, and other technology teams to develop and support applications and data-processing solutions. Prior experience in the Banking and Financial Services (BFSI) domain is preferred.

Key Responsibilities

• Design, develop, and maintain complex Oracle PL/SQL procedures, packages, functions, triggers, and SQL queries.
• Develop Python scripts/applications for data processing, automation, validation, and system integration.
• Analyse and optimize SQL/PL/SQL queries for performance and scalability.
• Develop data extraction, transformation, reconciliation, and validation processes.
• Troubleshoot application, database, and data-related production issues.
• Perform root-cause analysis and provide timely resolution of defects and incidents.
• Work with large datasets and ensure data accuracy, integrity, and consistency.
• Participate in requirements analysis, design, development, testing, deployment, and production support.
• Collaborate with business, QA, database, and application teams.
• Follow coding standards, version control, testing, and Agile development practices.

Required Skills

• Oracle PL/SQL Strong hands-on experience with stored procedures, packages, functions, triggers, complex SQL queries, and performance tuning.
• Python Strong development/scripting experience, including data processing and automation.
• SQL & Oracle Database Strong knowledge of joins, subqueries, CTEs, analytical/window functions, query optimization, and database concepts.
• Data Analysis & Troubleshooting – Experience with data validation, reconciliation, debugging, and production issue resolution.
• 5+ years of relevant development experience.

Preferred Skills

• Banking and Financial Services (BFSI) domain experience.
• Experience working with financial/transactional data.
• Knowledge of Unix/Linux and Shell scripting.
• Experience with Git, CI/CD, Jira, and Agile/Scrum.
• Knowledge of ETL/data integration concepts.
• Strong analytical, communication, and problem-solving skills.