Business Intelligence (BI) & Extract Transform Load (ETL)
Electronic Arts, Burnaby, BC
Senior Software Engineer / Consultant– December 2016– May 2017 (5 months)
Worked on ETL projects against VLDB, using .net to extract, transform-and load data in MS SQL while extracting from Teradata, and MySQL. The ETL engine was a multi-threaded WCF in-process duplex application, using per-session instancing, and hosted within a Window Service. Certain ETL tasks had to be passed onto certain servers in sequence therefore the callbacks strategy in WCF was essential.
Also used SSIS for ETL. Created web applications using ASP.NET MVC .Net 4.6.x, with OKTA SAML SSO for authentication.