Don't worry, we can still help! Below, please find related information to help you with your job search.
Etl Data Engineer (Ssis)
Company | CorGTA Inc. |
Address | Toronto, Ontario, Canada |
Employment type | CONTRACTOR |
Salary | |
Expires | 2023-09-23 |
Posted at | 8 months ago |
***For a TOP5 Bank in Canada!***
ETL Data Engineer
Role: ETL Data Engineer (SSIS)
Structure: Contract until Oct 31st, 2023 + possible extensions up to 2 years!
Location: Downtown,Toronto (*Fully Remote)
Pay: Up to $60-$70 INC
Typical Day in Role:
Reporting to the Senior Manager – Development of Enterprise Compliance and Regulatory Systems, the incumbent will be responsible for the following:
• Implementing data ingestion pipelines / DevOps (on prem and Azure cloud) to move data from source systems to our central data warehouse
• Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with data warehouse
• Develop custom reports, analytics and KPI’s for the Business and Collecting business requirements / user stories from clients
• Complete testing to ensure high quality product for clients
• Developing SQL views to enable data consumers to read data from data warehouse
• Integrate systems via REST API, database views, SharePoint lists, sFTP, etc
• Responsible for documenting databases, data process flows and maintain data dictionaries
• Troubleshoot and resolve database and applications defects in a timely manner. Consult with internal and external groups as required
• Coordinating code deployments / production implementations.
• Train and assist users at all levels
• Design and development of high quality dashboards / reports using tools like Power BI, SSRS, Excel/PowerPivot and Tableau.
Candidate Requirements/Must-Have skills:
1. 10+ years of experience with Microsoft BI stack SQL Server, T-SQL, SSIS development required
2. 5+ years of experience with data warehouse, ETL, SSIS to move data / integrate systems required
3. 5+ years of experience with databases, data modeling design required
4. Experience with SDLC methodologies e.g. Agile / Waterfall
Nice-To-Have Skills:
• Experience with Azure Data / Synapse / EDL / Hadoop / Hive / Jupyter Notebooks / Tableau
• Knowledge on Banking / Risk related systems
• Experience developing code to consuming REST API services
• Experience integrating systems with COTS Commercial Off The Shelf software packages
• Experience with implementing DevOps / MS Azure Cloud services, Google Cloud Platform etc.
• Experience with web development (in ASP.NET / SharePoint / Power Apps / Power Platform)
• Experience working with SFTP File transfers
• Expertise with data visualization / BI tools e.g. Power BI, SSRS
-
Agente Ou Agent De Prévention De Soir Au Service De La Gestion Des Sentences
By Ministère de la sécurité publique At Montreal, Quebec, Canada 7 months ago
-
Lead Line Cook/Manager On Duty
By Impact Kitchen At Greater Toronto Area, Canada 7 months ago
-
Refinish Tech (Temporary) Jobs
By Boyd Group Services Inc. At Saskatoon, Saskatchewan, Canada 7 months ago
-
Vice President - Treasury
By Boyd Group Services Inc. At Winnipeg, Manitoba, Canada 7 months ago
-
Rock Mechanics Eit Jobs
By WSP in Canada At Greater Sudbury, Ontario, Canada 7 months ago