A

Aman Gambhir

Associate Consultant

Gurugram, Haryana, India12 yrs 11 mos experience
Most Likely To SwitchAI ML Practitioner

Key Highlights

  • Over 12 years of data engineering experience
  • Multiple cloud certifications including Microsoft and Google
  • Conducted over 300 technical interviews
Stackforce AI infers this person is a Data Engineering expert with extensive experience in cloud technologies and data solutions.

Contact

Skills

Core Skills

Data EngineeringDatabasesData PipelinesSql

Other Skills

Agile methodologyAirflowAmazon Web Services (AWS)BMC Control-MBig DataBuild and ReleaseData ScienceDevOpsExtractGitHiveInformaticaInterviewingLeadershipLoad (ETL)

About

I am a data engineering consultant at GlobalLogic with over 12 years of experience designing and developing data pipelines, databases, and business intelligence solutions for various industries. To demonstrate my proficiency and expertise in data and cloud technologies, I have earned multiple credentials, including Microsoft Certified Data Engineer, Google Cloud Certified Associate Engineer, MongoDB Certified Developer, etc. I have taken more than 300+ interviews, including IITs and NITs college drives, referred more than 2000+ candidates, and given career and interview guidance to more than 500+ aspirants. My core competencies include working with Data Engineering, Data Science and Big Data ecosystems, such as Hive, Spark, Spark SQL, Sqoop, and PySpark, and Python, Shell Scripting, PL/SQL, and SQL. I have also used Databricks, Informatica, Snowflake, Tableau, and Airflow to create, manage, and visualize data. Additionally, I have experience with cloud modules of different cloud vendors, such as AWS, Azure, and GCP. I have good domain knowledge of the media, banking, EdTech, E-commerce and finance industries. I am skilled in process optimization, Agile methodology, requirement gathering, and supporting business users with data and BI solutions. My mission is to help clients leverage data and analytics to achieve their goals and improve their performance.

Experience

12 yrs 11 mos
Total Experience
1 yr 10 mos
Average Tenure
3 yrs 5 mos
Current Experience

Globallogic

Consultant

Dec 2022Present · 3 yrs 5 mos · Gurugram, Haryana, India · Hybrid

  • Senior Data Engineer, DB Lead
DatabasesData EngineeringSQLMongoDBMicrosoft SQL ServerPython+5

Gartner

Senior Data Engineer

Mar 2022Nov 2022 · 8 mos · Gurugram, Haryana, India · Remote

  • Senior Data Engineer
SQLAmazon Web Services (AWS)Oracle SQL DeveloperDatabasesData PipelinesData Engineering+3

Tavant

Technical Lead

Sep 2020Mar 2022 · 1 yr 6 mos · Noida, Uttar Pradesh, India · Remote

  • Project: Analytics
  • Client: Leading streaming service platform.
  • Role: Data Engineer
  • Size: 15
  • Tenure: September 2020 to Feb 2022.
  • Description: An American subscription video-on-demand over-the-top streaming service.
  • The team handles the data coming from various sources in the system and do necessary
  • things on data that is required according to business needs.
  • Roles and Responsibilities:
  • Writing snowflake queries for the ETL and the analysis part.
  • Creating data pipeline using Airflow i.e. creating dags to pick data from source and attach
  • snowflake queries which at last inserts the data in respective tables.
  • Using git for code versioning.
  • Provide on-call support in case of any failure
  • Data analysis in case of data duplication, nulls and other possible causes.
  • Co-ordinate with the analytics team for their requirement.
  • Data modelling according to the business needs.
SQLGitSnowflakeDatabasesData PipelinesData Engineering+6

Nagarro

Technology Lead

