Top ETL Tester Skills

Below we've compiled a list of the most important skills for an ETL Tester. We ranked the top skills based on the percentage of ETL Tester resumes they appeared on. For example, 21.1% of ETL Tester resumes contained Test Cases as a skill. Let's find out what skills an ETL Tester actually needs in order to be successful in the workplace.

The six most common skills found on ETL Tester resumes in 2020. Read below to see the full list.

1. Test Cases

high Demand
Here's how Test Cases is used in ETL Tester jobs:
  • Analyzed Business requirement document to understand the Business process and prepared test cases.
  • Executed test cases for web-based MicroStrategy reporting application.
  • Created test cases based on Report Design Document (RDD) and tracked the success/failure of the same in Test Director.
  • Executed all the Test Cases in the Test Environment and maintained and documented the test queries and result for future references.
  • Involved in exporting the test cases form Microsoft Excel to Test Director and running the cases remotely in different hosts.
  • Executed all Test cases in different phases of testing like Smoke, Regression, and System testing of the application.
  • Involved in adding Requirements, associating Requirements to the test cases writing and executed test cases using Test Director.
  • Created QTP scripts from the test cases written and also was involved with execution and debugging of the scripts.
  • Reviewed, analyzed FDR, DD documents, developed strategies, test plans, and executed the test cases.
  • Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the developers.
  • Coordinated with QA Testing Team to test various test scenarios involving Test Plans, Test Cases and Test Scripts.
  • Maintained latest version of test cases in Quality Center and ensured that was well communicated within the team.
  • Conducted data validation testing and Developed the Test Plan, Testing Strategy, RTM and Test Cases.
  • Prepared detailed test cases by understanding the business logic and user requirements for manual and automated testing.
  • Involved in development and execution of test plans and test cases for manual testing and automated testing.
  • Developed Test Plans, Test Scenarios and Test Cases to define scope of overall quality assurance testing.
  • Involved in analyzing System specifications, design, development and execution of test plans and test Cases.
  • Involved in writing Test Plan, Test Script and test cases by using the Requirement document.
  • Worked closely on new project requirements and trace it to the test cases in Quality center.
  • Designed and developed unit test cases, configured environments and prepared test data for testing purposes.

Show More

2. Business Requirements

high Demand
Here's how Business Requirements is used in ETL Tester jobs:
  • Developed Test Plans/Test Cases to Validate Key Business Requirements based on the report specification document.
  • Involved in analyzing business needs and document functional and technical specifications based upon business requirements.
  • Prepared and executed automated test scripts as per the business requirements and Requirements specifications Document.
  • Analyzed business requirements, use cases and technical specifications for scripting comprehensive test cases.
  • Performed detailed software Business requirements and technical design reviews to assure comprehensiveness and consistency.
  • Documented Test Requirements and generated Test scenarios based on business requirements using Test Director.
  • Developed Scripts by analyzing the business requirements documents, and technical specifications documents.
  • Attended Client calls for gathering and understanding Business requirements, clarification and analysis.
  • Developed test conditions and test scenarios according to Business Requirements in Quality Center.
  • Interacted with business analysts and business users to gather the business requirements.
  • Understand business requirements and High-level design and detailed level design document.
  • Involved in various meetings with Business Analysts and updated Business requirements.
  • Analyzed Business Requirements, System requirements and determine Business process impacts.
  • Documented business requirements by facilitating sessions between business and technical team.
  • Involved in Requirement review meetings and analyzed the Business Requirements.
  • Analyzed the business requirements and rules from business requirements document.
  • Developed Test Plans/Test Cases to Validate Key Business Requirements.
  • Communicated with business Analysts to understand business requirements.
  • Created Test Cases according to the Business requirements and ensured that all the positive and negative scenarios of testing are covered.
  • Validated the Source, Stage and Target (End-to-End) based on the test conditions derived from the business requirements.

Show More

3. Data Warehouse

high Demand
Here's how Data Warehouse is used in ETL Tester jobs:
  • Performed extensive data validation against Data warehouse.
  • Created Data warehouse test plans, UAT plans, test cases based on the ETL mapping document and functional design documents.
  • Handled SCD Type 1/ Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
  • Tested loaded data warehouse components like ODS (Stage), EDW and data marts tables after the jobs run.
  • Completed full data warehouse life cycle implementation including analysis, design ETL processes, development, and testing;.
  • Ensured all Main Frame and Data Warehouse enhancements and bug fixes are implemented with a high degree of accuracy.
  • Converted the business rules into technical specifications for ETL process for populating fact and dimension table of data warehouse.
  • Involved in writing complex SQL queries to validate data in source and target (data warehouse) database.
  • Executed test scripts to check the data flow from Source tables to Data Warehouse and Data Marts.
  • Experienced in understanding the Data Model in the Data Warehouse that consists of Dimension and Fact tables.
  • Involved in the testing of the source Database and the target Data warehouse to ensure data integrity.
  • Worked on testing and validating of data from data warehouse and sending it to SQL Server 2005.
  • Designed policies, standards and procedures for testing life cycle for the data warehouse and data marts.
  • Project scope involved building an enterprise data warehouse for the client covering its Stocks and Sales.
  • Tested data flow by introducing staging, transaction, and data warehouse and data mart area.
  • Involved in Database, Web - based Application testing in Data Warehouse and Data delivery side.
  • Apply solid understanding of the Software Development Life Cycle, Data Warehouse ETL and QA process.
  • Create SSIS packages to move data from PDW (Property Data warehouse) to Automation server.
  • Tested the ETL Data Stage Jobs and other ETL Processes (Data Warehouse Testing).
  • Tested the web reports by manually Querying data warehouse and comparing the results with Reports.

Show More

4. Pl/Sql

high Demand
Here's how Pl/Sql is used in ETL Tester jobs:
  • Performed the Back-End testing to verify and validate data consistency by writing and executing Oracle PL/SQL queries on the database.
  • Generated and tested reports using PL/SQL, SQL from Data Marts and compared these with the reports generated.
  • Tested Oracle PL/SQL Stored Procedures, Packages, Triggers, Cursors and backup-recovery for the various tables.
  • Performed testing on PL/SQL stored procedures and developed complex SQL queries for data testing.
  • Experience of working with SQL and PL/SQL Procedures, Packages, Functions and Triggers.
  • Worked extensively with SQL, ANSI SQL and PL/SQL queries to test database functionality.
  • Involved in writing SQL scripts and analyzing PL/SQL scripts for effective Data validation.
  • Performed back-end testing using SQL and PL/SQL for data validation.
  • Tested various PL/SQL procedures to validate inbound file process.
  • Created PL/SQL procedures, triggers, views, functions.
  • Tested PL/SQL stored procedures for data loading.
  • Provided design direction and oversight of code development in Ab Initio, KSH and PL/SQL.
  • Use SQL, PL/SQL to test backend functionality.
  • Use SQL, PL/SQL totestbackend functionality.
  • Performed backend testing for Database integrity by executing complex PL/SQL queries for validating the data in the backend database tables.

Show More

5. Target Database

high Demand
Here's how Target Database is used in ETL Tester jobs:
  • Validated data in Target database according to business rules.
  • Verified the financial order information like data in the pricing models against source and target databases by using SQL Queries.
  • Verified the data records by using check sum graph comparing Flat Files and Target Database (TPR).
  • Extract data from flat files, Oracle and load the data into the target database.
  • Worked closely with Development team and Verified the column mapping between source and target databases.
  • Executed ETL scripts to load data from input files to the target database.
  • Executed SQL queries to validate the ETL processed data in target database.
  • Validate the data in Target database systems like ODS and EDW.
  • End data validation of the various sources to the target database.
  • Queried against source and target database objects in ETL testing.
  • Performed column data mapping between source & target database.
  • Validated the data loaded into the target database.
  • Validated the data in target database and staging area from backend.

