IrvingRecruiter Since 2001
the smart solution for Irving jobs

Oracle SQL/PL-SQL Developer

Company: LTI - Larsen & Toubro Infotech
Location: Irving
Posted on: August 3, 2022

Job Description:

L&T Infotech is one of the largest global technology consulting and digital solutions company -holding an annual revenue of $1.4 bn. We were founded 20 years ago as the information technology arm of the Larsen & Toubro group. We are currently partnered with more than 350 clients (66 of which are Fortune 500 companies). We operate in 28 countries - employing over 28,000 employees world-wide!
Job Title: Oracle SQL/PL-SQL DeveloperJob Type: FulltimeJob Location: Irving TX and Tampa FL

  • 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
        How will you grow? - Role-based Training programs - Continuing Education Programs (CEP) to enhance your knowledge, skills, and attitude as a professional - We encourage you to acquire various beneficial international certifications, with costs s reimbursed - Our role-based workshop helps us groom future leaders for LTI
        What's in it for you? - Excellent benefits plan: medical, dental, vision, life, FSA, & PTO - Roll over vacation days - Commuter benefits - Excellent growth and advancement opportunities - Certification reimbursement - Rewards and recognition programs - Innovative and collaborative company cultureWe are an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, gender identity, sexual orientation, disability status, protected veteran status, or any other characteristic protected by law.

Keywords: LTI - Larsen & Toubro Infotech, Irving , Oracle SQL/PL-SQL Developer, IT / Software / Systems , Irving, Texas

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Texas jobs by following @recnetTX on Twitter!

Irving RSS job feeds