Data Warehousing Specialist (ETL)

Zylog delivers top jobs to top talent. We are currently seeking experienced professionals for exciting new opportunities and career advancement. Zylog represents hundreds of client companies for both contract and permanent positions. New jobs are being filled every day and our experienced professional resource managers are waiting to help you screen the top jobs that match your skills and experience. You don’t have time to search long lists of postings repeated on multiple web sites, so let our trained and experienced resource managers do the work for you. We review top jobs and will be the first to alert you when the right opportunity arises.

Job Description:

Our client has a requirement for 2 Data Warehousing Specialist (DW Specialist) for 7 month’s renewable contract opportunity.  The positions are located in Toronto. 

• Design and implement the data loading (ETL) and  publishing processes within the DW/BI environment
• Design and implement multi-dimensional models, including the construction of Data View, Dimensions, and Cubes while adhering to enforced development methodologies.
• Design and implement reporting applications including (but not limited to) BI dashboards, reporting cubes and static reports.
• Convert existing reporting tools to a standardized reporting infrastructure using SQL and Microsoft products.
• Design and implement required interfaces for the data warehouse including to BI tools and other applications used by the business
• Identify data quality issues and support the data governance initiative by participating in necessary activities including data profiling.

What makes this Special:

Our client has a prestigious reputation and excellent work environment. This position offers an opportunity for personal learning and to contribute to important initiatives that make a difference. Our client is actively screening resumes and scheduling interviews to fill this position, so let one our professional resource managers represent you to the client, promote your skills, and help you prepare.

Requirements and Qualifications

• Minimum of 5 years development experience using the following technologies:              
• Microsoft SQL Server 2005/2008; SQL Server Integrated Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS), Java J2EE, Oracle 10g, SQL, PL/SQL, Views, Functions, Stored Procedures, Packages, Tables, XML – parsing, messaging, , HTML, DHTML, JavaScript, .NET, Flat files
• Latest MCITP (BI) is a definite asset        
• Experienced in developing Business Intelligence solutions (reports, dashboards, scorecards) using Microsoft SSRS, SSAS, and MDX in a data warehousing environment
• Experience in the design and implementation of ETL processes
• Experience developing and running MDX queries
• Ability to perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples).
• Advanced knowledge of and OLAP technologies and dimensional

Keywords: Data warehouse, Data warehousing, Datawarehouse, Datawarehousing, ETL, DW, SSIS, SSAS, SSRS, Oracle, PL/SQL, BI, Business Intelligence, OLAP, MDX, MCITP

How to Apply:

Online:

To apply for this and other suitable exciting opportunities with Zylog Systems (Canada) Ltd., you can register and apply online at http://www.zylogcanada.com/

Email:

If you would like to email a copy of your resume for review, please reference this posted Job Number or Job Description in the subject line of your email for prompt identification and send your email with attached resume to resumes@zylog.ca

Company Overview:

Zylog is internationally ranked within the top 100 Global Recruitment Industry and one of the top three IT Professional Staffing Firms in Canada. Zylog provides consulting services, software development, application migration, and recruiting services for permanent and contract positions. Zylog is a Microsoft Gold Certified Partner, HP Alliance One Partner, Telus Business Solutions Partner, Oracle Partner, and proudly represents Fortune 500, Government, Banking, Healthcare and IT organizations globally. Zylog leverages ISO 9001:2000 certified processes, industry best practices, and ownership of one of the largest professional talent databases in Canada. We are dedicated to the progress of our clients, consultants, and our community. Apply now or contact one of our experienced professional resource managers to help you find the perfect career to make the most of your unique skills and experience.

Top Jobs for Top Talent

http://www.zylog.ca/

Sr. Data Integration Developer

 Zylog delivers top jobs to top talent. We are currently seeking experienced professionals for exciting new opportunities and career advancement. Zylog represents hundreds of client companies for both contract and permanent positions. New jobs are being filled every day and our experienced professional resource managers are waiting to help you screen the top jobs that match your skills and experience. You don’t have time to search long lists of postings repeated on multiple web sites, so let our trained and experienced resource managers do the work for you. We review top jobs and will be the first to alert you when the right opportunity arises.

About the Job

Our client has a requirement for a Technical Lead Developer for a six month Contract opportunity.  The position is located in Mississauga.

What makes this Special

Our client is one of the largest Banks in North America. With exponential growth and millions of customers and clients who are served through our various businesses: Canadian Personal and Commercial Banking, Wealth Management, U.S. Personal and Commercial Banking, and Wholesale Banking. Being part of this company is being part of a better Canadian service.

Responsibilities:

As a Senior Data Integration Developer, this candidate would build SQL queries using SQL database based on reporting requirements from a legacy system. A legacy system is being decommissioned and migrated to another system. The historical archived data needs to be retained. This candidate would take the functionality of the old system and build reporting based on historical data. Experience with data migration from older SQL version to SQL 2008 R2 would be preferred.

