Job Overview
Deloitte is actively hiring for the role of Analyst – PL/SQL. This is a significant opportunity for Experienced Professionals with a background in B.E/B.Tech/M.Sc/MCA to join the AI & Data Team in Pune. If you have expertise in developing, testing, and optimizing PL/SQL scripts, check the details below and apply immediately.
Role: Analyst – PL/SQL Location: Pune, Maharashtra Experience: Experienced (Early/Mid-Level) Qualification: B.E / B.Tech / M.C.A / M.Sc (CS) Team: AI & Data Key Skills: PL/SQL, Stored Procedures, Database Tuning, SQL Security Job Type: Full-time Salary: Best in Industry
Job Description
For the Deloitte drive, the company is seeking a skilled Analyst to join the AI & Data practice. You will be responsible for designing and modernizing data ecosystems. The role demands proficiency in PL/SQL to design and implement data migration and integration processes.
You will work with clients to leverage automation and AI-based solutions to manage data. As an Analyst, you must ensure that all code adheres to company standards and complies with industry best practices, while proactively identifying risks and communicating them to team leads.
Roles and Responsibilities
As an Analyst – PL/SQL at Deloitte, your key responsibilities will include:
- Development: Developing, testing, and maintaining PL/SQL scripts, stored procedures, triggers, and functions.
- Optimization: Optimizing and tuning PL/SQL code for performance improvements.
- Support: Providing technical support for PL/SQL-related issues, troubleshooting, and resolving database problems.
- Maintenance: Performing regular database maintenance tasks, such as backups, restores, and updates.
- Security: Managing database security by implementing and maintaining access controls.
- Migration: Designing and implementing data migration and integration processes.
Skills and Eligibility Criteria
To be eligible for Deloitte drive, candidates must meet the following criteria:
- Educational Background: B.E/B.Tech/M.C.A./M.Sc (CS) degree or equivalent from an accredited university.
- Must-Have Technical Skills:
- Strong experience in PL/SQL development (Stored Procedures, Triggers).
- Experience in Performance Tuning and monitoring database efficiency.
- Ability to manage database security and access controls.
- Proficiency in troubleshooting database production issues.
- Good-to-Have Skills:
- Experience with Version Control Systems for code management.
- Ability to generate reports and analyze data using complex queries.
- Documentation skills for scripts and database configurations.
Selection Process
The selection process for Deloitte typically includes:
- Resume Screening: Filtering based on PL/SQL project experience.
- Online Technical Assessment: SQL/PL/SQL coding challenges and Aptitude.
- Technical Interview 1: Deep dive into Cursors, Triggers, Indexing strategies, and Query Optimization.
- Technical Interview 2: Scenario-based database design and troubleshooting questions.
- HR Interview: Behavioral assessment and cultural fit.