Development of functions, stored procedures, and packages
Development using external tables,bulk statement processing, dynamic statement execution, the use of bind variables, and the use of ref cursors, PL/SQL object types
SQL statement tuning, reviewing explain plans, and utilizing optimizer hints
Dealing with large volumes of data (millions/billions of rows of data) and dealing with partitioned tables
Integration with ETL processes and experience in ETL tools
Coding applications using best practices, documentation.
Knowledge of Java/J2EE would be added advantage
Would be responsible for unit testing.
Contribute in design improvement and product enhancement.
Demonstrate ability to understand unique requirements and implement them.
He/ She should be a self-learner, able to work independently and manage tasks in hand.
Skills:
Excellent skills in relational database design
Knowledge of Oracle, MSSQL, MySQL, Maria DB
Extract Transform Load (ETL) concepts and technologies
Data Warehousing tools, patterns and processes
Knowledge of Scripting language (added advantage)
Web servers: Apache Tomcat, JBoss, Weblogic and any additional web server
Knowledge of Java/J2EE frameworks (added advantage)
