*Data Warehouse Analyst - In person interview- **Direct Client* *Immediate Interview and Start ASAP!!!*
*Please send resume to **s...@cncconsulting.com <s...@cncconsulting.com>* Job Title: Data Warehouse Analyst Location: Olympia, WA Duration: 2 Months+ Direct Client Position Client: State of WA Note: Need 3 references in order to submit In person interview The Washington State Department of Transportation (WSDOT), Office of Information Technology (OIT) requires one (1) senior level Data Warehouse Analyst to develop and implement extract, transform, and load processes needed to support WSDOT’s data warehouse The contractor shall perform the technical tasks required to set up, maintain, enhance performance, and troubleshoot extraction, transformation and load (ETL) routines that move data from transactional databases and flat files to the data warehouse. The contractor shall provide support to report analysts and customers to ensure accurate and timely performance of reports utilizing information from the data warehouse. The data warehouse operating environment is SQL Server 2012 and 2016 on Windows 10 and our ETL tool is Informatica Power Center 10.1. Specific duties include: Using client requirements and database design specifications, the contactor shall: • Determine how the data sources identified can provide the required data. • Test data structures to verify that the target databases will work as designed. • Set up ETL routines: write the code using Informatica mappings that move data from the specified sources; transform it as required and write it into the data mart. The outcome of this task shall be error-free ETL routines that meet requirements and design specifications, and are regularly scheduled within the Department’s Data Warehouse loading process. • Provide technical assistance to staff in writing complex data-mart queries, based on the detailed knowledge gained during the construction of ETL routines. The outcome of this task shall be the Washington State Department of Washington State Department of Transportation ITPS Work Request – WR 2016 1129 TS 3 provision of technical information and ideas to support staff and query-tools experts who are assisting users with advanced, complex data-mart queries. Mandatory : Minimum *5 years of experience in creating and maintaining Extract, Transform, and Load (ETL*) processes using SQL Server Integration Services (SSIS) and / or Informatica Power Center. Minimum 5 years of experience writing complex queries using Transact SQL for reporting and data validation purposes. Minimum 5 years of experience using *Microsoft SQL Server 2000, 2005, and 2008 r2* software tools to administer and/or manage SQL Server databases. *Minimum 5 years of experience working with large organizations (over 1000 employees).* Minimum 5 years of experience employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development. Desirable Knowledge: Understanding of database modeling and design principles and ability to use a data model diagram. Experience using PowerExchange for Mainframe ADABAS. *Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * *Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com <s...@cncconsulting.com>* -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at https://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
