ETL Developer

Introduction
At IBM, work is more than a job - it's a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you've never thought possible. Are you ready to lead in this new era of technology and solve some of the world's most challenging problems? If so, lets talk.

Your Role and Responsibilities
The IBM Client Innovation Center in Buffalo NY is expanding and has immediate opportunities for experienced forward thinking ETL Developer with a passion for growth and innovation. The success of IBM is in
your hands as you transform vital business needs into innovation solutions to drive growth for
our clients. Our clients are some of the world’s leading companies and you will be part of
challenging projects to build and support technical solutions for their needs You will have
access to the latest education, tools and technology, and a limitless career path with the world’s
technology leader. Come to IBM and make a global impact

The ETL Developer is responsible for data integration (ETL) development for data
warehouse solutions that deliver diverse reporting and analytic capabilities to
health and human services customers in the public and private sector.
This role develops data integration programs that load, transform and extract data
from the data warehouse, assures that architecture and development follow data
warehouse best practices. This individual works with DW architects, data architects,
hardware/software engineers, DBAs, application vendors and managed services to
ensure enterprise DW solutions are reliable, scalable, flexible and low maintenance.
This position requires a bachelor's degree or equivalent experience. The candidate
must demonstrate expertise in data warehouse concepts, practices, and
procedures, has technical hands on experience implementing data warehouse
solutions, has strong communication skills and the ability to provide consultation to
customers and collaborate internally on complex projects as a the key
contributor/specialist. This candidate should also be able to find creative solutions
to complex and diverse business requirements. This position typically reports to an
ETL Team Lead.
Essential Responsibilities (Specific day-to-day responsibilities):

• Review business and technical requirements and ensure the data integration platform meets requirements
• Apply industry best practices for ETL design and development
• Assists in design, development and implementation of end-to-end complex ETL system using Datastage tools
• Plan and contributes to ETL development efforts for team utilizing PL/SQL and DataStage tools
• Produce written deliverables for technical design, system testing and implementation activities
• Implement ETL systems that are operationally stable, efficient and automated
• Implement technical solutions that are scalable, aligned with the enterprise architecture and can adapt to changes in business
• Implement ETL systems that maximize re-usable components/services, collect/share metadata, incorporate audit, reconciliation and exception handling
• Implement parallel processing, load balancing, near real-time and real-time ETL processes
• Implement monitoring and measurement of data quality as defined by business rules
• Employ best practices, standards of excellence, and guidelines for programming teams
• Conduct Unit Testing - execute job flows, gather evidence of success, investigate defects, resolve defects and document results
• Assist in the development, documentation and application of best practices and procedures that govern DW implementations and operations
• Off hour and weekend support may be required to meet project milestones

The successful candidates for this position will become members of our Client Innovation Team.
You will work closely across the CIC network to delight our customers with leading edge
solutions with a keen focus on quality and client satisfaction. In addition to strong collaboration
across the team, you will be virtually integrated into our deep learning and knowledge program
as well as employee engagement across NA. All resources in our CIC network may be
requested to travel depending on specific client project needs. US Travel is typically related to
knowledge transfer and client relationship building at the client site, as well as subsequent travel
for key milestones or project initiatives. Travel is generally no more than 50% of the time.
Preferred locations: Albany, Rochester, Syracuse & Utica NY; Akron & Cleveland OH and
Pittsburgh PA


Required Technical and Professional Expertise

• 5 years’ experience programming ETL programs using DataStage language ortools
• 5 years’ experience performing data analysis and profiling, and designing ETL
• systems/program
• Advanced SQL skills
• In depth understanding of data integration best practices, leading industry applications and features such as master data management, entity resolution, data quality assessment, metadata management, etc.
• Understanding of data warehouse best practices
• Good communication skills
• Good interpersonal skills and the ability to collaborate with other technical teams, project management, client management and business analysts

Preferred Technical and Professional Expertise

• Health and human services experience
• Complete understanding of warehousing methodologies
• Experience with hash algorithms
• Experience implementing systems that utilize Oracle DBMS