Working@PXLTD

RRK - Words From Deborah

Words no better said in respect to Graham's CAP (capability, attitude and presence).

Deborah has the three, Respect, Recognition and Knowledge.

We really liked these three attributes of a company, employee and culture.

References

Why do companies do reference checks?

• To ensure that what is on paper is true;
• To look for insight that an potential employee would not share (habits, strengths, weaknesses)
• Get another persons opinion that should be someone who likes the candidate; and
• many other reasons.

So this should be an important part of your career arsenal and you should prepare the referencee to the nature of the call they are going to take.  This can help greatly as they will know the nature of the call, the type of information to share and plainly know about the call and not be surprised.

I got a call this week from someone to be a reference.  I am more than willing to be a reference for the person, but I did not know about it or the nature of the reference.  As it turned out, this was just a general reference of a recruiter in a staffing company without any respect to a specific opportunity.

Tsk Tsk on the candidate as I was very caught off guard.  Make sure your referencee knows something.

ETL Developer - Senior, Ascential DataStage

Hey all you Senior DataStage Developers

We are still looking for between 2-4 Senior DataStage Developers to join Project X a couple of projects and to help to shape and evolve the Business Intelligence and Data Warehouse environment for a client who believes in the value of data.

Start Date:    September/October
Duration:      3-24 months
Type:            This could be a contract or full-time position, we are flexible to the candidate and situation
Location:      Toronto, Ontario, Canada
Skills:           ETL,Ascential DataStage, SQL, Data Warehousing, Data Marts, Data Quality, Data Modelling

We are growing and have some customer projects we are ramping up for.  So we are looking for some good people that have varied proven ETL experience.  You will be working as part of our team helping a client evolve to their chosen reference architecture which we are helping to finalize now.

• You have been doing this sort of thing for 5-10 years and thrive in solving problems where others can not.
• You will enjoy the challenge of building, tuning and optimizing ETL code as part of an evolution of an Enterprise Data Warehouse and Business Intelligence program and roadmap.
• You have in depth DataStage skills
• You are qualified and understand it's strengths weaknesses and abilities.

Key Responsibilities:

• Work to understand data requirements under existing scenarios and work with clients to build good high performance ETL in DataStage
• Develop ETL on DataStage
• Test, Debug and Tune ETL processes
• Support existing ETL processes
• Documentation in support of the delivery process

Key Skills and Experience:

• DataStage ETL - lots of proven experience - 5+ years - version 7.1 and above / parallels
• Data Warehousing and Data Marts along with the concepts - experience with RDBMS tools, data models and modelling tools, architecture and Business Intelligence - strong
• SQL Knowledge - Strong
• Have been there and done that and have a proven track record of success
• Team Leader and Team Player
• Ability to communicate well with all the various stakeholders

We know you are a senior and competent person and will compensate you accordingly.  If you have any questions, please feel free to drop a comment or send me an email at working@pxltd.ca.

Update 1: updated timing and some details.

BEA Developer

Are you a BEA developer.  We are looking for some smart and seasoned developers in the following areas:

• Aqualogic
• J2EE Services Development
• Service Oriented Architecture
• Customer Master File - DWL (now absorbed by IBM)

OK so you may not have all of those, we know that, but if you are interested in this area we want to talk with you.

ETL Developer - Senior, Informatica

A Call out to Senior Informatica Developers

We are now generally looking for Senior Informatica Developers to join upcoming projects and  to shape and evolve the Business Intelligence and Data Warehouse environment for a clients who believe in the value of data.

Start Date:    not specific
Duration:      not specific
Type:            This could be a contract or full-time position, we are flexible to the candidate and situation
Location:      Toronto, Ontario, Canada
Skills:           ETL,Informatica, SQL, Data Warehousing, Data Marts, Data Quality

We are growing and have some customer projects we are ramping up for.  So we are looking for some good people that have varied proven ETL experience.  You will be working as part of our team helping a client evolve to their chosen reference architecture which we are helping to finalize now.

• You have been doing this sort of thing for 5-10 years and thrive in solving problems where others can not.
• You will enjoy the challenge of building, tuning and optimizing ETL code as part of an evolution of an Enterprise Data Warehouse and Business Intelligence program and roadmap.
• You have in depth Informatica skills
• You are qualified and understand it's strengths weaknesses and abilities.

Key Responsibilities:

• Work to understand data requirements under existing scenarios and work with clients to build good high performance ETL in Informatica
• Develop ETL on Informatica
• Test, Debug and Tune ETL processes
• Support existing ETL processes
• Documentation in support of the delivery process

Key Skills and Experience:

• Informatica ETL - lots of proven experience - 5+ years
• Data Warehousing and Data Marts along with the concepts - experience with RDBMS tools, data models, architecture and Business Intelligence - strong
• SQL Knowledge - Strong
• Have been there and done that and have a proven track record of success
• Team Leader and Team Player
• Ability to communicate well with all the various stakeholders

We know you are a senior and competent person and will compensate you accordingly.  If you have any questions, please feel free to drop a comment or send me an email at working@pxltd.ca.

Update 1: More Clarity added
Update 2: Now a general requirement, not for a specific project.

Business Analyst

We are looking for an experienced Data Warehouse Business Analyst to work in a dynamic, fast paced environment. The consultant will manage Business Analysis as part of an overall project team, deliver project artifacts, interface with clients, and deliver high quality Business Intelligence solutions.

Requirements and responsibilities include:

