Title: Senior Data Engineer - Data Migration & Modelling
Location: Gurgaon /Chennai/ Bangalore
Exp: 8+ Yrs

Job Description:
Key Responsibilities
Data Modelling

- Design and maintain conceptual, logical, and physical data models.
- Analyse existing Oracle data structures and define target PostgreSQL data models.
- Produce source-to-target mappings and transformation specifications.
- Support data lineage, reconciliation, and data quality activities.
- Ensure compliance with enterprise data standards and architectural principles.

Data Migration Strategy
- Execute end-to-end Oracle to PostgreSQL migration activities.
- Perform schema analysis, data mapping, conversion, validation, and reconciliation.
- Identify and resolve migration performance and data integrity issues.
- Support migration planning, dress rehearsals, cutover execution, and post-migration stabilisation.
- Develop automation for migration validation and reconciliation processes.

Data Engineering & ETL
- Design and develop ETL/ELT pipelines for data ingestion and transformation.
- Build scalable data processing solutions using AWS services.
- Implement monitoring, controls, and data quality checks.
- Support CI/CD and deployment automation for data engineering solutions.




- Optimise data pipelines for performance, scalability, and resilience.

AWS Platform Delivery
- Deliver solutions leveraging AWS technologies including:

o RDS PostgreSQL
o S3
o AWS Glue
o Lambda
o Redshift
o Athena

- Support performance tuning and operational readiness of data platforms.

Reporting & Analytics
- Support creation of reporting-ready datasets and data marts.
- Collaborate with reporting teams to ensure consistency and usability of data.
- Support Power BI, QuickSight, or equivalent reporting solutions.

Essential Skills & Experience

- 12-15 years of experience in Data Engineering
- Strong hands-on experience in enterprise data modelling.
- Proven delivery experience on large-scale Oracle to PostgreSQL migration programmes.
- Robust SQL and database performance tuning expertise.
- Experience developing ETL/ELT pipelines and data integration solutions.
- Strong AWS data platform experience.
- Experience with data validation, reconciliation, and migration testing.
- Ability to work independently while collaborating with architects, engineering teams, and business stakeholders.

📌 Senior Data Engineer - Data Migration & Modelling (India)
🏢 NR Consulting
📍 India