Feature Lead – Technology

Jobtailor; New Jersey; On-site; USD 110,000 - 150,000; Full time

Job summary

Jobtailor in New Jersey seeks an experienced Oracle data integration engineer to design, develop and deliver data workflows. You will translate requirements into scalable ETL pipelines, ensuring data quality and compliance.

The role requires strong SQL/PLSQL, Unix shell scripting, and Oracle database expertise. You will guide the team on estimation, participate in Agile delivery, and mentor peers while optimizing data flows across systems.

Qualifications

• Bachelor's degree in a related field is required.
• Strong experience with SQL/PLSQL development and Oracle databases.
• Experience designing Oracle-driven data integration pipelines and data modeling.

Responsibilities

• Designs, develops and is accountable for feature delivery.
• Guides the team on work breakdown and execution.
• Works with the Product Owner to ensure product backlog/requirements are healthy with clear acceptance criteria.
• Mentors the team and leads by example in planning and estimation.

Skills

SQL

PL/SQL

Unix Shell Scripting

Data Modeling

Dimensional Modeling

Star Schema

Snowflake Schema

Job Scheduling

Oracle Database

Data Flow Development

Team Leadership

Mentoring

Requirement Refinement

Collaboration

Communication

Education

Bachelor's Degree in Engineering/Science/IT/CS

Tools

Autosys

Job description

• Designs, develops and is accountable for feature delivery.
• Applies enterprise standards for solution design, coding and quality.
• Ensures solution meets product acceptance criteria with minimal technical debt.
• Guides the team on work breakdown and execution.
• Works with the Product Owner to ensure that product backlog/requirements are healthy, with clear acceptance criteria.
• Plays a team lead role (as an individual contributor) and mentors the team.
• Guides team members with skills and practices (planning and estimation, peer reviews, and other engineering practices).
• 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—understand how applications store, transform, and expose data within Vertica/Oracle.

Requirements

• Bachelors Degree in Engineering, Science, IT, Computer Science or job related field required.
• 3+ years of job related experience required.
• 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).
• 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.
• Ability to perform POCs/spikes to test new Oracle features or solution patterns.
• Develop, test, and deliver Oracle-based solutions that meet acceptance criteria and adhere to compliance standards.
• 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.

Hard Skills

• SQL
• PL/SQL
• Unix Shell Scripting
• Data Modeling
• Dimensional Modeling
• Star Schema
• Snowflake Schema
• Job Scheduling
• Oracle Database
• Data Flow Development

Soft Skills

• Team Leadership
• Mentoring
• Requirement Refinement
• Collaboration
• Communication