Sambit Panda Email & Phone Number

Bhubaneswar, Odisha, India

Hyderabad, Telangana, India

1.AWS Glue ETL Data Migration [PySpark, Python, AWS GLUE, S3, Secret Manager] July 2022- April 2023CONTRIBUTION:• Data extraction, transformation, aggregation, consolidation, loading of data into S3 in csv and json format.• Design and developing batch processing/ETL job and integration within GLUE ETL pipeline using PYSPARK.• Unit testing different scenarios and logic and fixing the ETL jobs’ defects in Dev and QA environment.• Experienced in performance tuning and query optimization.• Working in Encryption and decryption using GNUPG and Secret Manager.• Triggering the Millions of API calls from AWS Glue jobs and save the responses in S3 using python.2.AWS Glue ETL Development [PySpark, AWS GLUE, S3, REDSHIFT, Aurora PostgreSQL, CloudWatch] Feb 2022-Jun 2022CONTRIBUTION:• Data extraction, transformation, aggregation, consolidation, loading of data into data warehouse.• Design and developing batch processing/ETL job and integration within GLUE ETL pipeline using PYSPARK.• Unit testing different scenarios and logic and fixing the ETL jobs’ defects in Dev and QA environment.• Experienced in performance tuning and query optimization.• Good understanding of Spark’s RDD, DataFrame, Tables, Transformations.• Experienced in querying Redshift DWH, Spark SQL, Postgres for OLAP.• Good understanding of GITLAB, Data Normalization.

Hyderabad, Telangana, India

1.EMR PySpark ( PySpark, AWS EMR, AWS S3, Snowflake, Athena) 2020 June -Working in enhancement and maintenance.

Hyderabad, Telangana, India

1.Batch Optimization (Control M) [2020 March- 2020 April]CONTRIBUTION:• Checking and identifying the control m jobs end to end for optimization and Implement the job changes.2.Development & Enhancement (Informatica Power Center, Oracle DB, Control M, Unix) 2020 Jan- 2020 Feb• Development, Enhancement, Monitoring (Testing & Deployment) and Maintenance the ETL and Control M job• Developing, scheduling, testing the different types of Jobs, resolving various issues and using various Unix commands in Control M environment3.Mobile Comparison App (Training Project) 2018 Mar -2018 May• A web application to display various mobile phones and their specifications, based on certain criteria.4. Zolo Hotels & Taxi Service (Training Project/Python, RDBMS(MySQL) 2018 Jan -2018 FebAn application developed to book hotels and cabs

Raipur Area, India

Project Name - A International Lubricant Oil Market Analysis of distributing7 Weeks summer Internship at Ernst & Young(EY) from May 2016 to June 2016 at Raipur, Chattisgarh (On Client Location). It is analysis of client market share in that region and how to increase that share in market and provide the sales and marketing related solutions to them.• Collected the different type of issues and difficulties in that region.• Worked out and gave different solutions to increase the sales of oil.

Kolkata Area, India

CCNA in Routing and Swiching(200-120)

Kolkata Area, India

MCSA in Server Administration(70-410,70-411,70-412)

Bachelor Of Technology (B.Tech.), Computer Science & Engineering

Activities and Societies: quizProject - Online Attendance and Library System Using HTML4, CSS, PHP, JavaScript. • An application which has.

Intermediate, Science

Activities and Societies: CHESS CHAMPIONSHIP

Highschool Certificate, Science

Activities and Societies: VEDIC MATHEMATICS Chess Mathematics Arithmetic