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 View Citi s and the poster