We provide IT Staff Augmentation Services!

Etl Developer/tester Resume

VA

SUMMARY

  • Over 10 years of IT experience in Manual and Automated testing on Cloud, Web Based, Client - Server, Data warehouse applications.
  • Commendable experience with Test Plan, Test Strategy, Test case preparation, Test execution and Test results analyses.
  • Strong Experience in data warehouse architecture, Data Modeling, ETL and reporting tools for Data Warehousing.
  • Generate Requirement Traceability Matrix (RTM) to trace requirements till implementation.
  • Good Experience in Test Life Cycle and Test Methodology primarily on Agile Methodology.
  • Excellent knowledge of Software development and testing life cycles, SQA methodology and test process documentation and End user training.
  • Possess strong interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management.
  • Coordinated with Development, Integration, Configuration Management, Testing, Training and Production teams for Repository build and deployment
  • Experience in preparing Analysis Documents and User Acceptance Documents.
  • Experience in on shore and off shore model projects.
  • Strong debugging and problem-solving skills with excellent understanding of system development methodologies, techniques and tools.
  • Prepare backend test jobs, setting up in scheduler, execution of batch jobs and analyzing the job logs and test results.
  • Preparing JIL files and force starting Autosys scheduled jobs.
  • Strong experience on jobs schedulers on different technical environments and preparing job nets by fulfilling successor and predecessor.
  • Wealth experience in Front End and Back End testing.
  • Expert in writing complex SQLs and execute them in oracle for validating and analyzing system generated output in backend and Front End.
  • Experience in Cross Browser testing
  • Tested Web Services /XML / SOAP services using SoapUI tool
  • Programming skills using SQL, PL/SQL and Shell Scripts.
  • Knowledge of Automated testing using QTP
  • Hands on development experience with C++
  • Hands on development experience with Informatica Designer, Workflow Manager and Workflow Monitor & Mappings.
  • Experience in Core Java, development by applying different concepts like OOPS concepts, Collections, String s, Exception handling, Multithreading, etc.
  • Have knowledge on various CLOUD supported authentication systems namely RDS, S3, Postgrep tool .
  • Experience in HTML, HTTP, JavaScript, XML.
  • Experience in testing Web Services-SOA architecture, XML transactions, SOAP, HTTP, WSDL, and REST using various tools like SOAP UI.
  • Modify the existing regression framework as per few functionalities and executed the scripts by using Selenium

TECHNICAL SKILLS

Operating Systems: UNIX, LINUX, Windows NT and MS-DOS

Languages/Tools: Java, ASP .Net, SOAP, UDDI, TCP/IP, HTTP, XML, JMS, WSDL, VBA, PL/SQL, COM/DCOM Informatica PowerCenter 8.6/7.1//6.1/6.2/5.2 , PowerMart 8.6/7.1/6.2/6.1/5.2 , SQL, PL/SQL, SQL Loader, Unix Shell Scripts, Toad7.1.

DBMS: ORACLE, MS Access, MS SQL Server, UDB, SYBASE, DB2

Test Tools Used: QC, QTP, Clear Quest, Test Director, Load Runner, DOORs, Rapid SQL

PROFESSIONAL EXPERIENCE

ETL Developer/Tester

Confidential, VA

Responsibilities:

  • Participated requirement review sessions during the Sprint plan phase and understands the requirements conceptually mapping those requirements with future working software product.
  • Ensure there are no incompatibilities within requirements and raised clarifications to IA / Product Owner for those requirements are not clear.
  • Create the testing process for the project level and review with project manager.
  • Create Test Plan and review with team and incorporated the changes requested by team and sign off the test plan document.
  • Create less complexity mappings like error handling and loading data to Initial data hub (Landing Area)
  • Review the code and logic with Technical lead and made changes suggested by reviewer.
  • Create test data that matches business rules.
  • Creating Test cases in Excel sheet based on requirements and linked those test cases to requirements.
  • Run the test cases review meeting session for testing team, business team and Development Team.
  • Incorporated review comments suggested by stake holders in order to maintain good test coverage.
  • Creating Test Data in Database as per business transformations by using DDL statements.
  • Generate the execution test cases and defects and calculate the percentage of completion and provide the daily status on every Morning in scrum meetings.
  • Validate the data at every stage against the business rules.
  • Validate the dash boards created by using BI tool.
  • Validating the Report headers, column names, color and font.
  • Validated the values against database.
  • Review the test Results before sending to business review and suggest modifications if anything needed.
  • Reported the defects and maintains the defect management by using the JIRA.
  • Document the Test results in share point.

