Senior Data Engineer at Teradata
10 Years of Experience
Mumbai, Maharashtra, India
-
-
Not Available
Experience Summary • Total experience of 10 yrs in IT industry which includes Functional and Technical experience in Data Warehousing, Business Intelligence (BI), ETL tools, product development and Reports Generation. • ETL process design and implementation (enhancements). • ETL process automation (Cascade UNIX scripts, DDL scripts). • UAT support. • Analyzing end to end ETL failures in production. • Monitoring tickets, raising and analyzing change orders, Incidents and requests. Skill summary • Excellent knowledge of ETL process. • Effective communication skills, good analytical abilities, and keen interest in learning new tools. • Ability to work independently as well as in a team and the aptitude to solve issues analytically and creatively. • Basic knowledge of UNIX. • Dedicated and highly ambitious to achieve personal goals as well as the organizational goals. • Ability to simultaneously focus on quality, efficiency, and excellence.
Teradata, SaaS/Cloud Product, Information Technology & Services
Teradata
Teradata
Teradata, Teradata, Teradata, Teradata, Infosys, Infosys, Infosys
Job Title : Senior Data Engineer
Company name : Teradata
Period : December 2018 - Present
Summary : AIR CANADA / Air Canada Airlines
Worked in a Dev-Ops environment.
Actively participated in requirement gathering and creating the mapping documents.
Performed performance tuning and development of ETL jobs.
Involved in unit testing, SIT testing of ETL jobs.
Interacted with client and business user to gather the change requirement information and suggested the best possible approach.
Involved in performance tuning of SQL queries and stored procedures.
Worked on FASTLOAD, BTEQ, FASTEXPORT and MLOAD scripts on Teradata ETL platform.
Worked on Unix shell script for monitoring existing Teradata ETL scripts loads.
Provided KT and trained new members joining the project.
Analyzing end to end failures in production and providing quick response to meet SLA.
Location : Mumbai Area, India
Job Title : Senior Technical Associate
Company name : Teradata
Period : July 2018 - March 2019
Summary : POC – Informatica Code Review
Knowledge in development using Python 3.x.
Developed code review process for ETL tool like Informatica using Python 3.x.
Developed different test cases to test the created script.
Strong hands on experience in getting excel, csv, etc. to table format using DataFrames in Python.
Strong hands on experience with Python Sqlite database by reading data from and
writing data back to Dataframe.
Location : Mumbai Area, India
Job Title : Senior Technical Associate
Company name : Teradata
Period : February 2017 - June 2018
Summary : ELECTRONIC ARTS / EA SPORTS (FEB'17 - TILL PRESENT)
Analyzing End to End ETL failures in production and providing quick resolutions to meet SLA.
Worked with heterogeneous source to Extracted data from Relational database, XML, zip files and flat files and loaded to a DataWarehouse.
Developed complex mapping with multiple transformations like router, lookup, aggregator, expression, filter, sequence generator, update strategy, etc.
Worked with shortcuts, mapplets, parameter, variables, etc.
Developed SCD1, SCD2 type mappings to maintain the history data.
Modified several of the existing mappings based requirements.
Developed Informatica Sessions and workflows.
Created different tasks like session task, event wait, command tsk, decision task in a workflow.
Created unix scripts to check for source files and create file lists and then execute these scripts using command task in Informatica workflow.
Implemented Pushdown optimization and partitioning for sessions.
Migrated mappings, sessions and workflows to higher environments.
Involved in Unit, Integration, System, and Performance testing of sessions in DEV, BETA environment.
Prepare testing document and migration documents.
Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump,) Teradata parallel support and Unix Shell scripting.
Create load scripts using Teradata utilities to automate manual processes.
Automation of manual processes by using UNIX scripts.
Location : Mumbai Area, India
Job Title : Associate Technical Consultant
Company name : Teradata
Period : May 2016 - December 2016
Summary : EXPEDIA TRAVEL / EXPEDIA
Job scheduling (manually or using internally developed CMFast application) as well as modifying/deleting them using CONTROL-M/Enterprise Manager ver.6.4
Control-M Jobs monitoring, job flow analysis and troubleshooting.
Hadoop stack Operational and adhoc requests processing.
Location : Pune Area, India
Job Title : System Engineer
Company name : Infosys
Period : July 2015 - March 2016
Summary : ASTRAZENECA - APPLICATION SUPPORT, MAINTENANCE & ENHANCEMENTS (JAN'13 - MAR'16)
Working on ETL Tool (Informatica) and Reporting tool(Business Objects Infoview).
Requirement analysis.
Estimations and planning.
Code changes to the existing system by analyzing the impact.
Performance tuning.
Analysis of High Level Technical Design documents and preparation of Detail Design document and runbooks of individual applications.
Analysis of code, DML change or any artifact change and effect on the downstream due to that.
Tagging the latest code in Development and then migration to production environment.
Break fixes on production environment.
Monitoring Service Now tickets, raising and analyzing change orders, Incidents and requests.
Review the code, perform Unit Testing.
Maintain actual efforts tracker, daily status tracker, query log and issue log.
Respond to the production issues, arrive at a solution and implement the solution in order to enable the application availability as per agreed Service Levels.
Coordination and communication with the Clients.
ETL Code Analysis to identify potential code inconsistencies.
Data Analysis.
Location : Pune Area, India
Job Title : Senior Operations Executive
Company name : Infosys
Period : March 2015 - July 2015
Job Title : Operations Executive
Company name : Infosys
Period : October 2012 - March 2015
Title : Vantage Training - Essentials Level 2021
Period : May 2021 - Present
Summary : credly.com, https://www.credly.com/badges/daf66468-155f-449c-afb7-17637b5751b1?source=linked_in_profile
Issuing Authority : Teradata
Title : Python Essential Training
Period : February 2021 - Present
Summary : linkedin.com, https://www.linkedin.com/learning/certificates/42f8bb9ae4318888bbbae7d3158d894567190ad36a4761f24dfea94099731b04?trk=backfilled_certificate
Issuing Authority : LinkedIn
Title : Consulting Skills - Essentials Level
Period : January 2021 - Present
Summary : youracclaim.com, https://www.youracclaim.com/badges/d353fa0c-da93-4c22-ac1e-d71453f48096?source=linked_in_profile
Issuing Authority : Teradata
Title : Learning Python
Period : January 2021 - Present
Summary : linkedin.com, https://www.linkedin.com/learning/certificates/ff81b5adb6046223c91e4ef8b3f7f9f1deb7e17febf16ad4c696f3bc5158594b?trk=backfilled_certificate
Issuing Authority : LinkedIn
Title : Vantage Training - Essentials Level
Period : January 2021 - Present
Summary : youracclaim.com, https://www.youracclaim.com/badges/be7b86ec-83e1-47e5-a65d-0bf906d603cb?source=linked_in_profile
Issuing Authority : Teradata
Title : Vantage Training - Essentials Level
Period : January 2021 - Present
Summary : credly.com, https://www.credly.com/badges/be7b86ec-83e1-47e5-a65d-0bf906d603cb?source=linked_in_profile
Issuing Authority : Teradata
Title : Teradata - Intro to Vantage
Period : April 2019 - Present
Summary : youracclaim.com, https://www.youracclaim.com/badges/162e0f89-d89d-4ee6-b180-682bd736b687?source=linked_in_profile
Issuing Authority : Teradata
Title : Complete Python Bootcamp: Go from zero to hero in Python 3
Period : August 2018 - Present
Issuing Authority : Udemy
Title : Data Science A-Z: Real-Life Data Science Exercises Included
Period : August 2018 - Present
Issuing Authority : Udemy
Title : 6 Month Certificate Programme in Big Data Analytics
Period : July 2018 - Present
Issuing Authority : UpX Academy
Title : SAS Programming from Scratch & Practice Case Studies workout
Period : July 2018 - Present
Issuing Authority : Udemy
Title : Teradata 14 SQL Exam Completion
Period : September 2017 - Present
Summary : youracclaim.com, https://www.youracclaim.com/badges/a9b7cd55-4598-49e9-928d-de347b13f467/linked_in_profile
Issuing Authority : Teradata
Title : Teradata 14 Certified Professional
Period : June 2016 - Present
Summary : certmetrics.com, https://www.certmetrics.com/teradata/public/verification.aspx?code=XPBNDBV1BJ44YZNC
Issuing Authority : Teradata
English , Hindi , Marathi
Award : Employee Of The Quarter Q2-2021
Issuer : Teradata
Date : 8 2021
Summary : For high performance using a mix of qualitative criteria like - Project Execution/Contribution, Practice Development, Knowledge Management and self-Professional development.
Award : Project Team Annual Award
Issuer : Teradata
Date : 4 2021
Summary : For outstanding achievement and contribution to "Air Canada - MS" for the year 2020.
Award : SPOT Award
Issuer : Teradata
Date : 4 2021
Summary : For significant contribution and dedication on the assignment on the Air Canada Engagement.
Award : Service Recognition Award
Issuer : Teradata
Date : 4 2021
Summary : On reaching significant career milestone of 5 years.
Show More