Skillset: Informatica ETL Data warehousing
Experience: Bachelors Degree plus 5 years experience
The Lead Advanced Technology will design, develop, and modify Data warehouse ETL processes that load data for data warehouse users or for web applications using Informatica/other ETL tools. This role will perform requirements gathering, design, construction, testing, performance tuning, and maintenance for global data transformations and data loading. This person will also work directly with both internal and external customers to troubleshoot issues and provide support. The Lead Advanced Technology also designs ETL standards and design for future supportability and ease of enhancements, participate in the creation of reusable components related to the ETL framework, and assist with the management of ETL scalability.Informatica or equivalent ETL certification mandatory. Travel to customer location to perform job duties is mandatory.
Skillset: SSIS 2008 Data modeling
This individual will be focused on designing and implementing new aspects of our enterprise data warehouse.
The successful candidate will be skilled in drawing technical components out of the business requirements; integrating those components into Operational Data Store structures; and migrating them to the appropriate Data Mart. They will also be familiar with determining the applicability of existing warehouse components to new business requirements.
The successful candidate will have the ability to communicate Business Intelligence and Data Warehousing concepts to both our Business and Technology partners.
S/he will understand and champion Data Quality standards and ensure those standards are incorporated into the design and data processing for the enterprise data warehouse.
S/he will be conversant in understanding the various steps in boarding data to the various warehouse components and implementing solutions that allow delivery of meaningful information to the user via multiple delivery mechanisms.
Duties and Responsibilities:
Implement changes or additions to the data warehouse environment
Write and/or modify SSIS packages, SSRS reports and report models, and SSAS cubes as necessary
Design and direct the ETL processes, including data quality and testing
Define technical requirements for the data warehouse and data marts
Define and direct the implementation of security requirements
Define data capture methodologies
Define and design production release procedures
Education, Skills and Experience:
Bachelors Degree from an accredited college or university required
Advanced degree in Computer Science, Information Systems or Statistics preferred
Significant experience designing and maintaining large Data Warehousing environments (over 5 Terabytes)
Strong experience with Microsoft Business Intelligence Stack (SSRS, SSAS and SSIS) and/or MicroStrategy 9
Experience designing and supporting Data Warehouses utilizing SQL Server 2005 and/or 2008
Experience designing relational and multi-dimensional models
Data modeling skills
Strong business and communication skills
Significant skill and experience in requirements definition and analysis
Significant skill in source data discovery
Significant skill in data anomaly identification/resolution
Business Analyst with Data warehouse experience.