Showing posts with label ETL. Show all posts
Showing posts with label ETL. Show all posts

Wednesday, December 8, 2010

BI Developer/Report Writer (Don Mills/Green Belt Drive)

Our client is expanding its BI team to require additional resource. It is looking for contract resource for a period of 3-6 months. Although overall BI experience is desired, the work focus will be on Report development.
  1. Must have BI Developer skills shown on the resume
  2. Must have strong MS Reporting Services SSRS
  3. Experience integrating MS Reporting Service to SharePoint.
  4. Strong .NET and SQL Server experience.
The candidate will have the following background:
  • Strong knowledge in MS SQL
-Previous engagement in BI projects
-Experience in ETL, OLAP, Data cubes etc.
  • Strong knowledge in multidimensional DBs and data warehousing.
  • Hands-on experience with Microsoft technologies in the BI space
  • Very good communication skills are critical
  • Problem resolution skills are essential
The client might consider Permanent Full Time Canadidates.

Location: Don Mills/Green Belt Drive
Compensation: N/A (This is a contract job)
Email: tim@planitsearch.com

Tuesday, November 30, 2010

SAP BO Reports Developer (Toronto)

Our client, an energy provider for both commercial and industrial customers in Toronto, is looking for a SAP BO Reports Developer to join their team.

Salary: from $48 to $50 per hour

Tasks:
  • Develop BO XI reports including Web intelligence, Infoview & Crystal Reports
  • Design data mart/data warehouse using BO Universe Design, RDBMS & SQL
Requirements:
  • 3-4 years experience with BO reports development
  • Experience designing data marts using BO Universe
  • Some exposure to ETL
  • Excellent verbal and written communication skills
Connecting you + Quantum: With our contacts and your skills, we're a winning combination. Put Quantum on your team and apply today!

Contact Information
Pooja Masand
Fax: (416) 366-4363
pooja.masand@quantum-qtr.com

Visit us at www.quantum-qtr.com for more job opportunities!

If you refer a friend who is hired, you may be eligible for a monetary referral bonus or you may choose from a selection of Roots merchandise, depending on the specialty and position. Visit us at www.quantum-qtr.com for more details.

We appreciate all expressed interest in this position, however, only the candidates selected for interview will be contacted. You will certainly be contacted before we submit your resume to any of our clients.

Quantum is an equal opportunity employer.

Location: Toronto
Compensation: from $48 to $50 per hour
Email: pooja.masand@quantum-qtr.com

Wednesday, November 24, 2010

Lead Tester/4 mth contract/HR,Payroll or Time&Attendance sys-WorkDay + (VP/Sheppard or Waterloo)

4 month contract for a Lead Tester with HR, Payroll or Time & Attendance systems - WorkDay exp a huge asset - work in Waterloo or Vic Park/Sheppard travel to Waterloo once a week.

Our client is looking for a Lead Tester for this 3 month& 26 day contract. Must have previous experience in a leadership role with a focus on testing processes. This role is specific to a Human Resources Global project so previous experience working on a global HRIS (payroll implementation) would be ideal or Time & Attendance. WorkDay experience would be a terrific asset. This person would be dealing with the vendors and changes that would need to be made (all vendors are located in Canada). Work location could be Waterloo or Victoria Park & Sheppard with travel to Waterloo once a week.

Role Summary:

This is a contract opportunity for a technical analyst with experience working with HR applications in a client-server environment to join a team of development professionals in support of the Global HR Project. The successful candidate will be multi-skilled and adaptable as she/he will be working with our vendors and our IT team (business analysts, designers, developers and testers) to deliver on the testing and implementation of the various interfaces with our HR application. We are looking for an individual who is technically savy and provide technical management and support for a variety of activities within the project. You will be responsible for understanding the many interactions that exist for our HR process and providing direction and support of the testing of these interfaces. Environments and existing processes are being changed to implement the Global HR application and you will be accountable to work with vendors and internal staff to deliver change requests and defect corrections.

