Badges
Certifications
Tfiroz has not earned any certificates yet.
Work Experience
Software Engineer
Infosys Ltd•  June 2013 - Present
Have 7+ years of IT experience in Microsoft Business Intelligence, Data modeling, SQL Server, SQL Server Integration Services, SQL Server Analysis & Reporting services, Pyspark, Azure Data Factory (ADF v1/v2), Azure Data Lake(ADLS, ADLA) & Azure Databricks(ADB) along with Delta Lake • Designed Conceptual, Physical and Logical data models using Data Modeler tool. • Extracting, transforming, and loading data (ETL) between various Homogenous and Heterogeneous data sources using SSIS, Azure DataFactory (ADFv1/v2) and worked on improving ETL performance. • Good understanding of Spark Architecture including Spark Core, Spark SQL, PySpark, Data Frames, Spark Streaming, Driver Node, Worker Node, Stages, Executors and Tasks. • Experience in Pyspark & SQL to transform the data as per business logics and processing facts & dimensions. • Experience in handling large datasets using horizontal & vertical partitions, spark in memory capabilities, broadcasts in spark, effective & efficient joins during transformation using PySpark. • Created metadata (SQL) driven Azure Data Factory pipeline to load data from various source by implementing Data Quality checks & re-start from point of failure. • Created Data Factory pipeline using transformation like Lookup, ForEach, If Condition, Stored Procedure, Wait, Web, Execute Pipeline etc. • Experience in COSMOS (Microsoft’s internal massively parallel computing platform like ADLS & ADLA), Scope scripts (a U-SQL like language used in Cosmos). • Experience in upholding Azure cost management. • Proven proficiency at Data Transformations like Derived Column, Conditional Split, Aggregate, Multicast and Sort& Execute SQL Task using SSIS to load data into Data Warehouse. • Experience in writing complex SQL Queries & SQL Server database objects development including Stored Procedures, Functions, Views, Triggers, CTE, Indexes, and Synonyms. • Tuned Performance for Stored procedure and TSQL queries using SQL Profiler, Estimated and actual query plans and database engine tuning advisor. • Worked on Tabular Cube as well as MDDM cube in SSAS. Also, Implemented Row level Dynamic Security using DAX in Tabular. On top of tabular cube created a Power View for the user
Education
Tfiroz has not updated education details yet.
Links
Tfiroz has not updated links details yet.
Skills
Tfiroz has not updated skills details yet.