We provide IT Staff Augmentation Services!

Sr Etl And Batch Job Tester Resume

Milwaukee, WI

SUMMARY

  • Over 9.5 years of experience in the IT Industry with 1 year as Informatica Developer, 7.5 years as an ETL and Database Test Analyst and 1 year as BMC Remedy Developer
  • Implemented slowly changing dimensions Type 1 and Type 2 transformations to maintain historical data
  • Created Workflows, Worklets to load the data for different schedules
  • Designed ETL methodologies using Snowflake schema
  • Responsible for creating unit test cases for the corresponding modules
  • Involved in Business Requirement Analysis, Functional Requirement Analysis, Design, Use - Case analysis, Impact Analysis and STLC life cycle
  • Expertise in ETL Development and Testing, Database Testing, Integrated Functional Testing (IFT), Regression Testing, Positive/Negative Testing, User Acceptance Testing, Smoke Testing, Sanity Testing, Connectivity Testing, Payment Testing, Alert Testing, Adhoc Testing, Backend Testing, Compatibility Testing, End to End Testing, GUI Testing, Risk Based Testing, White Box Testing
  • Designed Test Strategy, created Test Plans, Test Cases, Traceability Matrix and executed test scripts based on business requirements
  • Monitored jobs in BMC Control-M and Autosys applications
  • Responsible for entering bugs into HP ALM 12.01, JIRA & IBM ClearQuest (defect management tools)
  • Expertise in Quality Control, Quality Assurance skills in both Waterfall and Agile methodologies
  • Strong knowledge in Excel Macros, understanding the Java code and testing as per the code flow
  • Excellent team management skills and handled onsite/offshore teams effectively
  • Expertise in Knowledge Management activities, Team Training, cross application trainings
  • Responsible for creating status reports, metrics reports and other project management artifacts
  • Good analytical skills and ability to multi-task and prioritize the work to meet the deadlines
  • Trained in Big Data - Hadoop
  • Trained in Informatica PowerCenter Developer
  • Trained in IBM Infosphere Optim Test Data Management tool

TECHNICAL SKILLS

Defect Tracking Tools: Quality Center/ALM, Clear Quest, JIRA

Languages: VBScript, HTML, XML

Platforms: Windows (XP, Vista, Window7), VM Ware

RDBMS/Database: PL/SQL Developer, Microsoft SQL Server Management, SQL Developer, SQL Toast, MS Access and Toad

Other Tools: Informatica PowerCenter, DataStage, Eclipse (for going through Java Code), Control-M, Autosys, SoapUI, VersionOne, JIRA, WinSCP, Putty, BMC Remedy Ticketing tools, IBM Lotus Notes, Hogan (Attachmate Reflection), IBM Infosphere Optim

Technologies/Domain: Banking Finance (Brokerage, Retirement, Payments), Financial Services, Document Management

Testing: ETL, Database, Functional, Web-service, White Box, Black Box, System Testing, Integration, Regression, UAT, Positive/Negative, Smoke/Sanity Testing

Other Skills: Writing functional specs, design documents. Knowledge of SDLC (Software Development Life Cycle), QA methodologies and Different Quality standards (ISO and CMMi).

PROFESSIONAL EXPERIENCE

Confidential - Milwaukee, WI

Sr ETL and Batch Job Tester

Responsibilities:

  • Worked as a senior testing analyst for two different teams, one for ETL testing and the other for Batch job validations
  • As an ETL Tester, validated the data movement between Oracle from upstream applications to Microsoft SQL Server which is the database used by the current product
  • Involved in the analysis of Mapping Documents and ETL job execution
  • Validated that the current data is loaded into the Database daily
  • Validated the completeness of the data, to make sure the target is loaded without any data loss
  • Reviewed the business and functional requirements to understand the transformations
  • As a Batch Job tester which is a single resource QA project, validated the data flow between the applications
  • Monitored the jobs in System Test environment to make sure there is no break in the flow
  • Performed data setup for the jobs and scheduled the jobs to run daily
  • Tested and reviewed the functionality of mappings for each transformation to validate the data loads
  • Validated the data also through the SoapUI to make sure that the same data is reflecting in the Web service calls
  • Involved in reviewing the test scripts for Batch jobs to make sure there were no gaps in the functional flow
  • Involved in the Readiness and Production validations

