Aman Kumar Email & Phone Number

Patna, Br, In

Chennai, Tamil Nadu, India

* Developed a Glue Job for Data Extraction and Staging: Created an AWS Glue job to streamline the process of extracting data from a client’s API. This involved configuring the job to pull data efficiently and load it into a designated staging area. The staging area acts as an intermediary storage location where the raw data can be held temporarily before further processing. This setup ensures that data is collected in a structured manner and is readily available for subsequent processing tasks.* Designed and Implemented PostgreSQL Functions for Data Transformation: Developed PostgreSQL functions to handle complex data transformations and manipulations on the data loaded into the staging area. These functions were designed to process and transform the data with high accuracy and efficiency, preparing it for integration into target systems. This step ensures that the data is formatted and cleaned according to the needs of the end systems, improving the quality and usability of the data once it reaches its final destination.* Collaborated with Cross-Functional Teams: Worked closely with various teams, including data engineers, analysts, and business stakeholders, to support and enhance data-driven decision-making processes. This collaboration involved understanding the data needs of different teams, ensuring that data workflows met their requirements, and providing insights and support to help drive informed business decisions. This teamwork helps align data strategies with overall business goals and improves the effectiveness of data utilization across the organization.

Noida, Uttar Pradesh, India

* Migrated Client Data to AWS Data Lake: Facilitated the transition of client data from an on-premises(JDE) system to an AWS data lake. Designed and executed the migration strategy to ensure accurate and efficient data transfer, enhancing storage and processing capabilities.* Developed and Maintained Data Pipelines: Created and managed data pipelines for the seamless extraction, transformation, and loading (ETL) of data. Ensured pipelines were efficient and reliable, contributing to streamlined data workflows.* Ensured Data Quality: Implemented data quality standards by conducting data cleansing, transformation, and validation. Ensured data accuracy and reliability throughout the processing stages.* Tested and Validated ETL Pipelines: Conducted thorough testing of ETL pipelines using mock data and developed System Integration Testing (SIT) documents. Ensured the robustness and effectiveness of data processing workflows.