Role description
4 positions open
Years of exp 4 to 7 less than 7
client office Location Bangalore
Hybrid
QA Data Testing Engineer
We are looking for a Data ETL Test Engineer 56 years with strong experience in ETL testing data migration and Alteryx You will validate data pipelines endtoendcovering extraction transformation and loadingand ensure accurate reliable data movement across onprem and cloud platforms eg Azure
Key Responsibilities
Define ETL test strategy and plans across multiple sourcestargets create comprehensive test cases scenarios and test data
Perform indepth data validation and reconciliation using advanced SQL joins aggregations window functions and profiling techniques
Build and maintain Alteryx workflowsmacros for data validation reconciliation profiling parsing cleansing regex batchiterative logic and exception reporting
Validate filebased integrations MFTSFTP file formats CSV XML JSON and largevolume data handling
Test and troubleshoot APIintegration flows eg MuleSoft or similar across upstream and downstream systems
Oversee data migration dress rehearsals and golives perform pre and postmigration checks and signoffs
Automate repetitive validation tasks using Alteryx andor scripting document results and provide improvement recommendations
Log and manage defects communicate status risks and coverage to stakeholders
MustHave Skills
Strong SQL expertise and sound understanding of relational data models and DB concepts
Handson Alteryx Designer complex workflows macros regex iterativebatch processing
ETL testing experience sourcetotarget mapping transformation rules data reconciliation
Experience validating integrations via API testing tools Postman and handling MFTSFTP
Experience with defect management JiraHP ALMAzure DevOps and AgileScrum ways of working
Strong analytical problemsolving and communication skills
NicetoHave
Azure data platform exposure Data Lake Databricks Synapse or similar cloud stack
REST Assuredautomation of APIETL validations
Alteryx Designer Core certification ISTQB certification
Skills
Mandatory Skills : Data Testing
About LTM
LTM is an AI-centric global technology services company and the Business Creativity partner to the world’s largest and most disruptive enterprises. We bring human insights and intelligent systems together to help clients create greater value at the intersection of technology and domain expertise. Our capabilities span integrated operations, transformation, and business AI — enabling new ways of working, new productivity paradigms, and new roads to value. Together with over 87,000 employees across 40 countries and our global network of partners, LTM — a Larsen & Toubro company — owns business outcomes for our clients, helping them not just outperform the market, but to Outcreate it. Please also note that neither LTM nor any of its authorized recruitment agencies/partners charge any candidate registration fee or any other fees from talent (candidates) towards appearing for an interview or securing employment/internship. Candidates shall be solely responsible for verifying the credentials of any agency/consultant that claims to be working with LTM for recruitment. Please note that anyone who relies on the representations made by fraudulent employment agencies does so at their own risk, and LTM disclaims any liability in case of loss or damage suffered as a consequence of the same. Recruitment Fraud Alert - https://www.ltimindtree.com/recruitment-fraud-alert/