Application Developer-Global Reconciliation Utility-GRU

Citi; Chennai District; On-site; INR 2,800,000 - 5,000,000; Full time

Job summary

Citi is seeking an experienced Application Developer for the Global Reconciliation Utility in Chennai. You will design, build, and maintain critical data reconciliation infrastructure, translate complex requirements into robust solutions, and ensure data integrity across downstream systems.

You will develop ETL jobs, configure data transmission across protocols, and write Hive/Spark queries. As a Level 3 expert, you will diagnose incidents and collaborate with upstream and downstream teams to

Qualifications

• Seasoned developer with data reconciliation focus in enterprise environments.
• Experience translating complex requirements into reconciliation solutions.
• Knowledge of data formats and pipelines; experience with data integrity focus.

Responsibilities

• Develop and maintain reconciliation solutions using proprietary Citi tools.
• Configure data transmission via protocols (SFTP, Kafka, S3, etc.).
• Write Hive/Spark queries to ensure accurate data reconciliation and distribution.
• Serve as Level 3 support for incidents and coordinate with partners.

Skills

SQL proficiency

ETL & data pipelines

Job scheduling tools

Data analysis

Scripting languages

Database management

Version control

Debugging & troubleshooting

Recon domain knowledge

Tools

Autosys

PMF

Control-M

Job description

Application Developer, Global Reconciliation Utility (GRU)

Join a Mission-Critical Team at the Heart of Citi's Institutional Data Operations

Are you passionate about data integrity and building robust systems that form the backbone of a global financial institution? The Global Reconciliation Utility (GRU) is the central Technology Reconciliation partner for all Institutional Data across Citi. Our team is responsible for designing, building, and maintaining the critical infrastructure that ensures the accuracy and consistency of data flowing through our systems.

We are seeking a seasoned and self-motivated Application Developer to join our dynamic team. In this role, you will be instrumental in safeguarding Citi's data integrity. You will collaborate with business analysts to understand complex requirements and translate them into sophisticated reconciliation solutions using our proprietary tools. Your work will involve configuring data transmission via various protocols (SFTP, NDM, Kafka, S3), developing ETL jobs, and writing Hive/Spark queries to ensure data is flawlessly reconciled and distributed to downstream consumers.

As a key member of our technical team, you will be a Level 3 support expert, diagnosing and resolving complex incidents, and working closely with upstream and downstream partners to tackle data-related challenges. Your ability to manage deliverables, meet regulatory commitments, and resolve JIRA tickets in a timely manner will be crucial to our success. This is an opportunity for a proactive and autonomous developer to make a significant impact on an enterprise-wide scale.

Key Technical Skills:

• SQL Proficiency: Ability to write, debug, and optimize complex SQL queries; Expertise in data validation, joins, aggregations, and filtering logic.
• ETL and Data Pipelines: Knowledge of ETL tools and processes for data extraction, transformation, and loading; Familiarity with data flow and pipeline troubleshooting.
• Job Scheduling Tools: Experience with tools like Autosys, PMF, or Control-M for job scheduling, dependencies, and calendar settings.
• Data Analysis: Strong skills in analyzing large datasets for accuracy, completeness, and consistency; Familiarity with data formats (CSV, JSON, XML) and data mapping.
• Scripting Languages: Basic knowledge of Python, Shell scripting, or similar languages for automation and data manipulation.
• Database Management: Understanding of relational databases (e.g., Oracle, SQL Server, MySQL, PostgreSQL); Familiarity with database schemas, indexing, and performance tuning.
• Version Control: Experience with tools like Git for managing code and recon configurations.
• Debugging and Troubleshooting: Ability to identify and resolve issues in data pipelines, recon logic, and job configurations.
• Recon Domain Knowledge: Basic understanding of Capital Markets, data flow, trade life cycle, etc., will be helpful.

Additional Qualifications:

• Total Experience - 8-12 years
• IT Service Management: Experience with ServiceNow (SNOW) for incident and ticket management.
• Agile Project Management: Proficiency in using Jira for tracking tasks, managing backlogs, and participating in sprint cycles.
• Communication Skills: Excellent verbal and written communication skills, with the ability to collaborate effectively with business analysts, project managers, and other stakeholders.

• 1.SQL Proficiency: Ability to write, debug, and optimize complex SQL queries; Expertise in data validation, joins, aggregations, and filtering logic.
• 2.ETL and Data Pipelines: Knowledge of ETL tools and processes for data extraction, transformation, and loading; Familiarity with data flow and pipeline troubleshooting.
• 3.Job Scheduling Tools: Experience with tools like Autosys, PMF, or Control-M for job scheduling, dependencies, and calendar settings.
• 4.Data Analysis: Strong skills in analyzing large datasets for accuracy, completeness, and consistency; Familiarity with data formats (CSV, JSON, XML) and data mapping.
• 5.Scripting Languages: Basic knowledge of Python, Shell scripting, or similar languages for automation and data manipulation.
• 6.Database Management: Understanding of relational databases (e.g., Oracle, SQL Server, MySQL, PostgreSQL); Familiarity with database schemas, indexing, and performance tuning.
• 7.Version Control: Experience with tools like Git for managing code and recon configurations.
• 8.Debugging and Troubleshooting: Ability to identify and resolve issues in data pipelines, recon logic, and job configurations.
• 9.Recon domain knowledge. Basic understanding of Capital markets, data flow, trade life cycle etc. will be helpful

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.