Description
Job Title: Oracle + ETL Developer (Informatica or DataStage)
Duration: 12-18 months
Location: Dallas, TX, Greater NY, Pennington NJ, Charlotte, NC
Required Pay Scale: $65 - 70 hr
Job Summary:
Project Details:
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.
Must Haves
• 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)
o 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
Desired Skills
• Exposure to CI/CD tools like Jenkins, Maven etc.
• Advanced understanding of SQL, PL/SQL stored procedures, triggers, partitions, primary keys, different indexes, views
• In-Depth knowledge of database concepts and hands-on experience in:
? Linux/Unix shell scripting
? Debugging and modifying existing application
? Installing configuration of applications and maintaining environments
? Toad
? Batch scheduling software such as Autosys
? Jira
? Python
? SQL*Loader
? External Tables and Directories
? Data Modelling
? Data Dictionary
? Common Packages such as UTLFile, DBMS_OUTPUT
? Oracle Enterprise Manager (OEM)
About Matlen Silver
Experience Matters. Let your experience be driven by our experience. For more than 40 years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works.
Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status.
If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at email and/or phone at: [email protected] // 908-393-8600
