ETL Testing Specialist, Citi

Citi

Location:
India, Chennai

Category:
IT - Software Development

Contract Type:
Employment contract

Salary:

Not provided

Save Job

Apply Position

Job Description:

The Applications Development Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities. We are seeking a ETL Testing Specialist experience in validating enterprise-scale data warehouse and ETL solutions. The ideal candidate will have deep expertise in data validation, complex SQL, and file-to-database comparisons. This role demands strategic thinking, strong analytical skills, and the capability to work closely with cross-functional teams to ensure end-to-end data quality and compliance.

Job Responsibility:

End-to-end validation of ETL processes, including data extraction, transformation, and loading validation across large volumes of structured and semi-structured data
Contribute to data quality assurance initiatives like test strategy and executing test cases based on data mapping documents and transformation logic
Validate file-based feeds (.csv, .json, .xls, etc.) by ensuring accurate ingestion into target data warehouse environments
Develop and optimize complex SQL queries to perform deep data audits, aggregation checks, and integrity validations across staging and warehouse layers
Own the defect lifecycle using tools like JIRA, providing high-quality defect reporting and traceability across all testing cycles
Collaborate with business analysts, developers, and data architects to ensure test alignment with business expectations and technical design
Perform report-level validations in tools such as Cognos or Tableau, ensuring consistency between backend data and visual representations
Contribute to QA process improvements, testing templates, and governance initiatives to standardize data testing practices across projects
Contribute to QA automation initiatives, including scripting, framework enhancement, and CI/CD integration
Support functional UI testing.

Requirements:

Strong hands-on experience in ETL and data warehouse testing
Advanced proficiency in SQL and strong experience with RDBMS technologies (Oracle, SQL Server, PostgreSQL, etc.)
In-depth experience with file-to-database validation and knowledge of various data formats
Experience with ETL tools like Talend, or custom data processing scripts (tool-specific expertise not mandatory)
Strong understanding of data modeling concepts, referential integrity, and transformation rules
Familiarity with Agile methodologies and experience working in fast-paced environments with iterative delivery
Exposure to BI tools like Cognos, Tableau, etc. for end-user report validation
Excellent communication and documentation skills.

Nice to have:

Prior experience in validating front-end UI connected to data dashboards or reports
Understanding of API testing where applicable in the data generation or file generation process
Knowledge on ETL testing automation.

Additional Information:

Job Posted:
August 05, 2025

Employment Type:

Fulltime

Work Type:

Hybrid work

View All Jobs In This Company

Job Link Share:

ETL Testing Specialist