Design, develop, test, implement, and maintain PL/SQL code, UNIX scripts, and Views for reporting and other needs
Job Summary
Design, develop, test, implement, and maintain PL/SQL code, UNIX scripts, and Views for reporting and other needs.
Create/Modify complex and large queries, writing/modifying stored procedures, functions, implementing error handling logic, performance tuning and query optimization, bug fixing, data auditing and Production Job monitoring.
Work closely with team members, DBAs, and business analysts to implement a sound solution, while adhering to agile methodology and lean integration techniques.
Matching Summary
Design, develop, test, implement, and maintain PL/SQL code, UNIX scripts, and Views for reporting and other needs.
Skills & Requirements
Must-have
PL/SQL development and maintenance
UNIX shell scripting
Data warehousing concepts
ETL strategies
Performance tuning and optimization
Oracle Scheduler and Crontab
Nice-to-have
Agile methodology
Lean integration techniques
Problem-solving skills
Adaptability to change
Collaboration with cross-functional teams
Key Requirements
Minimum 4 years experience programming using Oracle SQL and PL/SQL
Minimum 2 years experience of shell scripting
Experience with Oracle Scheduler, UNIX Crontab and OEM
Experience using both Oracle Transactional Database and Oracle Datawarehouse
Bachelor’s degree in Information Technology or related field