Show More

Job type you want
Full Time
Part Time
Internship
Temporary

6. Unix

high Demand
Here's how Unix is used in ETL Tester jobs:
  • Extracted data from multiple sources like flat files, web services, SQL Server and Oracle in UNIX platform.
  • Created Jobs to Written several UNIX Shell Scripts for cleanup, logging, file manipulation and transferring the files.
  • Used predefined UNIX scripts for file transfer and file manipulation as part of Test Data preparation.
  • Tested UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
  • Involved in developing UNIX and VB scripts for testing and documented complete software testing process.
  • Used UNIX commands to validate the Unix Script files and the parameter files.
  • Modified the UNIX scripts for Testing purpose to check the Rollback mechanism.
  • Developed UNIX scripts to validate the flat files and target table data.
  • Performed Integration, Regression testing and flat file validation using UNIX.
  • Experience in creating UNIX scripts for sending mails if any issues.
  • Created Unix scripts to do the regular jobs in Unix environment.
  • Experience with various UNIX Commands for checking and manipulating files.
  • Performed Shell scripting in UNIX for extracting the test data.
  • Created automated Unix Shell scripts to run data validation jobs.
  • Involved in developing, debugging and executing Unix Shell scripts.
  • Used UNIX Commands to compare source and target data.
  • Experienced in writing and testing the UNIX shell scripts.
  • Developed UNIX scripts for file transfer and file manipulation.
  • Executed Unix Shell Scripts for automating the Batch sessions.
  • Developed automated test scripts using UNIX shell programming.

Show More

7. SQL

high Demand
Here's how SQL is used in ETL Tester jobs:
  • Performed additional data validation using custom SQL scripts.
  • Experience in Data Migration, Database Transferring and related objects in SQL Server from one server into other Remote servers.
  • Analyzed and created test data using SQL queries to Insert and Update the data from the source to target databases.
  • Created the Unix Shell script to load the high volume flat files data into staging tables using Oracle SQL* Loader.
  • Developed and maintained SQL Scripts using SQL Developer to verify data in the database matched date in the front end.
  • Validated Audit tables and triggers created on SQL server side to find the incremental data for the policy data mart.
  • Designed and developed all use cases and implemented basic SQL queries for QA testing and report / data validation.
  • Tested the Transformation rules from source to target tables by running simple and complex SQL queries on oracle database.
  • Developed Data Stage parallel jobs to load data from sequential files, flat files and MS SQL Server.
  • Created SQL queries to verify the database updates, inserts and delete of the records and validate reports.
  • Optimized query performance using explain Plan to improve the performance of SQL queries used in test scripts.
  • Involved in testing of data merging activities like vertical merging and horizontal merging by using SQL unions.
  • Write complex SQL queries to perform data validation for RI checks for history and incremental loads.
  • Participated in testing and writing various reports and validation of the data by using SQL queries.
  • Verify the source to target data movement and verify the target data by writing SQL queries.
  • Involved in ETL & Report testing, executed SQL queries to validate data in target database.
  • Investigated and queried data by writing complex SQL scripts to help development team fix the defects.
  • Developed SQL joins, sub queries, tracing and performance tuning for better performance of queries.
  • Created User Documentation for SQL Query & Developed strategy to execute the same in sequence.
  • Tested database tables using SQL Queries to make sure that the data is correctly populated.

Show More

8. Informatica

high Demand
Here's how Informatica is used in ETL Tester jobs:
  • Worked with INFORMATICA Power Center to review and resolve data related issues.
  • Profiled the data using INFORMATICA DATA EXPLORER.
  • Used Informatica Data Validation which reduces the time required for data validation and production data auditing and verification.
  • Migrated Unix/Informatica application releases from development to QA and to UAT environments as required.
  • Used Informatica partition components to achieve parallel data transformations and filtering.
  • Executed Informatica mappings in test environment and validated business functionality.
  • Tested multiple Informatica mappings for data validation and data conditioning.
  • Fine-tuned existing Informatica mappings for Performance Optimization.
  • Performed unit testing by running Informatica sessions.
  • Installed and configured Informatica client.
  • Tested and validated Informatica mappings.
  • Analyzed the AR data and developed the code to extract the data for the AR module and implemented in the informatica.
  • Monitored the data movement process through Data Extract to flat files through Informatica execution flows and Loading data to Data mart.
  • Utilized Informatica Power Center designer to analyze mapping, sources, source transformations, expressions, aggregations, filters and targets.
  • Resolved production issues by performing testing and debugging of Informatica mappings and created test data for various test cases.
  • Involved in smoke testing while migration of various Informatica, DPA and Oracle objects from development to QA.
  • Tested conversion of existing processing of data in to Informatica mappings and load all tables into Landing/Staging area.
  • Worked closely with users, decision makers to develop the transformation logic to be used in Informatica PowerCenter.
  • Tested the Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
  • Worked on Informatica- Source Analyzer, Source Qualifier, Data warehousing designer, Mapping designer and Transformation.

Show More

9. Toad

high Demand
Here's how Toad is used in ETL Tester jobs:
  • Experienced using database query tools for Oracle, SQL and UNIX such as TOAD and SQL Plus.
  • Performed extensive Report Testing of the reports generated by COGNOS using Query Studio and Toad.
  • Used Toad and SQL Plus for testing execution of ETL Processes for business rules.
  • Used TOAD for Oracle in creating and executing SQL queries for testing ETL process.
  • Test Business Objects reports for data validations and compare results with TOAD.
  • Validate the data using SQL queries (TOAD) extensively.
  • Used TOAD & SQL Navigator tools for Querying Database.
  • Validated Data ware house tables using Toad.
  • Used Toad to interact with Databases.
  • Used TOAD, DB Artisan tools(9.0) to connect to Oracle database to validate the data.
  • Worked on SQL tools like TOAD, Rapid SQL to run SQL queries to validate the data.
  • Used Toad, SQL Developer to connect oracle and Sybase databases and tested PL/SQL store procedures as part of QA validation.
  • Have found critical defect by writing the critical sql query in all the projects using toad and QMF application.
  • Developed nested Queries and performed data loss or truncation testing using Oracle 10.g Performed Data Validation Testing using TOAD.
  • Worked on the Functional and Integration testing TOAD is used to perform manual test in regular basis.
  • Reported bugs and tracked defects using Quality Center Used TOAD Software for Querying the databases.
  • Experienced in writing SQL queries for extracting data from multiple tables by using Toad tool..
  • Validated mapping of Informatica using TOAD.
  • Used TOAD Software for querying the databases Developed SQL queries on Oracle to setup test data and review test results.

Show More

10. Windows XP

high Demand
Here's how Windows XP is used in ETL Tester jobs:
  • Supported software testing and validation for translating English web based training applications into various foreign localized training versions using Windows XP.
  • Involved in cross OS testing using Windows XP, Vista and Apple Mac.
  • Tested web-based application on different operating systems such as Windows XP, Vista and UNIX.
  • Installed Windows XP and Windows 7 and Windows 8.
  • Manage security software and applications on Windows XP, Windows Vista, and Windows 7.
  • Conducted browser compatibility tests using IE7 and Mozilla and tested the application on Windows XP.

Show More

11. Teradata

