Solomon D D

ETL Tester with 5+ years of experience in IT industry. Looking for a challenging role in reputable organization to utilize my technical, database and management skills for the growth of the organization and to enhance my knowledge.

• Total 5+ Years of experience in IT industry and performed ETL testing, Manual Testing and database testing with skills of Oracle SQL, UNIX, SSIS and ETL concepts.
• Analysed requirements and provided work effort estimates.
• Identified and implemented corrective measures based in gathered metrics.
• Created test cases based on the requirement.
• Conducting system integration and functional testing throughout the project in various iterations/Sprints.
• Proficient in SQL queries, SSIS validations.
• Proven experience in utlizing databases such as Oracel and SQL.
• Excellent Analysis and problem solving and communication skills.
• Experience in UNIX commands and SQL Joins, Group functions, Analytical functions and sub queries.
• Experience in Fact table and Dimension table analysis.
• Worked in the UNIX commands like grep, awk and find etc..
• To process the files in the UNIX environment.

Client: Adrent Captial Advisors | UK

Domain: Investment Banking

Databases: SQL Server, Snowflake

ETL Tool: Talend, Informatica

• Involved in analyzing business requirement documents, data mapping sheets, and risk model specifications to design effective test plans and test cases.
• Participated in peer review of test cases and test scripts to ensure coverage and accuracy before executing in the SIT environment.
• Performed row count validation, duplicate checks, metadata validation, referential integrity, and business rule validations across client portfolio datasets.
• Created detailed test scripts using SQL for data validation and Python for automated data quality checks including nulls, outliers, and transformation logic.
• Used UNIX commands like grep, awk, sed, and find to validate and parse raw market data files from Bloomberg and Reuters feeds.
• Logged defects in JIRA with attached test evidence and assigned them to the development team based on severity and priority.
• Actively participated in Agile ceremonies including sprint planning, daily stand-ups, and retrospectives, contributing to clarification of requirements and test scope.
• Conducted smoke testing for initial build validation, regression testing for impact analysis, and sanity testing for quick functional checks.
• Communicated effectively with business analysts and data engineers to resolve requirement gaps and ensure accurate implementation of risk scoring logic.

Client: AutoZone | US

Domain: Retail

Database: Oracle 12c,SSIS

Tool: JIRA, IICS, Tableau

Role: ETL Tester

• Created test cases in excel sheet and uploaded in JIRA.
• Used joins and subqueries to validate referential integrity relation between fact and dimension tables.
• Used JIRA tool to track the bugs based on priority and severity and until completion. ∙ Connected with business analyst to understand complex requirements.
• Before sign off checked RTM and Prepared the test closure document while doing sign off. ∙ Involved in peer-to-peer validation for test cases.
• Worked on impact analysis on the existing automation scripts.

Client:

Domain: Healthcare

Database:

ETL Tool:

• Partnered with Molina Healthcare, a leading U.S.-based healthcare and insurance provider serving Medicaid, Medicare, and Marketplace members.
• Involved in ETL testing of claims, enrollment, and provider data across multiple source systems and data warehouses.
• Validated member eligibility, policy details, premium payments, and claims adjudication data for accuracy and consistency.
• Conducted data quality checks to ensure HIPAA compliance and alignment with healthcare regulatory requirements.
• Developed and executed SQL queries to verify transformations, aggregations, and business rule implementations.
• Collaborated with business analysts to validate provider network data and patient service utilization reports.
• Prepared test cases, test results documentation, and defect reports to ensure smooth delivery of reporting solutions.