Senior ETL Developer Resume Example

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.

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.

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.