I’m Mohammed Ismail, a data infrastructure leader with 10+ years of experience designing and operating end-to-end cloud data pipelines, lakehouse/warehouse architectures, and high-performance database solutions. My work focuses on building scalable orchestration and transformation workflows (with CDC patterns), tuning query performance, and implementing cost-optimized analytics platforms. I also enjoy bridging business needs and engineering execution—working directly with stakeholders to turn data requirements into governed, secure, and reliable data products. From leading Medallion architectures and Unity Catalog/RLS governance to optimizing Power BI models for strong query folding, I’ve helped teams deliver faster insights while reducing cloud compute consumption.…

MOHAMMED ISMAIL Z

I’m Mohammed Ismail, a data infrastructure leader with 10+ years of experience designing and operating end-to-end cloud data pipelines, lakehouse/warehouse architectures, and high-performance database solutions. My work focuses on building scalable orchestration and transformation workflows (with CDC patterns), tuning query performance, and implementing cost-optimized analytics platforms. I also enjoy bridging business needs and engineering execution—working directly with stakeholders to turn data requirements into governed, secure, and reliable data products. From leading Medallion architectures and Unity Catalog/RLS governance to optimizing Power BI models for strong query folding, I’ve helped teams deliver faster insights while reducing cloud compute consumption.…

Available to hire

I’m Mohammed Ismail, a data infrastructure leader with 10+ years of experience designing and operating end-to-end cloud data pipelines, lakehouse/warehouse architectures, and high-performance database solutions. My work focuses on building scalable orchestration and transformation workflows (with CDC patterns), tuning query performance, and implementing cost-optimized analytics platforms.

I also enjoy bridging business needs and engineering execution—working directly with stakeholders to turn data requirements into governed, secure, and reliable data products. From leading Medallion architectures and Unity Catalog/RLS governance to optimizing Power BI models for strong query folding, I’ve helped teams deliver faster insights while reducing cloud compute consumption.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert

Work Experience

Lead Data and Process Analyst (Functional: Lead Data Infrastructure Engineer) at WPP PRODUCTION
January 1, 2025 - Present
Serve as the platform SME for production Snowflake analytics structures, implementing native Streams for CDC tracking and scheduled Tasks for automated ingestion. Coordinate with business stakeholders to translate complex requirements into scalable engineering solutions, including automated data quality audit controls and governance workflows. Led a BI-to-warehouse cost optimization approach by restructuring Power BI semantic models to enforce strict query folding and pushing business logic upstream into native Snowflake SQL blocks, eliminating expensive row-by-row cleansing on the Power BI Web Service. Mentor junior team members on parameterized Azure Data Factory (ADF) implementations, optimizing parallel copy throttling and handling dynamic schema drift paths.
Lead (Functional: SQL & Power BI Data Lead) at MOVATE (Formerly CSS Corp) - Client: Palo Alto Networks (USA)
June 1, 2023 - January 1, 2025
Led migration of legacy transactional databases into cloud-native Medallion Lakehouse architecture using Azure Databricks, PySpark, and Microsoft Fabric OneLake. Designed and deployed scalable ingestion frameworks via ADF metadata-driven pipelines and Self-Hosted Integration Runtime (SHIR) clusters. Built modular PySpark notebooks and mentored engineers on cluster tuning techniques including data salting and broadcast hash joins to eliminate data skew. Owned enterprise governance and RLS strategies using Unity Catalog across workspaces to securely serve masked data streams to 130+ analytics consumers. Managed release engineering and code promotion decisions with automated ARM templates and Git-based promotion workflows from Dev to Production, while supporting executive reporting through Power BI modeling and DAX.
Process Developer (Functional: Senior T-SQL Data Engineer) at GENPACT INDIA PVT LTD - Client: Intel (India)
November 1, 2018 - June 1, 2023
Led data delivery teams across the SDLC under Agile to engineer complex, optimized relational database management systems (RDBMS). Developed high-volume infrastructure objects using advanced T-SQL (window functions, indexed partitioning, dynamic stored procedures, and complex triggers). Built watermark-based incremental loading pipelines with lookback windows to handle late-arriving records for daily and weekly historical updates. Improved underperforming query architectures using execution plan analysis and targeted indexing, reducing computational overhead by up to 35% on critical BI workloads. Automated ingestion/validation/cleaning of semi-structured file dumps into transactional structures using PowerShell scripts and macro workflows.
Process Associate II (Functional: MIS & Data Reporting Analyst) at XOME SERVICES INDIA PVT LTD - Client: Mr. Cooper (USA)
May 1, 2016 - August 1, 2018
Partnered with multi-region mortgage operations teams to transform raw mortgage lifecycle tables into standardized corporate MIS reports. Delivered complex SQL querying and data mining for validating SLA conformity metrics across historical mortgage portfolios. Supported volume forecasting and workforce scheduling analytics using specialized reporting and analytics workflows.

Education

Bachelor of Computer Applications (B.C.A.) at Thiruvalluvar University, Tamil Nadu
January 11, 2030 - September 21, 2026

Qualifications

Add your qualifications or awards here.

Industry Experience

Software & Internet, Computers & Electronics, Financial Services, Media & Entertainment