Data and ETL Developer - only immediate joiners

Role & responsibilities

Data and ETL Developer for Banking Project for Banking Project

We are seeking a skilled Data Warehouse & ETL Engineer to design, develop, implement, and maintain enterprise data warehouse solutions. The role involves building scalable ETL/ELT pipelines, ensuring data quality, optimizing data models, and supporting business intelligence and analytics initiatives. The ideal candidate will have strong expertise in data integration, database technologies, performance tuning, and data governance

• Data Warehouse Development
  
• Design, develop, and maintain enterprise data warehouse architectures.
• Create and optimize dimensional data models (Star Schema, Snowflake Schema).
• Develop data marts to support reporting and analytics requirements.
• Implement data warehousing best practices and standards.
• Monitor warehouse performance and implement optimization strategies.
• ETL/ELT Development
  
• Design, develop, test, and deploy ETL/ELT processes.
• Extract data from multiple source systems including ERP, CRM, APIs, flat files, and databases.
• Transform and cleanse data to ensure consistency and accuracy.
• Load data into data warehouse environments according to business requirements.
• Develop incremental loading, CDC (Change Data Capture), and data synchronization processes.
• Troubleshoot ETL failures and implement corrective actions.
• Data Quality & Governance
  
• Implement data validation and reconciliation processes.
• Monitor data quality and resolve data integrity issues.
• Maintain data lineage and metadata documentation.
• Support data governance, security, and compliance initiatives.
• Establish data quality KPIs and monitoring mechanisms.
• Maintenance & Support
  
• Provide ongoing support for production ETL jobs and data warehouse environments.
• Perform root cause analysis for data and system issues.
• Manage release deployments and environment migrations.
• Create and maintain operational documentation and support procedures.
• Participate in disaster recovery and backup planning activities.