Muhammad Talal Zia

Results-driven Data Engineer with 16+ years of experience and 10+ years in designing and delivering enterprise-grade ETL/ELT pipelines, data integration architectures, and cloud data warehouse solutions. Deep expertise in Boomi AtomSphere (Local Atom, Molecule) and Boomi Cloud Integration. Skilled in building scalable, fault-tolerant data pipelines that process structured and semi-structured data across ERP, CRM, EDI, and eCommerce platforms.

Experienced with SAP, MS Dynamics 365, Salesforce Commerce Cloud, Snowflake advanced features including Snowpipe, Streams & Tasks, and Data Sharing with PowerBI for analytics. Proven ability to architect multi-layer data warehouse schemas, enforce data governance, and optimize performance for high-volume data processing environments.

Senior Data Engineer / Integration Architect at Visionet Systems Inc. (2020-02 – Present)

Tools & Technologies: Boomi AtomSphere (Local Atom, Molecule), Boomi Cloud Integration, Boomi Flow, Snowflake, PowerBI, Amazon S3, Amazon Redshift, SAP, MS Dynamics 365, Salesforce Commerce Cloud, Salsify, MI9, AS2/SFTP

• MS Dynamics 365 Implementation – Retail / E-commerce Domain – Boomi Cloud AtomSphere: Client planned to replace SAP with D365 while keeping all other integrated systems of their ecosystem as is. Integrated complete supply chain ecosystem from Product, Orders, Warehouse, Shipment, PO/SO and archiving systems.

Architected

Boomi data integration pipelines ingesting structured data from EDI and different systems to MS Dynamics 365 and back to these systems.

Implemented

Snowflake and PowerBI for reporting and analytics purpose where data was coming from MS Dynamics and other systems.

• Enterprise EDI Data Integration – Trucking Domain – Boomi Cloud AtomSphere: Designed and implemented end-to-end B2B/EDI data integration pipelines using Boomi AtomSphere for ANSI X12 transaction sets (204, 214, 850, 856, 810, 997, 864) across AS400, Smart, and Mastery platforms. Built canonical data models, cross-reference lookup mappings, and conditional transformation logic for complex partner-specific EDI field mapping; implemented error handling with reject file management, session-level logging, and exception queue workflows. Configured AS2/SFTP secure file transfer with TLS/SHA-256 encryption, digital certificates, and MDN acknowledgment integrated into Boomi process orchestration for end-to-end EDI lifecycle management. Established EDI data governance framework with partner onboarding templates, Boomi process version control, and compliance validation rules; achieved latency reduction via Boomi parallel processing optimization and parallel processing.

Implemented

Snowflake and PowerBI for reporting and analytics purpose where data was coming from MS Dynamics and other systems.

• SAP S/4HANA API-Led Product & Order Data Pipelines – Footwear Retail – Boomi Cloud AtomSphere: Architected real-time, API-led product data synchronization pipelines in Boomi ingesting data from Shopify into SAP S/4HAHA using REST connector, CSV-to-XML/JSON transformation mappings, idempotent processing, and duplicate detection logic.

Built

Boomi process flows for product, pricing, and inventory synchronization with parallel task execution and document batching.

Developed

Boomi order lifecycle integration (create, update, cancel, fulfillment) between Shopify and POS with SAP S/4HAHA (ERP) using REST/SOAP connectors with OAuth 2.0 and JWT authentication enforcement. Enforced API governance across all integration surfaces via Boomi API Management policies; enabled end-to-end monitoring using Boomi Atom Management dashboards and process reporting for SLA tracking.

• Salsify to SFCC Integration – Retail / E-commerce Domain – Boomi Cloud AtomSphere: Re-engineered high-latency Boomi Local Atom processes using parallel processing optimization, connector caching, bulk data operations, and sub-process decomposition; achieved ~40% reduction in average ETL execution time.

Established Boomi Local

Atom and Boomi Cloud AtomSphere development standards, reusable process component templates, and environment extensions; integrated Boomi AtomSphere APIs with CI/CD pipelines (Azure DevOps) for automated DEV→QA→PROD environment promotion. Migrated legacy file-based ETL integrations to encrypted SFTP/FTPS pipelines within Boomi, adding key-based authentication, audit trails, and real-time alerting for enterprise-grade file transfer governance.

Lead Data Engineer at Systems Ltd (2014-12 – 2020-01)

Tools & Technologies: Informatica PowerCenter 9.x/10.x, Informatica IICS, Snowflake, Oracle, SQL Server, CA AutoSys

• Cloud Data Ingestion & Processing – Healthcare Domain – IICS: Developed IICS Advanced Mode mappings for high-performance ingestion of Amazon S3 Parquet files; applied pushdown optimization to leverage native Snowflake compute. Implemented parameterized, reusable IICS mapping templates with watermark-based CDC for incremental load strategies; built fault-tolerant pipelines with session-level error handling, reject file management, and IAM-secured S3 connectivity via IICS Secure Agent. Designed automated reconciliation workflows in IICS comparing source record counts against Redshift load summaries; implemented alerting for threshold breaches with email notification via IICS Monitor.
• Order Management System (OMS) Transformation – Retail / E-commerce Domain – Informatica PowerCenter: Architected hybrid Informatica PowerCenter batch workflow solution for legacy mainframe OMS migration to Manhattan OMS; designed ODS staging layer to decouple source systems (Mi9, WMS, SFCC) from downstream services.

Built

PowerCenter mappings with complex transformations including Lookup, Joiner, Router, Update Strategy, and Aggregator to handle business rule enforcement, surrogate key management, and type-2 SCD logic. Managed enterprise pipeline scheduling using CA AutoSys; applied partitioning strategies and bulk loading techniques to optimize performance for nightly batch windows processing millions of order records.

• Product & Customer Master Data Pipelines – Retail / E-commerce Domain – Informatica PowerCenter: Developed 40+ mappings and workflows to extract, transform, and load product/SKU data from source systems into an ODS layer and generate SFCC-compliant XML payloads; designed full and delta load strategies with row-level hash comparison. Built 200+ Informatica mappings and workflows for MI9 merchandising, covering purchase orders, inventory management, pricing, and sales data; implemented hybrid IICS real-time + PowerCenter batch architecture with ODS staging for decoupled processing. Engineered 20+ customer master data pipelines applying deduplication, survivorship rules, surrogate key management, and business rule enforcement via PowerCenter Expression and Filter transformations; pipelines powered downstream analytics and personalization engines.

Bachelor of Science in Computer Sciences – National University of Computer & Emerging Sciences (2008)