Oracle PL SQL Developer jobs in United States
cer-icon
Apply on Employer Site
company-logo

LTIMindtree ยท 3 weeks ago

Oracle PL SQL Developer

LTIMindtree is a global technology consulting and digital solutions company that enables enterprises to reimagine business models and maximize growth. They are seeking an Oracle PL SQL Developer to leverage their expertise in SQL and PLSQL, focusing on database development and transformation projects.

ConsultingEnterpriseInformation TechnologySoftware
check
H1B Sponsor Likelynote
Hiring Manager
Vivek Saxena
linkedin

Responsibilities

Strong understanding between OLTP and Batch Processing using SQL and PLSQL
Oracle Table Indexs all types Primary Key
Oracle Table Partitions Fetch JSON data using PIVOT unknown number of columns applying rowlocks using SELECT
Strong written knowledge on SQL Joins PLSQL collections Deterministic function good understanding on sysrefcursor
How to capture which program is calling Oracle PLSQL Procedure function packages
Strong on Oracle SQL parsing SQL engine vs PLSQL engine PLSQL cursors ToDate totimestamp Renaming table columns
Very Good understanding of SQL execution plan inline functions
Best approaches on implementing user defined referential constraint check using PLSQL
Comparing data between two identical tables and finding list of columns with unmatched values fastest method on storing and retrieval of JSON data from CLOB columns why should be use Execute Immediate Oracle PLSQL exceptions user defined as well Oracle provided
PLSQL cursor Multiple ways to pass data from Oracle PLSQL procedure to Angular or Java or Python SQL operator in any ALL
Advantage and disadvantage of using PLSQL packages good understanding on Transaction within another Transaction in Oracle

Qualification

Oracle PL/SQLSQLJSON data handlingOracle Database certificationSoft skills

Required

Strong understanding between OLTP and Batch Processing using SQL and PLSQL
Oracle Table Indexs all types Primary Key
Oracle Table Partitions Fetch JSON data using PIVOT unknown number of columns applying rowlocks using SELECT
Strong written knowledge on SQL Joins PLSQL collections Deterministic function good understanding on sysrefcursor
How to capture which program is calling Oracle PLSQL Procedure function packages
Strong on Oracle SQL parsing SQL engine vs PLSQL engine PLSQL cursors ToDate totimestamp Renaming table columns
Very Good understanding of SQL execution plan inline functions
Best approaches on implementing user defined referential constraint check using PLSQL
Comparing data between two identical tables and finding list of columns with unmatched values fastest method on storing and retrieval of JSON data from CLOB columns why should be use Execute Immediate Oracle PLSQL exceptions user defined as well Oracle provided
PLSQL cursor Multiple ways to pass data from Oracle PLSQL procedure to Angular or Java or Python SQL operator in any ALL
Advantage and disadvantage of using PLSQL packages good understanding on Transaction within another Transaction in Oracle
Industry certification in Oracle Database

Benefits

Comprehensive Medical Plan Covering Medical, Dental, Vision
Short Term and Long-Term Disability Coverage
401(k) Plan with Company match
Life Insurance
Vacation Time, Sick Leave, Paid Holidays
Paid Paternity and Maternity Leave

Company

LTIMindtree

company-logo
LTIMindtree is a worldwide technology consulting and digital solutions company that empowers businesses in a variety of sectors.

H1B Sponsorship

LTIMindtree has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2651)
2024 (2855)
2023 (2267)

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Venu Lambu
Chief Executive Officer & MD
linkedin
leader-logo
Vipul Chandra
Chief Financial Officer
linkedin
Company data provided by crunchbase