ETL Developer - DataStage

Discover your future at Citi

Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, you’ll have the opportunity to grow your career, give back to your community and make a real impact.

Job Overview

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.

Responsibilities:

• Utilize knowledge of applications development procedures and concepts, and basic knowledge of other technical areas to identify and define necessary system enhancements
• Identify and analyze issues, make recommendations, and implement solutions
• Utilize knowledge of business processes, system processes, and industry standards to solve complex issues
• Analyze information and make evaluative judgements to recommend solutions and improvements
• Conduct testing and debugging, utilize script tools, and write basic code for design specifications
• Assess applicability of similar experiences and evaluate options under circumstances not covered by procedures
• Develop working knowledge of Citi’s information systems, procedures, standards, client server application development, network operations, database administration, systems administration, data center operations, and PC-based applications
• 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:

• 2+ years of relevant experience
• Experience in programming/debugging used in business applications
• Working knowledge of industry practice and standards
• Comprehensive knowledge of specific business area for application development
• Working knowledge of program languages
• Consistently demonstrates clear and concise written and verbal communication

Education:

• Bachelor’s degree/University degree or equivalent experience

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Minimum of 2 years of professional experience in ETL development.
Proven hands-on experience with an enterprise-grade ETL tool such as IBM DataStage, Talend
Strong understanding of data warehousing principles, dimensional modeling, and ETL methodologies.
Proficiency in SQL for data extraction, transformation, and loading, as well as for data analysis and troubleshooting.
Experience with relational databases (e.g., Oracle, SQL Server, PostgreSQL, MySQL).
Excellent problem-solving skills and attention to detail.
Ability to work independently and collaboratively in a fast-paced environment.
Strong communication skills, both written and verbal.
Added Advantages:
Experience with scripting or programming languages, particularly Python or Java, for data manipulation, automation, or API integrations.
Familiarity with Salesforce data models and API integrations (e.g., Salesforce Data Loader, Salesforce APIs) for data extraction or loading.
Knowledge of cloud data platforms (e.g., AWS Redshift, Azure Synapse Analytics, Google BigQuery) and cloud-based ETL services.
Experience with version control systems (e.g., Git).
Understanding of data governance and compliance best practices.

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

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.