In short
A PL/SQL developer supporting UAT testing, backend data validation, and analytics/reporting: developing PL/SQL procedures, functions, triggers, and packages, running SQL for data reconciliation, and validating ETL and business logic. Core stack is Oracle-style PL/SQL, advanced SQL, and ETL, with Power BI and data warehousing as nice-to-haves.
About the role
Job Description PL/SQL Developer
Role Overview
Looking for a PL/SQL Developer with strong SQL and database knowledge to support UAT testing, backend data validation, and analytics/reporting solutions.
Key Responsibilities
- Develop and validate PL/SQL procedures, functions, triggers, and packages.
- Perform SQL queries for data validation and reconciliation.
- Validate ETL processes, data transformations, and business logic.
- Prepare and execute UAT test cases and SQL scripts.
- Identify, document, and track data-related defects.
- Perform regression testing and validate bug fixes.
- Coordinate with business and technical teams for UAT sign-off.
Required Skills
- Strong hands-on experience in PL/SQL and Advanced SQL.
- Experience in UAT/QA testing and backend data validation.
- Knowledge of stored procedures, functions, triggers, and packages.
- Understanding of databases, data models, and ETL processes.
- Experience with data reconciliation and data integrity.
- Good communication and documentation skills.
Good to Have
- Power BI or other BI tools.
- Data Warehouse experience.
- Agile and release management knowledge.
Requirements
- Strong hands-on experience in PL/SQL and Advanced SQL
- Experience in UAT/QA testing and backend data validation
- Knowledge of stored procedures, functions, triggers, and packages
- Understanding of databases, data models, and ETL processes
- Experience with data reconciliation and data integrity