Application Programmer (Oracle SQL & PL/SQL)
Core
Design, develop, and optimize Oracle SQL and PL/SQL code while building automated tests and validating ETL processes for database upgrades.
Role type
Senior IC Application Programmer (Oracle SQL/PL/SQL & ETL)
Builds
Production database objects, automated test scripts, and validated ETL data pipelines
Domain
Enterprise Data Management & Database Engineering
Required skills
Oracle SQL, PL/SQL, Database Performance Tuning, ETL Testing, Data Validation, Automated Scripting, Data Modeling, Relational Database Design, Test Case Design, Defect Tracking
Preferred skills
API Testing, CI/CD Pipelines, Version Control, Oracle DBA Concepts, Cloud Database Platforms, Data Governance, Large-scale Data Migration
Technologies
Oracle, Informatica, DataStage, SSIS, Jenkins, Git, Azure, Postman, REST, Bitbucket, SVN
Responsibilities
Design, develop, and optimize complex Oracle SQL and PL/SQL code including procedures, packages, and triggers. Diagnose and resolve database performance issues using execution-plan analysis and indexing strategies. Create and maintain database objects such as tables, views, indexes, and materialized views. Build and maintain automated tests for functional, regression, and integration scenarios. Test ETL processes by validating data, reconciling results, and verifying source-to-target mappings. Analyze large datasets and conduct backend testing using SQL. Collaborate with business, development, DBA, and QA teams throughout Agile/Scrum ceremonies.
Seniority
Senior, hands-on IC