Environment: Informatica, BI, Putty, WinSCP, Jira, SQL developer 19.2.1 and backend as Oracle 12c

Test Designer

Confidential, VA

Responsibilities:

  • Participated requirement review sessions during the Sprint plan phase and understands the requirements conceptually mapping those requirements with future working software product.
  • Ensure there are no incompatibilities within requirements and raised clarifications to IA / Product Owner for those requirements are not clear.
  • Create test data that matches business rules.
  • Generate the execution test cases and defects and calculate the percentage of completion and provide the daily status on every Morning in scrum meetings.
  • Review the test Results before sending to business review and suggest modifications if anything needed.
  • Creating Test cases in Excel sheet based on requirements and linked those test cases to requirements.
  • Run the test cases review meeting session for testing team, business team and Development Team.
  • Incorporated review comments suggested by stake holders to maintain good test coverage.
  • Creating Test Data in Database as per business transformations by using DDL statements.
  • Deployed the code to QA environment by Providing EAR Artifact through Jenkins.
  • Select the parameters to deploy the code to QA environment by using Jenkins.
  • Verify the deployment, it is success then run the smoke test in QA environment and share the results with the team.
  • Executing the Job through EJS job container manually by using force start action “Execute”.
  • Validating Log in EJS and then log into Putty and verify whether reports generated or not?
  • Validating the Report headers, column names, color, and font.
  • Validated the values against database.
  • Reported the defects and maintains the defect management by using the JIRA.
  • Document the Test results in share point.

Environment: ODI, OBIEE, Putty, WinSCP, Rally, Salesfore, Oracle SQL developer 19.2.1, EJS (Enterprise Job Scheduler), Jenkins, Selenium IDE, Selenium WebDriver, Eclipse, Maven and backend as Oracle 12c

Sr Software Quality Engineer

Confidential, Herndon,VA

Responsibilities:

  • Participated requirement review sessions during the Sprint plan phase and understands the requirements conceptually mapping those requirements with future working software product.
  • Ensure there are no incompatibilities within requirements and raised clarifications to IA / Product Owner for those requirements are not clear.
  • Review test cases provided by the offshore team and generated RTM to make sure all requirements covered or not. Then suggest the modifications.
  • Help the team to create test data that matches business rules.
  • Generate the execution test cases and defects and calculate the percentage of completion and provide the daily status on every Moring in scrum meetings.
  • Review the test Results before sending to business review and suggest modifications if anything needed.
  • Motivate the team with collecting appreciation emails from business and share with them.
  • Creating Test cases in Excel sheet based on requirements and linked those test cases to requirements.
  • Run the test cases review meeting session for testing team, business team and Development Team.
  • Incorporated review comments suggested by stake holders to maintain good test coverage.
  • Creating Test Data in Database as per business transformations by using DDL statements.
  • Validating ETL Initial loads, Truncate and reload as well as incremental loads.
  • Validate the source, target counts, duplicate check, and data field to field validations.
  • Executing the reports through BIEE Tool
  • Validating the reports both GUI and data validations against data base
  • Validating the reports in Lower environments like TESDW1/7 and PERF (Image of production data) and higher environment K12PODW (Production).
  • Validating the breadcrumbs, filters, and global filters
  • Validated application across web browsers.
  • Validated data against data base for all possible combinations of filters and global filters.
  • Selected the Test Cases to be automated and performed functional testing of the front-end using Selenium (IDE and Web Driver) & Modified the existing Keyword Driven framework and executed.
  • Reported the defects and maintains the defect management by using the JIRA.
  • Document the Test results in share point.

