Wednesday 27 April 2011

ETL Developer x 3 roles

Job Description
ETL Developer

About the Job


Zylog Systems (Canada) Ltd delivers top jobs to top talent. We are currently sourcing talented IT, Engineering, and Healthcare professionals who are qualified for and interested in exciting new opportunities.

Zylog represents hundreds of client companies that are actively seeking top professional talent for both contract and permanent positions with experience in IT, Engineering, Retail, Bank and Finance, Insurance, Oil & Gas, Telecommunications, Government and Health Services. New positions are coming available every day and our experienced professional resource managers are waiting to help you screen the top jobs that match your skills for the best opportunities.

You don’t have the time to search the long lists on Job Boards everyday to look through all of the postings to find the opportunity that is best for you. Let our trained and experienced resource managers do the work for you. We are reviewing top jobs from Fortune 500, Government, and Healthcare as each opening becomes available. Let us look for new opportunities for you and be the first to alert you when the right opportunity arises.


Job Description:

Our client has a requirement for ETL Developer for a 3 months opportunity. The positions are located in Brampton

Requirement or Qualifications:

Qualified Candidates will have:

the Role

Objectives of the Role

The ETL Developer – will support the Information and Shared Services department within the Information Technology corporate head office. This position will be responsible for the coding /review / acceptance of ETL code to be promoted into production. The ETL Developer will be involved in projects from inception through design and development and into post production support, to ensure that items developed are of high quality and will not damage production. The ETL Developer will utilize the full suite of ETL tools technologies and practices ensuring compliance to configuration management and security best practices across the organization. This role work closely with Project BAs, the DBA, and the production support teams.


Specific Accountabilities/KPI’s

Strategic

•Work with Business Analysts to help analyze extraction requirements and formulate a sound strategy in implementing these requirements within the context of a comprehensive data warehousing solution
•Actively participate in design and analysis sessions to ensure sound team decision-making
•Design and develop ETL solutions for interfacing between applications and the Enterprise Data Warehouse.
•Support system and user acceptance testing activities, including issue resolution so that tasks are completed in a timely manner
• Leverage industry tools and best practices for implementing ETL solutions
•Conduct root cause analysis and resolve production problems and data issues
• Implement & enforce development standards and ensure timely execution of ETL processes.
•Adhere to quality standards and ensure single points of failure do not impact availability of business data & reports
•Executes the diagnosis/assessment/correction of deficiencies within the environment
•Design and document ETL solutions, develop SQL scripts, work tables and UNIX scripts.
•Create Autosys documents and jobs, test plans, unit test code, migrate to QA, retest, and implement into Production.
•Works with teams to ensure alignment of Dev, QA, and PRD controls, authorizations and promotions of new code, agents and changes
•Identify process improvement opportunities


Personal Accountabilities

•Able to enjoy the challenge of working with technology in a rapidly changing environment.
•Proven experience in solving complex or technical problems for individuals or teams; experience with analyzing and identifying the strengths and weaknesses of options; and exercise critical thinking, problem solving, and judgment skills.
•Strong work ethic
•Timely and accurately organize, prioritize and complete all job responsibilities.
•Proven record of multi-tasking and ability to handle a high pressure environment with significant timeline pressures.
Candidate Profile

•Demonstrated excellence in Database / ETL coder in a complex multi TB Datawarehousing environment.
•Teradata concepts and architecture
•Autosys
•UNIX Korn Shell Scripts, AWK
•Teradata load utilities: BTEQ, Multiload, Fastload, Tpump
•Business Objects Data Services ETL Tools background


Preferred Skills

•Full development lifecycle experience: requirements, design, build, test, deploy
•Broad technical experience across OS (Window, UNIX), Teradata Database, application server (J2EE, .NET) and other technologies (MQSeries, JMS etc.)
•Ability to map business requirements to technology capability.
•Ability to review ongoing and proposed projects to identify opportunities for reuse and process improvement.
•Attention to detail to review project deliverables for completeness, quality, and compliance with established project standards.


Professional Skill Requirements

•Excellent communication skills (both written and oral) combined with strong interpersonal skills
•Strong analytical skills and thought processes combined with the ability to be flexible and work analytically in a problem solving environment
•Attention to detail
•Strong organizational & multi-tasking skills


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


Apply Now:

If your browser shows a button to Apply Now, you can use this link to immediately register and apply for this job online.


Company Overview:

Zylog Systems (Canada) Ltd. is a leading provider of IT, Engineering, and Health professional services, human capital resource management applications, and technology solutions with global delivery capability. Leveraging 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.

Zylog Systems (Canada) Ltd has provided government and private industry clients with highly regarded and capable professional resources, services and solutions for over 29 years.


Top Jobs for Top Talent

www.Zylog.ca


Contact Information
Company Name Zylog Systems (Canada) Ltd.

No comments:

Post a Comment