Job Title

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. ETL Test QA Lead 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 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 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 Experience in tuning SQL queries Stored Procedures Views etc for performance improvements Knowledge of data models and entity relationship diagrams 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. 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 LTIMindtrees COVID-19 vaccination mandate for approval, in accordance with applicable state and federal law, by the date of hire.