Rachana K
Mysuru
Summary
Results-driven Senior Software Engineer at CitiusTech with expertise in SQL development and ETL testing. Proven track record in validating data integrity and optimizing archival processes, enhancing data accuracy and compliance. Strong collaborator with effective problem-solving skills, adept at leveraging cloud storage solutions for efficient data management.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Senior Software Engineer
CitiusTech Healthcare Technology Private Limited
Bengaluru
10.2024 - Current
- Validated and tested data archival processes to ensure data integrity and compliance with business standards, minimizing data loss risks.
- Developed and executed SQL queries to validate data in large datasets, ensuring data accuracy during archival and migration.
- Collaborated with cross-functional teams to understand data requirements, design test scenarios, and resolve data discrepancies.
- Performed ETL testing to validate data transformations, mappings, and data loads for accurate data flow in data warehouses.
- Analyzed data structures and schemas for effective archival, optimizing data retrieval, and minimizing redundancy.
- Utilized SSMS for data validation and debugging, ensuring seamless integration of archived data into reporting systems.
- Supported data archival projects by creating test cases, executing test plans, and reporting defects for efficient issue resolution.
- Monitored and validated data archival processes in cloud environments, like AWS S3, ensuring compatibility and accessibility of archived files.
Software Engineer
Citiustech Healthcare Technology Private Limited
Bengaluru
10.2022 - 10.2024
- Developed and executed comprehensive test cases for data validation and verification, ensuring the accuracy and integrity of data in complex data systems.
- Collaborated with software development teams to understand application requirements, identify edge cases, and design effective test scenarios.
- Analyzed and optimized SQL queries to improve data retrieval performance, and support efficient decision-making in data-driven environments.
- Designed and maintained test plans for end-to-end testing of data migration processes, ensuring seamless integration of systems.
- Performed ETL testing to validate data transformations, mappings, and data loads, maintaining data consistency across systems.
- Identified and reported software defects through detailed documentation, working closely with developers for timely resolution.
- Contributed to the software development lifecycle (SDLC) by participating in requirement analysis, test planning, and defect tracking.
- Coordinated with cross-functional teams to understand business needs, translating them into technical specifications for testing.
- Conducted root cause analysis on data discrepancies, and implemented corrective measures to maintain data quality standards.
- Utilized SSMS for data validation and debugging, ensuring data consistency and accuracy during data archival and migration.
Trainee Software Engineer
Citiustech Healthcare Technology Private Limited.
Bengaluru
11.2021 - 11.2022
- Assisted in developing and executing test cases for software applications, ensuring functionality and accuracy of data processing.
- Learned and applied SQL skills to validate and analyze data in relational databases, supporting data quality efforts.
- Collaborated with senior team members to understand system requirements and implement testing methodologies for data validation.
- Gained hands-on experience in ETL testing, verifying data transformations, mapping, and loading processes.
- Participated in requirement analysis and design discussions, contributing to the development of test plans and scenarios.
- Documented test results and reported defects to the development team for timely resolution and continuous improvement.
- Supported data migration projects by ensuring the accuracy and completeness of transferred data.
- Enhanced problem-solving skills by identifying data discrepancies and assisting in root cause analysis.
- Developed basic scripting skills for data validation tasks, contributing to automation efforts.
- Adapted to a collaborative work environment, learning effective communication and teamwork skills in software development projects.
Education
Bachelor of Engineering - Computer Science And Engineering
Coorg Institute of Technology
Kodagu08-2021
Skills
- SQL Development – Writing and optimizing complex SQL queries
- ETL Testing – Validating data extraction, transformation, and loading processes
- Data validation and analysis – ensuring data accuracy and consistency in databases
- Unix/Linux Commands – Working with Linux/Unix for data processing, Mainframe tools – familiarity with JCL, TSO, and ISPF for data archival and legacy system handling
- Defect Management – Using JIRA and ALM to track and resolve issues, Informatica PowerCenter – Understanding of data pipeline testing and transformation
- Cloud Storage and Data Archival – Knowledge of data archival strategies and storage solutions
Accomplishments
- Rising Star Award – Recognized as the best fresher on the team for exceptional performance
- Client appreciation: received recognition from clients for ensuring data accuracy and improving test processes
Certification
- The Complete SQL Bootcamp: Go from Zero to Hero from Udemy
- ETL Testing: From Beginner to Expert from Udemy
Languages
Kannada
First Language
English
Upper Intermediate (B2)
B2
Tamil
Intermediate (B1)
B1
Telugu
Intermediate (B1)
B1
Timeline
Senior Software Engineer
CitiusTech Healthcare Technology Private Limited
10.2024 - Current
Software Engineer
Citiustech Healthcare Technology Private Limited
10.2022 - 10.2024
Trainee Software Engineer
Citiustech Healthcare Technology Private Limited.
11.2021 - 11.2022
Bachelor of Engineering - Computer Science And Engineering
Coorg Institute of Technology