Senior ETL Developer Resume

SUMMARY:

Over 7 years of data warehousing experience
2 years of work experience interacting directly with the clients at Charlotte, NC, USA
Experience and Expertise on Teradata / Mainframes / Informatica with proven knowledge of the SDLC concepts(requirement gathering, design, coding, testing - unit, systems integration and acceptance, deployment & maintenance)
1+ year of experience as Hadoop ETL developer in the Proof of Concept and the conversion projects at Bank of America. Wide exposure to various tools on Hadoop Ecosystem like Hive, Sqoop, HDFS, Map Reduce, Oozie
2+ years of experience in grooming and leading teams as offshore tech lead
Competent in data warehouse project planning, maintenance, development, and enhancements project activities
Experience in performance tuning - Capacity savings and handling production tickets from a development team application support standpoint
Participated in software and hardware recoveries for the application supported
Lead and coordinated the efforts on the design and coordination aspects of application level disaster recovery
A team player with good problem solving, communication skills and possess strong inter personnel and negotiation skills
Completed Teradata SQL certification
Completed Domain Level certifications in Basic Banking and US Banking

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Senior ETL Developer

Confidential

Responsibilities:

Design and Development of Hadoop ETL model on the warehouse
Analysing business requirement and mapping rules of existing system.
Documentation of High Level Design / Low Level Design and ETL Designs
Coding / Review / Testing / Validation of Data
Writing map reduce algorithms to achieve the mappings . Build and Performance Tuning of Hive Queries
Comparison testing between the Legacy ETL and the Hadoop ETL process and production deployment

Senior Technical Developer

Confidential

Responsibilities:

ETL Lead

Confidential

Responsibilities:

ETL Design, Development, Coding, Testing, Production Deployment.
Organizing / Hosting team meetings to gather and finalize business requirement
Project estimation and planning. Establish project tasks and timelines and effectively manage them
Identify new project opportunities and providing solutions for the same
Managing a 3 member onshore team and a 11 member offshore development team
Daily customer interaction and project status reports

Technical Developer

Confidential

Responsibilities:

Re Modeling of the BDW Model (Along with BDW Modelers) to accommodate and to support the type of data in the Bank’s Legacy Enterprise Data Warehouse
Specialized code developed to do pre-processing of data before being set across to Data Stage (ETL Tool)
Documentation of Mappings / Business logic and hosting meetings with business partners to gather requirements
Implementation of dynamic CDC (change Data Capture) extraction model to convert the legacy customer data into BDW customer Suite of tables
Coordinating and Managing deliverables from a 4 member offshore team

Technical Developer

Confidential

Responsibilities:

Detailed Impact analysis on all applications on the warehouse
Development of the new interface to support the conversion data storage in the existing data model through ETL
Loading and Validation of of almost all deposits applications
Coordination of integrated testing of about 25 different applications for all these conversions with the upstream and downstream
Training the new joiners and educating them on the applications / setups to help them continue with the coding and data validations