high Demand
Here's how Teradata is used in ETL Tester jobs:
  • Tested and modified UNIX shell scripts, Teradata scripts to perform initial data validation before the data enters into the system.
  • Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending and show me functionality.
  • Tested change request that have been incorporated for CUSTOMER related tables and Common dimensions in DPA and Teradata environment.
  • Performed ETL testing using Data stage ETL tool for data coming from different sources in Target Teradata System.
  • Created the test graphs to extract the data from the Teradata tables by using the Fast Export utility.
  • Created Batch processes using BTEQ, UNIX and Teradata SQL to transfer, cleanup and summarize data.
  • Specialized in Testing Database of Data warehousing Applications in Oracle, Teradata, MS SQL Server.
  • Tested all the extracted data from Teradata database that is transformed and loaded into target database.
  • Tested the source and target systems Extracted data from Teradata tables and upload to Oracle.
  • Involved in using Sub Queries, Joins, Functions and Set Operations in Teradata.
  • Worked as a contractor through QSSI, Inc. on the IDR project to Teradata.
  • Used Teradata utilities to load the sample test data in to target tables.
  • Verified different scripts like MULTILOAD and FASTLOAD in Teradata and prepared Test Cases.
  • Performed Audit balancing check to validate count check on impacted Teradata tables.
  • Project - #3 Title: Allstate Investment Data Base: Teradata
  • Verified the data in Teradata database with BRS Document.
  • Learned to execute query in Teradata studio express.
  • Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region.
  • Tested Teradata tables (SET & MULTISET) to load the source files in to test region.
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning Managed and executed the test process, using Agile Methodology.

Show More

12. XML

high Demand
Here's how XML is used in ETL Tester jobs:
  • Created and developed test cases to test the web application called e-shopping based on HTML, XML and JavaScript.
  • Performed Web Services Testing and XML validation by creating test suite using SOAP UI for Security Application communication.
  • Worked on the design of SOAP, an XML-based messaging framework which is the foundation of Web services.
  • Tested the XML files transformation as per Business ad load it into Flat File as Target.
  • Tested both inbound and out bound XML files and prepared analysis document with various results.
  • Experience in testing XML files and validating the data loaded to staging tables.
  • Performed Web Services testing and Validated XML request/response data using SOAP UI.
  • Transformed data from various data sources like XML and flat files.
  • Parsed XML files using the event XML approach.
  • Validated XML Documents before sending the Message Bus.
  • Created a job that creates the XML file, and sends the file via secure ftp.
  • Involved in testing the B2B (XML) based applications using QTP and SOAP UI.
  • Extracted data from various sources like Oracle, XML, Excel and COBOL Flat Files.
  • Worked with SSRS XML export on the reports and with ranking values in the XML.
  • Tested Web Services, XML, WSDL, and Restful Services using SOAP UI.
  • Web Technologies JSP, ASP, XML, HTML, and DHTML.
  • Worked with XML, VSAM, CSV and Flat File sources.
  • Prepared reusable function in QTP to use across the automation scripts Involved in Installation testing and Transformation of XML documents.
  • Worked with SOAPUI for testing Web Services Generated XML data files using XML Spy.
  • Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF and many other.

Show More

13. QA

high Demand
Here's how QA is used in ETL Tester jobs:
  • Experienced on creating test designs by using ALM/quality center and tracked the defects and reported the defects to the QA lead.
  • Documented Defects found during test on the Quality center and communicated, recorded problems to the responsible QA or development personnel.
  • Mentored and leads the QA team members in the review of requirements, technical designs, test cases and defect tracking.
  • Test Closure: o QAC Preparation o Test Summary Report o Retrospective Meetings - To discuss on the Lessons learned.
  • Supported as QA in reporting test cases and defect metrics to all levels of the organization using Quality Center/ ALM.
  • Conducted walk-through with the Business Analysts and QA Managers to clarify critical issues related to the Business Requirement Document.
  • Assign and distribute work to offshore team members, get the status and report to QA & Project Managers.
  • Collaborated with QA staff on using documentation standards in the development and review of Test Plan and test cases.
  • Updated QA Manager and Lead weekly with the testing status, which included Test Task Plan, Defect Management.
  • Communicate the status of projects to the QA Manager, QA Lead, and Project Manager(s).
  • Performed QA Testing in distributed UNIX/ Windows Environment, Oracle databases as back end and performed end-to-end testing.
  • Developed Test Plans with the QA team and helped develop test scenarios for system testing and integration testing.
  • Collaborated with Project Manager and QA Lead to monitor and communicate status of showstopper and high severity defects.
  • Prepared the Test data bed for testing the ETL jobs in QA environment for verifying different test scenarios.
  • Worked closely with the project team in planning, coordination and implementing QA methodology in Agile Environment.
  • Provided comprehensive QA testing reports (detailed and summary) to the QA Manager and Project manager.
  • Attended Daily Release Planning Meeting with Developers and QA Team to discuss Software changes and configuration management.
  • Involved in maintaining QA lab and tested the application on different Operating systems and IE browsers.
  • Collaborated with all QA analysts, developers and project managers for gathering metrics and status reporting.
  • Worked closely with the QA Manager in coordination and implementation of the QA methodologies/QA processes.

Show More

14. DB2

high Demand
Here's how DB2 is used in ETL Tester jobs:
  • Used Rapid SQL tool for query the DB2 data and verified the results.
  • Worked with data validation and testing of SQL and DB2 databases.
  • Used Informatica and tested extraction from legacy, XML's, Flat Files and DB2 based sources.
  • Involved in Test Summary Report preparation Used SQL for Querying the DB2 database in UNIX environment.
  • Worked in an Agile technology with Scrum Compared datamart tables from Oracle against source tables from DB2 and SQL Server.
  • Created documents outlining steps for loading/unloading DB2 data in test environment for use in company's international operations.

Show More

15. UAT

average Demand
Here's how UAT is used in ETL Tester jobs:
  • Facilitated UAT readiness meetings and Production readiness meeting to mitigate issues and outline defect deferral process to facilitate progress.
  • Conduct both QA and UAT test cases and test scripts for both external and internal agents and performed QA Testing.
  • Developed and Executed the Test cases & Scripts for Functional, System, Regression, Integration, Performance and UAT.
  • Performed smoke testing when migration requests to move the changes from development to QA / UAT / production environment.
  • Involved in Integration testing, UI, User Acceptance Test (UAT), Functionality testing & Performance testing.
  • Involved in various process flows of UAT between the 2 systems and reporting to the PMO of all findings.
  • Worked on SQL scripts to load data in the target tables and also worked on writing UAT Test cases.
  • Migrated and deployed the ETL code in SIT, UAT & production environments in accordance to the control standards.
  • Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, UAT and Regression testing.
  • Participate in the creation of Test Scenarios & Test Cases with the UAT Team and the Business Analysts.
  • Participated in documenting defects, resolved defects and coordinated with UAT team to get sign-off for the application/project.
  • Provide on call support to the UAT team and the business teams involved in the UAT testing.
  • Involved in all phases of SDLC and give support to UAT team to perform their validations.
  • Involved in User Acceptance Testing (UAT) and also involved in end to end testing.
  • Created a complete test bed for User Acceptance Testing (UAT) in Mercury Quality Center.
  • Designed the test plans, test scripts, test scenarios and test data for UAT testing.
  • Performed Reports Validation and Verification across different environments (SIT, UAT and Prod).
  • Conducted down test and up test for release builds pushed to UAT and to Production.
  • Involved in Unit, System, Integration, Regression, Load and UAT Test phases.
  • Create the release document and pass it over to business for UAT and code deployment.

Show More

16. HP Quality

