Senior ETL Tester - AVP- CHENNAI

The Testing Sr Analyst is a seasoned professional role. Applies in-depth disciplinary knowledge, contributing to the development of new techniques and the improvement of processes and work-flow for the area or function. Integrates subject matter and industry expertise within a defined area. Requires in-depth understanding of how areas collectively integrate within the sub-function as well as coordinate and contribute to the objectives of the function and overall business. Evaluates moderately complex and variable issues with substantial potential impact, where development of an approach/taking of an action involves weighing various alternatives and balancing potentially conflicting situations using multiple sources of information. Requires good analytical skills in order to filter, prioritize and validate potentially complex and dynamic material from multiple sources. Strong communication and diplomacy skills are required. Regularly assumes informal/formal leadership role within teams. Involved in coaching and training of new recruits Significant impact in terms of project size, geography, etc. by influencing decisions through advice, counsel and/or facilitating services to others in area of specialization. Work and performance of all teams in the area are directly affected by the performance of the individual.

Responsibilities:

• Supports initiatives related to User Acceptance Testing (UAT) process and product rollout into production. Testing specialists who work with technology project managers, UAT professionals and users to design and implement appropriate scripts/plans for an application testing strategy/approach.
• Tests and analyzes a broad range of systems and applications to ensure they meet or exceed specified standards and end-user requirements.
• Work closely with key stakeholders to understand business and functional requirements to develop test plans, test cases and scripts.
• Works complex testing assignments.
• Executes test scripts according to application requirements documentation.
• Identifies defects and recommends appropriate course of action; performs root cause analyses.
• Coordinates multiple testers and testing activities within a project.
• Retests after corrections are made to ensure problems are resolved.
• Documents, evaluates and researches test results for future replication.
• Identifies, recommends and implements process improvements to enhance testing strategies.
• Analyzes requirements and design aspects of projects. Interfaces with client leads and development teams.
• Exhibits sound understanding of concepts and principles in own technical area and a basic knowledge of these elements in other areas.
• Requires in-depth understanding of how own area integrates within IT testing and has basic commercial awareness.
• Makes evaluative judgments based on analysis of factual information in complicated and novel situations.
• Participate in test strategy meetings,
• Has direct impact on the team and closely related teams by ensuring the quality of the tasks services information provided by self and others.
• Requires sound and comprehensive communication and diplomacy skills to exchange complex information.
• Provide metrics related to the cost, effort, and milestones of Quality activities on a project level
• Acts as advisor and mentor for junior members of the team.
• Regularly assumes informal/formal leadership role within teams.
• Perform other duties and functions as assigned
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• 10+ years Testing Analyst experience
• Familiarity with the Software Development Lifecycle (SDLC) and how Quality Assurance methodology fits into the SDLC Knowledge of relevant operating systems, languages and database tools Knowledge of defect tracking systems and processes; including change management Knowledge of automated regression testing tools. Experience of testing trading platforms or similar software. Ability to work under pressure during tight dead lines
• Requires methodical approach to testing and problem solving. Requires theoretical and analytical skills, with demonstrated ability in planning and operations
• Excellent communication and stakeholder management skills with a proactive attitude, always seeking opportunities to add value
• Specific software languages will be dependent of area of business

Education:

• Bachelor’s/University degree or equivalent experience

We are seeking a highly skilled ETL Automation Tester with strong expertise in complex SQL, file-to-database validation, and data quality assurance. The ideal candidate will have hands-on experience validating various feed file formats (.csv, .json, .xls), and be comfortable with automation frameworks and tools for enhancing test efficiency. This role involves close collaboration with developers, data engineers, and stakeholders to ensure the integrity, consistency, and quality of data across our systems. Experience in testing reporting systems with Cognos/Tableau is required.

Key Responsibilities:

• Lead the end-to-end validation of ETL processes, including data extraction, transformation, and loading validation across large volumes of structured and semi-structured data.
• Drive data quality assurance initiatives by defining test strategy, creating comprehensive test plans, 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.
• Mentor junior testers, review test artifacts, and guide the team in best practices for ETL testing and documentation.
• Contribute to QA process improvements, testing templates, and governance initiatives to standardize data testing practices across projects.

Required Skills:

• 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.
• Proven track record in test strategy design, test planning, and defect management for large-scale data migration or ETL initiatives.
• 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.
• Excellent communication, stakeholder management, and documentation skills.

Good to Have:

• Exposure to BI tools like Cognos, Tableau, etc. for end-user report validation.
• Prior experience in validating front-end UI connected to data dashboards or reports.

------------------------------------------------------

Job Family Group:

------------------------------------------------------

Job Family:

------------------------------------------------------

Time Type:

------------------------------------------------------

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.

View Citi’s EEO Policy Statement and the Know Your Rights poster.