Faisal Shaikh
Data Engineer at CitiusTech
- Role
- Technical Lead at CitiusTech
- Location
- Mumbai, MH, IN
- LinkedIn followers
- 500 followers
About Faisal Shaikh
Seasoned professional with seven years of experience in data engineering, with initial three years focused on the MSBI full stack and MS SQL, where my expertise were in developing and optimising ETL processes, SSIS packages, and data models. Over the past four years, have specialised in Azure Data Engineering and Databricks, leading the re-design of client’s data warehouse from MS SQL based On-premise architecture to Azure Cloud based one. This included developing Pyspark Databricks notebooks, using ADF pipelines to orchestrate ETL jobs and utilizing delta tables for efficient data management. I also have extensive experience with Azure Data Factory pipelines, Azure Logic Apps, Azure SQL, DevOps and designing ETL processes using modern warehousing techniques like SCD7.
Experience
Technical Lead
Apr 2024 — Present · Mumbai, IN
Worked extensively in re-designing the client’s data warehouse, migrating from Microsoft SQL Server to Azure, focusing on table design, ETL development, and adopting new technologies.• Developed Pyspark Databricks notebooks to ingest and optimize clinical and billing data domains for reporting.• Implemented a medallion architecture for organising data into a Raw layer (Parquet files in Azure Data Lake Storage) and bronze, silver, and gold layers within Databricks.• Leveraged Databricks’s delta tables and delta live tables to ensure accurate, safe, and efficient data storage for the Enterprise Data Warehouse.• Built and managed numerous Azure Data Factory pipelines, including datasets and linked services, to ingest data from diverse sources, integrate with storage engines and invoke Databricks notebooks to transform data into destination databases.• Collaborated with development teams to integrate resources into projects using Azure and Azure DevOps, including pipelines and repositories.• Designed and developed ETL processes for populating fact and dimension tables, utilizing SCD7 design principles and modern data warehousing techniques.
Education
M.H. Saboo Siddik College Of Engineering
Bachelor of Engineering - BE, Electronics Engineering
2014 — 2018
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.