SUMMARY

• Over 6+ years of IT experience in various phases of IT projects such as Development, Testing, deployment, Python, Django, MySql and application support.
• Hands on experience with all phases of Software Testing Life Cycle (STLC)
• Have the ability to elicit, understand and articulate business requirements and perform detailed analysis to map them to functional QA requirements.
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Data stage and Informatica using Oracle, Teradata and UNIX.
• Expertise in creating Test plan documents and Test strategy documents. Expertise in designing the test scenarios and scripting the test cases to test the application.
• Good exposure with databases like Oracle, Teradata, SQL Server 2008
• Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.
• Proven ability in designing and creating automation frameworks for J2EE based applications usingJava, Junit/ TestNG,SeleniumRC/WebDriver/IDE/Grid, ANT/Maven.
• Experience in automating different module using Selenium Framework. Creating Feature files using GWT, step definition, configuration file, drivers, path using Ruby Test Automation Script for Front End UI Automation.
• Knowledge in Automation Testing tool like Quick Test Professional and Test Management tool like HP Quality Center.
• Experience in developing Test FrameworkinSeleniumfor UI Regression TestAutomationwhen necessary, and potentially execute Unit Testautomation(Java/Junit).
• Experience in Test driven development for functional and integration testing using Python Nose test, PyUnit, Robot framework and Selenium frameworks.
• Have good knowledge on Working within the Data Access Layer with Object Relational Mapping (ORM) (Entity Framework), and an understanding of RDBMS modeling and design.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema
• Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Implementing infrastructure on new AWS systems and migration of existing Linux and Windows based infrastructure to AWS cloud platform and automated using terraform cloud formation templates.
• Experience in maintaining Full and Incremental loads through ETL tools on different environments.
• Experienced in Defect Management using HP Quality Center
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Worked with different data sources ranging from VSAM files, CSV file, flat files, and Teradata, oracle and SQL Server databases.
• Expertise in Informatica Power Center 9.x/8.x/7.x/6.x extracting data from Oracle, SQL Server and DB2 databases.
• Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources.
• Written templates for AWS infrastructure as a code using Terraform to build Staging and production environments.
• Experienced in testing performance in an Agile methodology
• Handsome experience in working with UNIX scripts in executing and validating logs for the issues.
• Extensively used SQL queries/Unix commands for data verification and backend testing.
• Have experiences testing on different components like customer data, Agreement data, Deal, Excess, violation, Asset, Organization, Application and securities.
• Hands on experience in writing SQL queries, Joins, Functions in Oracle and SQL Server databases.
• Good expertise in using TOAD, SQL*Plus and Query Analyzer.
• Strong experience in UNIX shell scripting and monitoring the UNIX logs to check for any errors.
• Strong experience in Backend testing on Relational Databases (RDBMS) like Oracle, SQL server 2012, Tara Data using complex SQL queries.
• End to End responsibility to close the defects and fixes

TECHNICAL SKILLS

ETL Tool: Informatica Power Center 10.4 and 8.6, Data stage 8.5

Reporting Tools: Excel, SSRS, Power BI, VISIO

Database: Oracle10g/9i, SQL Server 2005, 2012, IBM DB2, Teradata and MS - Access

Cloud Environment: AWS, Amazon EC2 & S3, Confidential, Open stack

Utilities: Toad, Oracle SQL Developer, SQL Advantage, SSIS, SSRS

Testing Tools: HP Quality Center 9.2/Test Director, HP ALM 11.0, Selenium IDE/Web Driver/RC/Grid, QTP, JIRA

Programming Lang: SQL, PL/SQL, JavaScript, HTML, Python.

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

QA Consultant / ETL Tester

Responsibilities:

