Main characteristics
- Company
- Tech Mahindra Limited
- Category
- Information & Communication Technology
Job summary
Designation / Job title : Developer Programmer - 261312 Developer (Other)Number of Positions: 10
Primary or Mandatory skills:-9 years of experience with expertise as Oracle PL/SQL Developer in areas of Application software development and maintenance in Oracle environment using Client/ServerExpert in Sonata application, Wealth Management.Good understanding of Business Functionality in the IT and Superannuation domain.Created Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX and Windows environmentCreated 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 usersTuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimizationUsed SQL*Loader, Import/Export, UTL_FILE, DBMS_XMLQUERY, DBMS_PIPE and other Oracle built-in packagesExtensive knowledge of the Life Insurance industry; products and operational processes.Automated SQL*Loader to load the data from the flat filesPerformance Tuning of Oracle Applications using TKPROFWrote 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, Java, Java Script, Angular JS
Detailed Job description:-
Roles and Responsibilities : Analyzing the requirements provided by clients and preparing Design documents.Responsible in preparing the Technical Specifications with the new functionality that must be implemented for the Impacted Programs.Identification of Test cases satisfying the requirement & Preparation of Test plans to test the
individual programs.Performing all the Implementation activities.Mentoring team members, including ensuring in time quality deliveries, and providing guidance in technical and business aspects and giving optimum solution to all the issues.Gathering requirements in business terms from the client and translating them into technical terms.Handling the Supports activities such as Incidents, Service requests and Problem records and delivering in timelines.Unit, System testing & coordinating with the testing team and resolving the issues, if any.Documentation of the entire project process flow from end to end.Performing Peer review and identifying defects in testing.Providing project related training for new resources.Preparing various knowledge documents through which a fresh associate resource could catch up things in an easy and faster way.Defect prevention analysis at application level to reduce repetitive number of issues.
Inform me about similar jobs: