Job Description :
Job title: ETL Developer
Location: Rensselaer, New York
Long Term contract
Requirements:
Years of work experience: 7 year(s)
Perform complex PL/SQL coding in a Data Warehouse environment with an Oracle Database.
Perform unit testing and correct all identified bugs.
Work in coordination with a team of developers to expand the current Data Warehouse.
Work with Business Analyst & customers on analysis and logical design for mappings and ETL.
The individual in this position will work under the direction of a Project Manager.
Work with KPI BA & Tableau developer to design/model, construct, load, and validate the data tables through the enterprise Data Warehouse.
Responsible for load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements (Oracle upgrades
Mandatory Qualifications:
Develops and implements applications and programs for the backend processing systems used in businesses and organizations.
84+ months-Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
Preferred Qualifications:
84 months experience in a data warehouse setting as a developer utilizing an enterprise data warehouse with dependent data marts.
84 months experience in SDLC including requirement gathering, development, testing, debugging, deployment, documentation, and production support.
60 months experience developing and testing maps, performing source-to-target mappings, storage capacity planning and developing ETL in Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI) including migrating OWB projects to ODI 12c.
60 months Data modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
60 months experience in an Oracle Data Warehouse as a developer performing development work using PL/SQL.
60 months experience in converting business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
Bachelor’s Degree.