Arshad Shaikh Email & Phone Number

Pune, Maharashtra, India

Pune, Maharashtra, India

• 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

Pune, Maharashtra, India

• 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

Pune, Maharashtra, India

• 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.