Genesis10 is currently seeking a Data Engineer (Oracle PL/SQL) for a hybrid position (minimum 3 days per week onsite) with a Global Financial Institution located in Jersey City, NJ and Addison, TX. This is a contract to hire opportunity. This role is part of a Data Engineering group focused on building and maintaining robust, database-centric data pipelines, database solutions, and analytics platforms across heterogeneous systems. The team develops and maintains Oracle PL/SQL packages, procedures, and functions, along with Unix Shell/Python automation, with workload scheduling orchestrated through Autosys. They ensure end-to-end data integrity, reliability, and performance across traditional database environments.
Responsibilities: - Develop a strong understanding of stakeholder needs and translate them into scalable database-based technical solutions
- Analyze existing business processes and design Oracle-centric optimizations, automation, and workflow improvements
- Gather and document functional, non-functional, and technical requirements for incoming requests
- Analyze functional and data requirements to understand how applications store, transform, and expose data within Vertica/Oracle
- Assist users and development teams with application testing, data validation, and troubleshooting Oracle/Vertica database processes
- Identify, document, and troubleshoot application and database-related issues (performance, data integrity, failures)
- Document end-to-end processes, database procedures, workflow logic, and operational runbooks
- Collaborate with other development teams to manage interdependencies, design test cases, debug issues, and maintain high data quality
- Ensure software stability through documentation, peer code reviews, regression testing, unit testing, and UAT
- Perform logical and physical data modeling, including schema design in Oracle
- Perform in-depth data analysis, profiling, and identification of data quality issues
- Support story refinement, requirement elaboration, and effort estimation in Agile processes
- Lead team members through technical complexities in Oracle development and CI/CD pipeline design
Requirements: - 10+ years of experience with relational and non-relational databases, focusing heavily on Oracle SQL and PL/SQL
- Strong experience designing and implementing Oracle-driven data integration pipelines using SQL, PL/SQL, and Unix shell scripting
- Experience automating Oracle processes using job schedulers (Autosys preferred)
- 10+ years of professional experience in SQL/PLSQL development, including packages, functions, procedures, triggers, and bulk processing
- Ability to refine requirements, participate in story sizing, and help drive Agile delivery
- Strong understanding of how to integrate multiple architectural components (data, application, business)
- Good understanding of dimensional modeling, star/snowflake schemas, facts, dimensions, and hierarchies
- Skilled in leading and developing complex Oracle data flows, connecting to heterogeneous databases such as Oracle and MS SQL Server
- Hands-on experience developing complex Oracle procedures, functions, and PL/SQL packages used in APIs, reporting, and data warehousing
- Ability to conduct proactive and reactive Oracle performance tuning using explain plans, indexing strategies, statistics, hints, and SQL optimization best practices
- Strong hands-on experience developing and supporting Unix shell scripts
- Experience with Agile tools (Jira)
Pay range: $63.68 - $71.68 per hour
Only candidates available and ready to work directly as Genesis10 employees will be considered for this position. This role will require resources that do not require sponsorship now or in the future.
If you have the described qualifications and are interested in this exciting opportunity, please apply! Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals.
For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client. Benefits of Working with Genesis10: - Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years.
- The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.
- Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)
- Behavioral Health Platform
- Medical, Dental, Vision
- Health Savings Account
- Voluntary Hospital Indemnity (Critical Illness & Accident)
- Voluntary Term Life Insurance
- 401K
- Sick Pay (for applicable states/municipalities)
- Commuter Benefits (Dallas, NYC, SF, and Illinois)
For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us at our website.
Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Never miss an opportunity! Create an alert based on the job you applied for.