About Us:

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 nearly 90,000 talented and entrepreneurial professionals across more than 30 countries, LTIMindtree - a Larsen & Toubro Group company - combines the industry-acclaimed strengths of erstwhile Larsen and Toubro Infotech and Mindtree in solving the most complex business challenges and delivering transformation at scale. For more information, please visit .

Job Title:

ETL Test QA Lead

Location:

Markham, CA

Description:

8 Years of Software Quality Assurance experience on enterprise level applications which includes Data Warehouse Testing

Experience with Cloud Showflake and AWSS3 including PostGres DB SQL Database Hadoop Data Lake and Mongo DB

Must have experience in using ETL Tool informatica Power Center BDM

Experience with developing 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 stores

Experience with data integration data cleansing and data analytics

Experience with data modeling and design principles for data marts and data warehouses

Experience in writing complex SQL queries Experience in writing complex SQL queries 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

Should have experience testing multiple test phases in medium to large projects

Understanding of information governance principles and how they could apply in a testing capacity

Should have adequate experience and clear understanding of data warehouse and data mart testing

Identification and Test Data Preparation Techniques

Ability to transform complex Business logic into SQL or PLSQL queries

Thorough knowledge of Software Test Life Cycle Test Case Life Cycle Defect Life Cycle etc

Creating requirements traceability matrix RTM

Proficiency with Test Case Preparation and Execution

QA Automation Test tools expertise using Python

Extensive exposure to ETL testing with highlevel of SQL skills is required

Should have exposure to large data sets and understand Data Quality Framework

Experience in data analysis including profiling auditing balancing and reconciliation in an Information technology operating environment

Defect tracking experience ie Jira ALM etc

Experience in tuning SQL queries Stored Procedures Views etc for performance improvements

Should be detail oriented with analytical mind set

Knowledge of data models and entity relationship diagrams

Must have the ability to multitask and adapt quickly to changes while maintaining urgency in completing assigned tasks

Soft Skills

Excellent problem solving and analytical skills able to handle challenging situations and act appropriately

Excellent learning skills must learn and also guide other team members on their knowledge

Should be a selfstarter takes responsibility and ownership and is selfdriven

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"

Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree ("LTIM"):

The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.

Disclaimer: The compensation and benefits information provided herein is accurate as of the date of this posting.

LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.

Safe return to office:

In order to comply with LTIMindtree' s company COVID-19 vaccine mandate, candidates must be able to provide proof of full vaccination against COVID-19 before or by the date of hire. Alternatively, one may submit a request for reasonable accommodation from LTIMindtree's COVID-19 vaccination mandate for approval, in accordance with applicable state and federal law, by the date of hire. Any request is subject to review through LTIMindtree's applicable processes.