Toronto, Ontario, Canada
This job allows you to work remotely
Our client is a home grown, Toronto custom consulting firm that takes on high-profile clients and brand names in many industries. Our solutions range across areas like auto finance, eHealth, capital markets, education, governmental, and pension initiatives (to name a few). We are consistently working towards designing and building high-performing enterprise digital solutions with emphasis placed on great user experience, robust architecture, and a perfect fit. Working here, you’ll have the opportunity to contribute your theoretical knowledge in a technically diverse environment alongside our team of software experts. We are looking to grow our ETL/Data teams, and have opening for both Senior and Intermediate level ETL Engineers.
What you'll like about working here:
-Family-friendly benefits and vacation time.
-Annual training budget and professional development for fulltime employees.
-The flexibility of a software consulting environment; project variety, adapting to new business domains, and building complex applications.
-Ability to flex your creativity muscle, and have your opinions heard.
-A work culture where you’ll look forward to communicating with team members and working on innovative and progressive projects every day.
Must Have Skills:
-Strong SQL skills, in at least one, preferably multiple relational database like Oracle, DB2 and SQL Server
-Strong stored procedure coding skills in at least one relational database – PL/SQL (Oracle) or DB2 SQL procedures acceptable, SQL Server T-SQL experience preferred.
-Strong graphical ETL tool skills in at least one, preferably multiple ETL tools like SSIS, Informatica, Datastage. SSIS preferred.
-Prior Azure Data Factory experience very nice to have
-Good understanding of Dimensional Data Modeling vocabulary, concepts and techniques ; prior experience developing ETL in a Kimball Dimensional Data Warehouse environment very nice to have.
Nice to Have Skills:
-Experience within in at least one scripting language like bash, Perl, Python. Python experience preferred.
-Prior experience implementing data-centric applications in any cloud computing environment – AWS, Azure, GCP; Azure preferred
-Prior experience writing AWS Lambdas or Azure Functions using Python.
-Experience handling typical development DBA tasks on SQL Server (physical database design, managing database object privileges, creating objects, tuning poorly performing SQL statements etc.)