Sourabh Maheshwari

Client: HSBC [Job Role: Senior Data Engineer]

Description: HSBC Corporate and Institutional Banking (CIB) offers financing, global payments, trade solutions and provides a range of wholesale banking services to corporations, financial institutions and governments.

Roles & Responsibilities:

• Owner of the Requirements– from gathering requirements to development, designing Architectural solutions and deploying applications.
• Worked on various use cases to develop various Contextual Datasets (CDAs) which are enriched and transformed from Generic Datasets (GDAs) and Master Datasets (MDAs) as per Business requirement.
• Built and maintained robust Data Pipeline workflows within the Databricks environment to streamline data operations.
• Worked on creation, managing and monitoring of Airflow DAGs.
• Designed and developed data transformation scripts using Medallion Architecture incorporating Data ingestion, Data Preprocessing and processing, Data Validation and loading data into the gold layer after all the enrichments and transformation.

Client: Northern Trust [Job Role: Data Engineer]

Description: Northern Trust Corporation is a global financial services company that provides wealth management, asset servicing, banking and liquidity services to large corporations.

Roles & Responsibilities:

• Worked as a Data Engineer on Azure Services like Synapse Analytics, Databricks to created Data Pipeline which covers end to end steps from Data Ingestion, Data Transformation & Enrichment to finally Data Delivery.
• Expertise in pre-processing data from various sources and different formats like SFTP, JSON formatted files from APIs, source data from Oracle & MS SQL DB, PSV files, Parquet, Avro etc.
• Data transferring from source to target by applying operations as per business requirements.
• Exposing enriched data from the gold layer to further DataMesh architecture which is using Snowflake as a technology and used by a wider group.
• Involved in Implementation of Agile process of development and CI/CD using Jira, Azure DevOps, GitHub and Git from scratch. Enabled Continuous Delivery through Deployment into several environments of Test, Pre- Prod and Production.

Client: Bank of America [Job Role: Data Engineer ]

Description: Bank of America is a multinational investment bank and financial services holding company offers services such as commercial banking, wealth management, and investment banking, and operates through a network of financial centers, ATMs, and digital banking platforms.

Roles & Responsibilities:

• Creation and implementation of various rules and transformations on dataset for Data Masking as per business.
• Worked on Data Quality component, built on Spark for various integrated rule engines to transform data as per business requirements.
• Experience of working on feature of sensitive data Discovery supports in nearly all file formats like text, csv, pdf, xls, parquet, Avro etc. by performing line by line processing and chunk processing of data.
• Hands on experience in running Data Discovery, Data Validation as well as Data sanitization thru IEDPS (Infosys Enterprise Data Privacy Suite) Tool.
• Worked on Sampling of Data by ingesting Data along with development of algorithm and pipelines for Data Masking, Data Sanitization and generation of Synthetic Data.

• Worked as Senior Software Engineer as Python Developer.