Mayur Dubey

Mayur Dubey Email and Phone Number

Manager Data Engineering @ Data Axle USA
Irving, TX, US
Mayur Dubey's Location
Pune, Maharashtra, India, India
Mayur Dubey's Contact Details

Mayur Dubey personal email

n/a
About Mayur Dubey

Cloud Data Engineer and ETL Solution Consultant with more than 12 years of experience. Latest Project Experience:1. Migration from On-prem Solution (Talend+Oracle+Unix) to AWS Cloud Solution.2. Data Ingestion Framework using Pyspark programming with features to Format+Convert+Validate+Reject+Lookup data from variety of sources (Multiple File formats like Delimited, Fixed Width, JSON, Parquet, etc and databases like Oracle, Redshift, etc).3. Pyspark Script Execution using AWS Glue.4. Performance and Cost Optimization using AWS Services like Glue, Athena, Redshift and S3.5. Migration of Oracle SQL/PLSQL to Redshift SQL/PLSQL.6. Airflow Orchestration – Developed Custom Airflow Opearators and Reusable shared functions.

Mayur Dubey's Current Company Details
Data Axle USA

Data Axle Usa

View
Manager Data Engineering
Irving, TX, US
Mayur Dubey Work Experience Details
  • Data Axle Usa
    Manager Data Engineering
    Data Axle Usa
    Irving, Tx, Us
  • Data Axle India
    Lead Database Developer
    Data Axle India Nov 2021 - Present
    Pune, Maharashtra, India
  • Datametica Solutions Private Limited
    Technical Lead
    Datametica Solutions Private Limited Jan 2021 - Oct 2021
    Pune, Maharashtra, India
    1. ADF Pipeline Development experience using activities Lookup, Switch, If Else, Copy, Delete, SFTP, Execute Pipeline, Web (Email Alerts using Logic Apps), ADLS Gen2 in my current project.2. Azure SQL Database - Stored Procedure Development using SSMS and Performance Tuning using Estimation Execution Plan and Live Query Stats.3. ADF and Azure SQL DB Deployment basic understanding using Azure Devops pipelines.4. Basic Knowledge of Creating and managing resources(ADF, Azure SQL DB, Logic Apps, ADLS Gen2) in Azure Portal.
  • Tieto
    Edw Configuration Owner
    Tieto Oct 2018 - Jan 2021
    Pune Area, India
    1. Responsible for planning, managing & coordinating all activities in Client’s EDW Environment.Planning & Assigning tasks to L3 and L2 AMS teams.2. Analysed ETL loads and designed performance improvement in Datastage jobs by introducing delta methods, delete capturing instead of full loads, SQL hints in Oracle DML; thereby reducing the load times by more than 50%.3. Achieved up to 50% performance improvement by replacing traditional Datastage ETL Design with ELT design wherever possible.4. Involved in UAT and stakeholder management with business owners, report owners, product owners.
  • Teradata
    Etl Technical Consultant
    Teradata May 2014 - Sep 2018
    Mumbai
    My responsibilities include:1) Developing new jobs in IBM Infosphere DataStage 11.3 to Extract, Transform and Load data from one system to another as per business requirement using IBM Infosphere Datastage, Unix Shell Scripting and SQL.2) Preparing SQL Scripts to perform end to end ETL logic using BTEQ. Debugging, analyzing and modifying Tpump/Multiload Scripts in Teradata.3) Working with Linux Server for DataStage.4) Using ESP Mainframe Scheduler.5) Using SQL to interact with Oracle, MS SQL Server and DB2 Databases.
  • Tata Consultancy Services
    Datastage Developer
    Tata Consultancy Services Mar 2012 - Apr 2014
    Mumbai Area, India
    Responsible for developing ETL Applications using Datastage 8.5, Unix and Oracle 10g RDBMS. Worked on creating End to End ETL Applications using Flat files, Oracle RDBMS and Unix Shell scripting.
  • Zolute Internet Solutions Pvt Ltd
    Senior Sales & Marketing Executive
    Zolute Internet Solutions Pvt Ltd Sep 2011 - Mar 2012
    Indore Area, India

Mayur Dubey Skills

Sql Oracle Databases Db2 Teradata Datastage Mainframe Business Intelligence Requirements Analysis Pl/sql C

Mayur Dubey Education Details

  • Acropolis Institute Of Tech & Research
    Acropolis Institute Of Tech & Research
    Computer Science And Engineering
  • Shri Gujrati Samaj Amnem School
    Shri Gujrati Samaj Amnem School
    Ssc

Frequently Asked Questions about Mayur Dubey

What company does Mayur Dubey work for?

Mayur Dubey works for Data Axle Usa

What is Mayur Dubey's role at the current company?

Mayur Dubey's current role is Manager Data Engineering.

What is Mayur Dubey's email address?

Mayur Dubey's email address is ma****@****ata.com

What schools did Mayur Dubey attend?

Mayur Dubey attended Acropolis Institute Of Tech & Research, Shri Gujrati Samaj Amnem School.

What are some of Mayur Dubey's interests?

Mayur Dubey has interest in Social Advice, Deals, Technology, Economics, Health And Wellness, Business, Stock Market, Group And Other, Education, Small Businesses.

What skills is Mayur Dubey known for?

Mayur Dubey has skills like Sql, Oracle, Databases, Db2, Teradata, Datastage, Mainframe, Business Intelligence, Requirements Analysis, Pl/sql, C.

Not the Mayur Dubey you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.