Share this Job

Specialist - Data Engineering

Apply now »

Date: Nov 11, 2022

Location: US

Company: LTIMindtree

Functional Role in the Program/Project: Oracle DBA/Data Modeler with DWH and PL/SQL experience

Key Skills (Keywords): OLTP/OLAP Data modeling experience, Oracle SQL, PL/SQL

Mandatory Qualifications:

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

• 8+ years of strong experience in Oracle database development with 2 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: Data modelling or Oracle Database SQL Certified Associate

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

Job Segment: Database, Information Systems, Computer Science, SQL, Oracle, Technology