We provide IT Staff Augmentation Services!

Etl Tester Resume

2.00/5 (Submit Your Rating)

Jacksonville, FL

SUMMARY

  • Over 4+ years of IT experience in Quality Assurance and Software Testing of various business applications in Client/Server environments and Data Warehousing solutions.
  • Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
  • Strong knowledge of SDLC and Software Test Life Cycle and highly proficient in SQA methodologies for Waterfall and Agile.
  • Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
  • Experience in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified.
  • Experience in gathering functional requirements from users and designing data model for ETL development.
  • Good knowledge in ETL/DWH testing concepts, Informatica Power Center and Talend.
  • Good Experience in creating ETL test data for all ETL mapping rules to test the functionality.
  • Good Experience in testing ETLTalend and other ETL Processes (Data Warehouse Testing)
  • Extensive experience in performing different types of testing including White Box, Black Box, System, Functional, Integration, Regression, Smoke, Database and User Acceptance Testing (UAT).
  • Experience in Data Profiling, Data Extraction, Data Integration, Data Testing and Data Cleansing.
  • Good Experience in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports.
  • Experienced in running SQL queries using Toad (Oracle), and SQL server.
  • Passionate worker to contribute individually and as part of a team.
  • Ability to learn modern technologies quickly with good analytical and problem - solving skills

TECHNICAL SKILLS

ETL Tools: Informatica Power Center, Talend Cognos, Datastage

Test Management Tools: Quality Center, Jira, ALM

Languages: Java, SQL

Databases: Oracle 9i/10g, IBM DB2, MS SQL Server, MS Access

WebServer/AppServer: Tomcat

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

ETL Tester

Responsibilities:

  • Involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
  • Extensively usedETLmethodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETLsolution usingETLtools likeTalend.
  • Tested variousETLprocesses developed usingETLtools like Informatica.
  • Tested the ETL Talendmappings and other ETL Processes (Data Warehouse Testing).
  • Testing ETL data feeds from various data sources to ware house.
  • Tested complex mappings using mapplets and reusable transformations.
  • Established and documented ETL QA standards, procedures and QA methodologies.
  • Extensively used Talendfor extraction, transformation and loading process.
  • Extensively tested several ETL Mappings developed using Talend.
  • Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scrfgjipts.
  • Tested the reports generated by OBIEE and verified and validated the reports using SQL.
  • Written SQL scripts to test the mappings and tested Cognos Reports
  • Written several SQL statements to confirm successful data transfers between source and target.
  • Executed SQL queries to perform backend database testing and verify/modify user data
  • Reported debuging using Talend and tracked defects using Quality Center/ALM.
  • Worked in AGILE Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
  • Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports.

Environment: Talend,Oracle 8i, SQL Server, SQL, PL/SQL, SQL*Plus, TOAD, Windows.

Confidential, East Norriton, PA.

ETL Tester

Responsibilities:

  • Created Test Scenarios and Test Cases based on system use-cases and business use-cases.
  • Identified various Business and Data Test Scenarios based on Source to Target Mapping and assisted in the preparation of extensive set of validation test case to verify the data.
  • Design and maintain the infrastructure for theETLprocess, metadata maintenance, and data validation.
  • CreatedETLtest data for allETLmapping rules to test the functionality of the Informatica.
  • Involved on ETL Functional testing. Involved in testing Reports. Requirements gathering and freezing of those requirements.
  • Involved in ETL process testing using TalendETL tool.
  • Created ETL test data for all ETL mapping rules to test the functionality.
  • Written Test Cases forETLto compare Source and Target database systems.
  • CreatedETLtest data for allETLmapping rules to test the functionality of Informatica mappings.
  • Worked with Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes using Informatica.
  • Validated the Cognos Reports against Data warehouse.
  • Performed InformaticaETLtesting to validate end-to-end data from source system MS SQL Server and Target system Teradata environment.
  • Extensively usedInformatica Power Center for extraction, transformation and loading process.
  • Perform User Acceptance Testing with UAT test scenarios.
  • Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
  • Evaluate and suggest improvements to the software development process.
  • Monitor Testing Activities within the team and report regular progress to the Test Manager.

Environment: Informatics Power Center 8.1/7.1, Oracle 10g, MS SQL Server 2005/2000, PL/SQL, Windows 2000, HP-UX.

Confidential, Atlanta, GA.

ETL Tester

Responsibilities:

  • Prepared data mapping document for various data feeds for ETL to write and develop the data extraction routines.
  • Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.
  • Coordinated between offshore and onsite team and managed multiple OLAP and ETL projects for various testing needs.
  • Extensively used Informatica for extraction, transformation and loading process.
  • Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
  • Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
  • Monitoring ETL jobs in Informatica which involved analyzing the issues and providing corrective actions.
  • Tested Cognosreports and written test cases using Quality Center.
  • Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
  • Defects were tracked and prioritized using Quality Center and analyzed the variation between expected result and actual result.
  • Designing and creating new reports, freeform SQL reports in cognos.
  • Designed and prepared scripts to monitor uptime/downtime of different system components.

Environment: Informatica, SQL Server, Quality Center, SQL, TOAD, Oracle, PL/SQL, MS Access/Excel/Visio

Confidential, New York, NY.

ETL Tester

Responsibilities:

  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Analyzing requirements and creating and executing test cases
  • Involved inETLprocess testing using Data Stagetool.
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Data Stage
  • Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
  • Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
  • Performed data validation testing writing SQL queries.
  • Wrote complex queries in SQL assistant to check the data from Source and Target.

Environment: Datastage,SQL, DB2, Oracle, HP Quality Center, Windows, UNIX.

We'd love your feedback!