Oracle SQL Developer – PL/SQL, ETL & Query Optimization
Synechron · Pune - Hinjewadi (Ascendas) ·
- Experience
- 4+ years
Synechron · Pune - Hinjewadi (Ascendas) ·
Job Summary
Synechron is seeking an Oracle SQL Developer with 4+ years of experience in Oracle SQL, PL/SQL, database development, performance optimization, and data management.The role will design, develop, maintain, and optimize database solutions that support business applications, reporting, data warehousing, and operational processes. The position will contribute to business objectives by improving data accuracy, query performance, database reliability, and the efficiency of data extraction and transformation activities.
Software Requirements
Required
Minimum 4+ years of hands-on experience with Oracle SQL and PL/SQL.
Experience using current and supported Oracle Database versions and development tools.
Strong ability to write complex SQL queries, including:
Joins.
Subqueries.
Common table expressions.
Analytical functions.
Aggregations.
Data manipulation statements.
Experience developing and maintaining stored procedures, functions, packages, triggers, views, and other database objects.
Knowledge of query performance optimization, execution plans, indexing, partitioning, and database performance analysis.
Experience working with large datasets and data manipulation techniques.
Familiarity with ETL processes, data extraction, transformation, loading, and validation.
Knowledge of data warehousing concepts, including fact tables, dimension tables, data marts, and data models.
Familiarity with source control, code review, documentation, issue tracking, and change management tools.
Ability to support production issues and investigate data accuracy, integrity, and performance concerns.
Ability to use current and supported versions of relevant SQL development, database administration, ETL, reporting, and monitoring tools.
Preferred
Experience with enterprise data warehouses and investment or financial data platforms.
Exposure to positions-related data views or equivalent financial data warehouse structures.
Experience with ETL tools and data integration platforms.
Knowledge of reporting and business intelligence tools.
Experience with query tuning, execution plan analysis, indexing strategies, partitioning, and workload optimization.
Familiarity with Agile/Scrum development teams.
Exposure to incident, change, and service management processes.
Experience with automated database testing and data quality validation.
Overall Responsibilities
Develop, enhance, and maintain complex SQL queries, PL/SQL code, stored procedures, functions, packages, views, triggers, and other database objects.
Perform data extraction, transformation, loading, reconciliation, and validation activities.
Optimize SQL queries and database performance for large-scale datasets.
Analyze execution plans, identify performance bottlenecks, and implement appropriate tuning solutions.
Apply indexing, partitioning, query refactoring, and data-access improvements where required.
Work with Business Analysts, developers, data teams, reporting teams, and stakeholders to understand data requirements.
Support database design, data modeling, data warehouse development, and data integration activities.
Investigate and resolve production issues involving data accuracy, performance, database objects, and ETL processes.
Participate in code reviews, technical design discussions, testing, release activities, and change implementation.
Maintain accurate documentation for database processes, data flows, data models, SQL logic, dependencies, and changes.
Ensure data solutions meet requirements for accuracy, integrity, performance, availability, security, and maintainability.
Identify opportunities to improve database development standards, automation, data quality, and operational efficiency.
Support Agile delivery practices, sprint activities, estimation, backlog refinement, and retrospective actions where applicable.
Consider efficient use of database and computing resources when designing queries, data processes, and database solutions.
Technical Skills (By Category)
Programming Languages
Essential
Oracle SQL using a current and supported database version.
PL/SQL development, including procedures, functions, packages, triggers, cursors, exception handling, and bulk processing.
Strong understanding of SQL joins, subqueries, analytical functions, common table expressions, aggregations, and data manipulation.
Ability to write readable, maintainable, reusable, and testable database code.
Understanding of database programming principles and transaction management.
Preferred
Shell scripting for database automation, batch processing, and operational support.
Familiarity with scripting used for ETL, reporting, data validation, or deployment activities.
Experience developing reusable SQL and PL/SQL utilities.
Databases/Data Management
Essential
Strong knowledge of relational database concepts.
Understanding of tables, views, indexes, partitions, constraints, keys, relationships, and transactions.
Experience with data modeling and database design.
Knowledge of data warehousing concepts, including fact tables, dimension tables, data marts, and historical data.
Experience working with large datasets and data manipulation techniques.
Understanding of data quality, data integrity, reconciliation, validation, and data lifecycle management.
Ability to analyze data structures, dependencies, and data flows.
Preferred
Experience with enterprise data warehouses and financial data models.
Exposure to positions, holdings, transactions, accounting, or investment-related data structures.
Knowledge of data lineage, metadata management, and data governance.
Experience with data migration, data reconciliation, and data quality frameworks.
Familiarity with SQL and NoSQL database technologies.
Cloud Technologies
Essential
Awareness of database deployment, connectivity, availability, monitoring, and security in cloud and on-premises environments.
Understanding of database performance, scalability, backup, recovery, and operational support requirements.
Ability to support database solutions across development, testing, and production environments.
Preferred
Experience working with Oracle databases in cloud environments.
Familiarity with cloud-based data warehouses, data integration, storage, and monitoring services.
Knowledge of cloud database security, identity management, encryption, and access controls.
Awareness of cost-efficient and sustainable use of database and computing resources.
Frameworks and Libraries
Essential
Experience with Oracle database development and PL/SQL programming practices.
Knowledge of ETL processes and data integration patterns.
Understanding of data transformation, validation, reconciliation, and error-handling techniques.
Ability to work with database connectivity, reporting, and data-processing components.
Familiarity with development standards for reusable database code and controlled releases.
Preferred
Experience with enterprise ETL frameworks or data integration platforms.
Knowledge of data warehouse loading patterns and incremental processing.
Familiarity with reporting, business intelligence, or data visualization frameworks.
Experience with database testing, automated validation, and data quality tools.
Development Tools and Methodologies
Essential
Familiarity with software development lifecycle practices, including requirements analysis, design, development, testing, deployment, maintenance, and support.
Experience with source control, branching, merging, code reviews, and controlled database releases.
Knowledge of defect management, issue tracking, documentation, and change management processes.
Experience supporting production incidents and resolving database-related issues.
Ability to participate in technical reviews, testing, release planning, and implementation activities.
Preferred
Experience working in Agile or Scrum teams.
Familiarity with CI/CD processes for database code and ETL solutions.
Exposure to service, incident, and change management processes.
Experience with automated testing, regression testing, performance testing, and data validation.
Knowledge of database monitoring, alerting, and operational dashboards.
Security Protocols
Essential
Understanding of secure database development and data protection principles.
Knowledge of authentication, authorization, role-based access, encryption, secure connectivity, and audit logging.
Ability to apply appropriate access controls to database objects, data, scripts, and environments.
Understanding of data privacy, data integrity, confidentiality, and secure handling practices.
Preferred
Experience with data masking, encryption, privileged access management, and security reviews.
Familiarity with database vulnerability management and secure configuration practices.
Knowledge of access segregation, audit requirements, and compliance controls.
Experience supporting security validation during database changes, releases, and production issue resolution.
Experience Requirements
Minimum 4+ years of experience in Oracle SQL development, PL/SQL development, database engineering, or related roles.
Experience developing complex SQL queries, stored procedures, functions, packages, views, triggers, and database objects.
Experience with Oracle database performance optimization and execution plan analysis.
Experience working with large datasets, data manipulation, data validation, and data integrity.
Experience with ETL processes, data extraction, transformation, loading, and reconciliation.
Experience with data warehousing, data marts, dimensional modeling, fact tables, and dimension tables.
Experience supporting production issues and resolving database or data-related defects.
Experience collaborating with Business Analysts, application developers, data teams, reporting teams, and business stakeholders.
Experience with financial services, investment data, banking, accounting, or other data-intensive industries is preferred.
Experience with enterprise data warehouse platforms or financial data views is preferred.
Candidates may also qualify through equivalent practical experience, relevant database certifications, professional training, or demonstrated delivery of complex Oracle SQL and PL/SQL solutions.
Day-to-Day Activities
Develop and optimize SQL queries, PL/SQL programs, stored procedures, database objects, and ETL processes.
Collaborate with Business Analysts, developers, data teams, and stakeholders to clarify data requirements and solution outcomes.
Analyze execution plans, validate data, investigate production issues, participate in code reviews, and support testing and release activities.
Maintain database documentation, track changes and defects, recommend performance improvements, and make implementation decisions within established technical and security standards.
Qualifications
Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field; equivalent professional experience may be considered.
Minimum 4+ years of experience in Oracle SQL and PL/SQL development, including experience with database performance and data management.
Certifications in Oracle Database, SQL, PL/SQL, data warehousing, ETL, or related technologies are preferred.
Complete Synechron-required training related to information security, data protection, workplace conduct, data governance, and responsible technology use.
Maintain continuous professional development in Oracle SQL, PL/SQL, query optimization, data warehousing, ETL, database security, Agile delivery, and data quality practices.
Professional Competencies
Critical thinking, data analysis, execution plan interpretation, and structured problem-solving.
Effective collaboration with technical teams, Business Analysts, data teams, and stakeholders.
Clear communication, technical documentation, knowledge sharing, and requirement clarification.
Adaptability, continuous learning, and effective application of evolving database technologies.
Innovation focused on query performance, data quality, automation, maintainability, and resource efficiency.
Effective organization, prioritization, time management, and delivery of multiple database activities.
SYNECHRON’S DIVERSITY & INCLUSION STATEMENT
Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.
All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.
Candidate Application Notice