About the Role
We are seeking an experienced
Data Warehouse Developer / Data Engineer to lead a large-scale migration of legacy Oracle-based data warehouse and reporting workloads to a centralized data warehouse environment. This business-critical initiative requires strong expertise in legacy system modernization, data pipeline development, regulatory reporting, and data migration strategies.
The successful candidate will play a key role in ensuring seamless migration with zero disruption to business operations and regulatory reporting processes, while maintaining the highest standards of data integrity, quality, and compliance.
Key Responsibilities
- Lead the architecture, design, and execution of migrating Oracle-based legacy data warehouse workloads into a centralized data warehouse platform.
- Analyze, reverse-engineer, and document poorly documented legacy Oracle programs and business logic.
- Design and implement scalable reporting data pipelines while preserving existing output formats for downstream systems.
- Ensure regulatory reporting requirements remain fully compliant throughout the migration lifecycle.
- Develop migration strategies and execution plans utilizing AWS services and migration tools where appropriate.
- Implement comprehensive data validation, reconciliation, and quality assurance processes.
- Plan and execute phased migration approaches with extensive testing to minimize business risk and operational impact.
- Collaborate with business, risk, compliance, and technical teams to validate reporting accuracy and completeness.
- Provide ongoing optimization, troubleshooting, and support for data pipelines and reporting solutions post-migration.
Required Qualifications
- 7+ years of experience in Data Warehouse Development, Data Engineering, or related roles.
- Strong hands-on experience with Oracle Database (11g, 12c, 19c or later).
- Advanced expertise in:
- SQL performance tuning
- PL/SQL development
- Database schema design
- Query optimization
- Proven experience working with legacy systems and undocumented code bases.
- Strong background in ETL/ELT design, development, and optimization.
- Experience supporting regulatory reporting systems and compliance-driven environments.
- Deep understanding of data migration methodologies, reconciliation, and validation processes.
- Excellent analytical, troubleshooting, and problem-solving skills.
Preferred Qualifications
- Experience with AWS cloud services and migration tools such as:
- AWS DMS
- AWS Data Pipeline
- Other AWS data services
- Previous involvement in Oracle-to-centralized data warehouse migration projects.
- Knowledge of data governance, metadata management, and data quality frameworks.
- Experience within financial services, banking, or highly regulated industries.
- Familiarity with regulatory reporting frameworks such as:
- IFRS
- Basel
- Solvency II
Technical Skills
Databases
Data Integration & ETL
- Informatica
- Talend
- Apache NiFi
- Equivalent ETL/ELT platforms
Programming & Scripting
- Python
- Java
- Linux/Unix Shell Scripting
Tools
- Git
- SVN
- Data Validation & Data Quality Tools
Critical Project Requirements
✅ Maintain uninterrupted business operations and reporting throughout migration
✅ Preserve all existing output formats consumed by downstream applications
✅ Ensure continuous regulatory compliance and reporting accuracy
✅ Validate 100% data integrity through robust reconciliation processes
✅ Effectively interpret and migrate undocumented legacy Oracle systems
What We're Looking For
- Strong project ownership and delivery mindset
- Exceptional communication and stakeholder management skills
- Ability to translate complex technical concepts into business-friendly language
- Detail-oriented approach with a strong focus on data quality and accuracy
- Experience working across multiple teams in fast-paced environments
- Ability to manage competing priorities while delivering high-quality outcomes
HCLTech