Maha Mondi Kanakamahalakshmi Lakshmi

WORK HISTORY

EDUCATION

ABOUT MAHA MONDI KANAKAMAHALAKSHMI LAKSHMI

As an ETL Tester, I am responsible for validating data sources, extracting data using transformation logic, and uploading data into target tables. My primary role involves designing, testing, and troubleshooting the company’s data storage system before it goes live.Work Experience:Wipro Technogies, HyderabadETL Tester (Aug 16,2021 - Present)As an ETL (Extract, Transform, Load) Tester, possessing the right skills is crucial for ensuring the integrity and performance of data warehousing systems. Here are key skills that ETL Testers should have:1. SQL (Structured Query Language): SQL is essential for ETL Testers to validate data transformation and ensure data integrity between source and target systems. It allows them to verify the accuracy, consistency, and reliability of data during the ETL process2. ETL Tools (e.g, SAP Data Services, DataStage, PLSQL): Familiarity with ETL tools is crucial for designing, executing, and validating ETL processes. Each tool has its own features and capabilities, so understanding them is essential.3. Database Knowledge (e.g, Oracle): Understanding databases, data models, and database management systems (DBMS) helps ETL Testers validate data transformations and troubleshoot issues.4. Data Validation and Reconciliation: ETL Testers should be skilled in comparing data between source and target systems, identifying discrepancies, and ensuring data consistency.5. Test Case Design: Creating effective test cases is essential for validating data migration, transformation, and loading processes.6. UNIX: Familiarity with UNIX commands is valuable for managing files, directories, and permissions during ETL testing.7. Data Quality Assurance: ETL Testers need to assess data quality, identify anomalies, and ensure that data meets predefined standards.8. Performance Tuning: ETL Testers should optimize queries and processes for better performance.