Fahad Mahmood

FAQ About Fahad Mahmood

• What is Fahad Mahmood's address?

  Fahad Mahmood is located at
  Noida, Uttar Pradesh, India

• What is Fahad Mahmood's job title?

  Fahad Mahmood is a
  Currently Associated with HCL Technologies- D&A practise as a Technical Architect with 10+ yrs. of Experience Snowflake DWH cloud,DBT cloud,Spark,Azure ADF,Azure Databricks,Azure Synapse,ADLS, Snowflake,ETL Informatica,Oracle SQL,SnowPipes,Migrating application from SAP HANA ,BW to snowflake through Datavard ,Hybrid cloud ingestion AWS in Snowflake tables,Continuous Data Load Ingestion pipeline for ETL/ELT Load,Dynamic DDL Schema change Detection,Creating ECC framework for Data load strategy using Automated Java Script Stored Proc and unloading to S3,Automating Hybrid Merge using Javascript Stored Proc,CDC Implementation using Stream and Task ,RBAC,Azure Cloud,PL/SQL,Sql server, Domain knowledge: US Health Care,Data Analytics,Telecom Key Roles: Worked on Data Warehouse Design Implementation . Extracting the data from various source system and Data Marts i.e. from Big Data platform Data Lake,Hive. . Creating transformation rules based on Mapping document and loading into the target system for different Subject Areas using Informatica as a ETL tool. . Worked on External stage AWS S3 to load semi structured data JSON,Parquet into snowflake through Snow Pipes,Copy command. . Developed Data Validation framework. . Worked on Informatica Designer for creating ETL mapping from source to target tables ,Implementing SCD2,Router transformation, Lookup,Joiner,Update Strategy, Incremental Load,Worked loading data from flat files into Staging layer and loading back to integration tables . • Created Snowpipe for continuous data load. • Worked on creating ETL pipelines in and out of data warehouse using Snowflakes SnowSQL Writing SQL. . Worked on creating Work Flow for creating Jobs,Monitor Log,Transferring files to downstream application through Unix shell scripts using ECG,Creating parameter files and session variables and maintaining entry in CFW Common Frame work table. . Worked on creating Data Model logical and Physical and Data Flow Diagram,Data base normalization techniques. . Creating TWS Jobs for scheduling jobs in different job streams and updating the dependency. . Worked on cursors and Refcursors,Exception Handling for error logging,Views and Materialized View. . Creating indexes for fast retrieval of data, Performance Tuning using DBMS_PROFILER and TKPROF,Hints,Database designing,Database Migration, Jenkins,CI/CD implementation,XL deployment set up in all server, Set up GITHUB , Hcl Technologies

• What industry does Fahad Mahmood currently work in?

  Fahad Mahmood currently works in the
  Hcl Technologies

• What is Fahad Mahmood's area of expertise?

  Fahad Mahmood specializes in
  Currently Associated with HCL Technologies- D&A practise as a Technical Architect with 10+ yrs. of Experience Snowflake DWH cloud,DBT cloud,Spark,Azure ADF,Azure Databricks,Azure Synapse,ADLS, Snowflake,ETL Informatica,Oracle SQL,SnowPipes,Migrating application from SAP HANA ,BW to snowflake through Datavard ,Hybrid cloud ingestion AWS in Snowflake tables,Continuous Data Load Ingestion pipeline for ETL/ELT Load,Dynamic DDL Schema change Detection,Creating ECC framework for Data load strategy using Automated Java Script Stored Proc and unloading to S3,Automating Hybrid Merge using Javascript Stored Proc,CDC Implementation using Stream and Task ,RBAC,Azure Cloud,PL/SQL,Sql server, Domain knowledge: US Health Care,Data Analytics,Telecom Key Roles: Worked on Data Warehouse Design Implementation . Extracting the data from various source system and Data Marts i.e. from Big Data platform Data Lake,Hive. . Creating transformation rules based on Mapping document and loading into the target system for different Subject Areas using Informatica as a ETL tool. . Worked on External stage AWS S3 to load semi structured data JSON,Parquet into snowflake through Snow Pipes,Copy command. . Developed Data Validation framework. . Worked on Informatica Designer for creating ETL mapping from source to target tables ,Implementing SCD2,Router transformation, Lookup,Joiner,Update Strategy, Incremental Load,Worked loading data from flat files into Staging layer and loading back to integration tables . • Created Snowpipe for continuous data load. • Worked on creating ETL pipelines in and out of data warehouse using Snowflakes SnowSQL Writing SQL. . Worked on creating Work Flow for creating Jobs,Monitor Log,Transferring files to downstream application through Unix shell scripts using ECG,Creating parameter files and session variables and maintaining entry in CFW Common Frame work table. . Worked on creating Data Model logical and Physical and Data Flow Diagram,Data base normalization techniques. . Creating TWS Jobs for scheduling jobs in different job streams and updating the dependency. . Worked on cursors and Refcursors,Exception Handling for error logging,Views and Materialized View. . Creating indexes for fast retrieval of data, Performance Tuning using DBMS_PROFILER and TKPROF,Hints,Database designing,Database Migration, Jenkins,CI/CD implementation,XL deployment set up in all server, Set up GITHUB ,

• Which languages does Fahad Mahmood speak? 

  Fahad Mahmood speaks the following languages:
  No languages available.

• Which industries has Fahad Mahmood previously worked in?   

  Fahad Mahmood has prior experience in the following industries:
  Unitedhealth , Wipro , Hcl Technologies , Igate

• What is Fahad Mahmood’s work experience?  

  Fahad Mahmood has the following professional experience:
  Hcl Technologies , Unitedhealth , Wipro , Hcl Technologies , Igate .

• How can I find Fahad Mahmood on LinkedIn?  

  You can view Fahad Mahmood’s
  LinkedIn profile at LinkedIn URL.

• What are Fahad Mahmood’s work email addresses?  

  Fahad Mahmood’s work email addresses are
  [email protected] .

• What company does Fahad Mahmood work for?  

  Fahad Mahmood works at
  Hcl Technologies