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
Comments