ORANGE COUNTY, NY

The right person for this position will be able to work and thrive in a truly collaborative environment, be an eager learner, self-motivated and not afraid to work in partnership in all areas of the DW as needed. We are looking for a colleague who will take pride in being part of a team that is responsible for building and supporting a reliable, accurate, and flexible reporting platform accessed by over 600 users.

GENERAL RESPONSIBILITIES
The Data Warehouse ETL Developer is responsible for application development tasks and assignments related to data integration as well as preparation of detailed specifications, diagrams and other programming structures related to ETL processes. This individual will design, code, test, debug and document moderately complex programs and applications in addition to performing application maintenance tasks.
• Responsible for the design, development, documentation of ETL processes.
• Work in a complex environment which includes Database, Job Scheduling/Automation/Performance Tools.
• Participate in ETL Design sessions with the team.
• Production support of new or changing mappings and workflows and produce technical specifications.
• Responsible for the analysis, data profiling, development, and integration of disparate systems throughout all phases of the project life cycle.
• Work as part of a team delivering high quality and efficient integration solutions.
• Assist in ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL related activities.
• Implement best practices and tune for optimization.
• Complete assignments in a timely manner.
• Complete any other work as assigned.