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 covid-19@lntinfotech.com
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
Didn't find what you're looking for? Search again!
Loading more jobs...