Dear Partners/Job Seekers One of our JobPencil’s client has opening for * Senior Data Warehouse Analyst* requirement, if you have matching candidates please submit their profiles, contact JobPencil service team for more details.
*Job Title: Senior Data Warehouse Analyst* *Location: 7345 Linderson Way SW, Tumwater, WA 98501 or WSDOT Headquarters – 310 Maple Park Ave SE, Olympia, WA 98504 * *Duration: 12 Months* *Client: State of WA (Department of Transportation)* *Job Description:* *Minimum Qualification: * · Bachelors or Masters Degree in the related field. *Mandatory Skills:* · A minimum of five (5) years of experience in Creating and maintaining Extract, Transform, and Load (ETL) processes using SQL Server Integration Services. · A minimum of five (5) years of experience in writing complex queries using Transact SQL for reporting and data validation purposes. · A minimum of five (5) years of experience in Administering and/or managing Microsoft SQL Server 2000, 2005, 2008 r2, 2012 databases. · A minimum of five (5) years of experience in Working with large organizations (over 1000 employees). · A minimum of five (5) years of experience in employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development. *Desired Skills:* · Demonstrated Skills and Knowledge in the following areas · Creating and maintaining Extract, Transform, and Load (ETL) processes using Informatica, including use of Power Center for SQL Server. · Experience using Power Exchange for Mainframe ADABAS · Tuning and optimizing SQL Server databases. · Understanding database modeling and design principles and ability to use a data model diagram. · Performing mainframe-to-server automation, bulk copy and FTP download. · Programming in .Net. or COBOL and/or Natural running on an MVS/zOS platform. · Creating and maintaining OLAP cubes. * * *Responsibilities/ Roles:* · Participate in project team meetings and work closely with the data warehouse administrator, ETL staff, data modelers, database administrators, support analysts, report writers, TLA project team members, and the data warehouse project manager to create ETL routines. Creating ETL routines includes writing the code for SQL Server Integration Services (SSIS) mappings that move data from the specified sources, transform it as required and write it into the data mart. Client requirements and database design specifications will be provided by WSDOT staff. · Test target data structures to ensure that all works as designed. · Verify identified data sources to ensure that the needed data can be properly provided. · Write technical documentation of ETL routines to explain how the routines operate to meet requirements and design specifications. · Provide technical assistance to write complex data-mart queries, based on the detailed knowledge gained during the construction of ETL routines. · Assist in troubleshooting data loading and data warehouse performance issues. *“Recruiting is made easier with JobPencil.com” * JobPencil.com – is the leading technology job portal which connects the Employers looking to hire highly talented professionals and the candidates looking for right opportunities and employers. Please join our trail month program and *take advantages of our unique services are especially tailored for you:* *Manage Job Posting* - Manage up to 25 active jobs. • *Manage Consultants* - Manage all of your consultants who are currently looking for jobs. • *Question Bank* - You can create question papers from question bank offered by JobPencil.com • *Resume Alerts* - Create your resume alert criteria and keep receiving matching candidates! • *Resume Search* - Contact our Admin team for more information! • *Featured/Premium Employer Listing* - Contact our Admin team for more information! • *Video Interview/Conferencing* - Will be available very soon! To provide you with our valuable service, we will work to get you matching candidate for your requirement. We are looking forward to serving you. Please contact us for your questions and suggestions! Regards, JobPencil Service Team Web: www.JobPencil.com Phone: 614-583-8755 Fax: 614-388-5556 Email: [email protected] -- You received this message because you are subscribed to the Google Groups "MCMS" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/mcms. For more options, visit https://groups.google.com/groups/opt_out.
