Educational requirements: Bachelor
English requirements: Competent English
Requirements for skilled employment experience for years: 3-5 years
Required residence status: Temporary visa, Permanent resident, Citizen
Accept remote work: unacceptable
Primary or Mandatory skills:- • 16 years of experience with expertise as Oracle PL/SQL Developer in areas of Application software development and maintenance in Oracle environment using Client/Server. • 7 Years of experience on SQL Server (SQL, T-SQL) along with SSRS, SSIS & WhereScapeRed ETL experience. • Successful implementation of Data Migration and upgrade projects. • Successful implementation on document migrations. • Expertise in Sonata application, Wealth Management. • 7 Years of experience on Sonata and SonataODS Applications • Good understanding of Business Functionality in the IT and Superannuation domain. • Created Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX and Windows environment • Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms. • Granted resources, privileges, and roles to users • Tuned SQL queries using EXPLAIN PLAN, Hints and SQLPlus Auto trace report for query optimization • Used SQLLoader, Import/Export, UTL_FILE, DBMS_XMLQUERY, DBMS_PIPE and other Oracle built-in packages • Extensive knowledge of the Life Insurance industry; products and operational processes. • Automated SQL*Loader to load the data from the flat files • Performance Tuning of Oracle Applications using TKPROF • Wrote Shell Scripts for scheduling jobs in Unix/Windows, regular backups, instance start/shutdown and migrating data into tables. • Experience on Data migration activities and business data validations. • Good experience in Trouble shoots the issues (WebLogic, PL/SQL, Batch scripts). • Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing Offshore consulting experience on JDA SCM & Retail products like Demand Planning, Fulfillment, and Allocation in implementation, migration, enhancement, and support projects.
Good to have skills : SQL, PL/SQL, Shell Scripting, SQL Server (SQL, TSQL), Sonata Application experience
