| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate
ETL Test Lead/Datawarehouse TesterName: Candidate's Name
Email ID: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLEPROFESSIONAL SUMMARY
13 years of experience in ETL Testing/DWH Testing, Database testing, Functional testing. Expertise in working on different ETL tools like Informatica, AbIntio, DataStage, SSIS.
Expertise in working on different schemas like Star Schema, Snowflake Schema and Fact Constellation Schema for validating the fact and dimensional tables and their structures. Worked on different databases like Teradata, MS SQL Server, MySQL, IBM DB2, MongoDB, Oracle for validating the stored procedures, functions, triggers, cursors, tables, views, synonyms, sequences and writing complex queries to validate the data. Extensively used Informatica PowerCenter client modules Informatica Designer, Workflow manager and Workflow monitor for Testing and monitoring workflows, worklets, sessions, mappings and mapplets. Experience in using Informatica Developer Client (IDQ) for analysing and validating the quality of data that is loaded to the target table. Worked on various reporting tools like Tableau, Cognos, Power BI, SSRS, Qlik and MicroStrategy for validating the data in the reports against the data in the database.
Worked on scheduling tools like Control M and Tivoli for validating the schedules and properties of the jobs. Worked on different Project Management Methodologies like Waterfall, Agile with scrum, Safe and Kanban process. Experienced in analysing and validating complex Stored Procedures, Functions, Triggers and cursors for data being populated to the target table. Experience in working on Microsoft SSAS for analysing and validating complex Cubes with complex Facts and Dimensions for validating the different types of aggregations and measures. Experience in working with different test management tools like HP QC/ALM, Jira, Bugzilla and TFS for writing and executing test cases, uploading test results and logging defects. Experience in using UNIX commands (PUTTY) for creating, editing, copying, moving files, changing permissions, creating and removing directories. Experience in using Beyond Compare for comparing folders and different types of files and listing out the differences between the different versions of files and folders. Experience in using WINSCP for transferring the files from one server to other server and creating and deleting files and directories. Experience in using IBM Rational Team Concert (RTC) for creating tasks and logging hours for maintaining track of user stories across the project for different teams. Good knowledge in using internal tool created by client for Cleansing/Scrubbing the source data to bring the data for processing. Good knowledge in using internal tools for validating the different types of source files against the data loaded to the tables.
Worked with different types of code promotion tools to check the implementation of different versions of codes for validating.
Got trained in ICEDQ for automating the different types of validations that are regularly performed in ETL Testing. Good knowledge on OOPS concepts in Core Java and Load Runner used for performance testing. Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC). Experience in creating Test Strategy, Test Plan, Requirement Traceability Matrix, Defect summary Document and test summary documents. Experience in analysing and validating PowerShell and Shell Scripts used in control jobs for validating and loading the data. Experience in Validating the API for JSON and XML and running the end-to-end flows for validating the data flow from API to Datawarehouse. Experience in training the associates in SQL and ETL testing will providing sessions on different ETL tools used. Highly organized, detailed oriented, able to plan, prioritize work and meet deadlines. Excellent communication, interpersonal, managerial skills and good presentation and technical skills.EDUCATION Bachelor of technology in Electronics and Communications from JNT University in 2011.CERTIFICATES ISTQB foundation level certified.TECHNICAL SKILLSETL ToolsInformatica, AbIntio, DataStage, SSISDatabasesTeradata, MS SQL Server, MySQL, IBM DB2, MongoDB, OracleReporting ToolsTableau, Cognos, Power BI, SSRS, Qlik, MicroStrategyTest Management ToolsHP QC/ALM, JIRA, TFS, BugzillaOperating SystemsWindows Server 2003/2008/2012Analytical toolsSSASScheduling ToolsControl M, TivoliProject Management MethodologiesWaterfall, Agile with scrum, Safe, KanbanPROFESSIONAL EXPERIENCE
Client: Santander Consumer USA Dallas, TX July 2022 PRESENTProject: Financial SolutionsRole: Test Lead Worked in requirement gathering of the projects with business to get better knowledge on the business. Analysed business requirements and wrote test strategy and test plan as per the requirements given. Prepared test cases, test scripts and set up the test environment for smooth test execution. Analysed and validated the informatica mapping and executed the informatica sessions and monitor the sessions and check the logs in informatica workflow monitor. Validated the business scenarios by thorough validation of data in stage environment with real time data. Connected with multiple vendors across the multiple projects to validate the data with different vendors. Involved in UAT validation of every project and in the end to end testing in UAT to clear the questions from business. Worked with business to analyse and prepare data for different types of data possible from users in real time. Prepared all the relevant test closure documents after the completion of all validations in test environment and provided sign off for the project for approval to the UAT environment.Client: Santander Consumer USA Dallas, TX Aug 2020 June 2022Project: Mature ModificationRole: Senior Test Engineer Analysed business requirements and wrote test strategy and test plan as per the requirements given. Prepared test cases, test scripts and set up the test environment for smooth test execution. Analysed and validated the informatica mapping and executed the informatica sessions and monitor the sessions and check the logs in informatica workflow monitor. Validated the different types of sources that are loaded to the table and validated the data loaded to the target table. Created tasks and logging hours, writing test cases and linking them to the user story and executing the test cases. Analysed and validated the sessions as per the rules mentioned in the IDD document and S2T document provided as part of requirement. Validated the jobs in control m for the properties and scheduling as mentioned in the requirements and verifying the successful execution. Validated the stored procedures and functions as per the requirement logic and executing the objects and validated the data from end to end. Worked on different types of user stories and logged defects for the missed requirements and tracked them till the closure of the defect. Worked on the PROD issues for the data stories by analysing the failures and making sure the proper fix is in place for the failures. Worked as a coordinator between the onsite and offshore teams to delegate the work and getting stories delivered on time. Validated the SSRS and tableau reports created on the end user tables to validate the data is being populated properly in reports and end users are able to see the data for the filters. Provided walkthrough of test cases and test results to the client for approval to higher environments. Reviewed the test scripts and test cases written by peers and provided the inputs for improvement. Validated the data in production environment with the special approvals after the deployment of code to production. Analysed all the stories in each sprint and provided estimates for the peers to work based on the objects involved in the user stories. Prepared all the relevant test closure documents after the completion of all validations in test environment and provided sign off for the project for approval to the UAT environment.Client: Santander Consumer USA Dallas, TX May 2018 Jul 2020Project: BOLD 360Role: Senior Test Engineer Validated the data from end to end by writing test cases and test scripts for each requirement and created the requirement traceability mapping to ensure all the requirements are covered. Validated the DDL for the tables and views as per the structure provided in the data model and validate the data loaded in the table. Worked on different API for the request and response created in the JSON format and validate the JSON test loaded to the table by running the views and workflows. Validated the data loaded to the table for the Chats loaded from the JSON text by validating the views that convert text to table data. Verified and validate the mappings and sessions and executed the workflows to load the data and monitored the execution and verified the logs in the informatica workflow monitor. Executed the Control M jobs that are integrated to the informatica PowerCenter client to ensure the integration between two tools. Verified and validated the complex table structures with constraints and triggers created on the tables. Validated the integration between the API server and SQL server for loading the data from API to the database tables. Performed end to end testing by writing different use cases and test scenarios to cover each and every requirement. Attended the sprint planning meetings, retrospective meeting and attended scrum calls to provide timely updates on user stories.Client: Santander Consumer USA Dallas, TX May 2016 Apr 2018Project: BridgerRole: Senior Test Engineer Created the test plan, test strategy and requirement traceability matrix for all user stories related to the project. Validated the dimension and fact tables part of star schema provided in the data model of the requirement. Validated the views, synonyms, sequences, stored procedures, functions and cursors created for each user story. Created data refresh request forms to refresh the data from higher environments to lower environment to validate the different data scenarios. Worked with DBA to get the data approvals for the NPPI data getting scrubbed in lower environment to maintain security of data. Worked on data seeding/data mocking to ensure the data is flowing through all the layers of logics mentioned for case statement to avoid failures in prod environment for different types of data being processed. Worked on validating the data quality by executing the profiles and scorecards in the informatica developer client and validating the rules written on each and every data column. Worked on different kinds of control m jobs like file watchers, SQL, Command, Email, Header, Footer, file transfer to ensure proper functionality. Executed PowerShell scripts in the control m jobs for the proper loading of data and validated it. Been part of sprint planning, Sprint backlog and retrospective meeting and provided required inputs for the stories handled by team.Client: Blue Cross Blue Shield Durham, NC June 2011 Apr 2016Project: HC3014 FEP performanceRole: Test Engineer Performed test execution by executing the test cases and test scripts written based on the S2T and IDD provided. Validated the data by using the source minus target and target minus source queries and validated the counts. Validated the inbound process by validating the source files against the data loaded in the table. Validated the outbound process by validating the target files created against the data in the table. Validate the data in the tables and views by executing the workflows and monitoring them in workflow monitor. Validated the data migrated form Db2 server to Teradata server by using complex SQL queries. Attended Daly stand up meeting and scrum calls to provide updates on the user stories being worked on. Validated the General properties, scheduling, prerequisites and out conditions for the control m jobs in each control m folder. Executed the SQL jobs and Ab initio jobs to check the integration between the different tools used for end-to-end flow of data. |
