PROFESSIONAL SUMMARY:

• Excellent Testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies and disciplines.
• Experience in full System Development Life Cycle (Process Engineering, Design, Development, Deployment Support and Testing) using Waterfall, and Agile methodologies.
• Expertise in ETL DWH testing concepts and good understanding of the ETL tools (Data stage, Informatica) BI tools (Business Objects).
• Expertise in using ETL methodology for supporting of Extract, Transform, and Load environment using Informatica Power Center 9.x/8.x (Designer, Repository manager, Repository Server Administrator console, Workflow manager, workflow monitor, Server Manager).
• Experience with Testing, Statistics, Data Analysis using Python and R language.
• Worked extensively in developing ETL (Extract, Transform and Load) for supporting Data Extraction, Transformation and Loading using ODI (Oracle Data Integrator)
• Extensive knowledge and experience on complex ETL with ODI package design, development, customization, testing and implementation.
• Extensive experience of development using Hadoop ecosystem covering Scala, Spark, Sqoop
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate - wide- ETL solution using ETL tools like Informatica.
• Worked on different types of data validations like data completeness, data accuracy, metadata, Source to target file validation.
• Experience working with SQL, T-SQL, PL/SQL scripts, views, indexes, stored procedures and other components of database applications.
• Extensive experience in ETL Data warehouse backend testing and BI Intelligence reports testing.
• Proficient in Designing Test Strategy, Test Plan, Test Schedules, Test Cases, Execution of Test Cases, logging bugs, Root cause analysis, tracking of bugs with module wise till closure. Good knowledge on Bug/Defect life cycle, Defect tracking and management.
• Types of Testing involved for various projects are Sanity Testing, Functional Testing, Regression Testing, Integration Testing, GUI Testing, and Compatibility Testing.
• Actively involved in User Acceptance Testing (UAT) and Training of the end users. Participated in cross-functional teams to reengineer and improve business processes.

TECHNICAL SKILLS:

Data modeling: Erwin, Pivot tables, Teradata

BI Tools: Teradata, Tableau, TOAD, and MSAccess

ETL Tools: Informatica Power Center 9.x/8x, Data Stage, Ab Initio

Analytics Tools: Python, SQL, TABLEAU

Databases: Teradata, SQL Server Oracle (8i/9i/10g), MS-Access, SQL, MySQL, DB2

Programming Languages: SQL, SAS, PL/SQL, Python SQL, Python

Others: MS Office Suit (Word, Excel, Power Point), MS Project, SQL Assistant

PROFESSIONAL EXPERIENCE:

Confidential - Dearborn, MI

ETL Tester

Responsibilities:

• Attended the business walkthrough meetings to understand the Requirements, analyzing the requirements and GAP analysis.
• Created the Test strategy, Test plan documents.Test Scenario preparation as per the business requirements. Reviewing test case written by the team members.
• Managed and executed the test process, using Agile Methodology. Logged the defects using Quality Center and Agile/Scrum methodology.
• Validated ETL process to load data into landing tables of MDM Hub using Informatica 9.6.1.
• Validate the scenarios based on the coverage and getting the approvals from business. Test data preparation to cover all scenarios. Trigger the ETL Informatica jobs to load the data from Source to Data ware house.
• Conducted internal data validation audits of testing records ensuring timely, accurate, and complete submission.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
• Performed conversion of SQL queries into Spark SQL for better performance. Developed Spark jobs using Scala for Batch analysis as per business requirement.
• Involved in Text Analytics, developing different Statistical Machine Learning, Data mining solutions to various business problems and generating data visualizations using R, Python and Tableau.
• Developed and maintained automated regression test cases in Selenium WebDriver using Java, Python language.
• Wrote Python Scripts to establish continuous workflows from different teams providing data. Wrote unit and integration tests in python to test the code.
• Hadoop using Spark Context, Spark-SQL, Spark YARN. Developed Spark code using scala and Spark-SQL/Streaming for faster testing and processing of data. Installed and configured Hadoop Horton works platform for UAT.
• Created the JIRA tasks and allocation of the tasks based on stories. Test case execution, data validation and defect tracking in JIRA. Conducted the regression/integration testing after the new functionalities are being introduced or after defect fixes.
• Analyzed various logs that are been generated and used various Python libraries to predict/forecast next occurrence of event with various Python libraries.
• Created Python scripting to test project functionality for regression setup.
• Performed ETL Testing (on Informatica and Teradata) on Data Warehouse to validate source to target mapping. Validated SSIS packages to test ETL batch jobs and exceptions built in the jobs.
• Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• Extensively created and executed SQL queries in Oracle, SQL Server, and MySQL tables to validate data at the back end excellent understanding and knowledge of Business intelligence tools for various applications of ETL, Reporting, Data mining, Data Warehousing, and Analysis of data.
• Used Python codes to handle textbox, dropdown, checkbox, buttons and popup controls.
• Involved in the Performance testing of the programs, ETL Procedures and Processes.
• Performed Database testing (ETL) on ETL applications validating the data in Sources/Targets using Data Stage Client Tools.
• Extensively used TOAD utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Participated in sprint planning, story grooming and backlog grooming sessions as part of agile process.
• Tested ETL applications in relational databases and flat files using Informatica and tested the reports generated.
• Prepared the complex SQL scripts using joins/functions to validate the Data flow from the Source to Target EDW as per the ETL mapping/logic.
• Responsible for Off shore/onshore co-ordination. Sending the project Status to the management. Worked with business users while UAT testing.

Confidential -Franklin, TN

