LiveCareer
LiveCareer
  • Dashboard
  • Jobs
  • Resumes
  • Cover Letters
  • Resumes
    • Resumes
    • Resume Builder
    • Resume Examples
      • Resume Examples
      • Nursing
      • Education
      • Administrative
      • Medical
      • Human Resources
      • View All
    • Resume Search
    • Resume Templates
      • Resume Templates
      • Nursing
      • Education
      • Medical
      • Human Resources
      • Customer Service
      • View All
    • Resume Services
    • Resume Formats
    • Resume Review
    • How to Write a Resume
    • CV Examples
    • Resume Objectives
  • Cover Letters
    • Cover Letters
    • Cover Letter Builder
    • Cover Letter Examples
      • Cover Letter Examples
      • Education
      • Medical
      • Human Resources
      • Customer Service
      • Business Operations
      • View All
    • Cover Letter Services
    • Cover Letter Templates
    • Cover Letter Formats
    • How to Write a Cover Letter
  • Jobs
    • Mobile App
    • Job Search
    • Job Apply Tool
    • Salary Calculator
    • Business Letters
    • Job Descriptions
  • Questions
  • Resources
  • About
  • Contact
  • 0Notifications
    • Notifications

      0 New
  • jane
    • Settings
    • Help & Support
    • Sign Out
  • Sign In
Member Login
  • LiveCareer
  • Resume Search
  • Senior ETL Developer
Please provide a type of job or location to search!
SEARCH

Senior ETL Developer Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
SENIOR ETL DEVELOPER
Professional Summary

Self-motivated Senior ETL Developer with 12 years of experience in warehouse data management. Collaborates effectively with multi-functional roles to identify and leverage areas for improvement in data systems. Bringing comprehensive understanding of warehouse operations and documentation needs.

Skills

Teradata SQL

DMX

Talend

Mainframe

JCL

COBOL

Salesforce

UNIX Shell scripts

CA7

NDM

Autosys

Work History
Senior ETL Developer, 10/2017 to 01/2021
Tata Consultancy Services – Jacksonville, FL

Citi Retail Services provides data from different source systems based on direct transactions executed by Citi customers which includes different products like debit cards, credit cards, online transactions, traveler's cheques, etc. Retail experts use this data for marketing insights and analysis and for applying customized solutions to grow sales. Also to provide customized solutions to meet specific needs of the industry and customers.

  • Analyzing business user requirements and coordinating with ETL team to transform them into ETL framework.
  • Involved in development of different ETLs using Talend tool to extract data from different sources.
  • Assisted in tweaking the scheduling of auto sys jobs which reduces the load and better utilization of resources.
  • Proactively monitored the system load and job progressand tuned the performance issues to maintain the SLAs.
  • Developed scripts using Java, SOQL and Shell scripting for better execution of jobs.
  • Educating user about the framework and its features
  • Prepared the process flow documents for data loads based on the application
  • Created Custom Talend components for the repeatedly used codes
  • Implemented secure password vault to store the functional id's password
Senior Hadoop Developer, 07/2016 to 09/2017
Tata Consultancy Services – Jacksonville, FL

The main objective is to provide Developments, Enhancements and Maintenance support to the Data Warehouse, 'The W' of Bank of America. The Warehouse is a Mainframe and Hadoop based with Teradata database, which is designed to handle Bank of America's Customer Knowledge & Decision Support activities. The prime aim of the Warehouse is to help the bank in making business Decisions and strategic analysis and help them in sustaining the business competition.

  • Utilized such technologies as Teradata , DMX and Autosys to develop new applications in The W Deposit domain of Bank of America.
  • Understand the requirement of the clients and prepare the design document with the listing of various sources, targets and impacted systems.
  • Identify the process to extract the data from various sources and modify or construct a program for fixes and other enhancements as per the requirement of the client.
  • Organize meetings with various team to successfully receive the data in W.
  • Test the data with all conceivable condition in the SIT and UAT cycles so that errors can be solved out be before the production.
  • Implementation and Maintenance until it is turned over to production support.
