Manzoor Mohammed

Senior Informatica ETL Developer

16+ Years of Data Integration Excellence | Certified IICS & PowerCenter Expert

📧 amanzoorm@hotmail.com 📍 Toronto, Ontario, Canada 💼 LinkedIn: /in/manzoorm
Let's Connect

Professional Summary

16+ Years Experience
50+ Projects Completed
8+ Industries Served
3 Certifications

Senior Informatica Certified ETL Application Developer with over 16 years of comprehensive IT experience in client-server and cloud/web-based application environments. Specialized in data integration, migration, profiling, and quality processes with proven expertise in Salesforce-Informatica integration.

Currently serving as Senior Data Quality Developer at Parkland Corporation, leading complex ETL architecture design and implementation across finance and retail applications. Expert in IICS, IDMC, PowerCenter, and enterprise data warehouse development with strong track record in cross-functional team collaboration.

Technical Expertise

ETL & Data Integration

Informatica PowerCenter 10.x/9.x IICS IDMC CDI CDQ CAI Data Quality MDM Multi Domain Business 360 Reference 360 SSIS SSDT

Cloud & Big Data

AWS S3 Azure Blob Storage Hadoop Hive 1.1.0 Kafka Cloudera 5.4.10 Hue 3.7.0 Beeline Snowflake

Databases & Platforms

Oracle 12c/11gR2/10g/9i/8i SQL Server 2017/2016/2012/2008 DB2 z/OS DB2 AIX MySQL PostgreSQL

Enterprise Applications

Salesforce Workday SAP Integration Data Lake PGP Encryption MFT

Programming & Scripting

SQL/PL-SQL Unix Shell Scripting Python Java C#.NET JavaScript XML/JSON XHTML/HTML

Integration & APIs

REST API SOAP API Web Services APIGee POSTMAN SOAPUI

Automation & Scheduling

CA Workload Automation/ESP Autosys Control-M Crontab SQL Server Agent Tivoli Maestro

Reporting & BI

Power BI Cognos Crystal Reports MicroStrategy

Artificial Intelligence

AI Agentic LLMs LangChain Autogen Agentic AI tools Autonomous Agents AI Orchestration AI Chatbot Agents

Professional Experience

January 2024 - Present
Parkland Corporation | Sunoco
Senior Data Quality Developer (IICS | IDMC)
Leading complex ETL architecture design and development for finance and retail applications.
  • Managing IICS Data Integration/Administration/Monitor/Mass Ingestions modules
  • Implementing data quality standards and creating Power BI reports and dashboards
  • Specializing in SAP/AWS data integration and automated process development
  • User and group management with role-based access control
  • Infrastructure management including agents, connectors, and servers
August 2023 - January 2024
BMO (Bank of Montreal)
Senior IICS/ETL Developer
Developed enterprise-level data integration solutions for banking operations.
  • Developed processes for Salesforce/Kafka/AWS data integration
  • Led requirements gathering and analysis for upstream application integration
  • Collaborated with business teams on development strategy and solution architecture
  • Expert in IICS batch scheduling, parameterization, and code deployment security
August 2022 - August 2023
The Cooperators
IICS/ETL Developer
Designed high-performance solutions for insurance industry data requirements.
  • Developed complex Salesforce object loading processes using IICS
  • Managed batch scheduling, parameterization, and code deployment security settings
  • Engaged with business teams to understand use case requirements
  • Participated in project requirements meetings with business analysts and architects
March 2021 - June 2022
Suncor Energy / Deloitte Canada
IICS/ETL Lead Developer
Led Agile project development for energy sector data integration initiatives.
  • Developed processes for Kafka/AWS data integration and Azure blob storage
  • Created SCD Type-1, Type-2, and Type-3 mappings using SSIS and PowerCenter
  • Managed IICS administration, monitoring, and mass ingestion modules
  • Implemented advanced security configurations and automated processes
October 2020 - March 2021
Ontario Ministry of Children, Community and Social Services
Informatica ETL Developer
Delivered government sector data integration solutions using Agile methodologies.
  • Developed SCD mappings and SSIS packages for government data systems
  • Created Power BI reports and dashboards for ministry stakeholders
  • Worked with Snowflake, Oracle 12C/11gR2, and SQL Server 2017
  • Provided mentorship and training to project teams
December 2016 - August 2020
John Hancock, Canada
Senior Database/Application Developer
Successfully completed 10+ major projects as Senior ETL/Database Consultant.
  • Led Informatica migrations across multiple PowerCenter versions (9.5.1 to 10.4)
  • Developed complex mappings for product line profitability systems
  • Provided SME production support and mentored development teams
  • Worked with Salesforce, Workday, Data Lake, and various database platforms
  • Coordinated with offshore development teams for timely delivery