Skills needed:
  • Experience working with HR applications, preferably WorkDay as a technical lead or technical business analyst
  • Proven experience with IT system development life cycle, particularly directing testing and coordinating work tasks for other team members
  • Proven IT skills preferably with a degree in Computer Science, related technology degree/diploma or equivalent experience
  • Demonstrates problem solving skills with ability to analyze situations/problems systematically and deliver effective right-sized solutions in a timely manner.
  • Experience with MS Sql Server and ability to do data analysis and investigation
  • Experience integrating vendor packages and dealing directly with vendor personnel
  • Ability to work independently as well as being a strong team player with the ability to work effectively in a multi-site environment.
  • Excellent organizational skills with the ability to handle several tasks efficiently.
  • Excellent verbal and written communications skills.
Assets:
  • Knowledge and experience with report building, particularly Crystal/BOXI
  • Knowledge and experience with ETL development, specifically PowerCenter Knowledge and experience with any of the following products:
  • MS .Net (VB.NET, ASP, C#)
  • Mainframe JCL and Zeke
Location: VP/Sheppard or Waterloo
Compensation: Hourly rate for this 4+ month contract
Email: julie.cox@careerdriven.com

Database Developer (Toronto, North York)

The Cardiac Care Network of Ontario (CCN) has built an international reputation promoting effective management and monitoring of patients requiring advanced cardiac services. CCN serves an advisory role to the Ontario Ministry of Health and Long-Term Care. We are dedicated to improving quality, efficiency, access, and equity in the delivery of adult cardiac services.

Reporting to the Director, Informatics and Business Intelligence, the Database Developer will be responsible for providing database administration, development and support services to CCN. This person will be responsible for all environmental aspects of the CCN data store including integrity, security, availability, performance, recoverability, development, maintenance and testing. Other responsibilities include the investigation, procurement, recommendation and management and maintenance of the database technologies as needed to support CCN and its comprehensive information resources. The Database Developer will work closely with other members of the team to ensure consistency and integrity of data; to assist with processes surrounding collection and reporting of complex, related information. The Database Developer contributes to the mission, vision and values of CCN by providing database and information management expertise that builds upon CCN’s solid reputation as an objective, evidence-based organization. This is a full-time position available immediately.

Position Summary:

As a member of the Informatics and Business Intelligence Team, the Database Developer position serves a key role in the organization by ensuring the database technology and related databases are available to support management decision-making and external reporting. This includes the following:
  • Identifying user business requirements.
  • Design and document database architecture and dictionary. Data Modeling.
  • Perform management of databases, including creation, restore, configuration, account set-up, access and permissions, upgrade, maintenance, backup and recovery, archiving, testing and troubleshooting.
  • Develop and maintain ETL processes to integrate and consolidate data
  • Defining data standards and models for BI architectures.
  • Design data warehousing and business intelligence platform.
  • Facilitating integration of data and systems to deliver business intelligence solutions, including analyzing existing processes, process mapping, source data analysis and source qualification, data profiling, and source/target mapping.
  • Designing and developing reports and data cubes using Business Objects, Crystal Reports, Reporting Services and other desktop and web reporting solutions.
  • Transforming data into information to support decision making using technology solutions such as OLAP, dashboards, scorecards and analytical applications.
  • Managing system infrastructure to ensure continuous operation of business intelligence solutions.
  • Investigating and implementing new technologies / solutions to meet reporting requirements.
  • Writing functional and technical specifications and user documentation.

Key Qualifications:
  • University degree or college diploma in computer science / information systems
  • 3 + years of experience with system analysis, database management, developing business intelligence solutions.
  • Good knowledge in storage technology to effectively configure database systems
  • Thorough in-depth understanding of database design and development methodology
  • Strong knowledge of SQL Server (2000/2005)
  • Strong knowledge of data warehouse concepts and processes, ETL technologies and methodologies
  • Experience with SQL Server Integration Services, Analysis Services and Reporting Services
  • Experience in building business BI portals, dashboards, scorecards and drill down reports
  • Experience in SQL, OLAP cubes and frameworks, Crystal Reports, Business Objects or other business intelligence tools
  • Project management experience and skilled in the conceptual mapping of projects and outcomes.
  • Strong interpersonal, analytical and communication skills
  • Highly skilled in stakeholder engagement and customer services with a proven ability to interact with people from all organizational levels and build consensus through negotiation and diplomacy.
  • Self-motivated, highly accountable, with demonstrated ability to work effectively as a team member.
  • Effective and creative problem solving skills
  • Ability to effectively manage workload and competing priorities to complete projects and/or provide operational support in a timely manner.
  • Previous experience working with health care data is preferred.

Please send your resume with cover letter stating Reference - Database Developer no later than Dec 10, 2010 to Tracey at tlynch@ccn.on.ca

No phone calls please.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

Please visit us at www.ccn.on.ca

Location: Toronto, North York
Compensation: TBD
Email: tlynch@ccn.on.ca 

Tuesday, November 23, 2010

Urgent Contract QA Team Lead (Data, ETL) (Toronto)

Very urgently looking for experienced and proven Senior QA Analyst who has good strong working experience in testing data, ETL process, etc. Candidates should have at least 4 to 8 years of QA and at least 2 to 4 plus years of QA Lead/QA Team Lead work experience. Incumbents who have insurance and/or banking industry work experience will be nice bonus but not mandatory at all.

Location will probably be in downtown Toronto.

The contract is 6 to 8 months to start with, has very good possibility of extension and is open to full-time/permanent employment.

Hourly rate will be around $ 50 to 67 or more hour.

Any qualified and interested candidate, please kindly email resume to wilfreshek@rogers.com as soon as possible.

Location: Toronto
Compensation: $ 50 to 67 per hour (This is a contract job)
Email: wilfreshek@rogers.com

Saturday, November 20, 2010

2 - 3 Data Architects with banking/financial industry exp - Perm (Downtown Toronto)

Location: Downtown Toronto
Email: julie.cox@careerdriven.com

Our client is looking for 2 - 3 DATA ARCHITECTS with banking/financial industry, information needs analysis, data quality audit, data warehousing arch, ETL, EAI, EII, kimball & Inmom - PERM.

Our client, a consulting company that develops software for the financial industry, is looking for 2 ¨C 3 Senior Data Architects who will provide technical leadership to their project teams to successfully deliver mid to large size initiatives in the Greater Toronto Area. One of the Data Architects needs to be able to travel within Canada for the next few months.

Must have a permanent employment background. $100k+

Responsibilities: 
  • Provide the overall information and data strategy and solution for client engagements based on an approach that is holistic, scalable, pragmatic, and effective structuring of data and information.
  • Understand business needs for data and information especially in the Banking and Financial Industries.
  • Develop data architecture (data definitions, data flows, identification of data sources and data consumers, business rules and transformations, and data models) for client engagements.
  • Design data models (conceptual or logical) that are adaptable, extensible, and sustainable.
  • Define data management and data improvement processes as part of the overall enterprise data strategy.
  • Perform data profiling and data quality audit.
  • Produce estimates for data requirement analysis, data model design, and ETL design. ​
  • Review and guide the technical team's deliverables to ensure overall data quality and information structure compliance with the overall data architecture.
  • Ensure compliance with business, data, and technical requirements.
  • Ensure that enterprise architecture standards, policies, and procedures are enforced.​
  • Provide assessments of architectural risk and mitigation strategies.​
  • Mentor and coach the technical team.
  • Assist with proposals and pre-sales.
Requirements:
  • Minimum 15 years experience in Information Technology, participating in complex projects.
  • Minimum Bachelors degree in Computer Science.
  • Strong Communication skills.
  • Strong business and IT knowledge and experience in the Banking and Financial Industries.
  • Proven Leadership skills.
  • Strong skill in Information Needs Analysis and Data Quality Audit.
  • Strong Data Warehousing Architecture knowledge (e.g. enterprise data warehouse, master data management, data integration, and data quality).
  • Strong knowledge in Data Warehousing Life Cycle and Data Integration Methodologies (ETL, EAI, EII).
  • Strong knowledge and experiences in both Relational and Dimensional Data Modeling C with both Kimball and Inmon approaches.
  • Integration experiences with industry or vendor data models.
  • Working knowledge of ERwin and other data modeling tools.
  • Working SQL knowledge in Oracle, Microsoft SQL, or IBM DB2 databases.
  • Knowledge in data management principles.
  • Ability to work concurrently on multiple initiatives and excel in a team environment.
 
TopOfBlogs