Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic
Tejaswini C

Tejaswini C

Bangalore

Summary

Detail-oriented ETL tester with 10+ years of experience in Analysis, Quality Assurance, Testing of Data Warehousing & Data Integration Solutions.

Well versed in Hadoop ecosystem - Cloudera, Hive, Oozie and Sqoop

Hands-on experience on UNIX, Create & execute complex SQL queries to perform data completeness, correctness, data transformation

and excellent communication skills and data quality testing for source to target mapping within the data warehouse.

Strong leadership skills that inspire team confidence and respect while motivating team members in a creative and effective manner.

Easily collaborate with stakeholders, developers and Project managers to accomplish milestones.

Good interpersonal skills, commitment, result oriented, diligent with a quest and zeal to learn new technologies

Overview

12
12
years of professional experience

Work History

Associate Consultant

Tata Consultancy Services
Bangalore
11.2021 - Current
  • Evaluated diverse organizational systems to identify workflow, communication, and resource utilization issues.
  • Compiled research data and gave professional presentations highlighting finds and recommended optimizations.
  • Liaised with Customers, Project Managers, Business Analysts and SME's to better understand customer needs and recommend appropriate defect prevention processes.
  • Delivered outstanding service to clients to maintain and extend relationship for future business opportunities.
  • Reviewed and Analyzed Business Requirement documents, Technical Specifications to ensure they are precise and accurate to test and implement test plans and test cases.
  • Estimated testing effort required and revised estimates when there is change in effort.
  • Conduct and participate in technical reviews/walk throughs for QA deliverables viz Test plan, Test strategy, Test cases.
  • Performed functional, application, integration, system and regression tests.
  • Performed end-to-end tests from Input/Output files/database to summary reports.
  • Analyzed test results, identified issues and reported to developers and Scrum master using Rally.
  • Demonstrated sufficient oral and written communication skills for effective dialogue with colleagues on project team and superiors.

Senior Test Engineer

Sling Media - Dish
Bangalore
10.2019 - 10.2021
  • Extensively used SQL queries for data validation and backend testing
  • Validated data files from source and made sure correct data has been captured on target tables.
  • Prepared test cases based on ETL Specification document, Use Cases, Low Level Design Documents.
  • Extensively worked on ETL testing including Data Completeness, Data Transformation & Quality for various feeds coming from source.
  • Validated data across different Databases using automation scripts developed using Python.
  • Involved in end-to-end defect management of assigned projects by identifying defects, assessing root cause and prepared detailed information report for developer and business stakeholders.

Senior Software Engineer

Accenture
Bangalore
07.2012 - 10.2019

Senior Software Engineer (Oct '17 - Oct '19)
Accenture - Nordea

  • Experienced in validating source data with target data and involved in developing Test Cases, Test Plans, Test Execution, Defect Tracking, and Report Generation using JIRA based on functional specifications.
  • Involved in end-to-end defect management of assigned projects. Identified defects, assessed root cause, and prepared detailed information for developers and business stakeholders.
  • Experience in validating and analyzing Hadoop log files, extensively used HQL queries to analyze the HDFS data, expertise in Data Validation to check data integrity.
  • Experience in UNIX, RDBMS, Hadoop, HIVE (HQL), Oracle (PL/SQL), MS Access.
  • Experience with different file systems /databases like Oracle, HDFS Teradata, and MS SQL Server to extract and load data using Sqoop.
  • Worked with project managers, developers, quality assurance and customers to resolve technical issues.
  • Checked client code for bugs and weaknesses using approved troubleshooting methods.
  • Trained and mentored junior developers and engineers, teaching skills in Testing methodologies and working to improve overall team performance.

Senior Software Engineer (May '15 - Oct '17)
Accenture - My Wizard BI Central (Bangalore)

  • Developed Test cases, Test scripts from data mapping documents, functional Specification documents and mapped test cases with requirements for generating Requirement Traceability Matrix (RTM).
  • Tested Raw Data by implementing BI Algorithms like Box Plot and Test of Hypothesis.
  • Performed Product Testing on Power view and Tableau dashboards. Worked on MS SQL Server and have a good command over database components.
  • Worked pretty closely with Dev Teams, BA's & FA's, by scheduling calls to understand functionalities better.
  • Mentoring new team members, prepared multiple understanding documents to make better understanding of application.
  • Basic knowledge on designing SSIS packages using components like Execute SQL Task, Data Flow Task components, Containers, Analysis Processing Task and some other Control flow Tasks.

Software Engineer (July '12 - May '15)
Accenture - Vimplecom Flexshore ISP

  • Analyzed Business Requirements and Rules, worked with Business Analysts and Business Users in preparing Test Plans.
  • Developed Test cases, Test scripts from data mapping documents, functional Specification documents and mapped test cases with requirements for generating Requirement Traceability Matrix (RTM).
  • Extensively used Info Sphere Data Stage and Quality Stage Director client to run workflows.
  • Monitored session logs/log files in IBM Info sphere Monitor.
  • Tested ETL Data stage mappings and other data stage Processes (DW Testing).
  • Analyzed and tested Data stage Mappings with OLTP source data, staging and target data.
  • Worked with Developers on Defects until test case is passed.
  • Extensively written SQL to confirm on data transfer from source to target.

Education

Bachelor of Engineering - Computer Science

Bhoj Reddy College of Engineering
India, Hyderabad

Intermediate - MPC

Narayana Junior College, Board of Intermediate Education, State Board
Anantapur, India

SSC - Schooling

Springdale High School
Anantapur

Skills

  • ETL Process
  • Test Planning, Review & Execution
  • Data Warehouse Testing
  • Hadoop Components
  • Oracle,Teradata, SQL Server
  • Redshift - AWS, GCP
  • Unix
  • Basics of python

Languages

  • English
  • Telugu

Timeline

Associate Consultant

Tata Consultancy Services
11.2021 - Current

Senior Test Engineer

Sling Media - Dish
10.2019 - 10.2021

Senior Software Engineer

Accenture
07.2012 - 10.2019

Bachelor of Engineering - Computer Science

Bhoj Reddy College of Engineering

Intermediate - MPC

Narayana Junior College, Board of Intermediate Education, State Board

SSC - Schooling

Springdale High School
Tejaswini C