Mohan Rajavelu
Smart Test Architect for Data Gov, Functional and API Automation [Data Quality, ETL, ELT Test, MDM, Data Migration, BI, AI and ML Test Design]. Banking, Finance, Insurance and Healthcare Test Analyst. Agile SM and CI/CD.
- Role
- Sr Big Data Tester at Capital Group
- Location
- Ann Arbor, MI, US
- LinkedIn followers
- 500 followers
About Mohan Rajavelu
19 Years of experience in various part of Software Industry such as Quality Assurance Supervisor, Assistant Manager, Big Data Testing, EDI Data Testing, ETL Data Validation Testing, Data Analysis, Test Automation development for Frontend web-based Application using DevOps concept, Integration / Component Level Validation, Project Gap Analysis, White Box Testing, Unit Testing and Manual Testing.# Successfully ran Daily Standup within 30min, Sprint Planning within 1hr, Sprint Review in 1hr, Backlog Refinement in 1hr and Retrospective in an hour including 15-member meeting.# One QA man resource to assure smooth STLC, Scrum and CI/CD process.# Independently handle Daily Unit Test and Deployment errors.# Extensive Experience in Big Data Quality Assurance process, Data warehouse and Data Migration and thorough understanding of SOURCE TO TARGET MAPPING (STTM) using supporting tools Hadoop, ICEDQ, HDFS, Lambda, EC2, S3, GLUE, Amazon SageMaker, Kafka Oozie, Hive, HBase, Spark, Athena, Snowflake, Zeppelin and Power BI.# Expertise in Master Data Management concepts, methodologies.# Developed Traceability Matrix for ETL Testing which is a proof of document to ensure that all the specifications are being tested and has no defect.# Tested mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica Power BI and ICEDQ.# Hands on experience on ETL processes to compare Source and Target DB’s which involves multiple layers (SRC->STG->EDW’s->MART) in between.# Worked with ETL Process to extract data from different sources Adobe Analytics, Google Analytics, Data Warehouse, Hive to Athena Raw, Processed and Confirm layer.# Hands-on experience in testing of dimensional modeling Star Schema and Snow- Flake schema, FACT and DIM tables.# Worked closely with Data Modelling team to design new tables and masterfully integrating them into the existing Warehouse structure.# Extensive Experience in Development and maintaining of QE, DSA, BDE repository in Git, Confluence, SharePoint for all Business Intelligence > Consumer Interactions Analytics related projects.# SAS ETL Testing: DDL validations, DML Validations, File based and source to target data transformation Experience in working with PL/SQL and ProcSQL, validate data from Stored Procedures and make it available for consumers to test.# Conducted Sprint Demo and Additional Review sessions with Business Teams and Consumers to validate the volume and nature of Production like scenarios during our Testing Phases.
Experience
Sr Big Data Tester
Oct 2024 — Present · PA, US
Source data validation:Transformation logic testing:Target data validation: Data quality checks: Data reconciliation testing: Constraint checks: Data profiling: Integration testing:Test case design and execution: Defect logging and tracking: Reporting and communication: Performance testing: Assessing the efficiency and scalability of the ETL process to ensure it can handle large data volumes within acceptable timeframes.
Education
University of Madras
Masters in Computer Application, Computer and Information Sciences and Support Services
2008 — 2011
University of Madras
Master's in Commerce, Business Law, Commerce, Accoutancy, Statistics and Computer Programming
2003 — 2005
The New College, Chennai
BBM, Banking Management, Business Law, Accountancy and Statistics
1998 — 2001
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.