Production Support Specialist, 01/2013 to 07/2016
Tata Consultancy Services – Jacksonville, FL

As a production support team of Data Warehouse of Bank of America, has to ensure mainly loading of data from different domains, including Channels, Deposits, Ecommerce, Marketing & Loans as per Service Level Agreements (SLA)

As per business rules, extracted data is loaded to The Warehouse after transformation. Any delay in availability will have impact on bank's business. So meeting SLA for all applications data is a challenge due to bigger size of system. To meet SLA, quick resolution is required if any jobs fails in loading the data. And need to make enhancements and proper planning on the usage of system to accommodate all users of data warehouse. Also have to address if any data issues occur in the loading process

  • System monitoring and solving job failures quickly
  • Ensuring the stability of Bank of America's Teradata production platform.
  • Actions to take ensuring data availability on-time
  • Analyzing requirements and seeking functional clarifications
  • Scheduling jobs using CA7
  • Tracking data issues using incident tracker tool
  • Implementing enhancements using Endevor
  • Review the development code in the change advisory board to make sure that the code is designed as per the standard and guidelines
  • Tune the poorly performing scripts/SQL queries to give better performance result and avoid performance related job failures
  • Resolving incidents, coding, testing and implementing the fix to resolve the incidents.
ETL Developer, 07/2009 to 12/2012
Tata Consultancy Services – Chennai, Tamilnadu

The main objective to provide Developments, Enhancements and Maintenance support to the Data Warehouse, 'The W' of Bank of America. The Warehouse is a Mainframe and Datastage based with Teradata, which is designed to handle Bank of America's Customer Knowledge & Decision Support activities. The prime aim of the Warehouse is to help the banking in making business Decisions and strategic analysis and help them in sustaining the business competition.

  • Understand the requirement of the clients and prepare the design document with the listing of various sources, targets and impacted systems.
  • Identify the process to extract the data from various sources and modify or construct a program for fixes and other enhancements as per requirement of the client.
  • Organize meeting with various team to successfully receive the data to the Warehouse.
  • Test the data with all conceivable conditions in the SIT and UAT cycles so that errors can be solved out before production.
  • Implementations and Maintenance until it is turned over to production support.
Education
High School Diploma: 04/2004
Government Boys Higher Secondary School - Magudanchavadi
Bachelor of Engineering: Electronic And Communications, 04/2008
Alagappa Chettiar College Of Engineering And Tech - Karaikudi
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • Tata Consultancy Services

School Attended

  • Government Boys Higher Secondary School
  • Alagappa Chettiar College Of Engineering And Tech

Job Titles Held:

  • Senior ETL Developer
  • Senior Hadoop Developer
  • Production Support Specialist
  • ETL Developer

Degrees

  • High School Diploma : 04/2004
    Bachelor of Engineering : Electronic And Communications , 04/2008

Create a job alert for [job role title] at [location].

×

Advertisement

Similar Resumes

View All
Senior-ETL-Developer-resume-sample

Senior ETL Developer

Apollo Group

Chandler, Arizona

Senior-ETL-Developer-resume-sample

Senior ETL Developer

Conduent Inc

Parsippany, New Jersey

Senior-ETL-Developer-resume-sample

Senior ETL Developer

Sherwin-Williams

Morrisville, North Carolina

About
  • About Us
  • Privacy Policy
  • Terms of Use
  • Sitemap
Help & Support
  • Work Here
  • Contact Us
  • FAQs
Languages
  • EN
  • UK
  • ES
  • FR
  • IT
  • DE
  • NL
  • PT
  • PL
Customer Service
customerservice@livecareer.com
800-652-8430 Mon- Fri 8am - 8pm CST
Sat 8am - 5pm CST, Sun 10am - 6pm CST
  • Stay in touch with us
Site jabber winner award

© 2021, Bold Limited. All rights reserved.