We provide IT Staff Augmentation Services!

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

Hire Now