Environment: ODI, OBIEE, Putty, WinSCP, JIRA and, HP ALM, Software Change Management Workbench 12.0, windows XP, Microsoft Visio, Oracle 12c /Exadata SQL Server 2008, VMware, Selenium IDE,, Selenium WebDriver, Eclipse, Maven

Back End Report Tester

Confidential, Reston, VA

Responsibilities:

  • Access Individual Student Scores, Electronic Score Reports and registration/score rosters
  • View a dashboard where they can analyze scores using a predefined set of student demographics
  • Run Insight analysis reports which allow schools, districts and states to take a detailed look at students' skills by providing an analysis of aggregate performance on each test question and skill
  • Participated requirement review sessions during the Sprint plan phase and understands the requirements conceptually mapping those requirements with future working software product.
  • Check reports available in cloud and export reports to the desktop for validation against base line reports.
  • Ensure there are no incompatibilities within requirements and raised clarifications to IA / Product Owner for those requirements are not clear.
  • Creating Test cases in Excel sheet based on requirements and linked those test cases to requirements.
  • Run the test cases review meeting session for testing team, business team and Development Team.
  • Incorporated review comments suggested by stake holders to maintain good test coverage.
  • Generated the RTM manually with the help of Test Lead.
  • Creating Test Data in Database as per business transformations by using DDL statements.
  • Executing the reports through COGNOS portal.
  • Validating the reports both GUI and data validations against data base
  • Validating the reports in Lower environments like PALM and Apple (Image of production data) and higher environment Pine (Production).
  • Validating the breadcrumbs, filters, and global filters
  • Validated application across web browsers.
  • Validated data against data base for all possible combinations of filters and global filters.
  • Reported the defects and maintains the defect management by using the JIRA.
  • Selected the Test Cases to be automated and performed functional testing of the front-end using Selenium (IDE and Web Driver) & Modified the existing Keyword Driven framework and executed.
  • Created LoadRunner scenarios and scheduled the Virtual Users to generate realistic load on the server using LoadRunner (Load generator machine)
  • Document the Test results in share point.
  • Supported End user

Environment: Cognos, Cloud, Java, Putty, WinSCP, JIRA and HP ALM, Software Change Management Workbench 12.0, windows XP, Microsoft Visio, Oracle 12c TOAD, LoadRunner

Back End ETL Tester

Confidential, Reston, VA

Responsibilities:

  • Participated requirement review sessions during the planning phase and understands the requirements conceptually mapping those requirements with future working software product.
  • Ensure there are no incompatibilities within requirements and raised clarifications to BA team for those requirements are not clear.
  • Creating Test cases in Quality Center based on requirements and linked those test cases to requirements.
  • Run the test cases review meeting session for testing team, business team and Development Team.
  • Incorporated review comments suggested by stake holders in order to maintain good test coverage.
  • Generated the RTM by using clear case tool with the help of Test Lead.
  • Creating Test Data in XML format as per business transformations by using XML SPY Tool.
  • Creating Securities, Different types of Buy and SELL Trades by using the mock up data.
  • Executing the Workflows by using AUTOSYS Job scheduler.
  • Validating the Session logs and verifying the Counts.
  • Validating the data at Staging tables and then Target tables (Business rules applied).
  • Tested Web Services, Validated Request and Response XML, SOAP Calls, Restful calls and WSDL using SOAPUI tool.
  • Validated End Points in WSDL File, XML Schema.
  • Added data related assertions to validate response XML in Web Services.
  • Validating the CSV files generated by workflows in the SCD Server.
  • Validating the data in different screens in SCD (COTS Product)
  • Validating the SCD Database (Target) as per business rules.
  • Reported the defects and maintains the defect management by using the Clear Quest tool.
  • Document the Test results and executing the test cases in Quality center.

Environment: HP Quality Center 10.0, TOAD, Clear Quest, UNIX, AUTOSYS, XML ALTOVA, SCD (COTS Product) Informatica, Java, TIBCO, SoapUI, Web Services.

Back End Tester

Confidential, McLean, VA