average Demand
Here's how HP Quality is used in ETL Tester jobs:
  • Keep track of the defects opened in HP Quality Center and retesting the defects once they are fixed by the developer.
  • Designed and executed the test cases on the application as per company standards and tracked the defects using HP Quality Center.
  • Supervised sanity test in multiple environments for various stages of the system and streamlined defect management process using HP quality center.
  • Used HP Quality Center for updating the test cases, requirements and also execution of test cases and defect tracking.
  • Used HP Quality Center to perform Manual Testing and logging and tracking defect in BugZilla until the bug was fixed.
  • Create Test cases in HP Quality Center to write test cases, analyzed the results, track defects in QC.
  • Monitored the entire process and provide reports and notifications to keep track of defect control system using HP Quality Center.
  • Used HP Quality Center 9.2 for Requirements, Test case repository; Test execution and Defect Tracking.
  • Generated Test Report (Results) from HP Quality Center for Test Plan and Defect Analysis.
  • Used HP Quality Center to log, monitor, and update defects found during testing.
  • Reported the bugs, E-mail notifications to the developers using the HP Quality Center.
  • Create scripts, track defects, and create reporting using HP Quality Center.
  • Used HP Quality Center for writing the test cases and logging the defects.
  • Established HP Quality Center 9.2 for Test management and execution of test cases.
  • Tested Micro Strategy reports and written test cases using HP Quality Center.
  • Reported bugs through HP Quality Center and prepared bug status reports.
  • Prepared detailed Test Scenarios and Test Cases in HP Quality Center.
  • Used HP Quality Center for bug reports and defect tracking.
  • Raised defects in HP Quality Center/HP ALM defect tracking system.
  • Utilized HP Quality Center for test plan creation and execution.

Show More

17. Cognos

average Demand
Here's how Cognos is used in ETL Tester jobs:
  • Enable customized analysis for benefit plan administrators and executives at their fingertips with Cognos Web Reports, eliminating programmer intervention.
  • Scheduled various reports using Schedule Management used in Cognos Connection.
  • Develop Daily Annual Enrollment and Health Plan Migration Cognos Cubes & Reports for 250 clients.
  • Used Framework Manager to build models, packages and publish packages to the Cognos connection.
  • Compared and validated Reports Generation with Query Outputs using SQL Scripts and Cognos.
  • Tested the reports generated by Cognos reporting studio and validated the reports.
  • Validated Cognos Standard Reports created based on Frame work manager and Cube.
  • Performed End User Data Validation on Cognos as a Reporting Tool.
  • Validate Reinsurance and Ultimate cognos cubes as per the business requirement.
  • Tested reports in Cognos using Analysis studio, Report studio.
  • Validated prompts, filters and other features in Cognos reports.
  • Validated reports cosmetic like color, size in cognos reports.
  • Validate various Cognos reports generated for ADM and IBNR application.
  • Test cases for Cognos reports based on report specifications.
  • Used Cognos reporting tool to validate the reports.
  • Involved in testing various reports created using Cognos.
  • Tested many reports developed in Cognos 8.0 series.
  • Tested Complex Reports in Cognos Report Studio.
  • Tested packages using Cognos reporting tool.
  • Involved in Cognos performance tuning.

Show More

18. Data Integrity

average Demand
Here's how Data Integrity is used in ETL Tester jobs:
  • Implemented various integrity constraints for data integrity such as referential integrity using primary key and foreign keys relationships.
  • Performed Black-box testing, White-box testing, System testing, and Data Integrity Testing, Regression and end-end testing.
  • Created and executed SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data.
  • Worked with various team for testing data quality, data integrity, data consistency, and data validation.
  • Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing and end to end Testing.
  • Prepare the Test plan and execute the Test cases to ensure the Data Integrity of DW.
  • Created test scripts to validate data across servers after server migration to ensure data integrity.
  • Verified data integrity using SQL commands for testing the database.
  • Performed Data integrity between the various source tables and relationships.
  • Automated frequently used test cases using QTP Extensively used SQL and PL/SQL for data Integrity testing at the backend.

Show More

19. User Acceptance

average Demand
Here's how User Acceptance is used in ETL Tester jobs:
  • Performed User Acceptance Test for the developed system application to verify requirements functionality.
  • Involved in Performance testing, Regression testing, Unit testing, System testing and User Acceptance Testing.
  • Coordinated with Fixed Income, Equity and Foreign Exchange Operations staff to support User Acceptance Testing.
  • Attended functional test meets, user acceptance sessions and worked on the gathered inputs.
  • Perform Functional, Data Validation, Integration, Regression and User Acceptance testing.
  • Conducted Functional, System, Regression, and User Acceptance Tests.
  • Performed user acceptance testing after the migration of universes.
  • Involved in performing User Acceptance Testing of the application.
  • Performed User Acceptance testing in TEST and PROD environment.
  • Performed User Acceptance testing, Data Base Testing.
  • Facilitate System, Regression and User Acceptance Testing.
  • Performed user acceptance testing of the reports created.
  • Support during System Test/User Acceptance Test/User Confirmation Test/Production phases.
  • Executed Batch jobs in UNIX as background process Involved in System Integration Testing & User Acceptance Testing.

Show More

20. Autosys

average Demand
Here's how Autosys is used in ETL Tester jobs:
  • Perform ETL run through AutoSYS job and validated the run after it gets completed.
  • Designed and developed UNIX scripts and used AUTOSYS for job scheduling.
  • Implemented automated Processes & scheduling using Autosys.
  • Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Autosys.
  • Used Autosys to schedule the Data stage ETL batch jobs on a daily, weekly and monthly basis.
  • Executed QA test plans and also worked on Autosys of database tuning and performance optimization techniques.
  • Configured the QA Environment for Manual Testing as well as Automation through autosys.
  • Used Autosys for scheduling the Jobs and setting up the Jobs for execution.
  • Used Autosys to do the shakeout whenever a new build is received.
  • Tested the adequate information gathering or not when Autosys job fails.
  • Executed Autosys jobs to load the data in ADS Target tables.
  • Involved in testing the batch jobs, using UNIX and Autosys.
  • Worked on end to end executions using Autosys scheduling tool.
  • Run the jobs through CA Autosys scheduler.
  • Have tested scheduler scenario on Autosys.
  • Executed several Informatica scripts using with Autosys job management tool and validated data.
  • Analyzed SQL code to ensure Business Objects queries the correct data from the database Run the jobs through CA Autosys scheduler.
  • Use Autosys jobs to execute Informatica mappings and verify the session logs in case of failures.
  • Tested UNIX shell scripts written for ETL Processes to schedule workflows on Autosys.
  • Executed the Autosys job and Testes the job status using Winscp.

Show More

21. ETL

average Demand
Here's how ETL is used in ETL Tester jobs:
  • Designed and developed UNIX commands as part of the ETL process, automate the process of loading, pulling the data.
  • Worked in creating test cases/ test scripts for Inbound and Outbound ETL processes and interfaces with other systems and streams.
  • Created and executed ETL test plans, ETL functional test cases (Manual Testing) and Integration Testing for DWH.
  • Performed metadata validation, performance testing, source to target data validation and appropriate error handling in ETL processes.
  • Coordinated with the development team based on the mapping document to review and sign off the ETL design document.
  • Created ETL test data for all ETL graphs based on transformation rules to test the functionality of the application.
  • Involved in system study, analysis of the ETL Testing requirements and designing of the complete Testing Strategy.
  • Worked on performance testing of ETL process, data migration and database performance after the target load.
  • Tested and Automated Various ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
  • Experience on ETL MicroStrategy tools in ETL process development, testing and in maintaining ETL codes.
  • Involved in testing to run various ETL Scripts to load the data into Target Database.
  • Participated in testing the ETL mappings/Jobs, based on the customer requests for SQL applications.
  • Prepared the Test Data to mock up all the Test Scenarios and ETL Test Cases.
  • Worked with ETL reconciliation team for exact count on source, target and reject records.
  • Experience in ETL, OLTP, OLAP, Data warehousing concepts and Python scripting.
  • Analyzed Data Models, Data mapping, Design, Conversion and ETL design documents.
  • Coordinate Test Data Preparation with business users covering all necessary features for ETL Testing.
  • Developed ETL Test Plan and Test Strategies for the entire Line of businesses.
  • Prepared several test scenarios for the work flow of the entire ETL cycle.
  • Worked with ETL rejected records with both Technology and Business Team for reconciling.