• Involved in the entire software development Life Cycle of the projects from Initiation to Implementation.
• Involving inWaterfallandAgileProjects, worked very closely with Product owners in Agile and attended different meetings likeSprint Planning meeting, Scrum, Backlog grooming, Sprint Review and Retrospective.
• Used Cloud Front to deliver content from AWS edge locations to users, allowing for further reduction of load on front-end servers.
• Assessed and analyzed user stories, Business Requirements (BRD), Functional Requirements (FRD), Technical design documents (TDD) and participated in Sprint planning, Review Sessions and Scrum Meetings.
• Expertise in writing and executing Test plans, Test Suites, Test Cases, Test summary reports, for automation and manual testing as well, based on User requirements, System requirements and Use Case documents.
• Being actively used JIRA/ALM to manage stories test cases, defects, Sprint planning related activities.
• Organizing weekly meetings with offshore managers, Onsite Coordinator & Onsite manager to discuss the Project goals and report the status of the overall project status.
• Actively being used Linux/ Unix server in Dev, CTE, QA/UAT environment for script run, job load, file transfer, and validate the flat and delimited files.
• Responsible for creating test scenarios for user stories and creating automation test suites using Python, Selenium web driver, Pytest framework
• Actively being used Informatica PC designer for creating metadata based on mappings, and workflow managers, workflow monitors for jobs updates.
• Being used DVO ETL automation tool for validation of file to file, file to table, table to file and table to table where we create table pair and single validation.
• Strongly being used SQL queries to validate the data in Raw stage, ODS stage by using oracle SQL developer tool.
• Validating the data coming from various sources like Oracle, SQL server, and DB2 in to Netezza and from Netezza to GBQ.
• Implemented Jenkins code deploy plugin to deploy to AWS and used to automate the build process and deploy the application to Tomcat server.
• We have been creating controls file and DDL file to load extracted files into temp table in order to validate the file vs table.
• Organizing and attending defect triage meeting, code review meeting, Test execution review meeting with all SDLC team.
• Built Python framework to transform Datasets and Data tables into HTTP-serializable JSON strings.
• Tested many features in an Agile environment using Python Django, HTML5, CSS, JavaScript.
• Used Business Objects for testing the scheduled reports and viewing the history.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Raised defects in HP Quality Center/HP ALM /JIRA defect tracking system.
• Managing security groups on AWS and custom monitoring using cloudwatch.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Good experience in writing SQL in order to data validation in migration as part of backend
• Testing. Worked with ETL group for understating mappings for dimensions and facts.
• Assisted in promotion of Data stage code and UNIX from UAT to Production.
• Tested data from various sources like Teradata, Oracle flat files and SQL Server. Worked on issues with migration from development to testing.

Environment: ETL Informatica, DVO, Oracle, SQL Server, DB2, Netezza, GBQ, Quality Center/ALM, SQL, Azure, Apache, Teradata SQL Assistant, SQL Server, UNIX/Linux, SSRS, MS Access, Flat Files, JIRA, Reporting database, Microsoft word, Excel, Excel pivot Worked with Angular 6 and typescript as part of migration from Angular and vanilla Javascript to Angular 6.

Confidential, Jersey City, NJ

ETL / QA Tester

Responsibilities:

• Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
• Involved with Agile team and worked out different sprint module.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Teradata databases.
• Experience in AWS services (S3, EC2, ELB, EBS) and deployment services (Cloud formation) and security practices (Cloudwatch and Cloud trial).
• Have used multiple advance SQL queries function such as join, union, alter, create, distinct and some other function to join different database in single query while executing the script
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Developed Test Automation framework scripts using Python selenium WebDriver. Implemented Page Object Model Framework with Python and Selenium.
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End) and Backend (Database).
• Performed parameterization of the automated test scripts in Selenium WebDriver to check how the application performs against multiple sets of data.
• Creation of EC2 roles, policy document in AWS using AWS identity and access management.
• Initially the project was started withrubycucumber and then shifted to Cucumber and Selenium Web driver. So have thorough knowledge onrubyand cucumber.
• Used ANT to build and run the Selenium WebDriver automation framework. Once the script got over, framework used to send the automation reports over email.
• Responsible for creating and maintainingautomationacceptance test suite using Selenium and Cucumber framework. Also responsible for convertingautomationscripts to new framework using Selenium WebDriver, Java and TestNG.
• Created Selenium Test cases for automation using Selenium Web Driver and Java.
• Used Hybrid Framework of Selenium to get data from Excel.
• Build a detailed, reusable, Script - free Keyword + Data - Driven framework for over 45% Test cases using Selenium WebDriver + TestNG.
• Configured continuous integration environment using Jenkins to kickoff daily builds and automation suites Jenkins, Maven and GitHub Python
• Involved in acceptance testing using Cucumber and Selenium Web Driver.
• Regression runs using Cucumber.Perform failure analysis of the test runs and fixing failed scripts.
• DevelopedTest FrameworkinSeleniumfor UI Regression TestAutomationwhen necessary, and potentially execute Unit Testautomation(Java/Junit).
• Have experiences testing on different components like customer data, Agreement data, Deal, Excess, violation, Asset, Organization, Application and securities.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatic.
• Worked with AWS cloud machines to setup Selenium GRID and also Jenkins server on HUB machine.
• Prepare advance QTP Scripts to automate the application-level functionalities.
• Execution and Maintenance of these test scripts so that are reused across multiple projects.
• Experienceworking in an Agile method
• Created QA test scenarios, test cases andtest case walk-throughin partnership with Business SMEs.
• Participate in QA test case execution
• Attend Daily Defect triage and executionmeetings
• Created QA Traceability Matrix for the workstream
• Participate in identifying Regression test cases
• Identified and escalate any QA Risks/Issues for the Line of Business in partnership with the Business SMEs for the line of Business to the UAT Manager
• Used JIRA for QA defect tracking and logged multiple defects
• Scheduling and reporting job control using AutoSys
• Created report using Power BI.