Responsibilities:

  • Conducted the performance testing (Execution of jobs) by Focusing on lessons learned from Pilot and previous waves to improve efficiency and reduce execution time.
  • Involved in risk Based Testing Approach, by testing the identified break points introduced by each upgrade. E.g. Testing of SOX key controls validated.
  • Verified the system whether a high level of confidence is achieved for each upgrade and performance is scaled up to handle large volumes.
  • Set up the meetings with Bio and Application SME’s for identifying the testing scope.
  • Created Test Strategy and Test plan and Review with business team for sign off
  • Created both functional and automated test cases in Quality center and QTP.
  • Executed the test cases, test scripts and validated results by comparing the actual and expected results.
  • Extensively used Quality center to log defects and to track defects until resolution.
  • Performed the SPE (Sybase Password Encryption) Verification for Web method and Web-logic Software upgrades.
  • Automatically executed the batch jobs by using jobs scheduler and documented the results.
  • Documented the test results, reviewed the testing artifacts with businesses team for sign off.
  • Provided technical help to team members.

Back End Tester

Confidential, McLean, VA

Responsibilities:

  • Created test cases, test scenarios and test scripts based on requirements.
  • Test cases have been written in Quality Center and linked to requirements to generate RTM (Requirements Traceability Matrix).
  • Created a framework that reads data from source systems to generate the expected results by applying business transformation rules.
  • Executed the test cases, test scripts and validated results by comparing the actual and expected results.
  • Extensively used Clear Quest to log defects and to track defects until resolution.
  • Interacted with the system analysts and developers to discuss the requirements details and testing issues.
  • Performed Functional testing.
  • Triggered events in MPS database by inserting a new record/updating an existing record in database.
  • Verified the data persistence in OEM (Oracle Enterprise Management) through workflow or BPEL (Business Process Events Flow).
  • Used SOAPUI to post the message on to the topic for event notifications.
  • Tested Web Services, Validated Request and Response XML, SOAP Calls, Restful calls and WSDL using SOAPUI tool.
  • Validated End Points in WSDL File, XML Schema.
  • Added data related assertions to validate response XML in Web Services.
  • Created temp tables to store expected and actual results.
  • Extracted data from DSI to create actual results data using X-query.
  • Created deal, facility, circle or trade and outstanding objects in LoanIQ tool GUI.
  • Participated in daily status meetings to update status of testing to lead and project manager. Also, provided a daily testing project status report the management team.
  • Documented test results and saved all the project related documents in the LAN.
  • Provided support to team members, if they have any questions.

Environment: HP Quality Center 1.0, Rapid SQL, SQL Developer, Oracle Enterprise Management (OEM), Clear Quest, UNIX, SoapUI, Web Services., Windows 2000/XP

Informatica Developer

Confidential

Responsibilities:

  • Studied the project requirement and designed the project.
  • Created tables, views, synonyms and sequences
  • Created Control files.
  • Used SQL Loader for data loading.
  • Analyzing Packages, Procedures.
  • Tested all the new and modified program units.

Environment: Oracle, UNIX, SQL loader.

DW Developer

Confidential

Responsibilities:

  • Created Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.
  • Used aggregator, lookup, expression, stored procedure, filters in the mapping.
  • Used Sequence Generator Transformation.
  • Used ETL to extract and load data from Oracle, SQL Server, and flat files to Oracle.
  • Involved in writing lot of Functions, Stored Procedures.
  • Created various transformations such as Update Strategy, Look Up, Joiner, Filter and Router Transformations.
  • Designing, Creating and testing of Cognos Reports.

Environment: Informatica, Cognos, Oracle 8i

Informatica Developer

Confidential

Responsibilities:

  • Worked on Informatica client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
  • Used Informatica to extract and load data from Oracle database and flat files to Oracle tables.
  • Created various mappings using Designer which include Expression, Router, Aggregator, Stored Procedure, Update strategy and Look-up Transformations.
  • Created Mapplets using Mapplet Designer to reuse in different mappings.
  • Created FTP connections, database connections for the sources and targets.
  • Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
  • Unit Test case preparation and test data.

Environment: Data warehousing (Informatica, Oracle 8i, UNIX)

Hire Now