Unix Scripting Specialist Officer

Citigroup; Chennai; Hybrid; INR 1,200,000 - 2,000,000; Full time

Job summary

Citigroup in Chennai seeks a hands-on Reconciliation Developer - Officer (C11) to design, test, and support data reconciliations and automated controls within financial systems.

You will implement matching rules, maintain data feeds, and resolve technical breaks, while writing Python scripts and SQL queries to move data through reconciliation engines. A hybrid work model is available.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, Data Analytics, or related field.
• 4-8 years of hands-on software development, data manipulation, or reconciliation configuration experience in Financial Services or IT.
• Solid foundation as a technical individual contributor executing assigned tasks with quality.
• Python: Practical experience with data manipulation (pandas, numpy), data parsing, and scripting.
• SQL: Strong proficiency in writing queries, joins, aggregations, subqueries, and working with relational databases (Oracle, PostgreSQL, etc.).
• Basic Understanding: Familiarity with Java, Scala, or C# is a plus.
• Working knowledge of batch data processing (e.g., Apache Spark/PySpark basics).
• Familiarity with scheduled workflow tools (e.g., Apache Airflow) and messaging/event concepts (e.g., Kafka).
• Exposure to cloud data platforms (e.g., Snowflake, AWS, or GCP) is advantageous.

Responsibilities

• Develop, configure, test, and support data reconciliations and automated data controls.
• Configure, test, and maintain multi-way matching rules, tolerance checks, and automated exception routing on reconciliation platforms.
• Investigate reconciliation breaks and discrepancies, identify root causes, and apply rule adjustments or fixes.
• Write and optimize Python scripts and SQL queries to extract, transform, and load data into reconciliation engines.
• Monitor daily reconciliation runs, batch feeds, and automated jobs from upstream systems.
• Actively deliver user stories and tasks to address the backlog of scheduled and ad-hoc reconciliation requests.
• Perform unit testing, assist with UAT, and prepare deployment artifacts using Git and CI/CD pipelines.
• Participate in daily stand-ups, sprint planning, and backlog refinement sessions within an Agile framework.

Skills

Python

SQL

Java/Scala/C#

Spark/PySpark

Airflow

Kafka

Cloud platforms

Education

Bachelor's degree in Computer Science/IT/SE/Data Analytics

Tools

Pandas

NumPy

Oracle

PostgreSQL

Job description

The Reconciliation Developer - Officer (C11) is a hands‑on technical individual contributor responsible for developing, configuring, testing, and supporting data reconciliations and automated data controls.

Working under the guidance of senior technical leads, the developer focuses on implementing matching rules, maintaining data feeds, resolving technical breaks, and executing scheduled and ad-hoc reconciliation requests across financial systems and data distribution pipelines.

Hybrid Schedule: 2 or 3 full days per week on-site in the office, with remaining days worked remotely in accordance with enterprise hybrid work policies.

Reconciliation Rule Build: Configure, test, and maintain multi-way matching rules, tolerance checks, and automated exception routing on enterprise reconciliation platforms (e.g., TLM SmartStream, Duco, Gresham, or internal reconciliation engines).

Break Analysis & Triage: Investigate reconciliation breaks and discrepancies, identify root causes in data transformations, and apply rule adjustments or fixes.

Data Processing & Scripting: Write and optimize Python scripts and SQL queries to extract, transform, and load transactional and ledger data into reconciliation engines.

Requirements Implementation: Review Business Requirement Documents (BRDs) and technical specifications to implement mapping rules, data schemas, and validation checks.

Data Feed Maintenance: Monitor daily reconciliation runs, batch feeds, and automated jobs, ensuring successful data ingestion from upstream systems.

Assisting Backlog Remediation: Actively deliver user stories and tasks to address the operational backlog of scheduled and ad‑hoc reconciliation requests.

Testing & Deployment Support: Perform unit testing, assist with User Acceptance Testing (UAT), and prepare deployment artifacts using Git and CI/CD pipelines.

Team Participation: Participate in daily stand‑ups, sprint planning, and backlog refinement sessions within an Agile framework.

Operational Collaboration: Work closely with operations users, business analysts, and quality assurance testers to clarify requirements and resolve defect tickets.

Technology Adoption: Learn and apply emerging tools and automation techniques, including data processing utilities (e.g., PySpark, Airflow) and automated anomaly detection workflows.

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, Data Analytics, or related field.
• 4-8 years of hands‑on software development, data manipulation, or reconciliation configuration experience in Financial Services or IT.
• Solid foundation as a technical individual contributor executing assigned tasks with quality.
• Python: Practical experience with data manipulation (pandas, numpy), data parsing, and scripting.
• SQL: Strong proficiency in writing queries, joins, aggregations, subqueries, and working with relational databases (Oracle, PostgreSQL, etc.).
• Basic Understanding: Familiarity with Java, Scala, or C# is a plus.
• Working knowledge of batch data processing (e.g., Apache Spark/PySpark basics).
• Familiarity with scheduled workflow tools (e.g., Apache Airflow) and messaging/event concepts (e.g., Kafka).
• Exposure to cloud data platforms (e.g., Snowflake, AWS, or GCP) is advantageous.

Time Type: Full time

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 .