Jul 2018May 2020 · 1 yr 10 mos · Gurgaon, India · On-site

  • Project : TCTP (Tooling Control and Tracking Platform)
  • Client : Siemens Energy
  • Role : Lead
  • Size : 12
  • Tenure : October 2018 to Februray 2020.
  • Description : The TCTP application supports the ordering and shipment of tools between depots and power stations world-wide. Tools and Kits are contained in a common Tool Catalog database.
  • Other functions support inventory management and tracking, purchasing, billing and administration of data used by all modules.
  • Roles and Responsibilities:
  • Interfaced with stake holders and facilitated communication between client and the development
  • team.
  • Involved in Feasibility and Risk Analysis to identify the business critical and high-risk areas of the
  • application.
  • Involved in Design, Development and Testing Phase.
  • Involved in code review and end to end implementation as well.
  • Monitoring jobs and health of Application as per the client requirement.
  • Automate existing processes thereby eliminating manual intervention and provide the data to
  • business user.
  • Developed Back end objects like stored package, function, procedure, trigger etc. for the client’s
  • application.
  • Worked on query optimization and performance tuning of existing code.
SQLMicrosoft SQL ServerOracle SQL DeveloperDatabasesOraclePL/SQL

Tata consultancy services

3 roles

Information Technology Analyst

Mar 2018Jul 2018 · 4 mos · Gurgaon, India · On-site

  • Project : DB-FSE (Financial Sector Entity)
  • Client : Deutsche Bank
  • Role : Module Lead
  • Size : 10
  • Tenure : March 2018 to July 2018
  • Roles and Responsibilities
  • ● Requirement gathering and Coordination with different teams which includes business as well as TCS Offshore team for on time delivery.
  • ● Status reporting to the Business on daily and weekly basis and driving the status calls to discuss show Stoppers, issues and providing resolutions for them across the applications.
  • ● Developed Backend procedures for the staging data load and SCD1 and SCD2 mappings for the dimension table.
  • ● Perform unit testing and defect closure in given timeline during batch runs to avoid delays in batch.
  • ● Provide technical and functional support to the application.
  • ● Co-ordinate with business users for application maintenance and application tuning.
  • ● Monitoring jobs and health of Application as per the client requirement through BMC Control-M utility. Automate existing processes thereby eliminating manual intervention and provide the data to business user with all the checks and to keep pace with upstream.
  • ● Extending high-end technical support and ensuring high customer satisfaction levels through prompt redress of the problems and documentation and to meet SLA within time.
SQLDevOpsDatabasesBMC Control-MBuild and Releaseunix shell scripting+1

Information Technology Analyst

Oct 2017Jul 2018 · 9 mos · Gurgaon, India · On-site

  • Project : Reference Data Services
  • Client : Deutsche Bank Team
  • Role : Module Lead
  • Size : 18 members
  • Tenure : Dec 2016 - Mar 2018
  • Roles and Responsibilities:
  • Involved in Documentation (BRD and FRD: business requirement documentation and functional
  • requirement documentation) Phase.
  • Interfaced with stake holders and facilitated communication between client and the IT department.
  • Gathered all requirement like list of artifact, changes going for the release and make plan according
  • to them.
  • Raised GCM on Service-Now, made handover document for L2/L3 Team for Project Release.
  • Made Deployment plan, Arranged hand over call, collect UAT sign-off documents,
  • Generate Source Code Change Report for Project Release.
  • Involved in Feasibility and Risk Analysis to identify the business critical and high-risk areas of the
  • application.
  • Successfully Delivered many live project release.
  • Worked as a liaison between business users and developers to submit requirements and changes,
  • clarify questions and issues.
  • Experienced for organizing and documenting requirements, preparing use cases, writing business
  • documents and reports in Pre- Testing phase.
  • Worked on a team environment to finalize use cases to develop functional and detail design
  • specifications of the application.
  • Involved in Design, Development Phase and Testing Phase.
  • Involved in code review and end to end implementation as well.

Systems Engineer

