Role Overview
We are seeking an experienced Xceptor ETL Developer to design, develop, and maintain robust and scalable ETL (Extract, Transform, Load) solutions. The successful candidate will be responsible for working with business stakeholders to gather requirements, translating these into technical specifications, and implementing data pipelines using the Xceptor platform. This role requires a strong understanding of data warehousing concepts, ETL methodologies, and the ability to troubleshoot and optimize data processes.
Responsibilities
- ETL Development: Design, develop, test, deploy, and maintain efficient and reliable ETL processes using the Xceptor platform for data extraction, transformation, and loading.
- Requirements Gathering: Collaborate with business analysts and stakeholders to understand data requirements, source systems, and data transformation rules.
- Technical Design: Translate business requirements into detailed technical specifications and ETL design documents.
- Data Quality & Governance: Implement data quality checks and validation rules within ETL processes to ensure data accuracy, consistency, and completeness. Adhere to data governance policies and standards.
- Performance Optimization: Identify and resolve performance bottlenecks in existing ETL processes and optimize Xceptor configurations for improved efficiency.
- Troubleshooting & Support: Provide ongoing support for ETL jobs, troubleshoot data loading issues, and resolve production incidents in a timely manner.
- Documentation: Create and maintain comprehensive documentation for all ETL processes, data flows, and technical designs.
- Collaboration: Work closely with data architects, data modelers, and business intelligence teams to ensure seamless data integration and reporting.
- Testing: Develop and execute unit, integration, and user acceptance test plans for ETL solutions.
- Mentorship: Potentially mentor junior developers and provide technical guidance on Xceptor best practices.
Qualifications
Essential
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven 5+ yrs of experience as an ETL Developer with hands-on experience using the Xceptor platform.
- Xceptor ETL developer certification
- Strong understanding of ETL concepts, data warehousing principles, and data modeling (star schema, snowflake schema).
- Proficiency in SQL and experience with various relational databases (e.g., Oracle, SQL Server, PostgreSQL).
- Experience with data integration from diverse sources (databases, flat files, APIs).
- Ability to analyze complex data sets and identify data quality issues.
- Excellent problem-solving, analytical, and communication skills.
Desirable
- Experience with other ETL tools (e.g., Informatica, DataStage, SSIS) is a plus.
- Familiarity with cloud data platforms (e.g., Azure Data Factory, AWS Glue, Google Cloud Dataflow).
- Knowledge of scripting languages (e.g., Python) for data manipulation and automation.
- Experience in the financial services industry.
- Understanding of Agile/Scrum methodologies.
Minimum 3 years of hands on experience with Xceptor ETL development, Testing and Implementation
------------------------------------------------------
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.
Skills Required
- Bachelor's degree in Computer Science, Information Technology, or a related field
- 5+ years of experience as an ETL Developer with Xceptor
- Xceptor ETL developer certification
- Strong understanding of ETL concepts and data warehousing principles
- Proficiency in SQL and experience with relational databases
- Experience with data integration from diverse sources
- Ability to analyze complex data sets
- Excellent problem-solving, analytical, and communication skills
- Experience with other ETL tools (e.g., Informatica)
- Familiarity with cloud data platforms
- Knowledge of scripting languages (e.g., Python)
- Experience in the financial services industry
- Understanding of Agile/Scrum methodologies
Citi Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Citi and has not been reviewed or approved by Citi.
-
Healthcare Strength — Benefits coverage is positioned as comprehensive, including health, dental, and vision insurance plus on-site clinics, prescription drug support, and disability coverage. Family-building support such as fertility assistance is described as a notable differentiator within the overall package.
-
Retirement Support — Retirement benefits are framed as strong, highlighted by a 401(k) with matching and additional plan options like a Roth 401(k). Financial support is reinforced through discounts and broader financial guidance resources tied to the benefits ecosystem.
-
Wellbeing & Lifestyle Benefits — Wellbeing support extends beyond insurance through programs like an Employee Assistance Program, counseling/legal resources, and gym or wellness reimbursement. These offerings increase the perceived total rewards value even when cash compensation sentiment varies by role.
Citi Insights
What We Do
Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.