- Facilitates discussions with Project Sponsor, Stakeholders and Key Users to gather business and process flow requirements.
- Conducts interviews and work sessions with key users and translates results into the appropriate documentation
- Analyses and documents business processes and formulates the Business Problem definition.
- May document proposed business processes.
- Identifies current systems and tools leveraged by business users.
- Assists the Project Manager in Risk Analysis and mitigation planning.
- Prepares the Business Requirements Document (BRD).
- Participates in the Presentation of Concept to gain acceptance by user population and obtain sign-off from Sponsor and Stakeholders.
- Provides input in the preparation of the target Data Models and performs data analysis.
- Assists the business in finalizing User test cases
- Reviews preliminary Test Plan and makes revisions accordingly.
- Supports the Application Team by being the functional 'go-to' person for resolving business related issues / decisions. Works closely with business stakeholders to resolve issues.
- Leads the preparation, test execution and verification of project components

Required skills:

- Experience as a Business Analyst in an Enterprise level Data warehousing environment
- Ability to quickly understand the business and the related processes
- Client facing skills are a must.
- Risk analysis experience
- Excellent communication skills
- Ability to interact with outside clients and customers
- Ability to work in high-paced outside the box problem solving environment

Senior IT Project Manager

We are looking for experienced, PMI certified Senior Project Manager in the software development area. The ideal candidate will:

• Solid Communication skills and an understanding on mediation and driving to consensus
• Understand the concepts of client management and team building
• Be a team leader in determining customer requirements and translating requirements into operational plans
• Ability to leverage multiple delivery models and geographically dispersed teams
• Determine, monitor and review all project economics to include project costs, operational budgets, staffing requirements, project resources and project risk
• Ensure adherence to customer long-term strategic goals, project charter and contracts
• Meet with customers to review project scope/progress and resolve project issues
• Coach and counsel members of cross-functional teams to accomplish projects, meet established schedules or resolve technical/operational issues
• Develop, propose and negotiate project proposals, quotations and add-ons to leadership and/or the customer
• Be innovative and ready to learn new methods of client breakthrough
• Stay current on emerging technologies and project management techniques

Qualifications

• College/University education and 10 years Project Management work experience or equivalent combination
• Proven track record of managing projects and successfully implementing and managing formal quality processes in projects
• Large project exposure and/or previous consulting experience
• Understands and is able to apply systems development life cycle principles, concepts and techniques on related projects
• Excellent communication (verbal and written), presentation, training and leadership skills
• Experience in the Telecom, Retail or Financial Services is an asset

IT Hiring Trends

A great article from DM Review discusses trends in IT hiring based upon some information from Robert Half.

In the article they highlight a couple things of immediate relevance to Project X.

1. Net hiring growth in Q2 due to business demands.
2. Areas of growth are in common areas with common skill-sets

The second point as indicated is of interest to us as these are not generally the skill-sets we are looking for.  We will be looking for more specific less widely taught skills.  So this means, that if the skills don't exist we are going to have to build them.  And guess what, that is our plan.

Welcome to the new Blog

Project X has been growing as of late and we need some good people.

In an effort to evolve our HR and Recruiting efforts we have launched this blog.  So welcome.  We plan to use this space to talk about general items of interest to people who work in our industry.  Within that realm we will show people what we are about and the opportunities in joining Project X.

Data Warehouse Consultant

Job Duties and Responsibilities

• The Data Warehouse Specialist is responsible for the design, development, performance, documentation, maintenance, support and operation of the Enterprise Data Warehouse; and, the documentation, maintenance, support and administration of Informatica software.
• Implement corporate policy; develop, publish, enforce and maintain standards and procedures.
• Manage the Informatica environment and the granting of access to data; perform administrative functions.
• Participate in EDW scope discussions and comment on feasibility.
• Create and maintain EDW data model and metadata.
• Identify and document data access and usage requirements with access frequencies.
• Participate in the design of Oracle structures.
• Design, develop and test ETL coding specifications, processes and documentation.
• Promote changes via established IT change control procedures.
• Proactively tune to improve performance.
• Plan, test and implement software upgrades; monitor alerts; administer licenses; interface with vendor.
• Remain current with industry, Informatica and Oracle direction; evaluate new technologies and product features; make recommendations as to how client can benefit.
• Coach and oversee Developer tasks.
• Troubleshoot problems; provide problem resolution assistance to IT staff.
• Provide day-to-day consultancy and support to IT staff; act as backup for other Database Systems staff.
• Investigate, identify and document source system data for extraction; design and implement confirmation processes for data loads.
• Monitor daily operation relative to SLA; log issues and ensure resolution.
• Strong analytical and problem-solving skills.
• Ability to multi-task and work at a detailed level in a fast-paced environment.
• Superior working knowledge of PowerCenter and PowerAnalyzer products and coding languages.
• Very good working knowledge of relational database technology, preferably Oracle, and the SQL language.
• Very good knowledge of data modeling in a data warehousing context.
• Good oral and written communication.
• Knowledge of ERWin, ODBC, Java, C/C++, HTML, XML and UNIX.
• Some experience with managing small development projects.
• Availability to carry a 24x7 production support pager on a scheduled basis.

Skills, Education, Knowledge and Experience

• Adaptable and innovative Team Player who collaborates and brings leadership and drives results

• Customer Focus

• Completion of a college or equivalent post secondary degree.

• 5+ years of data warehousing experience.

• 3+ years of ETL design and coding experience.

• 3+ years of SQL coding experience, with DB2, Oracle or Teradata.

• 5+ years of application development experience with at least 2 in a senior capacity.

Nice to have skills

• Teradata, Oracle or DB2
• Understanding of the Capability Maturity Model or ITIL

To apply email your resume to jobs@pxltd.ca
To learn more about Project X visit our Corporate Blog or Website