Senior Specialist - Data Engineering

Key Skills : Oracle SQL, PL/SQL, OLTP/OLAP Data Modelling experience

Mandatory Qualifications:

• Bachelor’s degree in Computer Science, Information Systems Management, or related field preferred

• 12+ years of strong experience in Oracle database development with 6 years or more hands on experience in Database Modeling

• Extensively worked on PL/SQL Packages, Procedures, Functions, Triggers, Views, MViews, External tables, partitions and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle

• Must have good experience data migration activities

• Should have strong Performance tuning and troubleshooting experience

• Must have experience in advance PL/SQL, Hints, Cursors to process huge volumes of data, bulk collect for performance improvement process

• Must have experience Data Modeling and Warehousing concepts such as Star Schema, OLAP, OLTP, Snowflake schema, Fact Tables for Measurements, Dimension Tables for Descriptive Context, Periodic Snapshot Fact Tables, Junk Dimensions etc.

• Hands on experience on SCD Type 1,Type 2,Type 3,Type 4,Type 5,Type 6

• Must have very good understanding of Snapshot tables, staging tables, History tables, Audit tables, Granularity, Single Granularity for Facts, Dimension Granularity and Hierarchies, Date Dimension, Degenerate Dimensions, Surrogate Keys, Generalization and Normalization of data, Ragged Hierarchies etc.

• Highly proficient in writing complex yet efficient SQL

• Aware of Linux or UNIX.

• Familiar with standard SDLC and Agile processes

• Must be familiar with basic DBA activities such as memory management, schemas creation, role creation, adding removing space from data files, identify long running queries, session management etc.

Desirable Qualifications:

• Very good understanding in Oracle architecture

• Knowledge of any data modeling tool such as IBM InfoSphere

• Ability to understand data very quickly

• Worked on migration projects

• Ability to prioritize and manage schedules under tight, fixed deadlines

• Strong writing, communication, time-management, decision-making, and basic task organization skills

• Experience creating high level technical/process documentation and presentations for audiences at various levels. Experience writing/editing technical, business, and process documentation in an Information Technology/Engineering environment

• Should be able to own and manage the database deliverables.

• Should be able to maintain the data dictionaries for large databases

• Mandatory Certificate: Oracle Database SQL Certified Associate or Data Modelling

Our client requires all the employees working on this engagement to be COVID-19 vaccinated.

• If you need a reasonable accommodation for a sincerely held religious belief or medical condition, please contact covid-19@lntinfotech.com

Job Segment: Database, SQL, Oracle, Computer Science, DBA, Technology