Data Engineer, Data Engineer, Data Engineer

Amit Paul
Data Engineer



HPE's new high-end storage platform to driving the next wave of the Intelligent
Edge and cloud choices. Customer validation , new creation of batch entity and
batch number of customer through HPI and HPE tenant.
Created implementation report for Customer inquiry and validation, used
interface implementation and standard method PRESET_SALES_AREA for valid
additional data under sales header area. Documented and specified it for
Implicit Implementation in BADI for Shipping Sales Requisition.
Roles & Responsibilities Undertaken
* Created the ODATA and REST web services report program to extract data in xml format using OOPS
and RFC methodologies
* Created class builder report using classic BADI and implemented it in XD01/XD02 to create and
fetch customer details based on shipping additional data screen fields and updated KNVV through
standard function methods PRESET_SALES_AREA using interface from implementation.
* Performed Unit testing and Integration testing for ALE Idocs which is generated and executed
successfully Worked on Conversion Routine to add field constraints in segment for ALE Idocs through
mandatory field LZONE with additional data and classification linking.
* Checked and verified partner details in presentation server file
* Cross verified with client to check extracted data migrated to standard field using BDC report and
merged it in custom table through field pointers concept.

Project: ETL for Retail domain client
In this Big Data project we extract data from different sources like
mysql, oracle and put them into Aws S3. From here we do the
transformation using AWS Glue and drop the data into processed layer.
The processed layer data residing on the data lake is being published to
the end user by using Athena Views.

Activities / responsibilities:
* Analyzing the different source systems and knowing how to extract data from each source system.
* Transforming and Loading the data to S3 by the help Apache Spark.
* Coordinated with BI team to provide them with necessary data required for reporting.
* Designed and developed complex data pipelines for customer
* Wrote production level code for logging, querying shipping sales
* Construct ETL to capture productivity and data quality checks

Technologies: Python, Spark, Aws Glue, S3, Athena

for banking domain
Infosys Finacle solutions address the core banking liquidity management, wealth
management, analytics, artificial intelligence, and financial institutions to
drive business excellence.
Infosys Finacle universal banking solution builds on the success of Finacle to
deliver powerful benefits to global banks. The solution makes possible faster
launch of new products and services , helping banks realize a 55 percent return
on core banking transformation investments and an average improvement of 33
percent in their time to market as banks aim to reinvent their business and
navigate the current challenges in the macroeconomic environment, Finacle 11E
promises a simplified approach to banking transformation.

Roles & Responsibilities Undertaken
* Cross verified with client to check extracted data migrated to standard field using BDC report and
merged it in custom table through field pointers concept.
* Created test cases in excel sheet and written test scenarios for database testing using query on
the data on MySql Server.
* Performed DDL/DML operations on backend databases, triggered stored procedures while database
designing.