Show More

22. Schema

average Demand
Here's how Schema is used in ETL Tester jobs:
  • Worked with Data analyst, to understand the metadata of Dimensional model and Snowflake schema and slowly changing dimension tables.
  • Imported data from tables in one schema to CSV files and exported to tables from another schema using SQL* Loader.
  • Used TOAD schema browser to check the characteristics of the schema objects (tables, synonyms etc).
  • Automated the Shell scripts for generation of SQL Loader Scripts for any schema definition and data file.
  • Tested various fact and dimension tables which were implemented on Star and Snowflake schema.
  • Involved in designing the Data Mart model with Erwin using Star Schema methodology.
  • Worked on Star Schema, Hierarchies, and Fact and Dimension tables.
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Tested the database schema with help of data architects using ERWIN.
  • Sound Knowledge and experience in Metadata and Star schema/Snowflake schema.
  • Involved in designing the D/W using Star Schema.
  • Used Dimension model & Start Schema.
  • Designed and developed Star Schema.
  • Tested simple and complex mappings using Informatica to load dimensions and fact tables as per STAR schema techniques.
  • Used Synonyms and DB Links to validate the data from different schemas and databases.
  • Experienced with data models Start Schema and Snow-Flake Schema Analyzed Data Marts and tested several Dimension and Fact tables.
  • Determined schemas and record-selection rules of Wachovia (Oracle) and Wells (SQL Server) data sets.
  • Worked with data masking validation between different schemas using Toad for oracle and Sql server.

Show More

23. Rational Requisite Pro

average Demand
Here's how Rational Requisite Pro is used in ETL Tester jobs:
  • Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
  • Developed business use cases and also extensively worked on Rational Requisite Pro in gathering the requirements.
  • Defined and documented business requirements by using Rational Requisite Pro.
  • Worked extensively on Rational Requisite Pro to create Requirements specification.
  • Organized documents use case documents using Rational Requisite Pro.
  • Accessed, updated, and tracked Software Requirements and designed documents in Rational Requisite Pro.

Show More

24. Status Reports

average Demand
Here's how Status Reports is used in ETL Tester jobs:
  • Provided weekly management status reports.
  • Generated test cases execution report and defects report in HP ALM/QC and provided daily status reports.
  • Track design and execution status and produce regular status reports and articulate status to QA Manager.
  • Prepared daily/weekly status reports on Test case execution, Defect status, and RTM.
  • Provided project managers with clear and concise status reports concerning the progress of work.
  • Prepared Status Reports and involved in Post production testing based on role complexity.
  • Involved in writing Test Status Reports and discussed with the developers about bugs.
  • Generated Daily and weekly Status Reports to the team manager and business.
  • Involved in writing Test Plan, Testing Strategy and Defect Status Reports.
  • Create clear and concise QA test documentation and status reports.
  • Provided Daily and weekly Status reports of testing progress.
  • Provided Regular status reports to client & lead.
  • Attended status meetings and sending team status reports.
  • Defect Reporting in QC, HP ALM Generation of Test Status Reports and Test Summary Report.
  • Used Microsoft excel and Word 2003 to document the test status reports and the Test Data.
  • Prepared Status reports to track the test status progress and to check if there is any slippage in timelines.

Show More

25. Traceability Matrix

average Demand
Here's how Traceability Matrix is used in ETL Tester jobs:
  • Mapped requirements in Quality Center and maintained Requirements Traceability Matrix.
  • Prepared Test Cases, Procedures and Requirements Traceability Matrix (RTM) using HP ALM.
  • Prepared and Executed Test Cases, Requirement Traceability Matrix and the required test data based on the Functional/Technical specifications.
  • Reviewed functional specification documents, design documents, requirements traceability matrix and involved in developing test plan document.
  • Involved in writing test scripts and preparing Requirement Traceability Matrix and testing applications in various operating systems and platforms.
  • Analyzed system requirements, prepared Requirements Traceability Matrix, and developed Test Cases for system testing in Test Director.

Show More

26. AB Initio

average Demand
Here's how AB Initio is used in ETL Tester jobs:
  • Executed Ab Initio graphs in test environment and validated business functionality.
  • Validated various Ab Initio Graphs according to business requirement documents.
  • Tested several data validation graphs developed in Ab Initio environment.
  • Verify log, reject and error files generated after successful execution of ab initio graph.
  • Design and develop data validation, mapping & load programs using ETL Ab Initio tool.
  • Developed and documented data Mappings/Transformations, and Ab Initio testing as per the business requirement.
  • Created test plans and performed unit testing for the Ab Initio graphs and its components.
  • Tested Ab Initio graphs for several business scenarios based on ETL data mapping document.
  • Worked with ETL group for understating Ab Initio graphs for dimensions and facts.
  • Involved in setup Test data in source tables using Ab Initio graphs.
  • Verify all input and output files location for ab initio graph.
  • Involved in testing Ab Initio graphs based on data mapping requirements.
  • Tested initial and daily loads for various Ab Initio graphs.
  • Involved in developing Ab Initio graphs for testing purpose.
  • Tested Ab Initio graphs for data loading.
  • Tested the functionality of Ab Initio graphs.
  • Tested the data coming out of the Master Queues and Ab Initio Queues.
  • Involved in testing the Ab Initio graphs parameters as per the data movement practice standards using Ab Initio tool.
  • Tested several data validation graphs developed in Ab Initio environment Involved in writing and executing the test cases.
  • Used Tivoli to schedule the Ab Initio deployed scripts and Unix Wrapper Scripts.

Show More

27. Ssis

average Demand
Here's how Ssis is used in ETL Tester jobs:
  • Assist members and providers with verifying benefits, eligibility, authorizations and medical referrals.
  • Have tested SSIS packages according to business requirements and data mapping requirement documents.
  • Interacted and assisted developers during testing for identifying and reproducing defect report.
  • Validated SSIS and SSRS packages according to business and functional specification documents.
  • Assisted with UAT(User Acceptance Testing) activities and execute connectivity tests with interfacing applications along with the end users.
  • Assisted Developers to design databases, tables, and table objects in support of development activities and to achieve optimal performance.
  • Designed new job process, new database maintenance plans, SSIS programs and did performance tuning of the existing processes.
  • Assisted in the implementation of QA processed to ensure correctness of data flowing through each stage of the ETL process.
  • Prepare test case analysis and assisted in creation of the system test plan and end-to-end data migration system test plan.
  • Assisted in the design of EDI solutions and represented Enterprise EDI team with regards to EDI/ XML industry standards.
  • Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications.
  • Created advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
  • Have solid experience on database query tools such as TOAD, SQL Navigator, and SQL Assistant.
  • Scheduled and executed test cycles, track results, test management and assist with test repository management.
  • Assisted with planning of test preparation and provided input on ways to improve the testing process.
  • Created SSIS Packages to import and export data from Excel, XML and Text files.
  • Validated several SSIS and SSRS packages to verify that they are working according to BRS.
  • Performed Functional, Regression, Data Integrity, System Integration and assisted in UAT Testing.
  • Tracked and maintained application test defects, impact assessments, and assisted operations team.
  • Assisted in maintenance and updates of documents after application and business changes occurred.

Show More

28. BI

