Urgent! Apps Dev Programmer Analyst 2 Job Opening In Pune – Now Hiring Citigroup
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 if applicable (good to have).
**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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm)_ _._
_View Citi’s_ _EEO Policy Statement (https://www.citigroup.com/global/eeo-aa-policy)_ _and the_ _Know Your Rights (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf)_ _poster._
Citi is an equal opportunity and affirmative action employer.
Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.
✨ Smart • Intelligent • Private • Secure
Practice for Any Interview Q&A (AI Enabled)
Predict interview Q&A (AI Supported)
Mock interview trainer (AI Supported)
Ace behavioral interviews (AI Powered)
Record interview questions (Confidential)
Master your interviews
Track your answers (Confidential)
Schedule your applications (Confidential)
Create perfect cover letters (AI Supported)
Analyze your resume (NLP Supported)
ATS compatibility check (AI Supported)
Optimize your applications (AI Supported)
O*NET Supported
O*NET Supported
O*NET Supported
O*NET Supported
O*NET Supported
European Union Recommended
Institution Recommended
Institution Recommended
Researcher Recommended
IT Savvy Recommended
Trades Recommended
O*NET Supported
Artist Recommended
Researchers Recommended
Create your account
Access your account
Create your professional profile
Preview your profile
Your saved opportunities
Reviews you've given
Companies you follow
Discover employers
O*NET Supported
Common questions answered
Help for job seekers
How matching works
Customized job suggestions
Fast application process
Manage alert settings
Understanding alerts
How we match resumes
Professional branding guide
Increase your visibility
Get verified status
Learn about our AI
How ATS ranks you
AI-powered matching
Join thousands of professionals who've advanced their careers with our platform
Unlock Your Apps Dev Potential: Insight & Career Growth Guide
Real-time Apps Dev Jobs Trends in Pune, India (Graphical Representation)
Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph below. This graph displays the job market trends for Apps Dev in Pune, India using a bar chart to represent the number of jobs available and a trend line to illustrate the trend over time. Specifically, the graph shows 8237 jobs in India and 221 jobs in Pune. This comprehensive analysis highlights market share and opportunities for professionals in Apps Dev roles. These dynamic trends provide a better understanding of the job market landscape in these regions.
Great news! Citigroup is currently hiring and seeking a Apps Dev Programmer Analyst 2 to join their team. Feel free to download the job details.
Wait no longer! Are you also interested in exploring similar jobs? Search now: Apps Dev Programmer Analyst 2 Jobs Pune.
An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at Citigroup adheres to the cultural norms as outlined by Expertini.
The fundamental ethical values are:The average salary range for a Apps Dev Programmer Analyst 2 Jobs India varies, but the pay scale is rated "Standard" in Pune. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.
Key qualifications for Apps Dev Programmer Analyst 2 typically include Other General and a list of qualifications and expertise as mentioned in the job specification. Be sure to check the specific job listing for detailed requirements and qualifications.
To improve your chances of getting hired for Apps Dev Programmer Analyst 2, consider enhancing your skills. Check your CV/Résumé Score with our free Resume Scoring Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.
Here are some tips to help you prepare for and ace your job interview:
Before the Interview:To prepare for your Apps Dev Programmer Analyst 2 interview at Citigroup, research the company, understand the job requirements, and practice common interview questions.
Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the Citigroup's products or services and be prepared to discuss how you can contribute to their success.
By following these tips, you can increase your chances of making a positive impression and landing the job!
Setting up job alerts for Apps Dev Programmer Analyst 2 is easy with India Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!
