Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Personal Information
Timeline
AdministrativeAssistant
Nivethitha Kanagaraj

Nivethitha Kanagaraj

Little Elm,TX

Summary

To take a challenging role and give an efficient and effective solution that would help the organization to achieve the best solution in business which would increase its productivity in the market.

Diligent ETL Testing with robust background in ETL testing and track record of ensuring data integrity across complex systems. Proven ability to identify and resolve data discrepancies while supporting data warehousing projects. Demonstrated expertise in SQL and advanced data validation techniques.

Overview

9
9
years of professional experience
2
2
Certification

Work History

Senior ETL Tester

Yorkshire global solutions
12.2022 - 03.2024
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources
  • Extraction of test data from tables and loading of data into SQL tables
  • optimized the long running queries from 12 hrs to 10 mins.
  • Collaborated and spearheaded the testing among the team of 10 members
  • Extensively used Informatica tool for extraction, transformation and loading process
  • Mapped Requirements to test cases (Traceability) for SIT and UAT
  • Worked in performance tuning queries by creating index and rewriting join conditions.
  • Implemented data testing using python Pandas libraries.
  • Implemented DTF (Data testing framework) -Home grown product which wil run against db /file to compare and validate data.
  • Involved in testing data integration, system integration and business workflow
  • Reported defects in timely manner and logged the same into defect tracking tool
  • Involved in Backend Database testing in Oracle using SQL
  • Followed State Street defined ETL Standards and Best Practices
  • Maintained high-quality documentation of test plans, scripts, and defects to facilitate knowledge sharing among team members.
  • Optimized ETL processes for faster data extraction, transformation, and loading.
  • Validated data accuracy through comprehensive testing of source-to-target mappings and transformations.
  • Improved system performance by analyzing bottlenecks and implementing effective solutions.
  • Enhanced data quality by identifying and resolving ETL-related issues in a timely manner.
  • Collaborated closely with development teams to ensure seamless integration of ETL components, resulting in accurate and efficient data processing.
  • Monitored resolution of bugs, tested fixes, and helped developers tackle ongoing problems by providing QA perspective.
  • Documented testing procedures for developers and future testing use.

Senior ETL Tester

DXC Technologies Limited
06.2019 - 02.2020
  • Working with users & analysts to understand requirements
  • Involved in bug tracking tools like Jira tickets
  • Participated in client meetings to review Integrated Data approaches and to interpret results
  • Closely involved in gathering requirement, design, development and implementation of the project
  • Defined the testing requirement documents
  • Performed database validation according to the business logic by comparing the source to the target in Spreadsheet
  • Work with source system personnel on source data delivery issues
  • Interacted with DBA for setting up test environment

Test Analyst

IBM Technologies Limited
07.2016 - 06.2019
  • Worked in AGILE Methodology
  • Active interaction with Product owner, Scrum master during scrum meeting
  • Understanding and identifying testing scope based on Solution specifications & Requirement documents
  • Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks
  • Developed data quality test scenarios and manually executed ETL test cases
  • Extensively used Informatica tool for extraction, transformation and loading process
  • Performed data quality analysis using advanced SQL skills
  • Designed and kept track of Requirement Traceability Matrix
  • Involved in Integrating, Functional System Testing, for the entire Data Warehousing Application
  • Used ALM for defect tracking
  • Participated in daily standup meetings, project status meetings as well as retrospective meetings and iteration reviews
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted

Software Engineer

IBM Technologies Limited
07.2015 - 07.2016
  • Getting the production copy source files to Lower Environment, and executing the sourcing jobs to load the Data to Database staging tables
  • Performing the data setup in the staging schema to create/validate the reconciliation and data quality checks for the data coming from various sources
  • Performing Reconciliation checks, Data Quality checks, Data comparison and Functional validations
  • Performing System and Integration Testing across Skandia-Insource applications such as Dashboard and Financials wealth management
  • Risk Based testing approach will be followed to perform regression testing
  • Good knowledge on point-based effort estimation
  • Identify the test data for the test case run
  • Involved in extensive DATA validation using SQL queries and backend testing
  • Effort Estimation and Test Plan preparation for incremental projects
  • Coordinating Defect Status calls
  • Coordinating Testing efforts, Tracking and Publishing Daily Status Reports to stakeholders
  • Collecting daily and weekly status reports from Team members and updating the same to the senior management

Education

Bachelor of Engineering -

Anna University

Skills

  • Financial Domain
  • Software Development Life Cycle (SDLC)
  • Data warehouse Testing
  • Software Testing Life Cycle (STLC)
  • Requirement Gathering
  • Project Planning
  • Test Design
  • Test Execution
  • Defect Tracking
  • Test Reporting
  • Data validation
  • Extract Transform Load (ETL)
  • AWS Services
  • S3
  • Lambda
  • EMR
  • Step Function
  • SNS
  • SQS
  • Requirement Analysis
  • Scenario preparation
  • Test data preparation
  • Defect management
  • UNIX scripts
  • Autosys job execution
  • SQL validation
  • Complex SQL queries
  • Database Updates
  • Informatica
  • Analytical skills
  • Logical skills
  • Interpersonal skills
  • Communication skills
  • Organizational skills
  • Functional testing
  • Manual Testing
  • Regression testing
  • User Acceptance testing (UAT)
  • Integration testing
  • Requirements Traceability Matrix
  • Toad for Oracle
  • Oracle SQL Developer
  • Putty for Unix
  • Mainframe Storage
  • Jira
  • HP ALM Quality Center
  • Quality Centre 100
  • Web application
  • AWS Developer certified
  • Python Certified Entry Level Programmer

Accomplishments

  • Collaborated with team of 5 members in the development of DTF test case.
  • Designed and Optimized Queries within 48 hours of me Joining the organization.
  • Created extensive report will all positive /Negative scenarios

Which captures errors, counts , Data integrity validation checks.

  • Automated Manual test cases in DTF and ran the test results on daily basis to generate Report.
  • Resolved product issue through consumer testing.
  • AWS Certified Developer
  • PCEP (Python Certified Entry Level Programmer)

Certification

AWS - Certified Developer Associate

PCEP (Python Certified Entry level Progammer)

Personal Information

  • Date of Birth: 05/26/93
  • Gender: Female
  • Nationality: Indian


Timeline

Senior ETL Tester

Yorkshire global solutions
12.2022 - 03.2024

Senior ETL Tester

DXC Technologies Limited
06.2019 - 02.2020

Test Analyst

IBM Technologies Limited
07.2016 - 06.2019

Software Engineer

IBM Technologies Limited
07.2015 - 07.2016

Bachelor of Engineering -

Anna University

Similar Profiles

CREATE PROFILE
Nivethitha Kanagaraj