Specialist - Quality Engineering

LTIMindtree

  • Markham, ON
  • Permanent
  • Full-time
  • 14 days ago
Job Description:Role 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 Primary
  • 7 Years of Software Quality Assurance experience on enterprise level applications which includes Data Warehouse Testing and Data mart applications
  • 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
  • Experience with Cloud Snowflake and AWSS3 including PostgreSQL DB SQL Database Hadoop Data Lake
  • Must have experience in using ETL Tool informatica Power Center BDM
  • Ability 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 delivered
  • Experience in validating data extraction transformation and load programs daily and initial load functionality on a wide range of data repositories structured and semi structured files relational and multidimensional data stores
  • Understanding of data modeling and design principles for data marts and data warehouses
Secondary Skills
  • Experince in Mongo DB
  • Experince in validating Informatica MDM
  • Understanding of Insurance domain
Soft Skills
  • Should be a selfstarter takes responsibility and ownership and is selfd riven
  • Ability to work independently with minimal supervision as well as ability to work within a team
  • Good team player commitment to highquality output and service
  • Effective communication and teamwork skills including the ability to collaborate with cross functional teams
Qualifying questions
  • Can 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 loading
  • Have 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 involvementSkills: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 83,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/.

LTIMindtree