ETL Tester

ETL Tester
Markham, Ontario (Hybrid 3 days Work From Office 2 days mandatory Tue Wed 1 day flexible any day from Mon Thu Fri)
Contract

Email: mohit@jconnectinc.com

Must have:-
Analyze business and functional requirements specific to P C insurance products eg personal auto commercial auto personal property commercial property
Design and execute manual test cases for applications testing by coordinating with SMEs and developers
Strong SQL knowledge Essential for querying and validating data across different databases and systems Strong SQL skills and experience with relational databases Oracle SQL Server Postgres etc
Solid understanding of PC insurance concepts including policy administration claims processing and underwriting
Perform functional regression integration backend and UAT testing
Collaborate with business analysts developers and product owners to ensure test coverage and quality
Identify and document defects using tools like JIRA work with development teams for resolution
Conduct API and backend testing sql to validate data integrity and system integrations
Participate in Agile ceremonies and contribute to sprint planning and retrospectives
Required Skills Experience
3-6 years of experience in ETL testing for Datawarehouse and Data mart applications
Strong domain knowledge of P C insurance including underwriting rating billing and claims
Experience with test case design execution and defect management
Proficiency in SQL for data validation and backend testing
Excellent communication and documentation skills
Ability to work independently and collaboratively in a fastpaced insurance environment
Detailoriented with a proactive approach to identifying issues and improvements
Skills
Mandatory Skills : ETL Concepts,Python,QuerySurge,ANSI-SQL,Data Testing