PL/SQL Consultant

Full-time
India
Posted 3 years ago

Open Positions: 10

REQUIRED SKILLS AND EXPERIENCE

  • Should have good knowledge in creating packages, procedure, functions, triggers, collections, scheduler jobs.
  • Should have knowledge in advanced SQL queries and Performance tuning techniques.
  • Should have knowledge reading data from XML, JSON files and storing into Oracle Tables.
  • Unix knowledge – Should know basic script writing, executing a procedure, handling file transfer related commands.
  • Should have ability to understand business and capture data access pattern from user interface.
  • Should have ability to convert details of data access pattern to Data Dictionary.
  • Should have clear understanding on Normalization.
  • Should have ability to create data flow based on business use cases.
  • Should have created simple database using oracle with minimum of 5 tables.
  • Should have ability to explain the business use of the created database.
  • Need to have good understanding on DDL and DM concepts.
  • Having knowledge in creating Entity Relationship Model(Crows Notation) and Data Modelling techniques is advantage.
Share

Apply Online