Wellington Steele & Associates (WS&A) is recruitment firm with roots deeply entrenched in Rochester, NY that is dedicated to supporting the continued prosperity of the Upstate NY region.  With more than three decades of successful staffing industry experience our team of employment experts is devoted to helping you explore all the worthwhile career opportunities that this area has to offer. 

Position Summary

The ETL Developer will work as part of the Information Management Team to bring together our operations, processes and information in order to deliver product, service and quality that exceed both our customers’ expectations and our competitors’ capabilities. The ETL Developer will be responsible for the design and development of new ETL processes utilizing Oracle Data Integrator to develop an Enterprise Data Warehouse and Operational Data Store that supports the our business initiatives. You will participate in all phases of the data warehouse lifecycle. He/she will develop and analyze requirements, map the system to the data warehouse schemas and incorporate future data sources into schemas.  In addition this person will be responsible for detailed technical designs, identifying technological risks, participate in the implementation phase, design walk through, and recommend technology solutions for the data warehousing projects.

Position Summary

This is contract-to-direct opening for a multi-billion dollar company.  This is a highly complex initiative that will involve integration data from disparate applications and data sources that are dispersed all over the globe.  Our client offers a tremendous amount of personal and professional career growth and a fantastic working environment. 

Responsibilities

·        Analyze business data requirements to produce relevant ETL architecture deliverables (source analysis, source to target maps, ETL flows)

·        Develop source to target maps and identify transformation rules

·        Create data integration blueprint and install, configure and tune ETL infrastructure to support the data warehouse solution

·        Develop ETL flows and framework to support ETL development

·        Development of ETL processes utilizing Oracle Data Integrator

·        Work closely with business and technical teams to understand, document, design and code ETL processes

·        Optimize data warehouse to support business users and Business Intelligence (BI) applications such as Cognos and other analytics tools

·        Performs other duties as assigned by manager.

Qualifications

• Bachelor’s Degree in Information Systems, Computer Science or equivalent knowledge/experience is required.
• 5+​ years of experience with relational databases (SQL Server, Oracle, DB2, Teradata, etc)
• 3+ years working on BI/DW Projects
• 3+ years of deep experience as an ETL Architect/Developer well versed in ETL tool usage, architecture, design, and development
• Substantial ETL architecture design experience within data warehousing environments governed by applying appropriate methodologies and ETL standards
• Ability to design ETL technical/functional specifications
• Conceptual, logical and physical data modeling through use of data modeling tools is a plus
• Must have experience with Oracle Data Integrator
• Experience working with JD Edwards data structures is strongly desired
• Experience in the beverage alcohol or consumer packaged goods industry helpful.
• Strong written and verbal communication skills, and very strong problem solving skills.
• Ability to work well with individuals at all levels in the organization.
• Ability to adapt and react quickly to changing business needs.
• Ability to balance multiple projects simultaneously and work on a team or individually.
• Ability to work with key staff in remote geographical locations is required.

ADA Physical/Mental/Workplace Requirements

·        Occasional lifting up to 25 lbs.

·        Sitting, working at desk/personal computer for extended periods of time

·        Primary work environment is professional corporate office

·        Ability to travel commercially