Job description

Role Description

· We are looking for a developer who possesses strong experience in Oracle SQL and PL/SQL plus ETL (Informatica or DataStage).

• Developing and delivering complex software requirements to accomplish business goals.

• Ensuring software is developed to meet functional, non-functional, and compliance requirements.

• Coding solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements

• Ensuring solution can be integrated successfully into the overall application/system with clear, robust, and well-tested interfaces.

• Becoming familiar with development and testing practices of the bank.

• Contributing to story refinement and defining/clarifying requirements.

• Participating and guiding team in sizing/estimating work necessary to realize a story/requirement through the delivery lifecycle.

• Performing spike/proof of concept efforts as necessary to mitigate risk or implement new ideas.

• Utilizing multiple architectural components (across data, application, business) in design and development of client requirements.

• Assisting team with resolving technical complexities involved in realizing story work.

• Contributing to existing test suites (integration, regression, performance)

• Performing analysis of test reports, identifying any test issues/errors, and Triaging underlying cause.

• Documenting and communicating required information for deployment, maintenance, support, and business functionality.

• Participating, contributing, and coaching team members in the delivery/release (CI-CD) events. e.g., branching timelines, pull requests, issue triage, merge/conflict resolution, release notes.

Required Skills

• Strong software engineering skills with deep hands-on programming experience in database programming and design using SQL, PL/SQL using Oracle 19c or better (5-7 years)

· In-Depth knowledge of database concepts and hands-on experience in:

• Oracle SQL

• Oracle PL/SQL

• Database Objects

• Database design and development

• Full life-cycle development experience working in data centric applications such as data warehouse, data mart, operational data store, etc. ecosystem including data modelling through final solution.

• Ability to perform analysis of performance bottlenecks, propose options, and implement performance tuning recommendations for Oracle database queries/code and batch processes.

• ETL Design and Development: Informatica and/or DataStage

· Monitoring performance, troubleshoot and tuning ETL processes as appropriate

· Developing ETL workflows for periodic data loads from source to target databases

· Applying ETL principles and practices, and ability to implement complex solutions to problems

· Designing and building scalable ETL solutions.

· Skilled at ideation, design, and deployment of ETL solutions

· Full life-cycle development experience working in data centric applications such as data warehouse, data mart, operational data store, etc. ecosystem including data modeling, ETL, etc.

• Experience working in an Agile team

• Strong written and oral communicator who can work with minimum supervision. Must be able to clearly and succinctly articulate progress, issues, solutions, plans, results, and success

• Ability to provide technical leadership to initiatives and teams

Job Type: Full-time

Pay: Up to $75.00 per hour

Schedule:

• 8 hour shift

Ability to commute/relocate:

• Jersey City, NJ 07302: Reliably commute or planning to relocate before starting work (Required)

Experience:

• Oracle: 10 years (Preferred)
• PL/SQL: 10 years (Preferred)
• Data warehouse: 10 years (Preferred)

Work Location: In person

smogtown13.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, smogtown13.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, smogtown13.com is the ideal place to find your next job.