We provide IT Staff Augmentation Services!

It Sr Qa Analyst Resume

2.00/5 (Submit Your Rating)

CA

Hire Now

SUMMARY

  • 8 years of experience as Big data Technologies ETL/DWH, and Data Analysis in multinational companies
  • 8 years of experience in Data warehousing concepts and Entity - Relationship concept, Facts and dimensions tables concepts, slowly changing dimensions (Star Schema and Snowflake Schema)
  • Microsoft Certified: Azure Fundamentals
  • Automated test using SQL and QuerySurge tool for regression and data migration testing
  • Won ‘Expertise Awards’ for two Quarters 2016 in United Health Group (UHG) for handling 5 new enhancement request projects during enrolment period and being a part of Testing-center of excellence (COE) team

TECHNICAL SKILLS

Technology: ETL/DWH, Big data

Cloud Technology/Tools: Microsoft Azure, ADLS

ETL Tools: Informatica, SSIS

Operating Systems: Windows

Test Management Tool: HP ALM, Bugzilla, Jira, TestRail

Databases: SQL Server, Netezza, Data bricks

Langages: SQL

Methodology: Agile-Scrum

PROFESSIONAL EXPERIENCE

Confidential, CA

IT Sr QA Analyst

Responsibilities:

  • In depth knowledge of Testing methodologies, concepts, phases, and types of testing, developing Test Plans, Test Scenarios, Test Cases, Test Procedures, Test Reports and documenting test results accordingly after analyzing Business Requirements Documents (BRD), Functional Requirement Specifications (FRS).
  • Experience in usingMicrosoft Azure, ADF, ADLS, Azure Blob, COSMOS, Logic app
  • Good experience in testing pipelines usingAzure Data Factoryand moving the data intoAzure Data Lake Store.
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Involved in testing the data migration in Azure cloud from ADLS Gen 1 to ADLS Gen 2
  • Experience in validating and analyzing partitioned log files.
  • Experience in loading multiple larger datasets into Data lake and processing the datasets in test environment
  • Performed Integration testing of Hadoop for ingestion, transformation and loading of massive unstructured data
  • Communicated with different stakeholders, business group, and user group to elicit and to analyze business requirements
  • Collaborated on insights with Data Scientists, Business Analysts and Partners
  • Involved in testing the ADF by placing raw file in storage containers and checking the data flow
  • Validated data using Azure resource group, ADF (data flow) and Data Bricks (data validation)
  • Diagnosed high-level design specification to simple coding along with business standards
  • Checked the source and target count, duplicate check, data validation, table structure validation and constraint validation
  • Proficient in Defect Life Cycle Management tools including defect creation, modification, tracking and reporting using Jira, Test rail

Confidential, CA

Senior QA Analyst

Responsibilities:

  • Collaborate with QA, Developers, Business Analysts and Project Team to ensure that issues and risks are identified, logged and resolved
  • Validated data, by applying the transformation logic given in the mapping document running the workflow and tested the target data
  • Checked the source and target count, duplicate check, data validation, structure validation and constraint validation
  • Inspected error log to identify the errors generated and involved in troubleshooting the bugs
  • Analyzed and reported defects with HP ALM and participate in the defect triage meetings
  • Participated in design walkthroughs to understand the functional requirements
  • Involved in importing the data from DB2 database to IBM Netezza to validate source and target data
  • Automated ETL Validation(T-SQL) to check the ETL process from source to target database
  • Handle responsibilities of developing test cases for business surveillance models as well as perform management of defect tracking process
  • Responsible for testing the modules and component parts of the application to ensure that it functions properly
  • Performed troubleshooting the stored procedures if any error occurred
  • Coded and executed T-SQL queries to verify ETL process from ERP to target database

Confidential

Reporting Analyst

Responsibilities:

  • Handled multiple tasks, meet deadlines and decisive with strong leadership qualities, flexible in work schedules and possess good communication skills
  • Contributed in all phases of software development life cycle (SDLC) by conducting meetings and explaining the changes done by the client in business requirement document and communicating with developer, tester, production, user training and support for production environment
  • Collaborated with clients through calls and Emails in gathering the business requirements
  • Spearheaded warehouse metadata by naming warehouse standards for future application development
  • Coded and executed SQL queries to verify ETL process data in target database
  • Analyzed and deep research in data, for is high increases or decreases in data counts
  • Inspected error log to identify the errors generated in mapping and involved in troubleshooting
  • Validated source and Target data based on source to target column mapping document

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship