Data Engineering Test Automation

Puja Saha

Software Development Engineer in Test

Address **** ******** ******, *******, ** 804-***-**** *******@*****.***

SUMMARY

Highly skilled and results-driven Data QA Engineer with over 8 years of combined experience in software testing and data engineering. Expertise spans both robust test automation using Selenium WebDriver, TestNG, Java, and BDD frameworks, and building scalable data solutions on AWS. Proficient in performing comprehensive data quality analysis, validating data pipelines, and leveraging cloud-native tools like AWS Glue, and Redshift. Proven ability to lead cross-functional teams, design comprehensive test strategies, and optimize testing and data processes for efficiency and reliability. Adept at ensuring code modularity, data-driven capabilities, and driving end-to-end data engineering projects. Adept at implementing ETL/ELT processes, managing distributed systems, and driving end-to-end data engineering projects. Strong collaborative skills and a passion for solving complex data challenges.

WORK EXPERIENCE

Elevance Health Atlanta, GA

Software Engineer in Test Aug 2023 to Dec 2024

Developed Test Plan, Test Cases, and Test Scripts.

Analyzed Business Requirements (BR) and Application design documents and created a Traceability Matrix interlinking the test requirements and test cases.

Worked on Claims adjudication and processing applications on the payor side.

Used BDD Cucumber by creating the Features and Step Definition files to execute test scripts.

Generated High-level Test Plans, various workflows, and Manual Scripts.

Extensively involved in all phases of Manual, Automation, White Box, Black Box, and Gray Box Testing including Functional, System, Integration, Regression, Load, and Performance Testing.

Extensively used Quality Center and JIRA for Test planning, Bug Tracking, Defect reporting, and Analysis of Test results.

Expert in working with hybrid framework incorporating BDD with Cucumber, Data driven,TestNG, Maven and Page Object Model.

Tested the application for specific Performance and End User Testing on its compatibility with various web browsers like Firefox, Safari, and Internet Explorer.

Extensive working knowledge in UNIX and Windows platforms.

Widely used the test automation frameworks such as keyword-driven, and data-driven.

Written various SQL queries and performed backend validations.

Worked in customizing of MVC modules using HTML/CSS and JavaScript Programming.

Experienced in developing test automation scripts using Cucumber framework by writing Feature files and step definitions.

Implemented the business modules using Core Java, Python.

Build and enhanced automated test framework using Selenium and Page Object Model concept.

Analyzed the System and Functional Requirements to understand the scope of the testing.

Involved in the preparation of the Master Test Plan, which talks about the Objective, Scope, Entry and Exit criteria, features, and functions to be tested.

Strongly performed QA Testing of Java applications with an Oracle backend.

API Testing using POSTMAN.

Extensively worked on application databases of ETL components.

Involved in Integration, System, Regression, and User Acceptance Testing (UAT).

Tested web applications in agile development processes.

Wipro Technologies State Street Banglore, India

Data QA Engineer Oct 2018 to Jan 2019

Performed comprehensive data quality analysis and validation for various data sources, ensuring accuracy and consistency.

Developed and executed test plans, test cases, and test scripts to validate data quality and functionality.

Validated data solutions within AWS environments, ensuring seamless integration and data integrity.

Validated data pipelines, identifying and resolving data quality issues and improving data flow efficiency.

Collaborated with cross-functional teams to define data quality requirements and implement data quality solutions.

Utilized SQL to query and analyze data, identifying data anomalies and inconsistencies.

Participated in Agile development processes, contributing to sprint planning, daily stand-ups, and retrospectives.

Maintained code version control using Git, ensuring code integrity and traceability.

Contributed to the development and implementation of data quality metrics and dashboards.

Wipro Technologies ELECTRONIC ARTS INC Kolkata India

Test Automation Lead Nov 2014 to Mar 2018

Lead a team of IT professionals in the successful planning and execution of SeleniumJava test automation projects.

Oversee the development and maintenance of robust test automation frameworks using Core Java.

Spearheaded automated testing efforts using Selenium WebDriver, TestNG, and Java to ensure comprehensive test coverage and the delivery of high-quality software.

Developed and maintained modular, data-driven automation frameworks using BDD Cucumber with Gherkin syntax, enabling efficient test case design and execution.

Assessed the existing testing framework, identified gaps, and implemented improvements to align with target state objectives.

Provided expert consultation on automation framework architecture, promoting best practices and code reusability.

