We provide IT Staff Augmentation Services!

Etl Test Resume

Brooklyn, NyC

PROFESSIONAL SUMMARY:

  • Over 6 years of experience ETL, database and manual testing in various domains such as Healthcare, Public Safety. Proficient in SDLC including analyzing business requirements, test strategy preparation, test plan development, Test Design, Test Execution, Defect Reporting and Tracking.
  • Experienced in implementation of different QA methodologies, plans and strategies in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
  • Extensively used SQL queries for data validation and backend testing.
  • Experience on writing SQL using JOINS, UNION and Date, Inner Queries
  • Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
  • Extensive experience in Informatica suite of products, Informatica Power Center (9.0).
  • Extensive experience in ETL Process, consisting of data transformation, sourcing, mapping, conversion and loading.
  • Experience in testing SOAP and REST API using SOAP UI and Postman Tool.
  • Understanding of REST API Method and JSON format
  • Excellent hands on experience on Data Migration, Data Completeness, Data Cleansing, Scrubbing and Aggregating.
  • Experience in Review mapping transformations documents with respect to ETL processes.
  • Preparation of Test Cases based on ETL Specification Document, Use Cases, Low Level Design document.
  • Experience in reviewing and analyzing the Business, Functional requirements for developing Test Plan, Test strategies, Test cases, Test data, Test procedure, Test reports.
  • Experience in different types of testing such as Integration testing, System testing, Smoke testing, Regression testing, Black box testing, Performance testing, Functional testing, GUI testing, Database testing, Web/UI and User Acceptance Testing.
  • Worked on HADOOP using Cloudera VM, Hive, HDFS, SQOOP, HBASE
  • Worked on AWS components like: S3, EC2, CloudWatch, CloudFront.performed testing on AWS.
  • Expertise on Agile Environment and tested the application under SCRUM (Agile) Methodology.
  • Proficient in HP QC/HP ALM, and JIRA tools,Query surge for data warehouse testing.
  • Thorough understanding of Data Warehouse concepts like Star Schemas, Facts, Dimensions.
  • Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

Test Approaches: Waterfall, Agile/SCRUM, SDLC, STLC

Testing API s: SOAP/REST API test using SOAP UI and Postman chrome tool

Test Management Tools: HP QC/HP ALM, JIRA

ETL Tools: Informatica Power Center 9.0

Informatica Suite: Informatica Power Center 9.0

Databases: Oracle

IDE: Toad, SQL Developer

Operating Systems: Windows, UNIX, LINUX

Big data testing: Hive,Hdfs,Mapreduce,yarn,Sqoop,Hbase

PROFESSIONAL EXPERIENCE:

Confidential, Brooklyn, NYC

ETL Test

Responsibilities:

  • Strong Expertise in the Software Development Life Cycle (SDLC), Test Management and Testing Lifecycle Methodologies like Waterfall, Agile, Software Testing Lifecycle (STLC) and extensive experience with QA testing procedures, processes, and standards.
  • Participated in the reviews of Business requirements, design documents, data models, mapping specifications.
  • Provided approval for ETL design specification, technical documents, source to target mapping documents from testing perspective.
  • Prepared test strategy document for ETL tasks and traceability matrix with respect to test cases.
  • Created mapping as per the requirement and transformed the data coming from different source in the design module,executed workflow and monitored the workflow logs using Informatica power center tool,scheduling transformation jobs for enterprise data warehouse.
  • Defining entrance and exit criteria for code and data migration into test and production environment.
  • Involved in Test Strategy Development, Test Planning, Test Design, Test Execution, Defect reporting, Test Status Reporting, Test Closure Activities.
  • Proficiency in Functional Testing, Positive and Negative Testing, Integration Testing, System Testing and Regression Testing of Web Based Applications.
  • Involved in Troubleshooting and Performance Tuning of ETL Workflows and Database (SQL/PLSQL) Objects which reduced 30% of the run time.
  • Expertise in Documentation of Use cases, Test Plans, Test Scenarios, Test Cases and Test Metrics.
  • Proficient in testing tools such as JIRA, QC/ALM, and defect tracking software such as Bugzilla.
  • Performed various types of testing include Unit testing, Functional testing, User Acceptance Testing, Integration testing, System testing, Performance testing, Exception testing, Compatibility testing for web based application.
  • Hands on expertise in writing complex SQL statements in order to validate and verify back end to front end testing.
  • Ability to learn and adapt to new tools and technologies very quickly
  • Worked in HADOOP environment to move data from local file system to HDFS, Hive, HBASE (NoSQL) for providing data analytic, processing and reporting
  • Used HiveQL
  • Knowledge of SQOOP

Environment: ETL, Testing, Application Compliance

Confidential, Brooklyn, NYC

ETL Test

Responsibilities:

  • Test Data creation to verify the data in UI
  • Provided extended technical support to Business to run UAT testing.
  • Track UAT testing progress.
  • Tested REST API using postman chrome browser tool
  • Effectively driven and coordinated defect tracking calls with Developers, Business, vendors and cross application teams and used to represent testing team for defects logged.
  • Participated in deployment activities to ensure the smooth flow of sample production order from End to End application.
  • Derived test design specifications and use case documents based on Business requirements.
  • Supported Complex ETL Workflows that interact with Oracle, and SQL Server databases.
  • Involved in Maintenance of ETL, Database and Reporting artifacts.
  • Worked under high pressure and challenging situations where QA team plays major role in delivering bug free products to production and end users.

Environment: s: Web Server(WebLogic), Mobile App, Oracle Database 11g, SQL Developer, Web App

Confidential, Brooklyn, NYC

ETL Test

Responsibilities:

  • Functional testing of placing the order and validating the HL7 message to make sure HL7 message has same information which is selected in UI
  • Validating the order from database to make sure it store correct information in the database
  • Wrote script to validate the order and order result to find any discrepancy in order result
  • Provided extended technical support to Business to run UAT testing.

Environment: s: Testing & Production Support, Project Management, Business Analysis, ETL, Informatica, ALM, UAT.

Confidential, Bentonville, AR

ETL Test

Responsibilities:

  • Drafted Test Plan which included testing objectives, testing phases, scenarios and test environment after a thorough analysis of the business requirements.
  • Tracking of test cycle progress and sending consolidated reports to higher management.
  • Tested reference data and data quality and involved in testing the data in Informatica 8.6.1 Environment.
  • Worked closely with business analysts and third party vendors to understand user requirements.
  • Reviewed the documents with the product owner to understand the process.
  • Data warehouse (ETL) testing including workflows ensuring data is intact starting staging till dimensions and facts.
  • Written test cases for ETL to compare source and target database systems.
  • Reviewed the ETL Mapping Sheet and identifying the test scenarios.
  • Verified that all tables and specified fields were loaded from source to staging.
  • Verified the data transformation from source to destination works as expected.
  • Executed Test Cases with respect to Source and Target database tables
  • Extensively worked with flat files and excel sheet data sources.
  • Ensured Error logs and audit tables are generated and populated properly
  • Verify data base for accuracy of orders downloaded from upstream application using SQL queries.
  • Coordinated UAT efforts with business teams from different regions around the globe.
  • Design and development of test suites and maintenance using HPQC

Environment: s: ETL, Informatica, Testing & Production Support, Project Management, Business Analysis

Hire Now