SUMMARY:

• Around 5 years of overall IT experience with emphasis in Software Testing, Quality Assurance and Big Data Analytics.
• Strong knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) with QA testing methodologies and process.
• Experience in analyzing business and technical requirements and create comprehensive Test plan and Test cases.
• Experience in developing and executing test cases, including automated tests.
• Experience in Functional Testing, Integration Testing, Regression Testing, System Testing, Smoke, Sanity, Exploratory Testing, Black Box Testing, Grey Box Testing, Performance/Load Testing and User Acceptance Testing.
• Adept at backend testing, data validation, data integrity and consistency using SQL queries.
• Experience developing ETL processes and ETL testing to assure that the data that has been loaded from a source to destination after business transformation.
• Experience in Manual Testing and good knowledge of automation tools like QTP and Selenium.
• Experience using IDQ tool for profiling, applying rules and develop mappings to move data from source to target.
• Background with traditional databases such as MySQL, MS SQL Server, Oracle.
• Extensive experience in HDFS, Sqoop, Flume, Hive, Pig, Impala, Spark, Map Reduce, Oozie.
• Experience in importing and exporting multi terabytes of data using Sqoop from RDBMS to HDFS and vice versa.
• Experience in Hive, Impala for querying and analyzing large datasets.
• Experience in using Spark over Map Reduce for faster and efficient data processing and to perform analytics on data.
• Experience in creating Resilient Distributed Datasets for the input data and data transformations using PySpark.
• Experience in processing large datasets of different forms like structured, semi - structured and unstructured data.
• Experience working with different file formats like Avro, Parquet, Text, Sequence, Flat, XML and JSON files.
• Experience in analyzing large datasets and deriving actionable insights for process improvement.
• Documenting defects with high level of detail, accuracy and informative recreation steps using defect tracking system.
• Knowledge of Advertising, E-Commerce, Financial, Insurance, Banking domain.
• Experience with Agile development methodologies.
• Detail oriented with strong multitasking, interpersonal skills and ability to produce high quality results.
• Good analytical, communication, problem solving skills with ability to quickly master new concepts and capable of working efficiently within a team as well as independently.

TECHNICAL SKILLS:

Testing / Test Management Tools: QTP/UFT, Selenium, SoapUI, Jira, HP Quality Center

Big Data Ecosystem: HDFS, Sqoop, Flume, Hive, Pig, Impala, Spark, Map Reduce, Oozie

Databases / AWS: MySQL, MS SQL Server, Oracle, S3, Redshift

Languages: Java, Python

Operating System: Windows, UNIX / Linux, Mac

PROFESSIONAL EXPERIENCE:

Confidential - Walnut Creek, CA

QA / ETL / Big Data Analyst

Responsibilities:

• Responsible for analyzing the business and functional requirements.
• Develop Test Plan, Test Cases, Test Script and Test Data across all areas for different types of testing activities.
• Primarily responsible for Functional, System, Integration, Regression, Black Box and Backend testing.
• Extensively used SQL and wrote complex SQL Queries for backend testing.
• Perform data driven testing and validated the test results.
• Involved in extensive data validation and verify the quality of data.
• Tested the validity and correctness of data in the system using data centric testing.
• Verify whether data is moved as expected, whether counts in the source and target are matching, whether the data transformed is as per the expectations and verify that the foreign primary key relations are preserved during the ETL.
• Used Address Validator transformation in IDQ passed the partial address and populated the full address in the target.
• Worked on data cleansing and standardization using the cleanse functions in Informatica IDQ.
• Handled importing of data from various data sources, performed transformations using Hive, loaded data into HDFS.
• Exported the analyzed data to relational database using Sqoop for visualization purpose and to generate reports.
• Load and transform large sets of structured, semi structured data using Hive, implemented partition in Hive and analyzed the data by performing Hive queries.
• Experience working with SparkSQL and creating RDD’s using PySpark.
• Extensive hands on experience in Hadoop file system commands for file handling operations.
• Experience in implementing efficient storage formats like Avro, Parquet and ORC.
• Actively involved in interacting with developers for the Bug Fixes and Problem resolution.
• Provided End to End support for the testing activities during System Testing, User Acceptance Testing.
• Responsible for bug tracking, bug reporting and bug reproducing.
• Managed and coordinated daily tasks and defects/bugs using JIRA.
• Participated in daily, weekly meetings, technical reviews and prepared reports showing the testing efforts.
• Worked in Agile environment, attend project meetings and scrums.

Confidential - San Francisco, CA

QA Tester / Analyst

Responsibilities:

• Analyzing the business and functional requirements and identified the test requirements.
• Analyzed technical documentations and learned about features and requirements of the application.
• Developing and Implementing the Test Plans, Test Cases and scenarios based on functional requirements.
• Primarily responsible for Black Box, Functional, Integration, System, Regression and Database testing.
• Write SQL queries to verify data in the database and verify consistency with the application.
• Set up test data, perform data driven testing and validated the test results.
• Checking data integrity and consistency, whether the data stored in table is correct and as per business requirements.
• Validate the source and target table structure against corresponding mapping doc.
• Involved in various ETL testing scenarios such as validation, constraint validation, data consistency, completeness, correctness, null validate, duplicate check, data quality, data validation
• Used IDQ's standardized plans for addresses and names clean ups.
• Loading data from local file system to HDFS and vice versa using hadoop fs commands.
• Involved in importing and exporting data between RDBMS and HDFS using Sqoop.
• Creating Hive tables, partitioning for efficient data access and writing hive queries for adhoc analysis.
• Experience creating RDD’s using PySpark and working with SparkSQL.
• Exported the analyzed data to the relational databases using Sqoop for visualization purpose.
• Manage and review log files, troubleshooting a failed job and resolving the issue.
• Updated Test Plans and Test Cases periodically to manage changes in requirements.
• Responsible for verification of defects manually using different scenarios.
• Logged defects in Quality Center and updated the status of bugs as they moved to different stages.
• Retested the resolved defects/issues after the developers fix the defects.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked in agile environment and participated in scrum and sprint meetings.

Confidential

QA / SQL Developer

Responsibilities:

• Involved in gathering business requirement, studying the application and collecting the information from developers.
• Managed software testing and database related activities.
• Developing and implementing Test Plans, Test Cases and scenarios based on functional requirements.
• Involved in fixing bugs and different forms of testing including black and white box testing.
• Performed Black Box, Unit, Functional, Integration, System, Regression, User Acceptance Testing.
• Tracking the defects which are encountered during testing of various modules of the application.
• Executed SQL statements for data validation to check data integrity, data redundancy and data consistency.
• Performed End-to-End testing after bug fixes and modifications.
• Involved in database design by analyzing business requirements.
• Involved in database development and creating SQL scripts.
• Create database objects such as tables, views, sequences, indexes, stored procedures, functions etc
• Created Joins and Sub queries involving multiple tables and writing SQL queries to fetch the business data.
• Created complex SQL queries for querying data against different data bases for data verification process.
• Analyzing SQL data, identifying issues and modifying the SQL scripts to fix the issues.
• Performance tuning the SQL code to efficiently process all of the data.
• Document proper tickets and ensure appropriate follow through to resolution.
• Effectively prioritize work while considering business need and urgency.
• Worked effectively and efficiently on multiple tasks and deadlines and produces high quality results.
• Participated in weekly status meetings, coordinated with developers to resolve the defects and close them.