Sign In
Looking for talent?
Check out our hiring section
Login to your account
Remember me?
Login
Forgot password?
Not a user yet?
Click here to register.
LOADING
Select Login
Uploaded File
Shilpa
shilpa6308@gmail.com
732-421-5651
New Brunswick, NJ 08989
Quality Assurance Engineer
16 years experience
W2
0
Recommendations
Average rating
107
Profile views
Summary
13 years of total IT Experience.
13 Years of QA Experience.
13 years of IT experience in the Analysis and testing Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Web and Desktop applications
Experience using databases like Oracle, MS SQL Server, Postgress, DB2, Sybase IQ, Teradata, TSQL and to validate ETL loads reports and troubleshoot data quality issues.
Extensive testing ETL experience using DataStage 8.1, Informatica, MDM, Informatica BDM, Informatica 10.4/9.6 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager), SSIS.
Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading . Documenting and reviewing results.
Involved in End-End Testing, Smoke Testing, System Integration Testing and Regression Testing.
Experience with Software Development Life Cycle (SDLC) with good working knowledge, disciplines, tasks, resources and scheduling.
Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
Strong working experience in the Data Analysis, Design, Development, Implementation of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL) concepts
Extensive experience in Data Analysis, Data Cleansing, Requirements gathering, Business Analysis, Data Mapping, Entity Relationship diagrams (ERD), Architectural design docs, Functional and Technical design docs, and Process Flow diagrams
Strong experience with Agile Methodology and Water Fall Methodology.
Extensively used Jira, Rally, Version One for creating User stories and tracking the Task status and Defects. Involved in Scrum, Grooming, Planning and Retro sessions.
Experienced creating Test Plan, Test Strategy, Test Scenarios, Test Scripts and Test Results documents. Experienced using Silk Central Test Manager (SCTM), HP ALM Confluence for test case creation for Business review
Application Data warehousing experience in Financials, Health Insurance, Health Care, Securities, and Investments domains.
Extensive knowledge on HIPPA 5010, EDI 837, 834 files and ICD 9.
Experience in testing Business Intelligence reports generated by various BI Tools like Power BI, OBIEE, Business Objects XI R2/3.1 and Qlik Sense.
Extensively used ETL methodology for analysis, testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
Extensively used Informatica Power Exchange 9.5.1 to read the EBCDIC files based on the Datamaps.
Involved in MDM, Database, ETL/ BI, API, Web Applications, Desktop Application and IVR Testing.
Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
Extensively wrote completed SQL and PL/SQL statements.
Experienced in Automating the Data warehouse testing using SAS EG.
Experienced using Automation framework to automate test cases.
Expertise in Developing PL/SQL Packages, Stored Procedures/Functions.
Expertise in utilizing tool and expertise in Toad, SQL Developer, PG Admin, DBeaver, AuqaData Studio, SQL server Managemnet studio, Win SQL Testing tool like QuerySurge for querying and testing applications.
Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
Experience in Performance Tuning of SQL and Stored Procedures.
Good analytical and problem solving skills.
Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.
13 years of IT experience in the Analysis and testing Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Web and Desktop applications
Experience using databases like Oracle, MS SQL Server, Postgress, DB2, Sybase IQ, Teradata, TSQL and to validate ETL loads reports and troubleshoot data quality issues.
Extensive testing ETL experience using DataStage 8.1, Informatica, MDM, Informatica BDM, Informatica 10.4/9.6 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager), SSIS.
Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading . Documenting and reviewing results.
Involved in End-End Testing, Smoke Testing, System Integration Testing and Regression Testing.
Experience with Software Development Life Cycle (SDLC) with good working knowledge, disciplines, tasks, resources and scheduling.
Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
Strong working experience in the Data Analysis, Design, Development, Implementation of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL) concepts
Extensive experience in Data Analysis, Data Cleansing, Requirements gathering, Business Analysis, Data Mapping, Entity Relationship diagrams (ERD), Architectural design docs, Functional and Technical design docs, and Process Flow diagrams
Strong experience with Agile Methodology and Water Fall Methodology.
Extensively used Jira, Rally, Version One for creating User stories and tracking the Task status and Defects. Involved in Scrum, Grooming, Planning and Retro sessions.
Experienced creating Test Plan, Test Strategy, Test Scenarios, Test Scripts and Test Results documents. Experienced using Silk Central Test Manager (SCTM), HP ALM Confluence for test case creation for Business review
Application Data warehousing experience in Financials, Health Insurance, Health Care, Securities, and Investments domains.
Extensive knowledge on HIPPA 5010, EDI 837, 834 files and ICD 9.
Experience in testing Business Intelligence reports generated by various BI Tools like Power BI, OBIEE, Business Objects XI R2/3.1 and Qli
Experience
Edit Skills
Non-cloudteam Skill
Education
Master's in Electrical Engineering
not provided
Record has not been verified.
Skills
SQL
2023
12
Oracle
2023
9
PL/SQL
2023
9
ETL
2018
8
Data Modeling
2023
7
Informatica
2019
7
Test Case Preparation
2023
7
TOAD
2023
7
Informatica Powercenter
2018
6
Regression Testing
2023
6
Data Warehousing
2018
5
SQL Server
2019
5
Agile Methodology
2023
4
Integration Testing
2023
4
JIRA
2023
4
PostgreSQL
2023
4
Postman
2023
4
Quality Assurance
2023
4
AWS
2023
3
AWS S3
2023
3
Business Analysis
2019
3
Data Analysis
2019
3
Git
2023
3
JSON
2023
3
Pipeline
2023
3
QA
2023
3
Scrum
2023
3
SQL Loader
2015
3
Test Planning
2019
3
UNIX
2023
3
Cognos
2014
2
SSIS
2012
2
SSRS
2012
2
Data Governance
2019
1
Data Integration
2019
1
Data Management
2019
1
Data Mapping
2019
1
Data Profiling
2019
1
Data Validation
2019
1
DB2
2019
1
Erwin Data Modler
2015
1
ETL Testing
2016
1
Functional Testing
2019
1
Informatica BDQ
2019
1
Informatica MDM
2019
1
Metadata
2019
1
MicroStrategy
2016
1
Requirements Gathering
2019
1
Spark
2019
1
System Analysis
2019
1
834
0
1
837
0
1
EDI
0
1
HP ALM
0
1
OBIEE
0
1
Performance Tuning
0
1
SAS
0
1
Smoke Testing
0
1
Snowflake
0
1
