Data Warehouse Developer- career in USA

Job title:Data Warehouse Developer / 84
Location:Appleton, WI 54914
Industries:Healthcare Services
Job Type:Full Time Employee
Career Level;Experienced (Non-Manager)
Job Reference Code:84
Deadline: 20/08/2013
About the Job
Position Description:
Data Warehouse 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.​

· Identify potential issues or improvements needed for any processes that the Data Services team supports which include file transfers, data warehouse population and systems supported by data warehouse data.​

Acquisition & Deployment:
· Conduct research on data warehouse products, services, protocols, and standards in support of procurement, development and support 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:
· Develop and test extraction, transformation, and load (ETL) processes

· Work with business requirements analyst to identify and understand source data systems

· Ability to code and unit testing mappings or scripts following Data Services detail design templates.​

· 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 PL-SQL coding.​

· Regression testing, impact analysis of changes to environment.​

· Write and execute detailed unit test cases for each program.​

· Ongoing support of back-end data warehouse processes including bug fixing and performance improvement
Qualifications:
Formal Education & Certification
College diploma or university degree in the field of computer science, information systems, or computer engineering and 3 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

·         Technical knowledge of platform operating systems, including Linux and Windows.​.​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.
​Click here to apply