The Data Warehouse (ETL) Developer’s role is to construct the programs, processes and procedures to extract, transform and load data for enterprise intelligence. This person is responsible for participating in the development, maintenance and enhancement of business applications and infrastructures.
Responsibilities
Strategy & Planning
· Assist in planning and implementing capacity and resource expansion to ensure scalability.
· Assist in designing and implementing redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective availability, protection, and integrity of data assets.
· Design and develop the scripts and programs required to extract, transform, clean, and move data and metadata so they can be loaded into a data warehouse, data mart, or operational data store
Acquisition & Deployment
· Conduct research on data warehouse products, services, protocols, and standards in support of procurement and development efforts.
· Evaluate data warehouse components, including hardware, database management systems, ETL (extract, transform, load) software, data mining tools, and meta data management tools.
Operational Management
· Maps source system data to data warehouse models
· Develops and tests extraction, transformation, and load (ETL) processes
· Work with business requirements analyst to identify and understand source data systems
· Diagnose and resolve ETL access and performance issues.
· Support change control and testing processes for modifications to data systems.
· Schedule extraction and load processes
· Stored Procedure development and adhoc T-SQL coding.
· Regression testing, impact analysis of changes to environment.
· Ongoing support of back-end data warehouse processes including bug fixing and performance improvement.
Position Requirements
Formal Education & Certification
· College diploma or university degree in the field of computer science, information systems, or computer engineering and 4 years equivalent work experience.
Knowledge & Experience
· Background in database platforms, including MS SQL Server and Oracle.
· Working knowledge of data integration applications, including Informatica and MS SQL Server Integration Services
· Experience creating data acquisition / ETL architectures to enable enterprise intelligence
· Technical knowledge of platform operating systems, including UNIX and Windows.
· Strong understanding of the organization’s goals and objectives.
Personal Attributes
· Exceptional analytical, conceptual, and problem-solving abilities.
· Strong written and oral communication skills.
· Excellent technical architecture and technical support documentation skills.
· Strong presentation and interpersonal skills.
· Ability to present ideas in user-friendly language.
· Ability to effectively prioritize and execute tasks in a high-pressure environment.
· Experience working in a team-oriented, collaborative environment.
Work Conditions
· On-call availability
· Some travel between company campuses may be required