Working@PXLTD

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 [email protected].

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

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 [email protected]
To learn more about Project X visit our Corporate Blog or Website