June 2015 - July 2016
CIBC, Canada
Data Analyst/Application Developer
Led team handling multiple applications and provided technical leadership.
  • Developed solutions using BDE Informatica Developer tool
  • Managed over 1000 Autosys jobs and provided production support
  • Worked with complex COBOL EBCDIC files and Hive/Hadoop sources
  • Created high-level and detailed design documents
January 2015 - June 2015
Rogers Communications, Canada
Informatica Developer
Developed ETL solutions for telecommunications data processing.
  • Created mappings to load data from various sources including flat files
  • Developed Information ETL applications using PowerCenter 9.1.0 HF3
  • Worked with Oracle 11g R2 and various data integration scenarios
June 2014 - January 2015
Genworth, Canada
Data Consultant
Focused on data modeling and warehouse optimization for mortgage insurance.
  • Redesigned ODS data mart for daily activity and analytical reports
  • Enhanced DWH data load processes in Informatica PowerCenter 9.5
  • Implemented data profiling mappings using Informatica IDQ Developer/Analyst
  • Worked with MicroStrategy 9.3 and Cognos reporting tools
January 2014 - March 2014
Ministry of Children & Youth Services / Deloitte Inc.
Data Migration/Profiling Consultant
Led CPIN (Child Protection Information Network) data migration project.
  • Performed comprehensive data profiling including Column, Rule, Join, and Multi-object profiling
  • Designed and developed profiling inventory documents
  • Worked with multiple legacy systems and HP Quality Center
  • Collaborated with global offshore teams (India) for project delivery
August 2013 - December 2013
Alberta Health Services (AHS) / PwC
Informatica Specialist
Contributed to E-Facilities initiative and Document Management System implementation.
  • Developed complex mappings using XML, Update Strategy, Lookups, and other transformations
  • Created templates for Primavera Unifier and managed data uploads
  • Worked with PowerCenter 9.5.1, SQL Server, and Oracle databases
  • Provided regular status updates and knowledge sharing with team members
June 2011 - July 2013
Zurich Canada, Toronto
ETL Lead Development Consultant
Led design and development of data warehouse systems for Multinational Insurance Program.
  • Developed comprehensive ETL solutions using PowerCenter 9.1/8.6.1 HF2
  • Worked with global offshore/near shore delivery model
  • Created mappings for various sources including EBCDIC files from COBOL
  • Optimized PL/SQL packages and procedures using BULKCOLLECT and FORALL
  • Customized in-house web application using .NET and SSIS
September 2010 - May 2011
ING Direct, Toronto
DWH Apps Developer
Developed business data mart solutions for retail banking operations.
  • Designed and developed mappings, workflows, and scheduling dependencies
  • Implemented error handling processes and automatic reload strategies
  • Enhanced existing applications and integrated with enterprise environment
  • Worked with Informatica 8.6, Oracle 10g, and Autosys scheduling
September 2008 - July 2010
ITC Limited / Intac Solutions Pvt. Ltd, Hyderabad, India
Senior Programmer Analyst
Built retail data mart from ground up for India's leading tobacco and FMCG company.
  • Developed, tested, and implemented supply chain system modules
  • Provided technical leadership to development team for BI solutions
  • Scheduled jobs using CRONTAB and Tivoli Maestro tool
  • Worked with Informatica 8.0/7.1.2, Oracle 10g/9i/8i platforms
November 2005 - August 2008
Intac Solutions Pvt. Ltd, Hyderabad, India
Programmer Analyst
Developed web applications and gained foundational experience in .NET technologies.
  • Designed and developed applications using C#, ASP.NET, and SQL Server 2005
  • Created web forms using Master pages and user-defined controls
  • Worked as analysis and design team member for multiple projects
  • Gained experience in Visual Basic and Oracle 8i development

Professional Certifications & Education

Informatica Certified Professional
PowerCenter Data Integration 9.x Developer Specialist
Certificate No. 041-000763
Administrator Specialist
PowerCenter Data Integration 9.x Administrator
Certificate No. 007-000195
Bachelor of Technology
Computer Science & Information Technology
Diploma
Business Administration

Let's Connect

Get In Touch

amanzoorm@hotmail.com
Toronto, Ontario, Canada
linkedin.com/in/manzoorm

Available for:

  • • ETL Development Consulting
  • • Data Integration Projects
  • • Informatica IICS/PowerCenter Implementations
  • • Data Quality & MDM Initiatives
  • • Technical Leadership Roles
  • • Salesforce Data Integration
  • • Cloud Migration Projects

Industries Served:

Financial Services • Insurance • Banking • Energy • Government • Healthcare • Telecommunications • Retail • Supply Chain Management

Send a Message