Environment: DataStage, JIRA, Agile testing, SoapUI, Control-M, MS Office, Eclipse, PL/SQL Developer, SQL Developer, Microsoft SQL Server Management, Putty, WinSCP, ETL Testing, Batch Job testing, White box testing, Positive/Negative, End to End testing, Regression testing

Confidential - Charlotte, NC

Sr Agile and ETL Tester

Responsibilities:

  • Worked as a testing lead for two teams for Exadata Database migration project which involved migrating the database from Sybase to Oracle
  • Reviewed the business and functional requirements to understand the transformations
  • Involved in the analysis of Mapping Documents and ETL job execution
  • Worked on source file extraction and validation, smoke testing relevant tables during Initial and Incremental Loads
  • Tested and reviewed the functionality of mappings for each transformation to validate the data loads
  • Validated the completeness of the data, to make sure the target is loaded without any data loss
  • Validated the email and command tasks using workflow manager
  • Involved in reviewing the test scripts against the Java code for Batch jobs to make sure there were no gaps in the functional flow
  • Reviewed the stored procedures and inline SQLs within the batch jobs and given walkthrough to various teams on the test scripts
  • Participated in the Defect review meetings with the Database Modeling Team to resolve them
  • Involved in all the Project meetings for Exadata DB migration and represented QA team for the analysis and risk management discussions
  • Involved in the documentation and walkthrough of Test Plans, Test Sizing documents and Traceability Matrix for all the teams
  • Involved in the Dress Rehearsals and Production validations
  • Also participated in the project meetings for the Business projects involving discussions on business requirements, functions requirements since the initial phases representing QA along with all client stakeholders
  • Attended daily standup scrum calls
  • Developed the Test Strategies and Test Plans during the Planning phase and estimated the team size required for each project
  • Developed Test Scenarios/Scripts and executed test cases for Batch jobs by reviewing the code and understanding the flow
  • Performed database testing, batch job testing, regression testing, white-box testing, functional testing, smoke & sanity testing
  • Identified and resolve issues that occurs during testing
  • Performed peer review of team members’ deliverables, identified and tracked bugs in ALM
  • Participated in daily risks identification meetings to identify, track, close various risks related to request
  • Involved in creation of status reports, metric reports for projects
  • Ensured no delivered defects and schedule deviation

Environment: Informatica PowerCenter 10.1.0, ALM 12.0, Agile testing, VersionOne, MS Office, Eclipse, Sybase, Putty, WinSCP, IBM LotusNotes, Batch job testing, White box testing, Positive/Negative, End to End testing, Regression testing

Confidential

ETL Developer and Tester

Responsibilities:

  • Had been a key resource for extracting the respective records from flat files and loading the data into the ODS tables
  • Had been a part of discussions with the Business Analysts, Data Owners and Developers to analyze and apply the requirements
  • Worked on the Informatica Workflow Manager, Workflow Monitor and Designer
  • Implemented slowly changing dimensions types 1 and 2 for loading historical data
  • Worked on various transformations like Source Qualifier, Lookup, Router, Sequence Generator, Filter, Update Strategy, Aggregator, Normalizer and Expression Transformations
  • Scheduled and monitored the workflows using the Workflow Manager and Monitor tools
  • Worked on Mapping variables for incrementing the data
  • Had been the key resource for all backend validations for the corresponding data
  • Had served as both Developer and Tester as this was a pilot project
  • Created complex SQL scripts for validating the data
  • Worked on both Unit Testing and Functional Testing in Informatica

Environment: ALM, Informatica PowerCenter, SQL Developer, Oracle 11g

Hire Now