Job Description

Technical:
•    Extensive experience in PL/SQL and Unix/Linux Shell Scripting
•    Strong hands-on experience in procedures, functions and packages in Oracle
•    Hands-on experience in writing queries and good knowledge on views, materialized views
•    Should have experience in analytical functions, hierarchical queries , pivot and unpivot
•    Strong hands-on experience in query performance tuning, explain plan, hints and parallel query
•    Working experience in fact and dimension table
•    Expertise in external table, SQL loader and also table partition, sub-partition and indexing
•    Knowledge on gathering tables stats and analyzing tables
•    Working experience in fact and dimension tables

Principal Accountabilities:           
•    Design, develop, test, debug, and automate ETL processes using Oracle PL/SQL and implement enhancements to existing ETL packages
•    Provide project, system, and other technical documentations
•    Document work/procedures in accordance with the agreed standards
•    Write unit and integration test plans/scripts and execute them
•    Conduct and coordinate analysis, design, and implementation of systems (application and database)
•    Review and get the design approved from the leads and onshore stakeholders
•    Report the progress of work in a timely manner
•    Take part in reviews of own work and implement the review comments
•    Ability to understand complex concepts and processes quickly
•    Participate in organization and department process improvement activities
•    Good time management and organizational skills
•    Ability to work independently and use good judgment
•    Ability to work in an agile team environment

Soft Skills:
•    Good communication, interpersonal, and problem-solving skills
•    Good team player

Educational Background:
•    Bachelor’s/Master's degree in Engineering or equivalent experience