Unix Scripting Specialist Officer

Overview

Hands-on individual contributor role developing, configuring, testing and supporting data reconciliations and automated data controls under senior technical leads.

What you'll do

• 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).
• Investigate reconciliation breaks and discrepancies, identify root causes in data transformations, and apply rule adjustments or fixes.
• Write and optimize Python scripts and SQL queries to extract, transform and load transactional and ledger data into reconciliation engines.
• Review Business Requirement Documents (BRDs) and technical specifications to implement mapping rules, data schemas and validation checks.
• Monitor daily reconciliation runs, batch feeds and automated jobs, ensuring successful data ingestion from upstream systems.
• Deliver user stories and tasks to address the operational backlog of scheduled and ad-hoc reconciliation requests.
• Perform unit testing, assist with User Acceptance Testing (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.
• Work closely with operations users, business analysts and quality assurance testers to clarify requirements and resolve defect tickets.
• Learn and apply emerging tools and automation techniques, including data processing utilities (e.g., PySpark, Airflow) and automated anomaly detection workflows.

What you'll need

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

Nice to have

• Basic understanding of Java, Scala or C#.
• Exposure to cloud data platforms (e.g., Snowflake, AWS or GCP).

Details

• Location: Chennai, Tamil Nadu, India.
• Hybrid schedule: 2 or 3 full days per week on-site in the office, remaining days remote per enterprise hybrid work policy.
• Employment type: Full time.