average Demand
Here's how BI is used in ETL Tester jobs:
  • Profit View is a profitability system that will calculate relationship profitability for Wholesale relationships.
  • Performed Functional programming and testing, Regression testing, Integration testing and Compatibility Testing.
  • Performed usability testing frequently to ensure continuous availability of online services to Personal clients.
  • Performed browser compatibility testing on different platforms and data validations for all reports.
  • Coordinated with other technical teams to ensure compatibility with other modules and applications.
  • Managed Lower Environments for testing availability and Test Data Preparation.
  • Performed responsibilities of integrating network in IVR systems as required.
  • Performed Cross browser compatibility testing and cross platform compatibility.
  • Experience in Medical, Pharmacy Plan changes from one plan to other plan with in Group, subgroup, class combinations.
  • Analyze the data in EDW and all the Systems in Information systems area where BI Analysis and Reporting is performed.
  • Design, build and test-reports, Dashboards, BI Publisher and Microsoft Integration and other functionality within the OBIEE suite.
  • Performed Regression, Functional, Usability and System Testing and review of Test Case results and Track issues to closure.
  • Worked on Electronic Bill Payment applications when select the Electronic Bill Payment as the Payment type in the Pay Plan.
  • Tested WEBI Reports using one or multiples data providers, Merged Dimensions, Union queries as per the report requirements.
  • Handled various P&C Insurance Modules like Policy, Billing, Document Solutions, Claims, and WIP etc.
  • Involved in writing test scenarios and test cases for data migration and BI reports for both functional and non-functional requirements.
  • Verified that the OBIEE report layout, prompts, titles, download and filter display meet the design.
  • Performed data quality gaps and data cleansing (Scrubbing) to ensure no missing data/duplicate data is found.
  • Involved in functional testing, black box testing, negative testing, compatibility testing, and recovery testing.
  • Created customized OBIEE reports using Answers from the existing Subjects Areas & incorporated Global Prompts & Filters.

Show More

29. QC

low Demand
Here's how QC is used in ETL Tester jobs:
  • Used MQC for bug tracking, reporting and storing the client requirements and managing test plans.
  • Gathered specifications and requirements to develop test plans and to create test cases using QC.
  • Raised defects and performed tracking using ALM QC and reported to developers and test manager.
  • Maintained the track of defect and defect report in QC and conducted defect review meeting.
  • Utilized QC to maintain test documents and record test results and tracking the requirements.
  • Used HP QC (Quality Center) for Test Case management and defect tracking.
  • Tracked Defects using HPQC and involved in defect triage meetings along with development team.
  • Used MQC to track bugs, analyze results and generate performance reports.
  • Experience in using Automation Tool Quality Center (QC) in Client/Server.
  • Tracked and reported defects into QC and notified management with details.
  • Tracked the defects using QC and generated defect summary reports.
  • Involved in Test Execution and Bug Reporting using QC.
  • Test Management using Mercury Quality Center (QC).
  • Tested the analysis reports and logged defects on QC.
  • Defect Logging, linking and tracking in QC.
  • Reported all defects in QC bug tracking system.
  • Defect Tracking and reports maintaining through HPALM QC.
  • Used DOORS to Map the requirement in QC.
  • Prepared and executed Test Cases in QC (Quality Center) Verified and mapped each requirement with the corresponding test case.
  • Involved in writing detailed Test Cases and Test Scripts using Quality Centre (QC) for Functional and Regression Testing.

Show More

30. Source Data

low Demand
Here's how Source Data is used in ETL Tester jobs:
  • Mocked source data for positive and negative test cases to cover all scenarios as documented in the test plan.
  • Design and develop complex transformations in Data Stage to do multiple look-ups when loading the incoming source data.
  • Created Test Reports that show the various discrepancies in the target database from that of the source data.
  • Reported bugs and tracked defects using Quality Center Worked with Data Source team to understand the source data.
  • Used Data Stage Designer to Import and Export Data Stage components and Import table definitions from source databases.
  • Profiled data of source to understand the source data quality and created a data blue print.
  • Worked in multiple source data extraction and data transition from existing production system to test environment.
  • Compared and Tested Source data for Products like Placements, Fed Funds with Output flow.
  • Validated source data in Unix server and compare against Target database.
  • Worked with Testing of Flat File and source data.
  • Identified and created source data as per requirements.
  • Performed Verification, Validation, and Transformations on the Source data before loading into target database.
  • Validated the data available in EDW, HUB and STG schemas against the source data.

Show More

31. Source Systems

low Demand
Here's how Source Systems is used in ETL Tester jobs:
  • Involved in design part for Extracting data from different source systems into the target database using IBM Data stage Server 8.1..
  • Prepared the test data for various source systems coming from Upstream by raising a TDM request Using HP service manager.
  • Skilled in retesting the existing test cases with the different kinds of source systems for different time periods of data.
  • Validated whether the claims processed through different source systems are loaded Correctly into the target without any rejections.
  • Involved in the analysis of source systems, gathering business requirements and identification of business rules.
  • Identified appropriate test data in relevant source systems and incorporated this data into test scripts.
  • Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
  • Performed analysis based on the source systems and existing OLTP database systems.
  • Extract data from different source systems using Data Services tools.
  • Managed multiple data feeds coming from different source systems.
  • Validate the data from the various source systems like RDBMS, XML files, text files and CSV files.
  • Executed Workflows in the Test Environment in order to load the data from the source systems to the WH.
  • Developed the Shell Scripts (Korn Shell) to run the batch jobs to test the different Source Systems.
  • Worked extensively through heterogeneous source systems: Flat files, xmls, Oracle, SQL.
  • Tested Ab Initio test environment for loading data from different source systems.

Show More

32. Data Migration

low Demand
Here's how Data Migration is used in ETL Tester jobs:
  • Performed Count Validation, Source isolation, Dimensional Analysis, Statistical analysis and data quality validation in Data Migration.
  • Tested several data migration application for security, data protection and data corruption during transfer.
  • Identify business rules for data migration and Perform data validations.
  • Worked with data reconciliation for the entire data migration project for both target system and rejected records.
  • Analyzed the data mapping and developed scenarios to verify the data migration from different data sources.
  • Prepared test data for positive and negative test scenarios for Data Migration and Business Intelligence.
  • Worked on BBU data migration project and written the Test Plan and Test Cases.
  • Tested data migration to ensure that integrity of data was not compromised.
  • Worked on testing data migration, data integration and data transformation.
  • Experience testing data conversions and Data migrations in cross platform scenarios.
  • Involved in Data migration and Data distribution testing.
  • Conducted Data Migration and Data Cleansing.
  • Performed DATA MIGRATION enforcement tasks.
  • Experience with backend database and data migration testing.

Show More

33. Data Analysis

low Demand
Here's how Data Analysis is used in ETL Tester jobs:
  • Conduct Data analysis including acquisition, cleansing, transformation, modeling, visualization, documentation and presentation of results.
  • Developed Excel models and templates to verify results and performed extensive data analysis and reconciliation.
  • Experience in data analysis, data integration, conceptual data modeling or metadata creation.
  • Assisted in Capacity planning based on Data Analysis and requirements gathering sessions.
  • Performed Business Analysis, Data Analysis and Dimensional Data Modeling.
  • Performed Data Analysis using SQL based on requirements gathering sessions.
  • Performed data analysis and data profiling using database queries.
  • Developed Strategies for Data Analysis and Data Validation.
  • Involved in data analysis during requirements gathering.
  • Conducted Data analysis and reviewed test cases prepared by offshore team in accordance with defined guidelines and processes.
  • Performed Data Analysis and develop Data Mapping documents for ETL projects.
  • Worked on Requirement Analysis, Data Analysis, Testing of various source systems sitting and coming from multi systems.
  • Worked on Data Analysis and compared VDM for the Shared System Harmonization and reconcillation of the data.
  • Performed ad-hoc data analysis to support BI reporting needs.
  • Involved in extensive Data analysis data validation using SQL queries and backend testing Used TOAD Software for Querying ORACLE.
  • Performed data analysis and data profiling using SQL and Informatica on various sources systems including Oracle and Teradata.