Collaborated with cross-functional teams to integrate automated tests into the

Continuous Integration/Continuous Build (CI/CD) pipeline, resulting in quicker feedback on code changes.

Ensured that automated test designs balanced clarity and efficiency, optimizing test scripts for maintainability and readability.

Wrote, executed, and maintained automated test scripts to validate software functionality and user experiences, reducing manual testing efforts by 100%.- Proficiently managed code repositories using Bitbucket/GitHub, ensuring version control and collaborative development.

Wipro Technologies NISSAN Kolkata India

TEST AUTOMATION ENGINEER Aug 2013 to Oct 2014

Contributed to the development and execution of automated test scripts using Selenium WebDriver, Java, and TestNG, enhancing test coverage and efficiency.

Assisted in designing and implementing data-driven test scenarios for various software projects, resulting in more thorough testing.

Collaborated closely with developers to report, track, and verify defects, ensuring timely resolution.

Actively participated in the creation of BDD automation frameworks using Cucumber and Gherkin, aligning testing efforts with business requirements.

Develop and maintain test automation scripts using tools such as Selenium WebDriver to ensure maximum test coverage and efficiency in the testing process.

Wipro Technologies ABSA Pune, India

JAVA Test Engineer Nov 2011 to July 2013

Played a key role in developing automation scripts for Web UI and Web Services using Core Java and Selenium.

Conducted test design and execution for comprehensive test coverage, identifying and reporting defects.

Collaborated with development teams to ensure timely defect resolution and quality improvements.

Gained hands-on experience in Core Java development and application development.

Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions.

EDUCATION

Master of Technology in Software Engineering

BITS Pilani, Rajasthan, India - May 2015

Bachelor of Computer Applications

West Bengal University of Technology, Kolkata, WB, India - June 2011

SKILLS

Automation Test Tool: Selenium, POSTMAN

Cloud Platforms: AWS, Azure

Programming Languages: Python, PySpark, SQL, Java, UNIX

Big Data Tools: Apache Spark, Kafka

Databases: PostgreSQL, MySQL, Microsoft SQL Server, DB2

Defect Tracking Tools: JIRA, Bug zilla

Version Control: GIT, BIT Bucket

HIGHLIGHTS

Skilled in designing, developing, and optimizing test automation frameworks to ensure modularity, data-driven capabilities, and efficiency.Proficient in TDD, BDD, and leveraging tools like Selenium WebDriver, Cucumber, and Rest Assured for comprehensive automation across Web Applications, API testing.

Adept at leading and collaborating with cross-functional teams to define and execute test strategies, ensuring alignment with project goals and agile development cycles. Proven track record of optimizing testing processes and significantly improving test coverage and efficiency.

Extensive experience with CI/CD pipelines using Jenkins,driving continuous improvement in test automation and integration. Skilled in setting up Jenkins environments and slave configurations to support seamless integration and delivery processes.

Strong expertise in Web UI Testing using Selenium WebDriver, Protractor, and Cypress with Cucumber BDD Framework. Experienced in creating data-driven tests and building custom UI layers over automation frameworks to empower business users with easy test execution capabilities.

Proven expertise in API testing with tools like Rest Assured and Postman, along with experience in Web Service Automation Frameworks built using Java and Eclipse to test RESTful services. Integrated JUnit, TestNG, and Extent Reporting to improve test reporting and monitoring.

Hands-on experience in performance testing using JMeter and Jenkins, driving optimization and providing critical performance insights for applications in high-demand environments.

Experienced in developing comprehensive Test Plans, Test Strategies, Test Cases, and Test Scenarios. Demonstrated performance in suggesting and implementing process improvements within test automation, significantly reducing testing cycles while increasing test coverage.

Deep experience working within Agile environments (Scrum, Kanban) and contributing to continuous improvement initiatives. Well-versed in Scrum ceremonies, sprint planning, and facilitating effective collaboration between development and testing teams.

Strong background in software configuration management using Git and SVN.

Extensive experience in the development, testing, and deployment of enterprise applications on Windows, Linux, and UNIX platforms using IDEs like Eclipse and Visual Studio Code.

Rich experience in Retail, Banking and Insurance domains, with a solid

understanding of domain-specific requirements and challenges.

Expertise in utilizing Jenkins for performance testing and continuous integration, automating test execution, and streamlining the test feedback loop for faster release cycles.

Contact this candidate