Pyramid Consulting, Inc · 3 weeks ago
Principal Oracle PL/SQL Developer
Jersey City, NJ
Contract
Onsite
Lead/Staff
$55/hr - $60/hr
8+ years expPyramid Consulting, Inc. is seeking a Principal Oracle PL/SQL Developer for a long-term contract opportunity. The role involves working with highly sensitive, large data sets in the financial industry, utilizing skills in Oracle, PL/SQL, Unix Shell Scripting, ETL, and Python.
ConsultingInformation TechnologyLegalProfessional ServicesSoftwareStaffing Agency
Responsibilities
Must have skills: - Oracle, Pl/SL, Unix Shell Scripting, ETL and Python
8 years of hands-on experience as an Oracle PL/SQL developer with highly sensitive, large, data sets
Strong RDBMS skills – SQL querying, writing stored procedures, triggers, functions, views, user privileges, object privileges, etc
Strong data analysis, problem-solving, and design skills with a desire to continually learn and grow in a team-based environment
Good experience with performance tuning of stored procedures and queries
Knows ETL processes to load large volumes of data at speed, e.g. SQL Loader, etc
Has experience in Linux environment and knows basic Unix commands
Experience working with team in Agile methodology
Experience with database modelling
Knowledge of Core Java, Python, scheduling tool like Control-M is nice to have
AWS Cloud experience is a plus
Strong data analysis skills, design, and coding experience in Financial Industry preferably in Client Markets/ Securities Finance
5 years working in the financial industry is a plus
Understand glossaries and terminologies in the financial industry
Ability to work independently and collaborate with teams
Motivated and able to deliver end-to-end solutions
Good communication skills to both technology folks and business partners
Quick learner, adaptable, has the right attitude to work across teams to find and deploy
10 TB of data (massive data sets – plus, if anything wrong happens here, it’s a big deal. Qualified candidates must be used to dealing with large volumes of sensitive, critical data sets with low tolerance for error.)
Data is coming from internal systems as an upstream from Oracle. We also have external data coming
Data moving all over the place in a lot of different directions
10 years’ experience, including hands-on experience with: Performance tuning existing or new
Extensive Oracle SQL & PL/SQL development experience
Unix shell scripting
Some reporting tool experience
For ETL, we use SQL loader
Python would be very good to have
Qualification
Required
Must have skills: - Oracle, Pl/SL, Unix Shell Scripting, ETL and Python
8 years of hands-on experience as an Oracle PL/SQL developer with highly sensitive, large, data sets
Strong RDBMS skills – SQL querying, writing stored procedures, triggers, functions, views, user privileges, object privileges, etc
Strong data analysis, problem-solving, and design skills with a desire to continually learn and grow in a team-based environment
Good experience with performance tuning of stored procedures and queries
Knows ETL processes to load large volumes of data at speed, e.g. SQL Loader, etc
Has experience in Linux environment and knows basic Unix commands
Experience working with team in Agile methodology
Experience with database modelling
Strong data analysis skills, design, and coding experience in Financial Industry preferably in Client Markets/ Securities Finance
Ability to work independently and collaborate with teams
Motivated and able to deliver end-to-end solutions
Good communication skills to both technology folks and business partners
Quick learner, adaptable, has the right attitude to work across teams to find and deploy
10 TB of data (massive data sets – plus, if anything wrong happens here, it's a big deal. Qualified candidates must be used to dealing with large volumes of sensitive, critical data sets with low tolerance for error.)
Data is coming from internal systems as an upstream from Oracle. We also have external data coming
Data moving all over the place in a lot of different directions
10 years' experience, including hands-on experience with: Performance tuning existing or new
Extensive Oracle SQL & PL/SQL development experience
Unix shell scripting
Some reporting tool experience
For ETL, we use SQL loader
Preferred
Knowledge of Core Java, Python, scheduling tool like Control-M is nice to have
AWS Cloud experience is a plus
5 years working in the financial industry is a plus
Understand glossaries and terminologies in the financial industry
Python would be very good to have
Benefits
Health insurance (medical, dental, vision)
401(k) plan
Paid sick leave (depending on work location)
Company
Pyramid Consulting, Inc
Pyramid Consulting, a global leader in workforce and technology solutions, empowers individuals and organizations to transform and thrive in the most challenging and competitive markets.
5001-10000 employees
H1B Sponsorship
Pyramid Consulting, Inc 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 (178)
2024 (112)
2023 (95)
2022 (62)
2021 (50)
2020 (117)
Funding
Current Stage
Late StageLeadership Team
Ramesh Maturu
President and Co-Founder
Manish Kaushik
Chief Financial Officer
Recent News
2025-08-18
Company data provided by crunchbase