Oracle SQL / PySpark

Innova Solutions • Jersey City, NJ

5d • Hybrid

About The Position

Innova Solutions is hiring an Oracle SQL & PySpark Developer for a client on an 18-month contract. The role is based in Jersey City, New Jersey, with three days onsite. The developer will design, optimize, and modernize large-scale data solutions using Oracle SQL and PySpark; lead big data migrations; develop high-performance data pipelines; and drive end-to-end delivery of scalable data platforms.

The position requires substantial Oracle SQL development and performance tuning experience, hands-on PySpark expertise, and experience with large datasets and Hadoop ecosystem technologies. Candidates must be available for W-2 engagement; 1099 contractors and Corp-to-Corp arrangements are not accepted. The hourly pay range is $65–$68 on W-2, with the final offer dependent on factors including education, experience, work location, job duties, and certifications. Benefits are offered based on eligibility.

Requirements

• 10+ years of experience in Oracle SQL programming and development.
• Strong hands-on PySpark experience, including RDDs, DataFrames, transformations, and actions.
• Experience designing and developing scalable data pipelines using PySpark.
• Strong expertise in Oracle SQL performance tuning and query optimization.
• Experience with the Hadoop ecosystem, including HDFS, YARN, and Hive.
• Experience working with large datasets of 100 million or more records.
• Strong understanding of Spark performance optimization, partitioning, caching, and execution plans.
• Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
• 8–12+ years of experience in data engineering, database development, or data architecture.
• Proven expertise in Oracle SQL and PySpark development.
• Experience designing and implementing enterprise-scale data pipelines.
• Must be eligible for W-2 engagement; 1099 and Corp-to-Corp arrangements are not considered.

Nice To Haves

• Experience with data architecture and big data platforms.
• Financial services or banking domain experience.
• Experience leading cross-functional development teams.
• Experience conducting code reviews and mentoring developers.
• Strong understanding of object-oriented programming concepts in PySpark.
• Experience with Agile development methodologies.
• Experience with large-scale enterprise data modernization programs.

Responsibilities

• Design, optimize, and modernize large-scale data solutions using Oracle SQL and PySpark.
• Lead big data migrations.
• Develop high-performance, scalable data pipelines.
• Drive end-to-end delivery of scalable data platforms.
• Design and implement enterprise-scale data pipelines.

Benefits

• Medical and pharmacy coverage, subject to eligibility.
• Dental and vision insurance.
• 401(k).
• Health savings account (HSA) and flexible spending account (FSA).
• Life insurance.
• Pet insurance.
• Short-term and long-term disability coverage.
• Accident and critical illness coverage.
• Prepaid legal and identity theft protection.
• Sick time and other paid leaves as required by law.
• Employee Assistance Program (EAP).

What This Job Offers

• Job Type: Full-time
• Career Level: Senior