Apps Dev Programmer Analyst 2

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.

Key Responsibilities:

• 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.

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.
• 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.

Good 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.

Qualifications:

• Bachelor's degree in computer science, Information Technology, or related field. Equivalent work experience also considered.
• 6-10 years of relevant experience in ETL testing and data warehouse validation.
• Consistently demonstrates clear and concise written and verbal communication.

Job Family Group:

Technology

Job Family:

Applications Development

Time Type:

Full time

Most Relevant Skills

Please see the requirements listed above.

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.

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.

---