Project -->> Telecom Domain• Telecom industry which provides fiber or optical lines to the customers and operates in 13 European countries, Data centers are located in Belgium, Netherland and other locations as well.Responsibilities• Developing tables using API’s as well as without API’s and creating Procedures accordingly• Creating tables for moving data from on premise database via ETL Tool• Fields Validation after moving data to target table like from on premise to GCP also validating data types• Creating and editing DAG like JSON file, .py file and deploying it, in the Cloud Storage, DAG folder, and creatingenvironment variables to trigger DAG• Identifying and Developing fields which were missed during migration i.e., Fields Enhancement• Developing Procedures using DDL, DML commands in dev environment also modifying if there is any• Performing AMB testing by writing SQL and implementing the changes it means basically we doo Field enhancemento Data Comparison and Correctionso Mapping Issueso New Entity Generation• Supported for L1 Technical Screening discussion for GCP Data Engineer Profile.

Project -->> BFSI (Financial Domain)• Payment processing company who is one of the leaders in the US market, whose business is handling all the transaction cyclesResponsibilities• Working on complex ETL jobs which includes extracting data from various sources• Understand mapping documents by collaborating with DBA & design team to apply business rules & transformations• Implementing ELT pipelines using BigQuery as Data Warehouse and Google Cloud Storage as file system• Scheduling pipelines using Airflow bash & python operators• Maintenance and bug fixes in Python wrapper code• Working under aggressive timelines for Jira tickets assigned in Sprint• Analysis of legacy data flows & data objects which need to migrate• Identifying & developing missing components• Deployment & Unit Testing of pipelines by collaborating with QA & DevOps team• Scheduling using cloud composer & Cloud-Functions for event-based automation

• Completed all assigned training and assignments.• Understanding of project business overview/concepts and modules.• Worked in SQL domain on MySQL Workbench tool for ETL purpose and Application Maintenance releasessuccessfully.• Knowledge of implementing business rules to source data using SQL, to perform ETL and load it to data warehousefor payment processing application.• Made enhancements in selenium scripts for automation and process set up & scheduling ETL jobs using Control-Mtool.• Work on performance tuning at database end. Improved performance of more than 100 tables.