Sohail Mohammed

Developed and maintained Azure Data Factory pipelines to automate ingestion and ETL workflows for BI and analytics. Used Azure Databricks with PySpark for data transformations, and led migration from on-premises Oracle/Informatica to Azure, implementing raw/curated/derived layers with a medallion architecture. Built CI/CD deployment workflows using Azure DevOps and Git, implemented data quality checks and business/SOX alerts, and scheduled Databricks workflows with Control-M while performing downstream impact analysis. Provided post-deployment support, including validation activities, troubleshooting, and issue tracking with technical stakeholders.

Built and enhanced ETL mappings using Informatica PowerCenter tools, including SCD Type 2 workflows, while optimizing ETL performance and mapping efficiency. Reverse-engineered existing Informatica designs and implemented equivalent Azure-based pipelines, using incremental ingestion patterns with Azure Data Factory Autoloader. Performed batch transformations in Azure Databricks using SQL, Python, and PySpark to prepare analytics-ready datasets. Supported QA after migration with validation and troubleshooting, and produced design documents, data dictionaries, and runbooks for operational readiness.