About the role
- Data Extraction, Transformation, and Loading (ETL):Design, develop, and implement ETL processes to support data extraction, transformation, and loading across various data sources.
Ensure data integrity, accuracy, and consistency during the ETL process. - Data Modeling and Warehousing:Create and maintain data models to support warehousing and reporting requirements.
Develop and optimize database schemas and maintain data dictionaries. - Data Integration and Performance Optimization:Integrate data from multiple sources, including databases, flat files, APIs, and external platforms.
Optimize ETL processes for performance and scalability, minimizing latency and maximizing throughput. - Data Quality Assurance:Implement data quality checks and validation mechanisms to ensure data accuracy and completeness.
Identify, troubleshoot, and resolve data quality issues in ETL pipelines. - Collaboration with Cross-Functional Teams:Collaborate with data engineers, analysts, and stakeholders to understand data requirements and implement ETL solutions accordingly.
Support data reporting and analytics needs through reliable data flow. - Documentation and Maintenance:Document ETL processes, data mappings, and workflows.
Maintain and update ETL scripts, jobs, and processes to meet evolving business needs.