Job Description:DATA ETL TesterLocation Markham Ontario CanadaWorking model Hybrid 3 days Work from Office 2 days mandatory Tue Wed 1 day flexible any day from Mon Thu FriTechnical Skills Primary8 + Years of Software Quality Assurance experience on enterprise level applications which includes Data Warehouse TestingExperience in writing complex SQL queriesExperience with Cloud Snowflake and AWSS3 including PostgreSQL DB SQL Database Hadoop Data LakeMust have experience in using ETL Tool informatica Power Center BDMAbility to determine the types of testing that must be conducted ie data validation regression etc including evaluating the testability of requirements and create a comprehensive test plan that supports the business and technological solutions being deliveredExperience in validating data extraction transformation and load programs daily and initial load functionality on a wide range of data repositories structured and semistructured files relational and multidimensional data storesUnderstanding of data modeling and design principles for data marts and data warehousesSecondary SkillsExperince in Mongo DBExperince in validating Informatica MDMUnderstanding of Insurance domainSoft SkillsShould be a selfstarter takes responsibility and ownership and is selfdrivenAbility to work independently with minimal supervision as well as ability to work within a teamGood team player commitment to highquality output and serviceEffective communication and teamwork skills including the ability to collaborate with cross functional teamsQualifying questionsCan you describe your experience with ETL testing Which ETL tools have you used?Have you worked with cloud platforms like AWS or Snowflake What kind of testing did you perform?How comfortable are you with writing SQL queries Can you give an example of how youve used SQL in testing?Have you tested data pipelines involving data extraction transformation and loadingHave you worked with data warehouses or data lakes What was your role in testing those systems?Have you done any testing related to data models or data marts?How do you ensure data quality during testing What kinds of issues have you identified in the past?Have you worked with tools like Informatica PowerCenter or Informatica MDM What was your involvement?Skills:Mandatory Skills : ETL Concepts,Python,QuerySurge,ANSI-SQL,Data TestingAbout Company:LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700 clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by 86,000+ talented and entrepreneurial professionals across more than 40 countries, LTIMindtree — a Larsen & Toubro Group company — solves the most complex business challenges and delivers transformation at scale. For more information, please visit https://www.ltimindtree.com/.