Show More

34. Perl

low Demand
Here's how Perl is used in ETL Tester jobs:
  • Design the Perl and UNIX Shell script to compare the flat file with the database content as per the Business requirement.
  • Tested several UNIX Shell Scripts and PERL scripts for data loading, data parsing, file manipulation and text processing needs.
  • Tested several UNIX Shell Scripts and PERL scripts for connecting to database and for file manipulation of data.
  • Involved in testing ETL (extract, transform and load) process to make sure transformations executed properly.
  • Validate if the attributes in EDI files are populated properly in ODS as per the Mapping Document.
  • Tested Data Migration from legacy databases to ODS to ensure business transformation takes place properly.
  • Experienced in using URL's, Hyperlinks, action filters for developing Complex dashboards.
  • Verify graph executed properly with all PSET information mentioned in TDD for respective graph.
  • Converted SQL queries results into PERL variable and parsed the same for multiple reasons.
  • Worked with PERL scripts for data parsing, text processing and connecting to database.
  • Worked with PERL control structures & Regular Expressions for substitutions based on matches.
  • Enforce standards to ensure that the data elements and attributes are properly named.
  • Extracted certain column of data from a number to files using PERL.
  • Used PERL for automating all the types of modules at a time.
  • Performed negative testing, to make sure validations are done properly.
  • Automated Test Cases using Perl Scripts.
  • Used PERL Scripts for automation.
  • Ensured Error logs and audit tables are generated and populated properly Performed UAT and Regression Testing on SAP modules.
  • Performed Secure View checks for all sensitive data making sure that all sensitive filelds masked properly.

Show More

35. Xslt

low Demand
Here's how Xslt is used in ETL Tester jobs:
  • Create and run BAT File to execute Automation Test Suites and generate XSLT Reports using Apache ANT and TestNG.
  • Created XSLT reports and emailed them using Java Mailing services.
  • Designed rich and user friendly interfaces for the web using HTML, CSS, XHTML, XML, XSLT.
  • Implemented Data Driven Frameworks to create parameterized test scripts and generate XSLT reports using Selenium WebDriver and TestNG framework.
  • Generated Xslt and Extent Reports using TestNG through Maven and used Log4j to generate log files in Reports.

Show More

36. XSD

low Demand
Here's how XSD is used in ETL Tester jobs:
  • Tested several XSD's for setting up standards for TIBCO Bus Message Formats.
  • Involved in XML validation for Eligibility Benefits, Claims enquiry against XSD.
  • Worked on xml files and xsd.
  • Validated XML file against related XSD schema files using XMLSPY.
  • Worked with XSD and XML files generation through ETL process.
  • Created and Validated the XML files based on the defined XSD's with the help of XML SPY.

Show More

37. GUI

low Demand
Here's how GUI is used in ETL Tester jobs:
  • Worked on Functional and GUI testing of the web application making sure the application looks and functions as per requirements.
  • Worked as a Lead ETL tester for Liberty Mutual (Insurance) guiding a team of three on ETL testing.
  • Review the Business Requirement Document (BRD) and discuss the understanding and ambiguities with the business team.
  • Conducted GUI, Functional, Front end & back end testing and reviewed pages for content problems.
  • Review the test cases written based on Solution Design Document, HLD, LLD and User Guide.
  • Perform Regression, UAT, Integration, User Interface, GUI, and Usability Testing.
  • Executed test scripts for Functional and Performance testing of GUI based applications GUI-less Web services.
  • Provided technical guidance to the QA test team to ensure test activities are performed.
  • Prepared the guides for UAT & Production readiness for entire ETL testing efforts.
  • Escalate unresolved problems to senior staff and provide guidance to less experienced testers.
  • Validated the Electronic Records and Electronic Signatures in accordance with the FDA Guidelines.
  • Analyzed application performance characteristics by creating GUI, Bitmap and Database Check Points.
  • Designed Test Procedures for different parts of the application, GUI and Non-GUI.
  • Used WinRunner for GUI tests and tested GUI Standards of this application.
  • Validated different policies and claim entered through Guide wire.
  • Conducted Functionality and GUI testing manually and recorded scripts.
  • Worked on Functional Testing and GUI testing.
  • Performed GUI testing and Navigation Testing.
  • Performed GUI testing and user acceptance testing (UAT) Entered and implemented stored procedure changes to the production DB.
  • Parameterized the scripts, handle errors and create checkpoints (GUI, text, bitmap) using QuickTest Professional.

Show More

38. Mercury Quality

low Demand
Here's how Mercury Quality is used in ETL Tester jobs:
  • Prepared manual test scripts covering different scenarios and documented in Mercury Quality center.
  • Tested application and reported bugs to development team using mercury quality center.
  • Correlated Requirements to test scripts in Mercury Quality Center.
  • Tracked and managed defects using Mercury Quality center.
  • Used Mercury Quality Center to formulate test plan, execute test cases and performed defect management.
  • Mapped the test cases with the requirements using Mercury Quality center.
  • Used Bug tracking tool with Mercury Quality Center.
  • Utilized test tools and completed quality assurance documentation as required Used Mercury Quality Center for Test Case management and defect tracking.
  • Performed End-to-End testing of full functionality Experienced in using Mercury Quality Center as a defect tracking tool.

Show More

39. Altova XML Spy

low Demand
Here's how Altova XML Spy is used in ETL Tester jobs:
  • Validated the XML files by using Altova XML spy and against XSDs which are posted in the JMS topic.

Show More

40. Sdlc

low Demand
Here's how Sdlc is used in ETL Tester jobs:
  • Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
  • Developed and enforced standards to ensure quality assurance in all phases of SDLC (Agile).
  • Associate is involved in all phases of SDLC life cycle and Agile Methodology.
  • Used Agile SCRUM methodologies utilizing TFS for version controlling and for managing SDLC.
  • Worked under development method Agile (Methodology) and SDLC.
  • Performed Database testing by executing SQL queries/Procedures Involved with working in all phases of SDLC methodologies.

Show More

41. Transformation Rules

low Demand
Here's how Transformation Rules is used in ETL Tester jobs:
  • Maintained Source definitions, Transformation rules and Target definitions.
  • Verified data completeness and transformation rules.
  • Arranged meetings with business analyst in better understanding the DW Design Mapping documents Transformation Rules by using business naming conventions.
  • Validated Counts, Referential Integrity Checks, table structures, and transformation rules in Source and Target tables.
  • Identified test scenarios and wrote test cases based on mapping document, functional document and transformation rules.
  • Detailed understanding of design specifications documents, S to T mappings, Transformation rules documents.
  • Gained knowledge for assigned area of CDM and all transformation rules that apply.
  • Validated Source - Target mappings applying various transformation rules and Business Rules.
  • Validated the Business Transformation Rules by writing new queries, Updating Tables or Mockup data whenever necessary.

Show More

42. Datastage

low Demand
Here's how Datastage is used in ETL Tester jobs:
  • Tested complex ETL DataStage jobs based on Business requirements and Business rules to load data from source files to target tables.
  • Tested the Data acquisition process (ETL - IBM DataStage 7.8) within the Status-one to verify the data load.
  • Used DataStage to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
  • Create various test Batch jobs to run and monitor group of jobs with DataStage Director.
  • Involved in the error checking and testing of the ETL programs using DataStage jobs.
  • Developed shell scripts to automate file manipulation and kicking off the DataStage jobs.
  • Involved in using Job Parameters, Parameter Sets while designing DataStage jobs.
  • Worked with DataStage Shell Commands and checking the job status.
  • Involved in testing the functionality of DataStage jobs.
  • Performed Tuning of DataStage Jobs for better performance.
  • Used DataStage director for execution of ETL Jobs.
  • Involved in Integration testing of DataStage mappings.
  • Worked with DataStage jobs and log files to monitor the test runs SOA testing was done on top down approach basis.
  • Tested DataStage jobs to extract data using IDoc Extract Stage, cleansed the data and loaded them into the data mart.
  • Scheduled the DataStage ETL batch jobs on a daily, weekly and monthly basis through Autosys.
  • Scheduled job runs using DataStage director, &used DataStage director for debugging and testing.
  • Prepared Test cases for DataStage jobs on 8.5 & Teradata Scripts on V13 Environments.
  • Experience in Test Datastage ETL processes by confirming data integrity between data sources.
  • Executed Datastage ETL jobs using UNIX to load the data into target tables.
  • Experience in testing on ETL Datastage process for various data loading scenarios.

