Sultan Usama Khan

• Built scalable data pipelines using Azure Databricks, Spark, and Delta Lake, reducing processing latency by 30%.
• Developed batch and streaming ETL workflows using Azure Data Factory, optimizing execution time and cost.
• Ingested and transformed structured and semi-structured data (JSON, Parquet) into ADLS Gen2 and Azure Synapse Analytics.
• Implemented data modeling, partitioning strategies, and lineage tracking to support business reporting and compliance.
• Automated pipeline monitoring and alerting to enhance data quality and system reliability.
• Collaborated with analysts and architects to align data assets with organizational goals and security standards.

• Developed and optimized standard Talend jobs and Big Data batch jobs using Talend Data Integration and Talend Big Data to enhance data processing efficiency.
• Implemented data loading processes from Oracle to HDFS, utilizing effective partitioning logic to improve performance and manageability.
• Crafted complex SQL queries by thoroughly analyzing source-to-target mapping documents, ensuring accurate data transformation and migration.
• Engineered Talend jobs to extract data from Oracle 11g data warehouse, applying necessary transformations per mapping specifications, and exporting results to CSV files for downstream use.
• Designed and deployed Big Data batch jobs, streamlining data workflows and enabling scalable data processing solutions.

• Developed and optimized Talend jobs for full and incremental data loads, ensuring efficient data processing and integration.
• Conducted thorough testing and scheduling of jobs to meet project requirements and timelines.
• Implemented file-based context for Talend jobs to comply with client-side data regulations, enhancing data security.
• Extracted and transformed data from diverse sources, including APIs, databases, and flat files, improving data accessibility.
• Took ownership of a collaborative task, leading the design and implementation of data solutions, showcasing strong teamwork and leadership skills.
• Enhanced data pipeline efficiency, contributing to improved data quality and reliability within the retail domain.

• Collaborated with the team to design and implement robust tables in SQL Server, enhancing data organization and accessibility.
• Independently developed and optimized ETL solutions using Talend and SQL, improving data processing efficiency.
• Created and scheduled ETL jobs to automate data workflows on daily, monthly, and file-based schedules, ensuring timely data availability.
• Demonstrated proficiency in crafting complex SQL queries for SQL Server databases, facilitating advanced data analysis.
• Engineered and deployed ETL jobs that integrate with Restful APIs, expanding data ingestion capabilities and streamlining data pipelines.