Unix Scripting Specialist Officer

Citi; Chennai; Hybride; INR 1 500 000 - 2 600 000; Plein temps

Avantages offerts par ce poste

Hybrid work model

Résumé du poste

Citi is seeking a Reconciliation Developer – Officer (C11) to build and tune multi-way reconciliation rules, maintain data feeds, and resolve technical breaks in financial data ecosystems.

The role emphasizes Python/SQL scripting, Spark/PySpark basics, Airflow, and cloud data platform exposure, with a hybrid on-site/off-site work model in Chennai.

Qualifications

• Bachelor's degree in CS/IT/Engineering/Data Analytics or related field.
• 4–8 years of hands-on software development, data manipulation, or reconciliation configuration.
• Strong technical contributor with quality output.
• Proficiency with Python for data manipulation (pandas, numpy) and scripting.
• SQL proficiency with joins, aggregations, and subqueries on relational DBs.
• Basic familiarity with Java/Scala/C# is a plus.
• Working knowledge of batch processing (Spark/PySpark) and Airflow/Kafka.
• Exposure to Snowflake, AWS, or GCP is advantageous.

Responsabilités

• Configure, test, and maintain multi-way matching rules and automated routing.
• Develop, test, and support data reconciliations and data controls.
• Write Python scripts and SQL to extract, transform, and load data into reconciliation engines.
• Review BRDs and technical specs to implement mappings and validations.
• Monitor daily reconciliation runs and upstream data feeds; fix issues.
• Contribute to backlog remediation and user story delivery in Agile sprints.
• Support testing (unit, UAT) and deployment artifacts via Git/CI/CD.
• Collaborate with operations, analytics, and QA teams to resolve defects.

Connaissances

Python

SQL

Pandas

NumPy

PySpark

Airflow

Kafka

Java/Scala/C#

Formation

Bachelors in CS/IT/Engineering/Data Analytics

Outils

Snowflake

AWS

GCP

Oracle

PostgreSQL

Git

CI/CD

Apache Airflow

Description du poste

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.

Requirements

• 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.

Job Family Group

Technology

Job Family

Applications Development

Time Type

Full time

Most Relevant Skills

Please see the requirements listed above.

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.