Resume

Sign in

ETL Tester

Location:
San Antonio, TX
Salary:
65
Posted:
November 15, 2019

Contact this candidate

Resume:

TAMILVANI THANGAVELU

Email : adasis@r.postjobfree.com

Mobile : 469-***-****

San Antonio, TX, USA.

Professional Summary

6+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing Solutions.

Have extensively worked in developing ETL program for supporting Data Extraction, transformations

and loading using Informatica Power Center.

Knowledge in Full Life Cycle development of Data Warehousing.

Experience with dimensional modeling using star and snowflake schema.

Understand the business rules completely based on High Level document specifications and

implements the data transformation methodologies.

Strong with relational database design concepts and proficiency in SQL and PL/SQL.

Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data

Independently perform complex troubleshooting, root-cause analysis and solution development.

Extensively worked with Informatica performance tuning involving source level, target level and map

level bottlenecks.

Team player, Motivated, able to grasp things quickly with analytical and problem-solving skills,

Excellent interpersonal and communication skills.

Educational information

Bachelor of Engineering in Information Technology - Bharathiyar University, India.

Technical Skills

ETL tools

OLAP tool

Informatica PowerCenter & ESP.

IBM Cognos, Business Objects.

Databases

Oracle & SQL Server.

SQL Language

Scripting Language

SQL & PL/SQL

Shell Script.

SDLC

Waterfall & Agile

Scheduling Tools

AUTOSYS & UNIX CRON.

Agile Tools RTC.

Operating System

WINDOWS & UNIX.

State Street Investment Management Service (IMS) & DataGX (Global Exchange)

(Oct 2018 to May 2019) - Consultant of HCL America Inc.

Roles & Responsibilities:

As an ETL Tester, I am responsible for the following

· Collaborate with Business Stakeholders define and understand the Business requirements

and KPIs.

· Perform the Data profiling on the Source and Target systems.

· Prepare the Test Plan, Test cases documents.

· Perform Manual testing/System Integration testing/Regression Testing/Functional Testing/Performance testing and capture the test results.

· Create Test cases which ensure that the required Business transformations and loading the data as specified in the requirement/mapping documents.

· Prepare the test data and test according to the requirements.

· Execute the test cases, Raise/track the defects and provide the sign-off.

· Collaborate and work with business analysts and data analysts to support their data warehousing and data analysis needs.

· Perform the Business Testing checkouts on the Dev, UAT and Production region.

· Clarify the requirement in the Backlog refinement sessions.

· Actively participate in the Standup, Backlog refinements, Iteration Planning, Demo and Retro

agile sessions.

· Provide the Story Demo to Business Stakeholders and obtain their approval.

· Support the Production Business Testing Checkouts and deployment.

· Review team members test cases and results.

Technical Environment:

Enterprise servicing Platform (ESP), Oracle 11g, Interactive Views (IV), RTC & Squirrel.

Order Management Data Warehouse (Jan 2012- Jun 2014)

Roles & Responsibilities:

As an ETL Developer/ Tester, I am responsible for the following

· Responsible for Business Analysis and Requirements Collection.

· Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

· Parsed high-level design specification to simple ETL coding and mapping standards.

· Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

· Developed mapping documents to outline data flow from sources to targets.

· Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

· Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

· Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

· Created mapplets to use them in different mappings.

· Developed mappings to load into staging tables and then to Dimensions and Facts.

· Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.

· Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

· Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

· Modified existing mappings for enhancements of new business requirements.

· Wrote UNIX shell Scripts to automate the ETL process.

· Involved in Performance tuning at source, target, mappings, sessions, and system levels.

· Prepared migration document to move the mappings from development to testing and then to production repositories.

· Collaborate with Business Stakeholders define and understand the Business requirements

and KPIs.

· Perform the Data profiling on the Source and Target systems.

· Prepare the Test Plan, Test cases documents.

· Perform Manual testing/System Integration testing/Regression Testing/Functional Testing/Performance testing and capture the test results.

Technical Environment:

Informatica PowerCenter 9.6.x, Oracle 11g, OBIEE, Tableau, RTC & UNIX.

Enterprise Data Warehouse (Jun 2004 to Aug 2007)

Roles & Responsibilities:

As an ETL Developer, I was responsible for

· Involved in Business Users Meetings to understand their requirements.

· Translate Business requirements into High level design/Low level Design documents.

· Prepare the ETL Design and Source to Target mapping.

· Designed, Developed Source Extraction, Transformation and Load mapping/Workflow.

· Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.

· Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.

· Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.

· Define the Dependency and automate the ETL process through AUTOSYS.

· Responsible to optimize the ETL/DB objects and fix the ETL, Reporting performance issues.

· Prepare the Test cases and Performed unit testing, integration testing and system testing.

· Responsible to deploy the code in the higher Environment with minimal impact to Business.

· Independently performed the complex troubleshooting, root-cause analysis and fixed many issues.

· Involved in enhancements and maintenance activities of the data warehouse including tuning, enhancement of existing code.

· Created various recon reports for reconcile the data between source to target.

· Maintain the Project Delivery and Issue logs up to date.

· Participated in weekly status meetings and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Technical Environment:

Informatica Power center 8x, Oracle, Cognos, SQL, TOAD, AUTOSYS & UNIX.



Contact this candidate