Lead Application Developer | Wawanesa Insurance | Kitchener, Ontario, Canada

Lead Data Engineer having over 12 years of experience with Data Management projects involving Data warehousing, Data integration, Data migrations, Data analysis, and Data Lake. Proficient development skills in building and testing the ETL, mappings, and data Pipelines are well-defined and manageable and Operational. Experience with a variety of data collection, processing, and storage with traditional as well as modern tools and services. Responsible for migrating 4000 ETL assets from Informatica PowerCenter to Informatica iPaaS platform (IICS). Well-defined architecture and migration assets are aligned with code reviews, standards and tested, and ready to deploy to production. Implemented solutions with AWS and cloud readiness for ETLs (AWS Glue, IICS, Confluent, Data bricks), and Data Migrations (AWS DMS, RedShift, Athena, RedShift, Quick Sight, RDS, Postgres, Kinesis). Build the relational data store for the Insurance platform using complex files, parquet, XML, CSV, JSON, VSAM, and Relational data based.