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