Shaik Haaji Rahamathulla

Shaik Haaji Rahamathulla

Data Engineer
India

About Me

Data Engineer with 5+ years of experience designing and building scalable, cloud-native data pipelines on Microsoft Fabric and Azure Databricks. Skilled in ingesting data from RDBMS, REST APIs, Salesforce, Snowflake Shar…

Experience

Azure Data Engineer (Databricks & Microsoft Fabric)

Infosys · Hyderabad , Telangana , India
Dec 2024 - Present · 1 year 11 months

<p>Designed and implemented data pipelines to onboard multiple source systems into a Fabric Lakehouse following Medallion Architecture (Bronze, Silver, Gold).</p><p> Built the transformation, cleansing, and data modeling logic aligned with business requirements using Fabric Notebooks and Data Pipelines, producing curated Gold-layer datasets for analytics and reporting.</p><p> Designed and built scalable ingestion pipelines to load data from RDBMS, REST APIs, Snowflake Share, CFG files, and Azure Storage into Azure Data Lake and Snowflake.</p><p> Architected end-to-end ingestion pipelines using Azure Databricks for structured and semi-structured data.</p><p> Implemented a Delta Lake-based ingestion framework with ACID transactions, schema evolution, and incremental load patterns.</p><p> Developed incremental PySpark pipelines with MERGE/UPSERT logic, reducing full refresh cycles.</p><p> Automated workflows using Databricks Jobs and Workflows, minimizing manual intervention.</p><p> Built complex PySpark transformation pipelines for data cleansing, enrichment, auditing, and SCD-like processing.</p><p> Applied Databricks and Spark optimization techniques to improve performance and optimize compute costs.</p><p> Developed optimized SQL queries and stored procedures for validation and analytical transformations.</p><p> Collaborated with analytics, BI, and governance teams and contributed to documentation and reusable frameworks.</p><p> Designed data pipelines following Medallion Architecture (Bronze, Silver, Gold layers) using Delta Lake to support incremental processing, data quality, and analytics-ready datasets.</p><p> Implemented data quality and audit frameworks with monitoring and exception handling.</p>

Data Engineer

Tata Consultancy Services
May 2021 - Dec 2024 · 3 years 7 months

<p>Worked with Azure SQL Database, Azure Cosmos DB, and ADLS for scalable data storage and processing.<br>
Developed ADF pipelines to migrate on-prem SQL Server data to ADLS, improving storage flexibility by 30%.<br>
Boosted distributed query performance by 20% using Broadcast Hash Joins.<br>
Implemented a partitioning strategy that improved large-table join operations by 25%.<br>
Applied caching techniques to accelerate multi-day queries, achieving a 30% performance improvement.<br>
Supported data modeling by designing and optimizing schemas, improving retrieval speed by 20%.<br>
Built automated data workflows, reducing manual effort by 50%.<br>
Developed Spark RDD transformations and Spark Core operations for distributed data processing.<br>
Reduced processing time by 30% using optimized Spark and Python transformations.<br>
Designed transformation workflows (cleaning, filtering, aggregation, enrichment) using PySpark, SQL, and Python.<br>
Collaborated with functional teams to troubleshoot, optimize, and enhance data pipelines.<br>
Tuned and monitored pipelines for performance and reliability.<br>
Wrote optimized SQL queries, stored procedures, joins, subqueries, and correlated subqueries.</p>

Skills

Microsoft Fabric Lakehouse OneLake Data Pipelines Dataflows Gen2 Notebooks Semantic Models Medallion Architecture Python Scala SQL Apache Spark PySpark Spark SQL Delta Lake Azure Blob Storage Azure Data Lake Gen2 Azure Data Factory Azure Databricks Azure SQL Database MySQL Snowflake Azure Cosmos DB Data Modeling Incremental Load CDC MERGE-UPSERT Data Quality Auditing CI/CD Spark Core RDD Broadcast Hash Joins Caching Stored Procedures Schema Evolution SCD
Report this Profile?