About imran sadiq:
I am a Senior Data Engineer & experience in Banking Industry and Telco. Big data , Data Warehousing, Hadoop, PySpark, Cloudera Administration, Vault Data Modeling WhereScape, Azure Synapse Analytics, Huawei Cloud Gauss DB, GCP, WhereScape and TimeXtender, eCommerce, I have worked on Core banking System Temenos T24 [Bank Alfalah Pakistan] & Misys Equation, Konnect [HBL Bank Pakistan] in data warehouse & Data Lake . Master’s in Software Engineering.
Experience
Projects
Cloudera Installation and Administration in Allied Bank, Islamabad, Pakistan
• Installing CDP Private Cloud and build data lakehouse in Allied Bank
• Maintenance of Data Lake Administration, Access, Security, Backups, Patches, etc.
• Managing and setting compression of the storage.
• Hands-on working in Cluster expansion activities for node addition and re-commission and decommission of nodes from cluster in case of disk hardware and volume failures.
MAF-UAE Migration on-premises to Azure remotely working with Predicagroup - Poland
• Analysis of existing Sources and in House DWH
• Migration of existing SSIS packages and SQL Server Databases to Azure Cloud
• Migration Plan and strategy through Azure Migrate, DMA and Self hosted VM for SSIS, Azure Synapse Analytics for Pipeline and Runtime Integration for SSIS.
• Reverse Engineering of TimeXtender ETL packages and creating Mapping Doc and find business rule.
• TimeXtender with Azure Synapse Analytics
BI Reporting for Commercial Bank of Dubai using ADF and Azure Synapse Analytics
• Access and Migrating On premise databases to Azure Data Lake using Azure Data factory
• Create dynamic Pipelines in ADF to Extract and Transform the data to azure synapse analytics and load data into different sources like Azure SQL, Blob storage, Azure Synapse.
• Extract, Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL and Azure Data Lake Analytics.
• Hands-on experience on developing SQL Stored procedure and Create schedule triggers for pipelines.
• Hands on experience on implementing the SCD type 1, SCD type 2 in ADF & azure synapse.
Huawei Hybrid Cloud CMPAK Telco, Islamabad, Pakistan
• Analysis of RAC [ Revenue Assurance Controls] developed in Teradata
• Migration of Teradata data warehouse to Huawei Hybrid Cloud Gauss DB
• Migration Plan and strategy and Convert Teradata script to Gauss DB
Big Data and Analytic for Bank HBL, Islamabad, Pakistan
• Data Analysis of core banking system Misys Equation for Data Modeling and Profiling
• Dashboard Analysis: HBL NTB Tracker, Current Accounts Averages CA dashboard, Rural Banking dashboard
• Identification of field in source system and monitor availability of data
• Developed Component wise test queries & data reconciliation from latest business dashboard
• Identification of field/business names in cube interfaces post cube development
• Ingest Data through SSIS ELT tool from RAW Zone to Refine Zone and to Presentation Layer
• Create Data Warehouse Model and Mapping of these business areas from Core Banking System-Misys.
Collateral, Biometric, PA Portfolio and Transaction Account Stat, Konnect BB
• Collateral ETL development in Impala for Raw Zone, Refine Zone and Presentation Layer
• Data Analysis & Profiling of Konnect BB sources in Informatica IDQ
• Worked on HBL DWH operations for data loading and ETL batch optimization
Big Data and Temenos T24 for Bank Alfalah, Islamabad, Pakistan
• Internal Report rationalization, Field level analysis based on reports
• Data reconciliation as per current Teradata extraction and migrate existing Teradata reports to T24
• Developed reports in Temenos T24 for Premier Banking, Treasury, Finance, Bank at work
• Build data lakehouse with Hadoop raw zone, refine zone and presentation layer
• User profile in ranger Ac, in ambari and in Linux
Recommendation Engine, Artilytics, Karachi, Pakistan
• Developed recommendation engine prototype in R
• ETL Development Life Cycle in oracle
• Business dashboard using power BI
Education
Master in Software Engineering
General: Data Analysis, DWH, Data Lakehouse, SQL Server, Oracle, Ecommerce, Vault Data Modeling & Metadata Management, data governess, Azure Synapse analytics, Huawei Cloud Gauss DB, Cloudera & Hadoop, and Teradata
Data Engineering: SSIS, Impala, Hive, Azure Synapse,GCP BigQuery, AWS, PySpark, Informatica IDQ, Huawei Gauss DB, Mongo db, Scoop, WhereScape, and TimeXtender.
Programming Language: Shell Scripting, Python, R, PHP
BI Tools: Power BI, Tableau
Professionals in the same Engineering / Architecture sector as imran sadiq
Other users who are called imran
Jobs near Islamabad
-
Manager Jobs
Found in: beBee S2 PK - 1 week ago
Army Facilitation Centre Rawalpindi, Pakistan Full timeLatest AFC Jobs in Rawalpindi February 2024 has been announce through Latest advertisement Applications are invited from Pakistani Nationals having relevant qualification/experience for recruitment against the following vacant posts. Terms and condition for eligibility is indicat ...
-
FUI Jobs
Found in: beBee S2 PK - 5 days ago
Foundation University Islamabad Islamabad, Pakistan Full timeFoundation University Islamabad(FUI)Jobs August 2023 has been announce through Latest advertisement Applications duly filled on the prescribed form (downloadable from FUI website: these Latest Govt Jobs in Islamabad the Male and Female candidate can Apply in these Jobs and can g ...
-
Stenotypist Jobs
Found in: beBee S2 PK - 2 days ago
Auditor General of Pakistan Islamabad, Pakistan Full timeStenotypist(BPS-14)Jobs in Islamabad December 2023 has been announce through Latest advertisement candidates for recruitment in the Department of the Auditor General of Pakistan against the following posts Stenographer .In these Latest Govt Jobs in Islamabad the Male and Female c ...