Dec 2015Sep 2017 · 1 yr 9 mos · Gurgaon, India · On-site

  • Project : Reference Data Services
  • Client : Deutsche Bank Team
  • Role : Team Member(Developer)
  • Size : 15 members
  • Tenure : March 2016 - Sept 2017
  • Roles and Responsibilities:
  • Developed many Oracle objects like Procedure, Function, Package, Trigger, Materialized view, Index.
  • Created many shell script in UNIX to handle the entire file handling related tasks.
  • Involved in Feasibility and Risk Analysis to identify the business critical and high-risk areas of the application.
  • Worked as a liaison between business users and developers to submit requirements and
  • Changes, clarify questions and issues.
  • Experienced in query optimization and performance tuning.
  • Provided Extensive support on UAT Environment to client and consumers.
  • Experienced for organizing and documenting requirements, preparing use cases, writing business
  • documents and reports in Pre- Testing phase.
  • Worked on a team environment to finalize use cases to develop functional and detail design
  • specifications of the application.
  • Developed a user acceptance test plan and test case scenarios to guide a select group of key end-
  • users in testing the user interface and functionality of the application.
  • Performed requirement walk through with the Dev. and QA teams with the aim to develop testing
  • strategies and test plans such that test cases reflect user needs.
  • Involved in code review and end to end implementation as well.

In-solutions global pvt. ltd.

Software Engineer

Jul 2013Nov 2015 · 2 yrs 4 mos · Mumbai Area, India · On-site

  • Projects: Debit Card Reconciliation System (DCRS) / Cash in ATM (CIA) / Prepaid(Loyalty) Card
  • Management System.
  • Client: Punjab National Bank, Bank of India, IDBI, United Bank of India, Oriental Bank of India,
  • Dena Bank, Federal Bank
  • Role: Team Member (Developer, Client Support)
  • Size: 20 members
  • Tenure: July 2013 – November 2015
  • Roles and Responsibilities:
  • Gathering and analyzing the requirements of different banks to make the system as generalized system so that it can work for any Bank.
  • Worked with client and functional team to finalize their requirement for develop and change in application.
  • Development of File Processing module, GL Recon Report Generation module, TTUM Generating Module using PL/SQL Stored procedures.
  • Worked as a liaison between operation team and Project manager to submit requirements and changes, clarify questions and issues.
  • Deployed the application at client side.
  • After deployment analyzing the performance issues and made necessary changes to improve the performance.
  • Performed requirement walk through with the Development and QA teams with the aim to develop testing strategies and test plans such that test cases reflect user needs.
  • Involved in code review and end to end implementation as well.
  • Creation of Tables, Views, Constraints, Indexes and Packages.
  • Developed Complex database objects like Stored Procedures, Functions, and Triggers using SQL and PL/SQL.
  • Developed a user acceptance test plan and test case scenarios to guide a select group of key end- users in testing the user interface and functionality of the application.
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  • Involved in the meeting with Client to understand their future requirement and scope.
  • Migration of old interfaces from Java to Oracle.
  • Involved in Analysis, Design, Development Phase and Testing Phase.
SQLDatabasesPL/SQL

Nucleus software exports limited

Software Engineer Trainee (Intern, Contractual)

Dec 2011Aug 2012 · 8 mos · Noida Area, India

  • Project: Learn@Will
  • Client: Nucleus Software
  • Role: Team Member
  • Size: 06 members
  • Tenure: Feb 2012 – June 2012
  • Roles and Responsibilities:
  • Written the backend JavaScript code for tooltip.
  • Generated the xml in backend for required data.
  • Developed a user acceptance test plan and test case scenarios to guide a select group of key end-users in testing the user interface and functionality of the application.
  • Involved in code review and end to end implementation as well
SQLDatabases

Education

Rajiv Gandhi Prodyogiki Vishwavidyalaya

Bachelor of Engineering - BE — Computer Science

IPS College of Technology & Management, Shivpuri Link Road, Gwalior

Bachelor of Engineering (B.E.) — Computer Science

Jan 2007Jan 2011

Stackforce found 100+ more professionals with Data Engineering & Databases

Explore similar profiles based on matching skills and experience