SQL/ETL Data Warehouse Developer

Job# FT25842
Location Toronto, ON
Job Type Permanent
Salary Negotiable
Contact agupta@finney-taylor.com
Date Posted October 05, 2021
Submission Deadline October 15, 2021
Job Stream
Benefits Fulltime Position


Job Description :Our client is looking for SQL/ETL Data Warehouse Developer to join their team in Toronto, ON

Must Have Primary Skills :
  • SSIS ETL and SQL Developer with minimum 5 years of exp
  • SSIS Advanced component experience is required (transformation objects in data flow).
  • 4 years of advanced SSIS, SSRS and database development experience.
  •  Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL process, documentation, and long-term preparedness.
  • Data Warehousing experience is preferred.
  • Develop cross validation rules to ensure mapping accuracy.
  • Designing database tables and structures.
  • Creating views, functions and stored procedures.
  • Writing optimized SQL queries for integration with other applications.
  • Creating database triggers for use in automation.
  • Maintaining data quality and overseeing database security.

Nice To Have Secondary Skills :
  • Communicate issues, risks, and concerns proactively to management.
  • Self-sufficient and good communication skills
  • Must be skilled with MS Office applications.
  • Reporting (SSRS) experience is good to have.

Proven Experience In :
As mentioned above
  • Databases
    • Must Have at least 4 years of experience with/in MS SQL Server Reporting Services (SSRS), SSIS
    • Must Have at least 5 years of experience with/in ETL