Data Warehouse Developer

HCLTech is a global technology company, home to more than 220,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services.

We are seeking an experienced Data Warehouse Developer to lead the migration of legacy Oracle-based data warehouse and reporting workloads This is a critical initiative requiring deep expertise in legacy system architecture, data pipeline management, and regulatory compliance. You will be responsible for ensuring zero disruption to business operations and regulatory reporting throughout this complex migration.

Key Responsibilities Lead the architecture and technical design of migrating existing Oracle-based legacy programs from Local Data Warehouse to Central Data Warehouse infrastructure, ensuring all processes remain intact and functional Design, develop, and implement robust reporting data pipelines that preserve output formats for downstream consumer systems without any format changes or disruptions Analyze and understand poorly documented legacy Oracle workloads, reverse-engineer business logic, and create comprehensive technical documentation for the migration process Ensure regulatory reporting requirements are fully maintained throughout migration, coordinating with compliance and risk teams to validate all regulatory outputs remain accurate and timely Develop migration strategies and execution plans using AWS technologies and tools, leveraging AWS services where appropriate while maintaining on-premises infrastructure Implement comprehensive data validation and reconciliation processes to ensure complete data integrity during transition from Local to Central Data Warehouse Manage and minimize business impact through careful planning, phased migration approaches, and extensive testing protocols to ensure zero operational disruption Provide ongoing technical support, troubleshooting, and optimization of data pipelines and reporting workloads post-migration

Required Qualifications Minimum 7+ years of experience in data warehouse development and design Deep hands-on experience with Oracle Database (11g, 12c, 19c or later), including schema design, SQL query optimization, and PL/SQL programming Proven experience working with legacy systems and poorly documented codebases Strong expertise in ETL/ELT design, implementation, and data pipeline development Demonstrated experience in regulatory reporting systems and data compliance requirements Solid understanding of data migration methodologies, validation techniques, and reconciliation processes Strong analytical and problem-solving skills with the ability to manage complex technical projects under tight deadlines

Preferred Qualifications

Experience with AWS cloud services and AWS database migration tools (AWS DMS, AWS DataPipeline, etc.) Familiarity with Oracle to centralized data warehouse migration projects Experience with data governance frameworks and metadata management Knowledge of financial or regulatory reporting systems (e.g., IFRS, Basel, Solvency II) Experience with data quality tools and frameworks for validation and reconciliation Technical Skills Required SQL and PL/SQL programming and optimization ETL/ELT tools and platforms (Informatica, Talend, Apache NiFi, or equivalent) Version control systems (Git, SVN) Data validation and quality assurance tools Linux/Unix shell scripting Python or Java for data processing and automation Key Project Requirements Zero Business Disruption: Maintain 100% uptime for existing reporting and business operations during migration Output Format Preservation: Ensure all downstream consumer systems receive data in identical formats with no structural or content changes Regulatory Compliance: Maintain continuous compliance with all regulatory reporting obligations throughout the migration process Legacy System Expertise: Interpret and work with undocumented or minimally documented legacy Oracle systems Data Integrity: Implement and validate comprehensive data validation processes to ensure 100% accuracy and completeness Professional Attributes Strong project management and organizational skills Excellent communication skills and ability to translate technical concepts for non-technical stakeholders Proven ability to work collaboratively across multiple teams and departments Detail-oriented with strong focus on data quality and accuracy Ability to work effectively in fast-paced environments and manage competing priorities Location & Work Arrangement