Swathi Chundru is a highly skilled QA Automation Engineer with over 13 years of comprehensive experience in ETL Testing, Data Warehousing (DWH) Testing, Database Testing, Functional Testing, and Automation. Her in-depth expertise spans across multiple industries, making her a key player in ensuring the quality and accuracy of complex data systems.
Expertise in ETL Tools and Data Validation
Swathi has an impressive command of various ETL tools, including Informatica, AbInitio, DataStage, SSIS, and Informatica Cloud. With her extensive experience, she has worked on different database systems such as Teradata, MS SQL Server, MySQL, IBM DB2, MongoDB, and Oracle. Swathi’s ability to create stored procedures, functions, triggers, tables, and complex queries has enabled her to efficiently validate large datasets and ensure data accuracy.
In her role, Swathi extensively uses Informatica PowerCenter for designing and monitoring workflows, worklets, sessions, mappings, and mapplets. She is proficient in analyzing and validating data quality through the Informatica Developer Client (IDQ), ensuring clean and accurate data delivery to target systems.
Proficiency in Database and Reporting Tools
Swathi’s experience extends to working with various schemas, including Star Schema, Snowflake Schema, and Fact Constellation Schema, to validate fact and dimensional tables. Her strong command over database technologies, coupled with her knowledge of complex stored procedures and triggers, allows her to deliver consistent, high-quality results.
Additionally, Swathi is experienced with a wide range of reporting tools, including Tableau, Cognos, Power BI, SSRS, Qlik, and MicroStrategy. She is highly adept at validating data in reports against the actual data in databases, ensuring consistency and accuracy in reporting.
Strong Command of Automation and Project Management Tools
Swathi’s technical expertise is complemented by her experience in test automation and project management. She has worked on scheduling tools like Control M and Tivoli to ensure proper validation of job schedules and properties. Her experience with test management tools such as HP QC/ALM, Jira, Bugzilla, and TFS allows her to efficiently manage test cases, track defects, and ensure smooth project execution.
With a strong foundation in UNIX commands and proficiency in tools like Beyond Compare and WINSCP, Swathi excels in comparing file versions, transferring files between servers, and managing directories. Her ability to automate validations through tools like ICEDQ for ETL Testing adds significant value to her role as an automation engineer.
Expert in Data Warehousing and End-to-End Project Life Cycles
Swathi has a thorough understanding of all phases of the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC). Her vast experience in Data Warehouse (DWH) Project Life Cycles, from development to system testing, gives her an edge in managing and executing complex data projects.
She is well-versed in designing test strategies, creating test plans, and developing Requirement Traceability Matrices. Swathi’s attention to detail and analytical skills enable her to validate APIs for JSON and XML, ensuring data flow from APIs to Data Warehouses is seamless.
Skilled Trainer and Leader in ETL Testing
In addition to her technical skills, Swathi is a proficient trainer. She has conducted training sessions in SQL and ETL Testing, sharing her vast knowledge with associates and helping them gain hands-on experience with various ETL tools.
Swathi’s ability to troubleshoot and optimize performance by identifying bottlenecks in workflows, combined with her experience in handling complex mappings using a variety of transformations, further exemplifies her role as an expert in her field.
A Proven Leader in Automation and Data Testing
Swathi Chundru’s journey in QA Automation and Data Warehousing testing is marked by her meticulous attention to detail, organizational skills, and ability to meet tight deadlines. Her strong communication and interpersonal skills allow her to effectively collaborate with teams and deliver exceptional results on every project.
Her dedication to ensuring data quality, optimizing performance, and mentoring others makes her a valuable asset to any organization looking to enhance its ETL, Data Warehouse, and QA Automation capabilities.