Dipesh Bansal

Dipesh Bansal Email and Phone Number

Data Engineer | Snowflake | Matillion | Informatica | ETL Developer @ LTIMindtree
Dipesh Bansal's Location
Faridabad, Haryana, India, India
Dipesh Bansal's Contact Details

Dipesh Bansal personal email

n/a
About Dipesh Bansal

12+ Years of ETL development expertise. Worked on multiple tools such as Snowflake | Matillion | Informatica PowerCenter | IICS |Microgen Aptitude | Load Def | Oracle SQL | Teradata | Sql Server | Gitlab | Jira | Excel VBAExposure to multiple Domains such as:Telecom | Insurance | Healthcare | Automobile

Dipesh Bansal's Current Company Details
LTIMindtree

Ltimindtree

View
Data Engineer | Snowflake | Matillion | Informatica | ETL Developer
Dipesh Bansal Work Experience Details
  • Ltimindtree
    Specialist - Data Engineer
    Ltimindtree Mar 2022 - Present
    Noida, Uttar Pradesh, India
  • Birlasoft
    Senior Technical Consultant
    Birlasoft Feb 2020 - Mar 2022
    Noida, Uttar Pradesh, India
    Telecom domainworking on the snowflake migration project. Parallely working on Aptitude Software which is among the fastest growing ETL tools. Also worked on Informatica PowerCenter to fulfill the client needs and provide the end to end ETL solutionUsing Teradata and Oracle as database, Control-m as scheduling tool, Gitlab as repository manager, Jira as agile project management tool.
  • Ventiv Technology
    Senior Software Engineer
    Ventiv Technology Jan 2017 - Feb 2020
    Noida Area, India
    Insurance Domain• Estimated timelines for the changes required and allocated the tasks among the resources using JIRA.• Proactively participated in client calls and identified the business requirements and provided the required support in terms of functional and logical changes in Live Environment• Worked on Load Def & Informatica PowerCenter ETL tool to create and enhance Mappings/Workflows/Schedules• Used SQL to transform and extract the data with inputs taken from Flat Files/Relational Database• Worked on SQL Loader to load data from flat files obtained from various TPA• Debugged and rectified the production load fails in live environment• Worked on Move-It tool to extract the files from SFTP servers, decrypt and place them in local folder
  • Mercer
    Lead Implementation Analyst
    Mercer Dec 2013 - Jan 2017
    Gurgaon, India
    Healthcare Domain• Designs the ETL processes flow, developed mappings/sessions using Informatica power center to load data from Flat File/ Relational Database into the target Flat file/ Relational Database.• Uses Informatica Workflow Manager & Monitor to Create, Schedule and Monitor workflow/sessions. • Creating data jobs in Data Integrator by using SQL query, reading data from source (Oracle), performing transformations via mapping and then writing that data to a Target (EDI-FlatFiles).• Optimization/performance tuning of SQL queries for fast execution. Investigated data quality issues and implemented appropriate solutions (SQL hints, analytical func, views, optimize joins).• Create scheduler using DI Scheduler tool & Monitor the data jobs created in Data Integrator so as to run them in a specific order and schedule time. Also notify in case of process/ schedule failures.
  • Motherson Automotive Technologies & Engineering
    Software Engineer
    Motherson Automotive Technologies & Engineering Dec 2012 - Dec 2013
    Noida Area, India
    Automobile Domain• Designed the ETL processes flow by loading the data from Flat File/ Relational Database, developing mappings/sessions and further storing it into the target Flat file/ Relational Database• Implemented/Supported Vendor Portal in various in-house units• Performed user acceptance testing required to ensure that the build meets the requirements authored including development and execution of test cases• Tested/debugged mapping to assure that data is loaded as per the mapping logic applied, ETL specification and business standard• Created dashboards and daily reports using Excel and VBA Macros

Dipesh Bansal Skills

Informatica Oracle 10g Mysql Unix Windows Microsoft Office Php Web Development Html 5 Javascript Css Html Sql C

Dipesh Bansal Education Details

Frequently Asked Questions about Dipesh Bansal

What company does Dipesh Bansal work for?

Dipesh Bansal works for Ltimindtree

What is Dipesh Bansal's role at the current company?

Dipesh Bansal's current role is Data Engineer | Snowflake | Matillion | Informatica | ETL Developer.

What is Dipesh Bansal's email address?

Dipesh Bansal's email address is di****@****ech.com

What schools did Dipesh Bansal attend?

Dipesh Bansal attended B.s.a.i.t.m, D.a.v. Public School - India.

What are some of Dipesh Bansal's interests?

Dipesh Bansal has interest in Human Rights, Economic Empowerment, Civil Rights And Social Action, Travelling, Education, Science And Technology, Swimming, Food, Living.

What skills is Dipesh Bansal known for?

Dipesh Bansal has skills like Informatica, Oracle 10g, Mysql, Unix, Windows, Microsoft Office, Php, Web Development, Html 5, Javascript, Css, Html.

Not the Dipesh Bansal 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

Aero Online

Your AI prospecting assistant

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.