Feature Lead - Technology

Responsibilities

• 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
• 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)
• Create and maintain training material for end-users and support teams
• Demonstrate exceptional analytical/problem solving skills with strong communication and collaboration
• 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
• Develop strong understanding of stakeholder needs and translate them into scalable Database based technical solutions

Qualifications

• Bachelor's 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 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
• Able to conduct both 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 (critical skill)