- Provide superior operational support both on premise and in the Cloud- Safeguard our client’s data- Continuously monitor our environments to identify and implement operational improvement- Ability to understand the code logic to analyze and troubleshoot data consumption issues for Sun Life clients- Be able to write complex SQL queries, joins, and stored procedures to manipulate and analyze data- Experience building and supporting ETL processes, data integration and pipelines- Valuable business intelligence application experience to design, analyze, and format reports for clientsRequirements- 2+ years experience developing in:- Mainframe: TSO, ZEKE, JCL, COBOL- ETL: Informatica, IDMC (Informatica Cloud), Master Data Management (MDM), AWS Glue- Business Intelligence (BI): SAP Tools (Crystal, Universe Design)- Knowledge and experience with the tools to support several Data Warehouses (DW), from data ingestion to data consumption- Technical and analytical abilities required to design, build, and maintain centralized repositories for historical and analytical data- Excellent analytical skills to dive into the processes we support to resolve complex data discrepancies or job failures- ITIL knowledge for incident,



problem and change management policies and processes- Create and maintain superb technical documentation that will help support our poly-skilled team- Excellent communication skills to support Project Teams, Operation teams and vendorsCore CompetenciesDemonstrates expertise in SQL query writing, ETL process development, and business intelligence reporting, with a strong focus on data integrity and operational support in both on-premise and cloud environments. Proficient in technical documentation and communication to facilitate collaboration across project and operations teams.Highest-signal resume keywords- SQL Query Writing- ETL Process Development- Business Intelligence Reporting- Mainframe Technologies- ITIL KnowledgeHard Skills- SQL- ETL- Data Integration- Data Warehousing- COBOL- JCL- Informatica- AWS Glue- SAP Tools- Master Data ManagementSoft Skills- Analytical Skills- Communication SkillsIndustry Keywords- Operational Support- Data Consumption- Data Discrepancies- Incident Management- Change ManagementTools & Technologies- Informatica Cloud- Crystal Reports- Universe Design#J-18808-Ljbffr

📌 Enterprise Email Archiving Support Engineer (Toronto)
🏢 Proofpoint
📍 Toronto