ETL Tester

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases. Involved in ETL process testing using Informatica ETL tool. Test Case Execution and Ad-hoc testing
• Used SQL queries to perform the back-end testing on Oracle. Co-ordinate in application setup for UAT Testing.UAT Testing done based on UAT Test Cases. Created reports using SQL Reporting Services.
• Used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide- ETL Solution using Informatica.
• Participated in defining and executing test strategies using agile methodology.
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews. Performed data validation testing writing SQL queries.
• Involved in python functions and script mode programming. Worked on python modules, dictionary and exceptions
• Wrote Python scripts to parse JSON documents and load the data in database and also used python scripts to update content in the database and manipulate files.
• Performed ETL Testing (on Informatica and Teradata) on Data Warehouse. Wrote complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Installed and configured Hadoop and responsible for maintaining cluster and managing and reviewing Hadoop log files.
• Improved the performance and optimization of existing algorithms in Hadoop using Spark context, Spark-SQL and Spark YARN. Involved in converting SQL queries into Spark transformations using Spark RDDs, Python and Scala. Worked with Apache Spark for large data processing integrated with functional programming language Scala.
• Formulating procedures for integration of R programming plans with data sources and delivery systems.
• Assisted Data Validation Department with account management for client companies
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica. Performance monitoring for ETL Solution using project parameters, connection manager, and SSIS packages. Wrote Test Cases for ETL to compare Source and Target database systems.
• Involved in the Performance testing of the programs, ETL Procedures and Processes.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Wrote and executed various MYSQL database queries from python using Python-MySQL connector and MySQL dB package.
• Used Unit Test Python library for testing many programs on python and other codes.
• Wrote complex Hive-SQL queries for data validation for verifying the ETL Mapping Rules. Wrote Test Cases for ETL to compare Source and Target database systems.
• Created Selenium web driver automation scripts using Python to validate functionality on various browsers.
• Worked on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results. Used HP Quality Center for storing, maintaining the test repository, bug tracking and reporting.
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects. Developed UNIX scripts to validate the flat files and to automate the manual test cases. Developing Test Matrix to give a better view of testing effort
• Provided Efforts Estimate and coordinated the test schedule using Agile testing methodology in UAT phase.

Confidential -Detroit, MI

ETL Tester

Responsibilities:

• Interacted with Business users on Testing needs and technical specifications document, High-level design document, Source to target mapping document, develop and test custom developed applications.
• Developed testing Scripts to process for data extraction, transformation and loading from flat files, Oracle, Teradata and MS SQL Server.
• Worked with Business users, ETL Developers team to gather testing requirements, technical specifications documents. Used Informatica ETL tool to perform ETL testing and validating end-to-end flow of data with Informatica
• Worked in AGILE-SCRUM Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Used STM- Source to target mapping document to understand ETL end to end flow of data in ETL design.
• Involved in designing of Test Plan, Identifying Test Scenarios and Executing the Test Cases. Identified and logged the defects based on the User Stories in JIRA.
• Planning and performing software automation tests involving definition and implementation of test and verification requirements, with complex software and testing with Python scripting
• Automated course utilization data validation process with Python for various records
• Performed Informatica ETL testing to validate end-to-end data from source system MS SQL Server and Target system Teradata environment.
• Involved in migration of ETL code from development repository to testing repository and then to production repository.
• Developed Spark scripts by using Scala shell commands as per the requirement. Used Spark API over Cloudera Hadoop YARN to perform analytics on data in Hive.
• Implemented Spark using Scala and utilizing Data frames and Spark SQL API for faster processing of data.
• Worked with Structures, semi-structured and unstructured data, using a broad range of data science programming languages and big data tools including R, Python, Spark, SQL, Hadoop MapReduce.
• Performed automation test scripting (Python Selenium) and Socket programming using Python techniques. Responsible for regression testing ETL jobs before test to production migration.
• Used Team Foundation Server for defect tracking, updating status of defect and task assign list, uploading test cases and test documents for multiple applications.
• Performed Storm test using python code to validate multiple tables using different SQL DBs
• Performed ETL testing using Data stage ETL tool for data coming from different sources in Target Teradata System. Worked on writing test scripts and test scenarios for validating end-to-end data and source and target in ETL flow design.
• Involved with ETL Development team and database team to ensure on testing needs and development process as per functionality. Scheduled ETL batch jobs using Autosys, Control-M tool.
• Created different jobs using UNIX shell scripting to call the workflow by using Command tasks.
• Used Oracle and SQL server Management studio for SQL server to write complex SQL queries to fulfill Backend Testing.
• Used of DB Visualizer tool to write SQL queries to access Oracle databases and DB2 for back-end validation.
• Review the Test Plans, Test Cases and Test Scripts to ensure consistency with strategic direction, goals and objectives of QA resources using Agile Scrum Methodology and Waterfall Methodology
• Involvement in Black Box Testing, Functional Testing, Regression Testing, System Integration Testing, End-to End Testing, UAT.

Confidential - Washington, D.C

QA Tester

Responsibilities:

• Analyzed business requirements, use case documents, functional specs & assisted QA team lead in writing the test plans.
• Managed various testing activities throughout the Software Testing Lifecycle (STLC) for multiple projects.
• Responsible for testing all new and existing ETL data warehouse components.
• Performed various types of testing such as Functional, Regression, SIT, UAT, Backend etc.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Verified data for ETL Packages using SQL Queries
• Utilized Informatica Data Warehouse for testing ETL process
• Performed Unit testing for ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Used SQL for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Created test plans, conditions, scripts, and test data; performed product testing, user acceptance, remote user testing, usability standards validation, and performance testing; and resolved system defects.
• Detected, reported and tracked defects using Quality Center.
• Used Jira to log the defects found during testing.
• Produced various test reports such as Test Execution Status, Test Execution Summary/Progress, Defect Status, Defect Summary, Defect Inject Rate on daily and weekly basis and submitted
• Wrote SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Retesting the resolved defects/issues after the developers fix the defects.
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.