Home

Vijay - ETL Tester

[email protected]

Location: Jersey City, New Jersey, USA

Relocation: Yes

Visa: H1B

Vijayasekar Muthumani Place Edison, New Jersey, USA PROFESSIONAL SUMMARY: Having overall 12+ years Experience in QA Software Testing Having 9+years experience in ETL/Big Data Testing, BI / Data Visualization Testing and as Business Data Analyst Strong 7+ years experience in Health Care / Life Science Domain. Strong 4+yrs Experience in HCM Domain Good Experience in QA Testing, Business Analysis wit Client facing experience and Support. Good Experience as Test Lead with Team Handling skills. Also worked as Individual Contributor Worked in various Databases like Oracle, MSSQL, MYSQL, POSTGRESSQL, AWS Redshift, Mongo DB A Quick learner, self-starter, highly motivated individual possessing strong analytical power, and Problem-solving abilities. Liaise with onsite counterparts in gathering project requirements and work closely with onshore counterparts in delivering projects. Understand project / technical requirements and work with onsite team and Developer to address ambiguities in requirements. Define Test Strategy, Test Plans for the project and manage resources for testing. Involved in creating source to target mapping, edit rules and validation, transformations, and business rules Work on managing multiple activities/projects. Mentor junior team members and help to solve their technical/functional queries. Strong knowledge in SQL Good Knowledge Python for Data Analysis Using Pandas Data frame and Pytest to perform Unit Test Good Knowledge API testing of XML and JSON using Postman Experience in Automation ETL Testing using Python integrated with CI/CD pipeline using Jenkins and Maven Experience working on HiveQL, Redshift, Athena, Snowflake, GCP BigQuery. Experience UAT Testing Experience in Agile Methodology using Scrum. Interfacing and interacting with the technical teams, Business analyst and End Users. Experienced working towards building a strong team/work environment and have the ability to acclimate to new technologies and situations with ease. Ability to communicate verbally and via written documentation and work under minimal supervision. DOMAIN: HRMS, Banking, Payments, Automobile, Clinical Research, Health care, Life Science, GRC SKILLS: Database Oracle 11G, SQL Server, HIVE, Amazon Redshift, Mongo DB, GCP BigQuery ETL Tool ODI 12c, SSIS, Talend, Informatica Power Centre Reporting Tool OBIEE 11G, SSRS, Tableau, Google Looker Datawarehouse - AWS Redshift, Snowflake, Big Query Cloud Amazon Web Services, GCP, Azure, AWS Glue, AWS Lambda, Ec2, S3, Dataproc, Pub/Sub, CLoud Function. Hadoop - AWS EMR, GCP Dataproc, Cloudera, UNIX API - XML, JSON CI/CD tools - Maven, Jenkins, UNIX Test Management JIRA CERTIFICATIONS AND TRAININGS: Completed Training on Oracle SQL-iconic clinical research. Dipl med'Etudesen Langue Fran aise - DELF A1, DELF A2 (French Language). ISEB foundation certificate in Software Testing. Certified AWS Data Analytics. Prince 2 Agile Project Management Foundation Certified. EXPERIENCE: Lead Software QA/BA - ETL/Big Data SMBC BANK USA - Remote 23-Feb-2023 - till date Conducting workshops with Business to understating the requirement. Initiating FSD to Business, creating source to Target Data Mapping sheet and Validate FSD. Interacting with Business and Application End user to understand Various source systems to check how the data is setup in each systems, Performing Gap Analysis, Doing Data Analysis and Data Profiling on Source data Conducted requirements walk-through with the Users, Development, and project Management team and testing team. Analyzing Requirements based on the Data Mapping Sheet, BRD and TDD Validating Data from GCP Cloud Storage to GCP BigQuery. Validating API data from upstream application to GCP Pub/Sub to GCP BigQuery. Automating the Testing Pipeline using Python to validate count and Data from Source and Target Performing API testing using Postman. where data is loaded in GKE clusters (Kubernetes) Involved in Report and Dashboard Testing from BigQuery to Looker Dashboard. Validating LookML code are as per Business Requirements. Testing Dashboard and Drill down reports using SQL. Preparing Test Cases for both Data Lineage Testing and Data Reconciliation Testing Testing Snapshot and Delta Load Validating Business logic for Data Quality and Data Integrity using SQL Writing complex SQL Queries using Analytical function for Data Analysis from Source to Target. Manage daily activity to meet all deadlines. Prepare Test Planning, Test Strategy and Test Approach Document. Providing Estimates for Testing Tasks Manage daily activity to meet all deadlines. Providing feedback/updates to relevant Project Managers. Participation in Daily Scrum Stand-Up meeting along with the managers, Developers Environment - GCP, Parquet, pyspark, Python, flat files, Rest-API Senior Specialist - Data Engineering - QA LNT Infotech, India (Client Marsh McLennen - Project Marsh Digital - Insurance and Banking Domain) Jan-2022 to Jan-2023 Responsibility: Reviewing BRD and TDD to understand the ETL Requirement Preparing Test Cases for both Data Lineage Testing and Data Reconciliation Testing Validating Data From Extract File (Flat File) processed thru Informatica BDM into Amazon S3 Raw Layer, from Raw layer and Processed Layer (Amazon Redshift) then to Data Mart (Tableau Reporting Testing) . Performed End to End Testing Identifying the ETL Process and validating the Transformation Logic for ETL Testing. Using SQL / Python. Testing Snapshot and Incremental Load Testing. Using JIRA for Agile Scrum Story Board and Defect Tracking Performed testing on multi database testing like SQL Server, PostgreSQL, Redshift Performing Data Quality Testing Using Python with Pytest like Null Check, Unique Value Check, Data Type Test and Lookup values Test. Performed using Python / Pyspark Data Frame to do Data Analysis Task. Work in conjunction with BI and Data Engineers to ensure high quality Data Deliverable. Writing complex SQL Queries using Analytical function for Data Analysis from Source to Target. Validating data from S3 bucket, Flat Files/CSV Files to Raw Layer using Validating Raw Layer. Validating data from Mart to Tableau Reports Reports Testing/BI Testing. Testing BI Dashboard for UI, Filter conditions, User Profile restriction. Manage daily activity to meet all deadlines. Worked as a Individual Contributor Prepare Test Planning, Test Strategy and Test Approach Document. Provide Post Implementation Support for UAT for Preparing Test Data and Assisting Business users. Preparation of Test Scenarios & Cases, Expected Results for the release. Providing Estimates for Testing Tasks Provide Input on client clarification. Assisting Business Analyst in UAT Tetsing phase Participation in Daily Scrum Stand-Up meeting along with the managers, Developers Took part in the meetings with Sr. Business Analyst and managers and understood various process plans, business process, and functionality in detail. Environment - Informatica BDM, AWS Redshift, Step Functions, AWS Lambda, Tableau, JIRA, SQL, Python Specialist - Data Analytics - Technical BA/QA 10-Aug-2020-31-July-2021 CMA-CGM, India Responsibility: Conducting workshops with Business to understating the requirement. Initiating FSD to Business, Create Data Mapping and Validate FSD. Conducted requirements walkthrough with the Users, Development, and project Management team and testing team. Identifying Testing Objective, Analysis of test requirement and Test case documentation. Identifying the ETL Process and validating the Transformation Logic for ETL Testing. Performing Data Integrity Checks and Data Quality Checks and Data Profiling using SQL. Testing Data from various DB s like MySQL, Oracle and PostgreSQL. Used Inner join, Outer Join, MINUS operations and Case statements in SQL scripts Monitor Daily Dashboard to improve the Quality of Data. As Team Lead assigned Testing Tasks for Team Members, Conducting Daily Scrum Meeting with Off-shore Team Providing feedback/updates to relevant Project Managers. Work in conjunction with BI and Data Engineers to ensure high quality Data Deliverable. Writing complex SQL Queries to validate data in the data repositories against the data in the source systems. Validating data from Source to ODS and ODS to Mart -ETL Testing. Validating Qlik Reports Reports Testing/BI Testing. Manage daily activity to meet all deadlines. Consultant - Data Analytics 26-Oct-2018 to 08-May-2020 Bhawan Cybertek, India Client:- AstraZeneca (HEalth Care Domain) Responsibility: Identifying Testing Objective. , Analysis of test requirement and Test case documentation. Identifying the ETL Process and validating the Transformation Logic for ETL Testing. From Source Workday HCM to DWH Woking with Talend to perform Data Load, Data Quality Checks for the data loaded in Target Database. Testing Snapshot and Incremental Load in ETL Testing. Performed Automation ETL Testing using Python, Jenkins and Maven to automate. Performing Data Integrity Testing and Data Quality Testing. Work in conjunction with BI and Data Engineers to ensure high quality Data Deliverable. Writing complex SQL Queries using Analytical function for Data Analysis from Source to Target. Validating data from Source to ODS and ODS to Mart -ETL Testing. Validating data from Mart to MSTR Reports Reports Testing/BI Testing. Written positive and negative test cases for MicroStrategy reports based on report specifications. Validated several Drilldown and Pivot reports published in MicroStrategy Testing BI Dashboard for UI, Filter conditions, User Profile restriction. Manage daily activity to meet all deadlines. Prepare Test Planning, Test Strategy and Test Approach Document. Provide Post Implementation Support for UAT for Preparing Test Data and Assisting Business users. Preparation of Test Scenarios & Cases, Expected Results for the release. Provide Input on client clarification. Participation in Daily Scrum Stand-Up meeting along with the managers, Developers Took part in the meetings with Sr. Business Analyst and managers and understood various process plans, business process, and functionality in detail. Environment - Talend Big Data, Snowflake, AWS Redshift, MSTR, JIRA, SQL, Python Data Quality Engineer 05-Apr-2018 to 25-Oct-2018 Wipro, India Client - Kohls Responsibility: Identifying Testing Objective. Analysis of test requirement. Test case documentation. Identifying the ETL Process and validating the Transformation Logic for ETL Testing. Testing Snapshot and Incremental Load in ETL Testing. Writing complex SQL Queries using Analytical function for Data Analysis from Source to Target. Identify the Test Requirements inbound to Hadoop Hive Big Query mapping and Data Analysis Performing and Validating Hadoop Testing Using Hive, Big Query (Google Cloud Platform) Writing Complex Queried in GCP Big Query Ensuring GCP Big Query Migration is successful Performing DB to File and File to DB data validation Ensure all the QA Activities are as per schedule. Manage daily activity to meet all deadlines. Prepare Test Planning, Test Strategy and Test Approach Document. Provide Post Implementation Support for UAT for Preparing Test Data and Assisting Business users. Preparation of Test Scenarios & Cases, Expected Results for the release. Provide Input on client clarification. Conduct Daily Scrum Meeting internally within Testing Team. Providing feedback/updates to relevant Project Managers. Participation in Daily Scrum Stand-Up meeting along with the managers, Developers. Conduct Scrum Meeting for internal Testing team. Facilitate Scrum Retrospective for internal Testing team along with Test Manager. Took part in the meetings with Sr. Business Analyst and managers and understood various process plans, business process, and functionality in detail. Senior System Engineer 10-Oct-2017 to 31-Mar-2018 IQVIA, India (Healthcare Domain) Responsibility: Identifying Testing Objective and Validation Scope. Analysis of test requirement. Test case documentation. Identifying the ETL Process and validating the Transformation Logic for ETL Testing. Testing Snapshot and Incremental Load in ETL Testing. Writing complex SQL Queries using Analytical function for Data Analysis from Source to Target. Identify the Test Requirements inbound to Hadoop mapping and Data Analysis. Performing Hadoop Testing Using Hive, Impala, Scoop and Spark. Ensure all the QA Activities are as per schedule. Manage daily activity to meet all deadlines. Prepare Test Planning, Test Strategy and Test Approach Document. Provide Post Implementation Support for UAT for Preparing Test Data and Assisting Business users. Preparation of Test Scenarios & Cases, Expected Results for the release. Provide Input on client clarification. Conduct Daily Scrum Meeting internally within Testing Team. Providing feedback/updates to relevant Project Managers. Participation in Daily Scrum Stand-Up meeting along with the managers, Developers. Conduct Scrum Meeting for internal Testing team. Facilitate Scrum Retrospective for internal Testing team along with Test Manager. Took part in the meetings with Sr. Business Analyst and managers and understood various process plans, business process, and functionality in detail. Raising defects where discrepancy found in the database and reporting it to the onshore development team. ETL/EDW - BI 03-Mar-2013 to 31-May-2017 ICON Clinical Research, India (Healthcare Domain) Responsibility: Project Name PFIZER-CAL (CLINICAL AGGREGATION LAYER)-R5 Client Pfizer Technologies: - ODI, OBIEE, XML Spy, Soap UI Project Perspective: The Enterprise Data Warehouse (EDW) is aimed at extracting the clinical trials data from Multiple disparate source systems in a meaningful way to CDR and OMR repositories by building data warehouse and data marts to meet the overall objectives of the ICONIK (ICON Immediate Knowledge) initiative, with the objective of providing secure access to the clinical data with appropriate analysis tools in an operational, holistic and aggregate manner that supports their decision making Identifying Testing Objective and Responsibility: Understanding Validation Scope. Analysis of test requirement Test case documentation Identifying the ETL Process and validating the Transformation Logic for ETL Testing. Testing Snapshot and Incremental Load in ETL Testing. Writing complex SQL Queries using Analytical function for Data Analysis from Source to Target. Identify the Test Requirements inbound to Hadoop mapping and Data Analysis Performing Hadoop Testing Using Hive and Impala Verifying data in HDFS ecosystem using Cloudera HIVE Monitoring Hadoop Jobs using OOZIE Dashboard Middleware API testing (XML and JSON) using SOAPUI. Performing BI Reporting testing. Ensure all the QA Activities are as per schedule. Manage daily activity to meet all deadlines. Prepare Test Planning, Test Strategy and Test Approach Document. Provide Post Implementation Support for UAT for Preparing Test Data and Assisting Business users. Preparation of Test Scenarios & Cases, Expected Results for the release. Provide Input on client clarification. Conduct Daily Scrum Meeting internally within Testing Team Providing feedback/updates to relevant Project Managers. Participation in Daily Scrum Stand-Up meeting along with the managers, Developers Conduct Scrum Meeting for internal Testing team. Facilitate Scrum Retrospective for internal Testing team along with Test Manager Took part in the meetings with Sr. Business Analyst and managers and understood various process plans, business process, and functionality in detail. Raising defects where discrepancy found in the database and reporting it to the onshore development team. Consultant 23-Jul-2012 to 30-Jan-2013 Helios and Matheson Client Bank of America, India Project Name Online Payment Process Project Perspective: Payments coming for Indian Retail banking customer will be processed via SWIFT messages and XML in core banking system in Bank of America and the same will be validated and responded back. Responsibility: Reviewed BRD and LLD/HLD to identify business process and design. Identifying the Objective and Testing Scope. Prepared Test plan for the project based on the BRD and LLD/HLD documents. Ensure all the QA Activities are as per schedule. Validating SWIFT Messages flat files against XML. API Testing using SOAP UI. SPOC for all QA related Queries and deliverables. Manage daily activity to meet all deadlines. Preparation of Test Scenarios & Cases, Expected Results for the release. Involved in End-to-End testing. Providing feedback/updates to relevant Project Managers. Participation in Daily Stand-Up meeting along with the managers, Developers Took part in the meetings with Sr. Business Analyst and managers and understood various process plans, business process, and functionality in detail. Consultant 03-Aug-2011 to 13-Apr-2012 Ciber, India Client Ford Motors Project Name Product Definition and Offering (PDO) Responsibility: Analyzing requirements and understanding business process. Thorough understanding of reengineering and designing processes. Doing reviews of standard operating procedures and updating the feedback to the Business Analyst. Involved in planning and estimation meeting. Preparation of Use cases, Test Scenarios (Basic path and Alternate Path), & Cases, Test Matrix, Expected Results for each release. Involved in basic flow and Alternate flow (End to End) testing. Preparation of Test Bed to enable QA Team to effectively Test all Functional Scenarios. Providing feedback/updates to relevant Project Managers. Participation in Daily Stand-Up meeting along with the managers, Developers Took part in the meetings with Sr. Business Analyst and managers and understood various process plans, business process, and functionality in detail. QA Engineer 13-Aug-2010 to 13-May-2011 Mastek, India Client Fidelity Management and Research Corporation, USA Project Name OSG Mail Services Content Management and Image Capture Services Responsibility: Analyzing requirements. Doing reviews of requirements and updating the feedback to the Managers Preparing QA Metrics and tracking the QA status as per the plan. Preparation of Master Test Scenarios & Cases, Expected Results for each release. Involved in End-to-End functional testing. Involved in Regression Testing on SAT. Preparation of Test Bed to enable QA Team to effectively Test all Functional Scenarios. Providing feedback/updates to relevant Project Managers. Responsible to manage the requirement throughout the project lifecycle like reviewing regularly and changing the necessary Test cases, Scenarios and Test Data s accordingly. Scheduling, Managing and Tracking the testing Activities as per the project plan. Participation in Daily Stand-Up meeting along with the managers, Developers. Took part in the meetings with Sr. Business Analyst and managers and understood various process plans, business process, and functionality in detail. EDUCATIONAL QUALIFICATION: M.Sc. (Software Engineering), [ 2007-2009] (Annamalai University, Chidambaram) Keywords: continuous integration continuous deployment quality analyst business analyst user interface business intelligence sthree database information technology South Carolina