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