The challenge would be reverse engineering as there is not a lot of documentation to refer to. This individual would need to understand the data and work with the new system to determine what reports are produced. From this information, the individual would build SQL queries to ensure the historical data is captured and the output is similar to that of the new system. In other words, the historical data needs to be preserved.

Please submit candidates who have worked for a large organization, migrated data from older SQL version to SQL 2008 and has the ability to work with any incompatibility issue that arise; can understand the requirements, can take the functionality of a legacy system, understand the data and able to build SQL queries on historical data. Shortlisting will take place as soon as qualified candidates have been submitted. Interviews will take place next week. 

Must have: 
- SQL Server, SQL reporting services and SSIS (SQL Server Integration Services)
- Data migration experience
- Database
- Has strong experience with upgrading from MS SQL 2000 to SQL Server 2008 R2 server and software related products such as SSIS, SSAS and SSRS 

Nice to have: 
- Data migration experience from older SQL version to SQL 2008 (R2 is preferred)
- Working knowledge of SDLC
- Worked with large organization
- Ability to work with any incompatibility issue that arise

Soft Skills Required:
Strong communication skills, detail oriented, problem solver, can work reverse engineering

Team Culture: Fast paced, results oriented

How to Apply

Online:

To apply for this and other suitable exciting opportunities with Zylog Systems (Canada) Ltd., you can register and apply online at www.ZylogCanada.com.
Email:

If you would like to email a copy of your resume for review, please reference this posted Job Number or Job Description in the subject line of your email for prompt identification and send your email with attached resume to Resumes@zylog.ca.

Company Overview:

Zylog is internationally ranked within the top 100 Global Recruitment Industry and one of the top three IT Professional Staffing Firms in Canada. Zylog provides consulting services, software development, application migration, and recruiting services for permanent and contract positions. Zylog is a Microsoft Gold Certified Partner, HP Alliance One Partner, Telus Business Solutions Partner, Oracle Partner, and proudly represents Fortune 500, Government, Banking, Healthcare and IT organizations globally. Zylog leverages ISO 9001:2000 certified processes, industry best practices, and ownership of one of the largest professional talent databases in Canada. We are dedicated to the progress of our clients, consultants, and our community. Apply now or contact one of our experienced professional resource managers to help you find the perfect career to make the most of your unique skills and experience.

Top Jobs for Top Talent

www.Zylog.ca

Zylog Systems (Canada) Ltd.

Database Analyst/IM Administrator

Zylog delivers top jobs to top talent. We are currently seeking experienced professionals for exciting new opportunities and career advancement. Zylog represents hundreds of client companies for both contract and permanent positions. New jobs are being filled every day and our experienced professional resource managers are waiting to help you screen the top jobs that match your skills and experience. You don’t have time to search long lists of postings repeated on multiple web sites, so let our trained and experienced resource managers do the work for you. We review top jobs and will be the first to alert you when the right opportunity arises.

Job Description:

Our client has a requirement for a SQL Server SSAS Analyst for a 6 month contract opportunity.  The position is located in Ottawa, Ontario.

What makes this Special:

Our client has a prestigious reputation and excellent work environment. This position offers an opportunity for personal learning and to contribute to important initiatives that make a difference. Our client is actively screening resumes and scheduling interviews to fill this position, so let one our professional resource managers represent you to the client, promote your skills, and help you prepare.

Requirement or Qualifications:

Qualified Candidates will have:

• 1-2 years of hands on experience with SQL Server,  SSAS, SSIS, SSRS and SQL;
• 5 years experience with database models and database design; and
• Must have Secret clearance.

Keywords:   SQL Server, SSAS, SSIS, SSRS and SQL   

How to Apply:

Online:

To apply for this and other suitable exciting opportunities with Zylog Systems (Canada) Ltd., you can register and apply online at www.ZylogCanada.com

Email:

If you would like to email a copy of your resume for review, please reference this posted Job Number or Job Description in the subject line of your email for prompt identification and send your email with attached resume to resumes@zylog.ca

Company Overview:

Zylog is internationally ranked within the top 100 Global Recruitment Industry and one of the top three IT Professional Staffing Firms in Canada. Zylog provides consulting services, software development, application migration, and recruiting services for permanent and contract positions. Zylog is a Microsoft Gold Certified Partner, HP Alliance One Partner, Telus Business Solutions Partner, Oracle Partner, and proudly represents Fortune 500, Government, Banking, Healthcare and IT organizations globally. Zylog leverages ISO 9001:2000 certified processes, industry best practices, and ownership of one of the largest professional talent databases in Canada. We are dedicated to the progress of our clients, consultants, and our community. Apply now or contact one of our experienced professional resource managers to help you find the perfect career to make the most of your unique skills and experience.

Top Jobs for Top Talent

www.Zylog.ca

Zylog Systems (Canada) Ltd.