Data Engineer

Job Description:

• Design and develop ETL solutions for loading Data Warehouses and Data Marts.
• Develop mappings for complex business logic, transformations, and aggregations for various data marts and tables.
• Implement data quality processes, including translation, analysis, standardization, and enrichment for real-time and batch modes.
• Perform source-to-target and logical-to-physical data mapping, including third normal form to dimensional models.
• Design and create database tables based on project requirements.
• Generate DDL and SQL for physical models and views for DBA implementation.
• Troubleshoot and resolve data consistency and quality issues.
• Support testing and QA efforts on data-related projects.
• Conduct quality control with both automated and manual testing.
• Create and update project documentation for ongoing support.
• Manage support and maintenance of assigned interfaces and applications.
• Review and troubleshoot production jobs and resolve issues.
• Monitor systems to ensure optimal application performance.
• Use performance monitoring tools to resolve root cause issues.
• Handle escalated project issues and ensure timely resolution.
• Provide regular project status updates to ensure visibility.
• Participate in agile ceremonies like stand-ups, backlog grooming, retrospectives, and demos.