non-locals are fine as far as delivery is not an issue.
Skills: ETL Development , MaP SourceSystems to data warehouse, Develop and test extraction, ETL Processes
GENERAL DESCRIPTION
Responsible for the scripts 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.
KEY RESPONSIBILITIES
• Map source system data to data warehouse and data mart models • Develop and test extraction, transformation, and load (ETL) processes • Define and capture metadata and rules associated with ETL processes • Adapt ETL processes to accommodate changes in source systems and new business user requirements • Provide production support for existing ETL processes KEY SKILLS • Understand source and target data structures, ETL processes, and products • Knowledge of 3GL/4GL programming languages • Strong problem-solving and metadata skills KEY DELIVERABLES • Completes mapping and transformation specifications and programs • Schedules extraction and load processes • ETL metadata documented and maintained in metadata repository • Prepares deployment plans for ETL projects to be implemented in QA and Production environments • Provides analysis and troubleshooting for production ETL maps that incur any errors
Qualifications: Broad understanding of data warehousing, dimensional modeling, and enterprise reporting capabilities. Experience with Oracle Warehouse Builder, ERWin or similar tools required. ERP for manufacturing experience is a plus. Excellent analytical and communication skills to work with a large user base for understanding application issues and providing a quality, long-term resolution required. Must have demonstrated the ability to work as a member of an enterprise team. Experience with and understanding of IT Change Management processes. The position typically requires a college or university degree or certification that is equivalent. In addition, this position requires five or more years of experience with progressively increased levels of IT experience. The ability to listen to others is an important trait for this job.
•
Last updated on Nov 6, 2017