Reporting and Data Migration lead

Comviva; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Comviva is looking for a skilled ETL Developer in Bengaluru, Karnataka, to design and maintain data pipelines that ensure efficient data management for business intelligence and analytics. The ideal candidate will have experience in ETL processes, data integration solutions, and databases like Oracle and Postgres. Knowledge of Kafka is also required. Responsibilities include overseeing data transformation, supporting data warehouse development, and ensuring the reliability of data workflows.

Qualifications

• Experience in designing and maintaining ETL processes.
• Familiarity with data integration solutions and APIs.
• Knowledge of data warehouses and schema development.
• Experience in monitoring and troubleshooting ETL processes.

Responsibilities

• Design and implement ETL processes to manage data flows.
• Develop data integration solutions for diverse data sources.
• Transform and standardize data for analytics and reporting.
• Support data warehouse development and database management.

Skills

ETL Design

Data Integration

Data Transformation

RDBMS Knowledge (Oracle, Postgres)

Kafka Experience

Job description

Position Overview

We are seeking a skilled and detail-oriented ETL (Extract, Transform, Load) Developer to design, build, and maintain robust data pipelines and workflows. The ETL Developer will play a key role in our data management strategy by ensuring the efficient collection, transformation, and delivery of data from diverse sources to support business intelligence, analytics, and reporting initiatives. Should have idea about kafka and databases like Oracle, Postgres, MongoDB etc.

Key Responsibilities

• ETL Design and Development:
  • Design, implement, and maintain ETL processes to extract, transform, and load data from various sources into data warehouses or other storage systems.
  • Optimize ETL workflows for performance, reliability, and scalability.
• Data Integration:
  • Develop and manage data integration solutions, including integrating structured and unstructured data from multiple sources.
  • Work with APIs, databases, and flat files to retrieve and process data.
• Data Transformation:
  • Clean, transform, and standardize data to meet business requirements.
  • Apply data validation, enrichment, and aggregation techniques.
• Data Warehouse Development:
  • Support the design and development of data warehouse schemas, star/snowflake models, and dimensional data structures.
  • Implement and manage database objects such as tables, views, and stored procedures.
• RDBMS:
  • Must have idea about few RDBMS like Oracle, Postgres etc.
• Kafka:
  • Must have hand of experience in Kafka.
  • Kafka topics etc.
• Monitoring and Troubleshooting:
  • Monitor ETL processes for failures or inconsistencies and troubleshoot issues as they arise.
  • Implement error-handling and recovery mechanisms.