Unix Scripting Specialist Officer

Citigroup Inc.; Chennai; Híbrido; INR 1.200.000 - 2.400.000; Jornada completa

Descripción de la vacante

Citigroup Inc. is seeking a Reconciliation Developer – Officer to design, implement, test, and support data reconciliations across financial systems. You will configure matching rules, maintain data feeds, and resolve technical breaks in a hybrid setup with 2–3 days on-site in Chennai and the rest remote.

Responsibilities include scripting with Python and SQL, reviewing BRDs, and participating in Agile teams to deliver backlog items and deployment artifacts using Git and CI/CD.

Formación

• Bachelor’s degree in CS/IT/SE/Data Analytics or related field.
• 4–8 years hands‑on software development, data manipulation, or reconciliation configuration in Financial Services or IT.
• Strong Python data manipulation (pandas, numpy) and scripting.
• SQL proficiency with joins, aggregations, subqueries, and relational databases (Oracle, PostgreSQL).
• Basic familiarity with Java, Scala, or C#; batch processing with Spark/PySpark; Airflow; Kafka; cloud platforms.

Responsabilidades

• Configure, test, and maintain multi‑way matching rules and automated exception routing.
• Write and optimize Python scripts and SQL queries to load data into reconciliation engines.
• Monitor daily reconciliation runs, batch feeds, and automated jobs.
• Review BRDs and specs to implement data mappings, schemas, and validation checks.
• Collaborate in Agile ceremonies and assist with deployment artifacts via CI/CD.

Conocimientos

Python data scripting

SQL querying

Java/Scala/C# basics

Spark/PySpark basics

Airflow

Kafka

Educación

Bachelor’s degree in CS/IT/SE/Data Analytics or related

Herramientas

PySpark

Apache Spark

Snowflake

AWS

GCP

Airflow

Kafka

Descripción del empleo

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.

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.