Company : Sutherland Global Services
Website : www.sutherlandglobal.com
Job Role : Oracle PL SQL Developer
Eligibility : Any Graduate
Experience : 5 – 10 Years
Job Location : Mumbai
Job Description:
Development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, testing & support.
Develop interfaces to load data into targeted database and extract data from flat files.
Created Tables, Constraints, Indexes, Triggers, Cursors, Ref Cursors, anonymous blocks, sequences etc.
Tune SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization.
Use Collections, Bulk Binding, Materialized Views, Packages and Dynamic SQL.
Applied Tuning and Optimization, Normalization in the database design.
Wrote Audit programs for data consistency check and validation.
Interpret / analyze business requirements & functional specifications.
Determine the impact of proposed functionality on current system.
Provide input/assist in conducting system feasibility studies.
Participate in and/or Create Design documents.
Completes independently efficient coding on complex applications.
Document unit test plans; completes unit testing successfully.
Feasibility study, planning, implementation, testing, deployment and close-out.
Responsibilities:
Minimum 5+years of technical experience on Oracle PL/SQL and advanced PL/SQL. i.e. Procedures, Packages, Functions, Indexes, Collections, Materialized views, Triggers, Bulk Binding, Exception handling etc.
Experience in Performance tuning, Data Modelling and Data Analysis.
Experience in Database architecture and design.
Excellent in writing complex SQL Queries and improving the performance of existing queries. Should able to perform query optimization & database tuning.
Experience on Oracle 11g is preferred.
Good to have Experience in MS-SQL 2008 (T-SQL) or above.
Good foundations in ETL concepts.
Good in Logic building, Reasoning and Analytical skills.
Should be assertive with problem solving skills.
Fair verbal and written communication skills.
Domain knowledge of Travel vertical would be an added advantage.
Walk-In Date : 07 Apr 2018
Walk-In Time : 09:00 AM Onwards
Venue Details:
Sutherland Global Services,
5th Floor, Liberty Tower, Behind Reliable Plaza,
Thane Belapur Road, Airoli, Navi Mumbai – 400708.
Contact Details:
Nicola Fernandes
8056030418