Environment: ETL Informatica, Oracle, SQL Server, Quality Center/ALM, SQL, Teradata SQL Assistant 6.0, Teradata, PL/SQL, SQL Server, UNIX, SSRS, MS Access, Flat Files, JIRA, Reporting database, Selenium

Confidential, Parsippany, NJ

ETL Tester

Responsibilities:

• Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
• Involved with Agile team and worked out different sprint module.
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Tested different Informatica Mappings especially are used effectively to develop and maintain the database.
• Developed ETL test cases for various lines of businesses based on ETL mapping document.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Teradata databases.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End) and Backend (Database)
• Have experiences testing on different components like customer data, Agreement data, Deal, Excess, violation, Asset, Organization, Application and securities.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica
• Developed entire frontend and backend modules using Python on Django Web framework.
• Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files)
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Normalizer.
• Performed troubleshooting, fixed and deployed many Python bug fixes of the two main application that were maintained main source of data.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica
• Have programming skills in SQL and experience in Oracle and Teradata databases on UNIX and Windows platforms.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Teradata databases.
• Written Complex SQL Queries to do manual testing for every release and check the configurations.
• Tested several different types of reports including Report Layout, Naming Conventions, Totals, Sub-Totals, Drilling options, prompts, metric calculations, drill maps and security filters using Business Objects.
• Used Business Objects for testing the scheduled reports and viewing the history.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Raised defects in HP Quality Center/HP ALM /JIRA defect tracking system.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Good experience in writing SQL in order to data validation in migration as part of backend
• Testing. Worked with ETL group for understating mappings for dimensions and facts.
• Assisted in promotion of Data stage code and UNIX from UAT to Production.
• Tested data from various sources like Teradata, Oracle flat files and SQL Server. Worked on issues with migration from development to testing.

Environment: ETL Informatica, Oracle, SQL Server, Quality Center/ALM, SQL, TOAD, Teradata SQL Assistant 6.0, Teradata, PL/SQL, SQL Server, UNIX, WinSQL, SSRS, MS Access, Flat Files

Confidential, Jackson, MI

ETL Tester

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Performed automation testing for the Back Office using Quick Test Pro and coordinate with the dev team for immediate hot fixes.
• Executed SQL queries to perform backend database testing and verify/modify user data
• Enhancing the Quickest Pro Scripts with GUI checkpoints, Database Checkpoints, Parameterization, User Defined Functions (adding functional features) and Synchronizations.
• Performed Manual Functional Testing and Automated Testing using QTP, of the application against new builds.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Tested complex mappings using mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
• Conducted back-to-back meetings with developers and discussed about all open issues.
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports.

Environment: Informatica Power Center, QTP, SOAP, Windows NT, Test Cases, Test Scripts, Test Plans. Oracle 8i, SQL Server, SQL, PL/SQL, SQL*Plus, TOAD and Shell Scripting