Sr. Data Engineer (ETL/SQL) / Lead Engineer

Full Time
  • Full Time
  • Toronto

Next Pathway Inc.

Next Pathway – The Automated Cloud Migration Company

Next Pathway is a technology services company providing clients a pathway from existing to emerging technologies. Our automation technology helps our customers accelerate the migration of complex applications and workloads to the cloud.

We are looking for a skilled Sr. Data Engineer (ETL/SQL) / Lead Engineer to join our team!

The candidate needs to have extensive experience as follows:

· Minimum of 8 years of proven experience in a core competency or leading engagements and running teams


· Proven hands-on Software Development experience

· Strong Data Warehouse knowledge and experience, include data modeling, data ingestion, transformation, data consumption patterns

· Strong SQL knowledge and experience, including developing and optimizing complex queries, creating efficient UDFs to extend the functionalities

· Experience in at least 3 of below RDBMS: Teradata, Netezza, SQL Server, Greenplum, Oracle, Sybase, DB2, MySQL, Redshift, SQLDW.


· Experience with Cloud Technologies (Azure, GCP, Snowflake, AWS, Yellowbrick)

· Experience with ETL tools (Informatica, DataStage, SSIS, Talend)

· Experience with major programming languages (Java, Pcorrespondenceython, Scala, C++, Java Script)

· Strong understanding and experience of relational database, include design and implementation


· Develop and maintain unit tests and integration tests, and test automation.

· Adoption of Agile and Scrum development methodology

· BA/MS/PHD degree in Computer Science, Engineering, or a related subject

.

Other Technologies you Might Work with Include:

· Microsoft Office Suite (Excel, Word, PowerPoint, Outlook)

· Basecamp: Project Management & Team Communication

· Slack: Messaging Platform


· Zoom: Meetings and Video Conferencing

· Confluence: Collaboration Tool

· JIRA: Project Management Software

.


Other Skills:

· Team Player with Excellent Interpersonal and Communication Skills (Written and Verbal)

· Strong Work Ethic with a Positive Attitude and a Passion for Data and Development

· Strong Analytical and Problem-Solving Skills


· Excellent Time Management Skills

To apply, please visit the following URL: