Data Sql Server
Resume:
Jyotishna 720-***-****)
ETL/DWH QA Tester
Professional Summary:
Extensive knowledge on all phases of Software Development Life Cycle (SDLC).Experience in Agile and Waterfall models of SDLC.
Extensive experience in Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC). Participate in complete testing Lifecycle, Test Plan, Test Cases, Test Execution, & Defect Report.
Met with business analysts to understand the business and involved in walkthroughs, and periodical meetings to come up with project plans.
Extensive use of defect tracking tools like Quality Center and Test Director
In-depth knowledge of all QA Phases that include Manual, Functional, System, Integration, Regression Testing End-to-End testing
Uploaded Business requirements, test scenarios, test cases and defects from MS Excel to Test Director. Analyzed and Reported the Defects to the Developers using QC.
Experienced in Integrating and coordinating testing activities into software development activities.
Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
Helped in building scalable distributed data processing solutions with Hadoop (CDH4, CDH5), Sqoop, Zookeeper, Oozie, Flume, Hive & Pig, Kafka
Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata, Netezza, Ms Access, Flat files into a staging area.
Experience using query tools like, TOAD, Teradata SQL Assistant, WinSQL, SQL server Management Studio for Teradata, Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
Proficient in designing, reviewing and documenting system test plans, defining test procedures and creating test cases on the basis of product release features, client’s requirements and related technical documents.
Worked heavily on testing various ETL process as well as many reports developed used various BI tools.
Working knowledge on various types of data feeds like: XML and Flat files.
Excellent in writing SQL queries and UNIX shell scripts to perform Backend testing
Experienced in supporting multiple projects simultaneously while maintaining strong quality and ability to meet deadlines
Excellent analytical skills, documentation skills and presentation skills
Self-starter and ability to present ideas in a concise, logical and well organized format
Technical Skills:
Bug Tracking / Test Management Tools
HP ALM/ Jira/ VersionOne/ TestLink/ Quality Center
ETL Tools
Informatica, AbInitio, SSIS
Languages
Sql,, Shell script, PL Sql, T Sql
BI Tools
Business Objects, SSRS, Cognos
DBMS
MS Access, SQL Server, Oracle, Teradata
Operating Systems
Windows XP/2000/2003/Vista/ 2016,UNIX
Big Data
Hdfs, MapReduce, hive, pig, sqoop, flume, storm, Kafka
Software Lifecycle Management Methods:
Scrum, Agile, Spiral, and Traditional Waterfall model.
General Business Tools:
Microsoft Office, Toad for Oracle, QTP
Professional Experience:
PNC Bank August 2017 – Present
Role: Security and Authentication/ Lead System Quality Analyst
Responsibilities:
Worked heavily on a Agile methodology as a Security and Authentication Lead for Online Banking Application
Co-Ordinate between on shore and off shore team
Delegate responsibilities between on-shore and off-shore team during critical releases
Attend daily stand ups and provide with updates
Frequently communicating with different application team (Virtual Wallet, Mass Market, Wealth, Mobile) to provide with the details
Attend various meeting with Product Owners and with my application
Updating user stories and defining their levels in Version One and updating Test Plans in HP ALM
Provide Daily Status Report (DSR) after End of Business to all the stakeholders on a daily basis
Facilitate Defect Management Meeting with entire team and provide with the Defect status
Creating Test Data in Mainframe and providing different test datas to test team and development team if needed
Work closely with thorough regression team to do testing with different application before each release
Used Postman to do the API testing for Online Banking Application after designed document has been given by the development team
Attended each Sprint Meeting and discuss testing hours, points to be provided for User Stories
Attend Grooming meeting with Scrum Master, Develeoper, Product Owners and BA, Tech Lead
Provide production team support during release
Support hotfixes by doing regression testing
Interact with Performance team and provide with datas for Performance testing and with automation teams for the scripts to be automated for the current sprint
Environment:
VersionOne, Postman, HP ALM, Mainframe, Perfecto, Monitise, Switiches, Jira
Professional Experience:
Catalina Marketing, St. Petersburg, FL February 2016– June 2017
Role: ETL QA Tester
Responsibilities:
Collaborating with team members across the globe.(France, UK)
Involved reviewing systems requirements to write detailed test plans and scripts, track and facilitate defect resolutions, and apply analytical problem-solving skills by collaborating with business and technical staff throughout the testing process within an Agile SDLC.
Run the given job in Autosys before testing.
Participated in test plan and test case review.
Reported and tracked issues/bugs in QA/UAT environment
Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
Tested and worked on creating open document reports for business.
Worked with QA Team and use Jira to Defect logging and tracking them to closure.
Provide status updates to development leads and project manager.
Working closely with Developers and Architects in solving software defects.
Loaded data into Netezza tables from various data sources like Netezza, SQL Server, Oracle, flat files by creating Informatica Mappings
Written several complex SQL queries for validating Cognos Reports
Handled importing of data from various data sources, performed transformations using Hive, MapReduce, loaded data into HDFS and Extracted the data from MySQL into HDFS using Sqoop
Worked on Sqoop to export data into HDFS and Hive
Performed data validation on the flat files that were generated in UNIX and Netezza environment using UNIX and sql Loader commands as necessary
Tested Cubes by using Cognos Power Play to analysis
Responsible for testing packages using Informatica (ETL) to verify data and Involved in testing data migration.
Identifying field and data defects with required information in ETL process in various mappings and one to one mapping.
Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
Executed SQL queries for validation of data and used TOAD for Oracle
Used TOAD and NZSQL for Netezza and Oracle to write SQL queries for validating constraints, indexes.
Analyze changes that span application test team and functional processes to ensure all impacts have been identified for testing
Conduct test team meetings to ensure business and IT testing expectations are met, and test deliverables are traceable to business requirements
Collaborate with software/systems personnel in application testing, such as unit, system, regression, load and acceptance testing methods
Collaborate with the development and configuration management team for deployments into the test environments
Environment: Informatica 9.6, Oracle 11g, SQL, Netezza NPS (data warehouse appliances), Cognos, Hadoop, TOAD, WinSQL, Business Objects 4.1,Testlink (web based test management system).Jira, Putty, Autosys, UNIX
Wells Fargo, Addison TX August 2014 – February 2016
Role: ETL/DWH QA Tester
Responsibilities:
Managed multiple OLAP and ETL projects for various testing needs.
Debugging the SQL-Statements and stored procedures for various business scenarios.
Performed extensive Data Validation, Data Verification against Data Warehouse
Loading Flat file Data into Teradata tables using Unix Shell scripts.
Analyzed business requirements and develop detailed Test Matrices, Test Scenarios and Test Cases.
As an ETL Tester responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.
Performed Metadata Analysis by Data Profiling and acted as a data steward in maintaining the quality metrics on a continuous basis.Extensively used Informatica Workflow Manager to run the workflows.
Monitored the session logs/log files in Informatica Workflow Monitor.
Participated in Requirement gathering phase with business team for Data migration test
Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
Wrote SQL scripts in TOAD for Oracle and Teradata SQL Assistant for Teradata
Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2005 and Oracle 10g.
Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
Tested the reports developed in Cognos against the database
Involved in Test Scenarios & Test cases authoring in HP ALM QC – Test Plan & Test Lab, Test
SQL Design using Oracle SQL Developer 4.0, Oracle client 11g.
Experience testing SOA with Restful/SOAP Web Services and Create entire architecture for backend testing internal and third party API using Test Complete and SOAP UI.
Performed UI/Reports and Data centric tests for to satisfy business in test SQL server environments
Tested several Informatica Mappings to validate the business conditions.
Testing the source and target databases for conformance to specifications
Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center 10
Used Informatica Power Center Workflow Manager to run the workflows.
Tested UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.
Designed and prepared scripts to monitor uptime/downtime of different system components
Written Test Cases for ETL to compare Source and Target database systems.
Interacting with senior peers or subject matter experts to learn more about the data
Identifying duplicate records in the staging area before data gets processed
Extensively written test scripts for back-end validations
Environment: Informatica, Oracle 11g, TOAD, SQL Server, Teradata, Cognos,ALM, Server, SQL, HP Quality Center, Agile, UNIX, XML, Autosys, PL/SQL
United Health Group, Eden Prairie, MN February 2012 – July 2014
ETL/QA Tester
Responsibilities:
•Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
•Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
•Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
•Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
•Extensively worked on Oracle 10g DB and queried the DB using TOAD.
•Performed back-end testing on the Oracle database by writing SQL queries.
•Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
•Performed Integration Testing and Batch Testing in QTP
•Developed Test Plans with the QA team and helped develop test scenarios for system testing and integration testing.
•Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in Sql Server Database.
•Performed MS SQL Server T-SQL Queries, creating Tables, and Views by following Teradata Best Practices.
•Experience in using Automation Tool Quality Center (QC) in Client/Server.
•This work will include loading of historical data onto the Teradata platform, as well as reference data and metadata.
•Tested the Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
•Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
•Tested the Oracle PL/SQL testing programs
•Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
•Tested the XMLs feeds received from another source which is a third party for data consistency.
•Tested the ETL with XML as source and tables in the data warehouse as target.
•Tracked defects to closure by coordinating with the dev team.
•Tested source data for data completeness, data correctness and data integrity.
•Performed End to end testing starting from the source to the report.
•Conducted and coordinated integration testing and regression testing.
•Participated in business requirements gathering and in modifications of the requirements based on the scope.
•Worked with the DSO team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
•Prepared test data to cover all the test scenarios.
•Prepared UNIX scripts to run the informatica ETL jobs from command line.
•Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
•Tested the migration of reports from Business objects XIR2 to XIR3.
Environment: Informatica, Oracle 11g, TOAD, SQL Server, QTP, Oracle 10g, Teradata, Agile, SQL, HP Quality Center, PL/SQL, Business Objects, UNIX, Rational Clear Quest, Autosys
EXTEDO, INC.
Jr. QA/ Validation Services Jan 2010- Feb 2012
EXTEDO is a leading Regulatory Information management and global electronic data solution provider with 700 + life science customer including 35+ regulatory authorities.
Responsibilities:
Supporting the installation and implementation of EXTEDO products.
Gaining a deep understanding of the regulatory environment of EXTEDO products, and applying that knowledge to help client’s better leverage our products.
Assisting Clients with technical and product functionality inquiries.
Prepared the Test Plan, Test data and Testing Strategies for EXTEDO’s Application
Working closely with QMS team enhancing the Validation/test scripts and SOP’s.
Validate EXTEDO’s application to see if it meets the required business requirement for provided by the clients.
Worked with Clients during migration of DMS products to check the Correctness and Completeness during the migration.
Worked directly with clients during submissions to the governing body, to make sure that there are not any issues during export.
Performed Validation activities on several projects involving authoring and where applicable execution of SOP’s, validation protocols, functional requirement specifications, user requirement specifications, installation qualification, operation qualification, performance qualification, master validation plan and master test plan strategy.
Working closely with the Product owners, Development and Support team to discuss about the enhancements and bug defects.
Environment: eCTDmanager, eSUBmanager, RImanager, Veeva Vault, MS Share Point, MS SQL Server, MS Word, Adobe Acrobat, TFS, Microsoft Dynamics CRM
Contact this candidate