ETL Analyst Resume

SUMMARY:

5+ years of overall experience in complete Software Development Life cycle ( SDLC ) including Estimations, Gathering requirement, Analysis, Design, Development, Unit Testing, System Testing and implementation of Data warehousing projects.
In - depth knowledge and understanding of concepts of Data warehouse, Business Intelligence, OLTP, OLAP and Data Modelling (Physical/Logical/ER-Diagrams) etc.
.Worked as a Teradata Developer and involved mainly in building Teradata warehouse.
Strong Hands on Teradata utilities such as MLOAD, FLOAD, TPUMP and FAST EXPORT .
Experienced in query/scripting languages such as SQL, PL/SQL and UNIX Shell scripting.
Experienced in tools like SQL*Plus, Teradata SQL Assistant .
Expertise in Problem solving and Tracking Bugs during the production failure.
Experience in integration of various data sources from Databases like Teradata, Oracle, SQL Server, and text files.
Have hands on experience on requirement analysis and Health care/Retail testing. Proficiency in bug tracing, fixing, multi-task and achieve objectives within time and budget constraints.
Expert in Scheduling tool WLM (work Load manager)
Excellent knowledge and experience in documents like BSD,TSD & Mapping documents .
Extensively involved in identifying performance bottlenecks in targets, sources and transformations and successfully tuned them for maximum performance using best practices.
Experience in documenting Design specs, Unit test plan and deployment plan.
Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.
Regularly evaluate processes and make recommendations to improve efficiency.
Attend and participate in meetings that pertain to assigned responsibilities.
Provide support outside normal business hours as required.
Involves frequent dialogue with Technical Program Directors, Technical Architects, Release team and Project Managers.

TECHNICAL SKILLS:

Database: Teradata, Oracle & SQL Server

Operating Systems: Unix and Microsoft

Tools: Teradata, SQL, BTEQ, Mload, Fast export, Multiload, Shell script, Putty,File Zilla,ALM,Clear case, Build forge, control-M, Work Load Manager,CA7 & Autosys

PROFESSIONAL EXPERIENCE:

Confidential

ETL Analyst

Tools: used - Teradata-SQL, BTEQ,,Multiload, Fastload,Unix-Shell scripts, Clearcase,and Main Frame

Roles & Responsibilities

Involved in the Design of the project and create a technical Specification document.
Develop Multiload load scripts to load data from host file in to Landing Zone table.
Involved in writing the ETL specifications and unit test plans for the mappings.
Create BTEQ scripts to load the data from staging table in to target table.
Apply the business transformation using BTEQ scripts.
Involved in writing the ETL specifications and unit test plans for the mappings
Provided required support in Multiple (SIT, UAT & PROD) stages of the project.
Promote the code in to higher environment using Build forge & Clear case.
Support Testing & Business acceptance team for the testing.

Confidential

ETL Anallyst

Tools: used - Teradata - SQL, BTEQ, Fast load, Unix & Build Forge & CA7

Roles & Responsibilities

Involved in writing the ETL specifications and unit test plans for the mappings.
Design and development of ETL process extracting Member, pharmacy and provider from IDW and send files to Inovalon for generating analytic report.
Extensively make use of Bteq Scripting, Utilities such as Fast Export, Multi Load and Fast Load
Performance Tuning of Queries to handle large volume of data.
Automated the jobs thru scheduling using Main Frames scheduler i.e CA7, which runs every day by maintaining the data validations.
Effectively worked with supporting groups data architect, DBA, Infa Admin, Testing team, Scheduling team and production control team
Have developed a level of competency, which helps to anticipate issues and solve them in advance.

Confidential

Project Manager

Tools: used - Billing System, ALM (Application Life Cycle Management), Microsoft Excel and Microsoft word.

Roles & Responsibilities

Played Active part in preparation of Project Plan and Test Plan.
Prepared the test cases based on the development system design specification and the Solution Requirement Specification document.
Test execution performed for all the features.
Test Execution of all the Acceptance Manual test cases.
Documenting and tracking all the defects found in the daily incident report.
Effective coordination between development team and testing team.
Involved in Build and Deployment verification

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship