SUMMARY

• To work in a stimulating and challenging milieu dat would facilitate teh maximum utilization and application of my broad skills and expertise in making a positive difference to teh organization
• Meticulous and highly accomplished Datawarehouse professional holding Bachelor’s Degree in Engineering with 5 years of experience in ETL and DW testing.
• Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing.
• Possess valuable insights, keen analysis and a team approach to implement best practices to and maintain high quality industry standards.
• Good skills and proven track record in ETL testing, DW testing and business applications with a high degree of confidentiality.
• Has a strong experience in direct interaction with clients while my One Year tenure at Onsite (United Kingdom - 2013 to 2014) for Lloyds Banking group where me developed immense knowledge in client management and played an instrumental role in resolving various issues/escalation and roping in new projects for teh team by showing teh level of confidence and business excellence.
• Worked on Hadoop/Big data testing for 5 months during my tenure at Cognizant Technology Solutions where me worked on Pig, Hive and Sqoop.

TECHNICAL SKILLS

Operating Systems: Windows XP/98/07/08, Unix.

Programming Languages: C, C++

Software Testing: ETL Testing, DW Testing

Datawarehouse Tools/Applications: Informatica 8.1, IBM Autosys scheduler, DataStage 8.1, Datastage 9.1

Defect Reporting tools: Quality Centre 10

Database(s): Oracle 10g, MS SQL 2005, DB2.

PROFESSIONAL EXPERIENCE

Confidential

Application Test lead

Responsibilities:

• Requirement gathering and understanding teh scope of datastage and DW for teh project.
• Prepare Master test plan and Detailed test Plan.
• Test scenario and Test script preparation.
• Trigger teh datastage jobs to load teh file into teh database and validate if all teh transformation logic is applied as per teh specification provided.
• Issues if any raise it as a defect or clarification to teh ADM team or any concerned team.
• At teh same time, debug teh datastage code by checking teh individual jobs and teh logic coded to spot teh exact issue.
• Prepare teh complex query based on teh specification/mapping specs provided and fire it against teh database to ensure dat teh data is loaded corrrectly and no data loss is observed.
• Trigger teh next set of datastage jobs to create Solvency reports which extracts teh data from teh database in flat files and ensure there are as per specifications.
• To aid further reporting, new set of datastage jobs are triggered which loads teh data in Reporting layer where teh data is stored in FACT and DIMENSION tables in star schema.
• Prepared complex queries, to ensure teh dimension and FACT tables are updated and maintained properly depending upon if a new record is inserted or an existiing record is amended.
• Execute teh test scripts in QC with appropriate snapshots.
• Was largley involved in building requirement for creating schedules (automated schedules) in SIT environment which would control teh execution of jobs in live.
• Testing these schedule in SIT environment to ensure teh multiple source files are processed in a defined sequence and incase if unavailability of any source files or failures, error messages are triggered to teh project akin to wat would be observed in production.
• Provide support after teh code is promoted to live to analyse critical issues along with BA and DEV team and offer necessary suggestion.
• Prepare EOTR document and recommend wat can be one to improve teh process.

Confidential

Test lead

Responsibilities:

• Provide technical advice to teh team.
• Manage teh cost utilization by teh team and ensure teh QA team is on track to deliver teh project until end of test window within teh approved budget. If not (due to delays or other factors), raise teh concern with teh project.
• Review QA various deliverables prepared by teh team (MTP, DTP, TEST SCRIPTS etc).
• Prepare cost estimation documents.
• Resolve escalation and any issues raised against teh team.
• Involve in resolving issues and defects raised by teh team by coordinating and liaising with development team and project stakeholders.
• Generate and validate QA test progress report on weekly, monthly and yearly basis and share it to account and cognizant management.
• Arrange KT session for teh new joiners. Classroom training if required, raise it with my Manager.Ensure High quality testing is maitained and no compramise is done with respect to quality.
• Responsible for creating Master Test document.
• Prepare test scripts for testing various scenarios.
• Move teh file from Unix system into HDFS.
• Test teh Pig and Hive scipt prepared by teh ADM team to ensure teh raw file is correctly converted into teh readable formate for preforming further analysis.
• Ensure dat all teh above mentioned requirements are successfully coded and works properly. This is achieved by comparing teh result of teh ADM script with teh result achieved by teh scripts/queries prepared by myself (testing team).
• Ensure dat teh final data result present in teh text file are successfully loaded into RDBMS via sqoop.

Confidential

ETL/DW tester

Responsibilities:

• Go through teh technical spec, raise teh concerns/Static defect wherever possible and get it clarified before teh start of test window.
• Preparing test scenario and test scripts.
• Providing my inputs for Master Test Plan.
• Executing teh test scripts into QC with relevant snapshots.
• Running teh job and monetring it in Informatica and checking teh entire flow of data going into various stages and sub jobs.
• On completion of Informatica job, fire teh queries in Oracle 10g to esure data has landed successfully into teh target table.
• Compare teh content of teh source file against teh data in Oracle to ensure dat teh data has moved into teh target as per teh specification.
• Prepare teh own query based on teh specification provided and cross check teh result with teh actual result to ensure teh corrrectness of Informatica code (mapping, transformation, datatype/length check). Discrepency if any, log a defect in QC.
• Perform negative testing by providing invalid data in teh source to ensure dat teh code is stable enough to handle any false situation if occurs in live.
• Post testing teh indiviual jobs, schedule teh jobs in Autosys load runner, and check teh end end to end flow.
• Attend teh defect call for getting clarifications on teh defects/ concerns raised.

Confidential

Technical Test lead

Responsibilities:

• Plan and manages teh testing activities
• Understand teh scope of project from data wareouse prespective and ETL impact.
• Prepare test strategy document and share it with teh business.
• Review teh master test plan.
• Go through teh technical specs and raise static defects if any.
• Raise request for datstage and unix environment build.
• Assist teh team is resolving technical doubts.
• Prepare and review teh test scripts.
• Ensure high quality of testing is performed.
• Validate teh datastage code as per teh specification.
• Ensure teh schedule testing for processing teh files coming from external Hubs are working as required in live.
• Review teh testing process, check teh snapshots and proofs attached by teh team in QC to ensure 100% test coverage.
• Validate teh queries prepared by teh team to fetch teh data from teh tables in DB2.
• Review deliverbales like daily status report, weekly status report, etc.

Confidential

Technical Test lead

Responsibilities:

• Involved in understanding teh entire upstream flow to know how and wat type (XML data) data is entered into teh source database DB2.
• As teh source was XML data, additional effort was required to learn and understand teh source mapping and map teh source data and fields in teh XML records to teh target.
• Enagage teh appropriate source team to support teh testing activities and create teh policy data in XML format.
• Ensure datastage connectivity to both source and target database.
• Analyse datastage code to ensure it meets teh requirement.
• Upon successful completion of teh job, ensure teh data is successfully loaded into Netezza database.
• Constantly review teh execution status and teh monitor teh test scripts in QC to ensure no gaps are left.
• As one of teh source was flat file, checks were perfored to ensure it was successfully recived via C:D script.
• Schedules calls with Dev team, BA’s and project stakeholders with teh aim to expedite teh issue resolution process.
• Involved in Knowledge sharing and clearing teh DW and datastage concept to teh new memebers in teh team.
• Constanlty monitor cost utilization to ensure teh team is on track to finish teh project within teh communicated timelines.
• Maintain high standard and quality of testing.
• Review various deliverbles and EOTR documents.
• Responsible for checking and updating teh Monthly and yearly dashboards.

Confidential

Test lead

Responsibilities:

• Responsible for understanding teh scope of teh project.
• Prepare and review teh test scripts based on teh specification document provided.
• Understand teh datasatge code build to load teh source files coming from teh source Hub and creating teh output extracts as per teh requirement.
• Ensure teh test scripts are executed correctly in QC with all relevant snapshots.
• In case of any blockers in datastage testing, debug teh entire code to find out teh issue and highlight teh issue.
• Responsible in knowledge sharing and clarifying teh doubts raised by teh team members.
• Responsible in ensuring dat teh output files created by datastage are in correct format and data is populated as required.
• Responsible to ensure dat teh output files are moved correctly to teh target location via C:D script from where teh business would start their validation.
• Arrange and provide BAT support to load teh source files and send it to business location and halp to resolve any datastage or data warehouse related queries/concerns raised by teh BAT team.
• Prepare/Review teh EOTR document to highlight teh achievement and challenges faced during teh test window.
• Ensure there are no open defects in QC.
• Responsible in maintaining high quality testing standards