Senior Software Engineer

Location Name: Pune Corporate Office - Mantri

Job Purpose

3in1 Data Tech team manages data which is consumed by applications like- 3in1 App/web, Customer 360, IVR and other digital channels. To provide timely delivery and to manage data integrity between source system and Cosmos DB resources are required.

Duties And Responsibilities

• ETL Development
  
  

Design and develop ETL pipelines to transfer data from source systems (Data Lake) to target systems (NoSQL or RDBMS).

Develop Azure Functions to capture and process data modifications occurring in Cosmos DB collections, as required.

• Reconciliation Development and Analysis
  
  

Develop reconciliation logic to compare data between source systems (Data Lake) and target systems (NoSQL or RDBMS).

Analyse reconciliation reports and investigate discrepancies or data issues identified during validation.

• Code Review
  
  

Review code developed by junior team members and provide constructive feedback to improve code quality, correctness, and performance optimization.

• Support
  
  

Provide operational support for ETL and reconciliation job failures.

Identify and resolve data or code-related issues causing job failures in ETL or reconciliation processes.

Provide timely support to API and application teams as required.

• Cosmos DB Monitoring
  
  

Monitor Cosmos DB for RU consumption, throttling, and overall performance.

Analyse logs and metrics to identify and troubleshoot potential issues proactively.

• IT Requests
  
  

Coordinate with the Tech-Ops team to track, follow up, and close IT service requests.

Ensure timely resolution of user-related queries and operational requests.

• BRD Discussion
  
  

Conduct initial-level requirement discussions with business stakeholders for new initiatives or enhancements.

Key Decisions / Dimensions

•  When to repair and execute the failed job and when to modify the code to mitigate the issue.
  
  

Major Challenges

•  Will have to gain knowledge and enhance technical skill set to carry out day-to-day tasks.
•  Will need to handle Support tasks without impacting development timeline.
  
  

Required Qualifications And Experience

•  Qualifications
• E, MCA, M.E, B.Tech/M.Tech in Computer Science.
•  Work Experience
  
  

Total 7-8 Years Experience With Relevant Technology Skills

•  Skills Keywords
  
  

DataBricks, PySpark, SQL, Scala/Java, NoSQL.