Show More

43. Technical Specifications

low Demand
Here's how Technical Specifications is used in ETL Tester jobs:
  • Involved in analyzing of functional specifications, technical specifications, creating data mapping document and conceptual diagrams.
  • Performed cubes validation for reporting based on the technical specifications document.
  • Involved in gathering requirements and translating them to technical specifications and mapping document for ETL process.
  • Worked with Business users, ETL Developers team to gather testing requirements, technical specifications documents.
  • Created technical specifications from source to target in absence of technical lead.
  • Tested mappings as per the technical specifications approved by the client.
  • Created technical specifications, mapping documents and managed test cases.
  • Test enhancements and system fixes Involved in creating the design and technical specifications for the ETL process of the project.
  • Executed campaign based on customer requirements Followed company code standardization rule Preparation of technical specifications and Source to Target mappings.

Show More

44. Html

low Demand
Here's how Html is used in ETL Tester jobs:
  • Inspected HTML elements utilizing web development tool Firebug to assist with troubleshooting.
  • Tested HTML documents for compatibility.
  • Experience testing HTML 5, JavaScript, Web Services, SOAP API's, and browser compatibility.
  • Involved in testing and validating the HTML front-end code for the web application across multiple browsers.
  • Tested the list, cross tab, repeater and Drill-through reports in different formats like PDF and HTML.
  • Tested compatibility of application for dynamic and static content under various cross browsers using HTML ids and XPATH in Selenium.

Show More

45. Linux

low Demand
Here's how Linux is used in ETL Tester jobs:
  • Configured servers (VM s) on Linux box for Sandbox and Prod environments to facilitate Non-Prod and Prod Testing.
  • Analyzed system/error logs and output/input files to verify test results and resolve discrepancies in Linux operating system.
  • Deployed multiple environments from Windows servers and desktops/ Linux environment.
  • Developed database management applications for various clients on Linux platform.
  • Performed web application testing on Windows and Linux operating systems.
  • Configured router/switch devices and administered Linux/Windows software.

Show More

46. RTM

low Demand
Here's how RTM is used in ETL Tester jobs:
  • Maintained and created descriptive documentation for development an implementation for ongoing business objects reporting and department projects for users and vendors.
  • Developed graphic representation of various metrics used in the forecasting, budgeting and procurement processes for the Merchandising Department.
  • Created Test Plan, Test Case Specification document, Test Summary Report, BRTM for the project and maintained in Alfresco.
  • Complete Individual participation in documenting Documentation Inspection (DI) in order to present the result to the Business Intelligence department.
  • Designed a new system for the Fire Prevention Department using Tidemark's Advantage, Utilities, Designer and Import/Export modules.
  • Developed test cases, test strategy plan and RTM to ensure accurate coverage of requirements and business processes.
  • Created links between Fire Prevention Department case types never done before in Tidemark Advantage.
  • Tested various historical data and department wise data.
  • Created Test Cases in ALM and RTM and mapped Test Cases to Requirements in Req Pro.

Show More

47. JCL

low Demand
Here's how JCL is used in ETL Tester jobs:
  • Tested JCL coding to check Adhoc jobs running or not.

Show More

48. T-Sql

low Demand
Here's how T-Sql is used in ETL Tester jobs:
  • Create scripts by using Transact-SQL.
  • Write T-SQL queries to validate that actual test results match with expected results.
  • Used T-SQL for Querying the SQL Server database for data validation.
  • Created T-SQL queries to retrieve the data the SQL Server database.
  • Tested and created stored procedures for the business logic using T-SQL.
  • Used T-SQL for validating the data generated at OLAP server.

Show More

20 Most Common Skill for an ETL Tester

Test Cases25.4%
Business Requirements10.4%
Data Warehouse9.5%
Pl/Sql6.5%
Target Database6.1%
Unix5.1%
SQL4.8%
Informatica4.4%

Typical Skill-Sets Required For An ETL Tester

RankSkillPercentage of ResumesPercentage
1
1
Test Cases
Test Cases
21.1%
21.1%
2
2
Business Requirements
Business Requirements
8.6%
8.6%
3
3
Data Warehouse
Data Warehouse
7.9%
7.9%
4
4
Pl/Sql
Pl/Sql
5.4%
5.4%
5
5
Target Database
Target Database
5.1%
5.1%
6
6
Unix
Unix
4.2%
4.2%
7
7
SQL
SQL
4%
4%
8
8
Informatica
Informatica
3.6%
3.6%
9
9
Toad
Toad
3.2%
3.2%
10
10
Windows XP
Windows XP
2.8%
2.8%
11
11
Teradata
Teradata
2.6%
2.6%
12
12
XML
XML
2.3%
2.3%
13
13
QA
QA
2.1%
2.1%
14
14
DB2
DB2
2%
2%
15
15
UAT
UAT
1.9%
1.9%
16
16
HP Quality
HP Quality
1.5%
1.5%
17
17
Cognos
Cognos
1.4%
1.4%
18
18
Data Integrity
Data Integrity
1.1%
1.1%
19
19
User Acceptance
User Acceptance
1.1%
1.1%
20
20
Autosys
Autosys
1.1%
1.1%
21
21
ETL
ETL
0.9%
0.9%
22
22
Schema
Schema
0.8%
0.8%
23
23
Rational Requisite Pro
Rational Requisite Pro
0.8%
0.8%
24
24
Status Reports
Status Reports
0.8%
0.8%
25
25
Traceability Matrix
Traceability Matrix
0.8%
0.8%
26
26
AB Initio
AB Initio
0.7%
0.7%
27
27
Ssis
Ssis
0.7%
0.7%
28
28
BI
BI
0.7%
0.7%
29
29
QC
QC
0.7%
0.7%
30
30
Source Data
Source Data
0.7%
0.7%
31
31
Source Systems
Source Systems
0.6%
0.6%
32
32
Data Migration
Data Migration
0.6%
0.6%
33
33
Data Analysis
Data Analysis
0.6%
0.6%
34
34
Perl
Perl
0.6%
0.6%
35
35
Xslt
Xslt
0.6%
0.6%
36
36
XSD
XSD
0.6%
0.6%
37
37
GUI
GUI
0.6%
0.6%
38
38
Mercury Quality
Mercury Quality
0.6%
0.6%
39
39
Altova XML Spy
Altova XML Spy
0.5%
0.5%
40
40
Sdlc
Sdlc
0.5%
0.5%
41
41
Transformation Rules
Transformation Rules
0.5%
0.5%
42
42
Datastage
Datastage
0.5%
0.5%
43
43
Technical Specifications
Technical Specifications
0.5%
0.5%
44
44
Html
Html
0.4%
0.4%
45
45
Linux
Linux
0.4%
0.4%
46
46
RTM
RTM
0.4%
0.4%
47
47
JCL
JCL
0.4%
0.4%
48
48
T-Sql
T-Sql
0.4%
0.4%

3,329 ETL Tester Jobs

Where do you want to work?