Pl/sql Developer (sql Optimization & Etl)
- Synechron
- 9 - 14 years
- Bengaluru
- 4 months ago
- Email to a friend
- Report this job
Job Description
Job Description: Synechron is seeking a skilled PL/SQL Developer to design, develop, and maintain SQL and PL/SQL code for database applications. The ideal candidate will have strong technical expertise in relational databases, performance tuning, and ETL processes. This role involves collaborating with cross-functional teams, troubleshooting database issues, and optimizing code for efficiency.
Software Requirements:
- Proficient in SQL and PL/SQL.
- Strong understanding of relational database management systems (RDBMS) such as Oracle, MySQL, or SQL Server.
- Experience with query optimization, indexing strategies, and analyzing execution plans.
- Knowledge of ETL tools and processes (optional).
- Familiarity with DevOps technologies such as Jenkins, Ansible, SonarQube, Bit Bucket, Artifactory (optional).
- Knowledge of scheduling tools and defect management tools (mandatory).
- Proficiency in programming languages like Python, Perl, or VB Script (optional).
Overall Responsibilities:
- Design, develop, and maintain SQL and PL/SQL code for database applications.
- Analyze query performance and provide tuning suggestions to improve overall efficiency and speed.
- Develop ETL processes for data migration and integration with other systems.
- Identify and resolve issues in database operations and scripts.
- Create and maintain documentation for SQL and PL/SQL code, database structures, and any modifications made.
- Work closely with application developers, database administrators, and other IT staff to meet project goals.
- Develop stored procedures to build reports for end-users using SQL 2016.
- Mentor new team members and optimize code.
- Learn and understand reconciliation concepts, ETL tools, reconciliation tools like IntelliMatch, and scheduling tools like Autosys.
- Contribute to reconciliation development activities using IntelliMatch tools and ETL workflow setup and scheduling tool configuration.
- Involvement across all stages of the Software Development Life Cycle (SDLC).
- Analyze and develop test strategies, design test plans, and execute test cases.
- Perform enhancements and deliver quality code.
- Guide support teams and propose improvements related to development and support activities.
Technical Skills:
- Primary Skills:
- Advanced skills in SQL queries, stored procedures, packages, functions, and triggers.
- Experience with query optimization and performance tuning.
- Proficiency in ETL tools and processes.
- Knowledge of scheduling tools.
- Strong analytical and troubleshooting skills.
- Secondary Skills:
- Familiarity with DevOps technologies (optional).
- Experience with defect management tools (optional).
- Knowledge of programming languages like Python, Perl, or VB Script (optional).
Experience:
- Minimum of 9 years of experience in SQL and PL/SQL development.
- Prior experience with relational databases and performance tuning.
- Experience in ETL processes and tools (optional).
Day-to-Day Activities:
- Write, maintain, and execute SQL and PL/SQL code.
- Troubleshoot and debug database scripts.
- Collaborate with cross-functional teams to meet project goals.
- Analyze query performance and provide optimization suggestions.
- Develop and maintain ETL processes.
- Create and maintain documentation for database code and structures.
- Mentor team members and guide support teams.
- Participate in agile sprint planning and retrospectives.
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or related field.
- Relevant certifications in SQL and PL/SQL (preferred).
Soft Skills:
- Strong communication and interpersonal skills.
- Ability to work effectively in a team environment.
- Strong organization and prioritization skills.
- Pragmatic approach to problem-solving.
- Willingness to improve functional knowledge and technical skills.
- Ability to work closely with end-users and developers.
- Expected to work in European business hours (including holidays and weekends).
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Data warehouse DeveloperEmployement Type: Full timeContact Details:
Company: SynechronLocation(s): Bengaluru+ View Contact
Keyskills: relational databases sql plsql stored procedures etl tool sql development python sql queries performance tuning triggers relational database management system prioritization pl / sql development troubleshooting defect management etl process
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Synechron
We are a digital solutions and technology services company that partners with global organizations across industries to achieve digital transformation. With a strong track record of innovation, investment in digital solutions, and commitment to client success, at Zensar, you can help clients achieve...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in