- 6-8 years of ETL development experience with an ETL tool such as: Informatica, DataStage, Ablnitio, or MS SSIS
- 6-8 years of experience developing reports with a BI tool such as MicroStrategy, Cognos, Business Objects, Birst, Tableau, etc. (tabular, dashboards, mobile, or visualization)
- 4-6 years of SQL experience
- Experience with relational databases (MySQL and Postgres preferred)
- Experience with dimensional modeling (dimensions, facts, star and snowflake schemas)
- Understanding of OLTP and OLAP , including their differences
- Understanding of data warehousing and ETL-specific concepts (landing, staging, lookups, aggregates, batches, transformations, DQ, SCDs, archiving, surrogates, ragged hierarchies, etc.)
- Ability to unit-test data (different from testing applications)
- Knowledge of performance and tuning techniques for data warehouses
- Experience gathering and documenting requirements
- B.S. or higher in Computer Science
- 1-5 years of experience with: HTML, PHP, CSS, Javascript/JQuery
- Experience in both software development and testing environments
- Web & Mobile Automation experience is a plus
- Familiarity with Selenium Web-Driver, Appium and Jenkins is a plus
- Co-op experience an asset
- Recent graduate from University or College with a degree in Computer Science or equivalent
BI/ETL Developer: http://hire.jobvite.com/m?3Pk5ahwa
Software Test Developer: http://hire.jobvite.com/m?3Sj5ahwc