This role focuses on building test methodologies for ETL pipelines, data feeds, and BI solutions, leveraging Microsoft Azure cloud technologies. The position ensures data accuracy, reliability, and scalability in On-prem & cloud-hosted ecosystems, supporting the mission to deliver tailored insurance solutions, effective risk management strategies, and organizational wellbeing initiatives.

Key Responsibilities

- Validate incoming data feeds for accuracy, completeness, and consistency.
- Perform data integrity checks between source systems and target systems.
- Ensure proper handling of data transformations, mappings, and business rules in ETL pipelines.
- Conduct end-to-end testing of data feeds, including file format validation (e.g., CSV, JSON, XML).
- Monitor and validate scheduled data feed jobs for successful execution and error handling.
- Identify and troubleshoot issues in data feeds and provide actionable recommendations for resolution.
- Collaborate with data engineers to ensure proper feed configurations and error logging mechanisms.

Required Skills & Qualifications:

- Strong expertise in feed validation processes, including data integrity and format validation.
- Proficiency in SQL for data validation, reconciliation, and testing.
- Hands-on experience with ETL tools (e.g., Informatica, SSIS) and BI tools (e.g., Tableau, Power BI).
- Solid understanding of data warehousing concepts, data modeling, and database systems.
- Experience with test automation tools and frameworks,



including Selenium/Python
- Proficiency in Microsoft Azure cloud technologies, including Azure Data Factory, Azure SQL Database, and Azure Synapse Analytics.
- Strong analytical and problem-solving skills to identify and resolve data quality issues.
- Excellent communication and collaboration skills to work with cross-functional teams.
- 10+ years of experience in QA testing, with a focus on ETL, BI, feed validation, automation, and cloud technologies.

Qualifications

- Advanced knowledge and Strong experience in QA testing, with a focus on ETL, BI.
- Advanced English proficiency
- Years of Experience: + 5 Years from specified domain
- Bachelor's in computer science or other equivalent technical discipline

Work modality: Hybrid

(Candidate needs to be located or relocate to Querétaro, Guadalajara, Monterrey or CDMX, it will be requested to attend office at least 3 day per week).

If you are interested, send us your resume to [email protected]

If you are interested, send us your resume to [email protected]

Other Considerations

Tata Consultancy Services is an equal opportunity employer, our commitment to diversity & inclusion drives our efforts to provide equal opportunity to all candidates who meet our required knowledge & competency needs, irrespective of any socio-economic background, race, color, national origin, religion, sex, gender identity/expression, age, marital status, disability, sexual orientation or any others.

📌 ETL Automation Tester (Santiago de Querétaro)
🏢 Tata Consultancy Services
📍 Santiago de Querétaro