ETL Tester-Remote
Posted 1 week ago by 1765259142
Negotiable
Outside
Remote
USA
Summary: The ETL Tester role involves working remotely for Coforge, focusing on testing within the healthcare domain, specifically with EDI transactions and various file formats. The position requires strong ETL and SQL skills, as well as experience in regression, integration, and system testing. Candidates must demonstrate proficiency in data validation and manipulation, along with effective communication and analytical abilities. The role emphasizes a thorough understanding of healthcare standards and methodologies, including Agile and Waterfall.
Key Responsibilities:
- Conduct ETL testing within the healthcare domain, focusing on EDI transactions.
- Perform data validation and manipulation using SQL.
- Create and execute test cases and test scripts for regression, integration, and system testing.
- Conduct root cause analysis and defect tracking using JIRA.
- Utilize both Agile and Waterfall testing methodologies.
- Engage in end-to-end testing across various file layouts.
Key Skills:
- Strong ETL background with exposure to delimited, fixed, XML, and JSON file formats.
- Proficiency in SQL for data validation and manipulation.
- Experience in creating and executing test cases and test scripts.
- Strong analytical and problem-solving skills.
- Understanding of healthcare EDI standards and HL7.
- Familiarity with JIRA test management tools.
- Ability to work independently and in a team-oriented environment.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Role: ETL Tester
End Client: Coforge
Location: Remote (as of now)
Contract Type: Contract
Pay Rate: $40/hr C2C
Interview: Face-to-Face
Work Authorization: H1B, EAD- L2 USC Must have skills: ETL, Healthcare Domain, EDI Transactions (837, 835, 834, 820), HL7, Delimited Files, Fixed Files, Variable Files, XML, JSON, SQL, Joins, Functions, Group By, Data Validation, Data Manipulation, Test Cases, Test Scripts, Regression Testing, Integration Testing, System Testing, Root Cause Analysis, Defect Tracking, JIRA, Waterfall, Agile, MMIS, Analytical Skills, Problem-Solving, Communication Skills
Recent Client Interview Feedback (Mandatory Areas)
- Healthcare domain experience Mandatory
- Strong knowledge of EDI Transactions (837, 835, etc.) including headers, layouts, and related business processes
- Good understanding of HL7 standards
- Data testing & functional testing
- End-to-end testing approach
- Testing across file layouts: fixed, variable, delimited
- Understanding delimiters and differentiating delimiters vs text
- Strong SQL: joins, functions, data aggregation (GROUP BY, etc.)
- JIRA usage pros & cons
- Waterfall vs Agile testing methodologies
- Test case prioritization approach
Job Description
Required
- Strong ETL background; exposure to delimited, fixed, XML, JSON file formats
- Proficiency in SQL for data validation & manipulation
- Strong test case and test script creation & execution skills
- Experience in regression, integration, and system testing
- Ability to perform root cause analysis and defect tracking
- Strong analytical and problem-solving skills
Desired
- Understanding of Medicaid Management Information Systems (MMIS)
- Familiarity with healthcare EDI standards (837, 835, 834, 820)
- Familiarity with JIRA test management tools
- Ability to work in a fast-paced, team-oriented environment
- Ability to work independently or as part of a team with strong communication skills