Senior PL/SQL Developer (Chennai)

Senior PL/SQL Developer (Chennai)

19 Nov
|
truelancer staffing
|
Chennai

19 Nov

truelancer staffing

Chennai

Senior PL/SQL Developer with Snowflake

Experience: 8+ Years

Location: Bangalore / Hyderabad / Chennai / Pune

Work Model: Hybrid

Job Summary

We are looking for an experienced Senior PL/SQL Developer with strong expertise in Oracle PL/SQL and hands-on experience with Snowflake. The ideal candidate should have 8+ years of experience in database development, query optimization, stored procedures, functions, packages, and database performance tuning, along with a good understanding of Snowflake architecture and data warehousing concepts.

The candidate will be responsible for developing, maintaining, optimizing, and supporting database solutions while working on data integration and migration activities involving Oracle and Snowflake.

Key Responsibilities

- Design, develop, and maintain complex PL/SQL procedures, functions, packages, triggers, and database objects.
- Write, analyze, and optimize complex SQL queries for improved database performance.
- Work extensively on Oracle databases and PL/SQL development activities.
- Develop and maintain data processing solutions using Snowflake.
- Work on data integration, transformation, and loading activities between Oracle and Snowflake.
- Perform database performance tuning, query optimization, and troubleshooting.
- Analyze business and technical requirements and translate them into efficient database solutions.
- Identify and resolve database-related issues, ensuring data accuracy and consistency.
- Work on database schema design, indexing, partitioning, and optimization.
- Collaborate with data engineers,



application developers, and business stakeholders.
- Prepare technical documentation and ensure adherence to coding and development standards.

Required Skills & Experience

- 8+ years of overall experience in database development.
- Strong hands-on experience in Oracle PL/SQL development.
- Expertise in writing complex SQL queries, stored procedures, functions, packages, triggers, and cursors.
- Strong knowledge of Oracle database architecture and concepts.
- Hands-on experience with Snowflake database.
- Understanding of Snowflake architecture, data warehousing, and database objects.
- Experience in SQL query optimization and performance tuning.
- Good understanding of ETL/ELT processes and data transformation.
- Experience in data validation, reconciliation, and troubleshooting.
- Robust analytical and problem-solving skills.

Valuable to Have

- Experience in Oracle-to-Snowflake data migration.
- Knowledge of Snowflake features such as Virtual Warehouses, Snowpipe, Streams, Tasks, and Time Travel.
- Familiarity with cloud-based data platforms.
- Experience with database migration, modernization, and data integration projects.
- Knowledge of Python or scripting for database automation.

Candidate Expectations

- Should have strong hands-on PL/SQL development experience, not just database support experience.
- Must have practical exposure to Snowflake.
- Should be capable of independently handling complex database development and optimization activities.
- Good communication and stakeholder management skills.

📌 Senior PL/SQL Developer (Chennai)
🏢 truelancer staffing
📍 Chennai

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior pl/sql developer (chennai) / chennai

Subscribe to this job alert:

Get the latest job offers by email for: senior pl/sql developer (chennai) / chennai