Engineer L3

Job Description

Entity-Relationship Diagrams (ERD) Dimensional Modelling (Star Schema, Snowflake Schema) Database Management Systems (DBMS) PostgreSQL Data Warehousing Solutions Amazon Redshift Snowflake Teradata Programming and Scripting Languages SQL Python Java Shell Scripting AWS (Amazon Web Services) Cloud Platforms Data Visualization Tools Tableau Power BI Version Control and CI/CD Git/GitHub Jenkins Docker Kubernetes Key Responsibilities: 1. Design and Development: o Design and implement data warehouse architecture, including data models, schemas, and ETL processes. o Develop and maintain ETL scripts and workflows to extract, transform, and load data from various sources into the data warehouse. o Create and optimize database queries, stored procedures, and views. 2. Data Integration: o Integrate data from multiple heterogeneous sources, including databases, flat files, APIs, and external data feeds. o Ensure data consistency, quality, and integrity throughout the ETL process. 3. Performance Optimization: o Monitor and tune the performance of data warehouse components. o Implement indexing, partitioning, and other optimization techniques to improve query performance. 4. Data Quality and Governance: o Establish and enforce data quality standards and governance policies. o Perform data profiling, validation, and cleansing activities. 5. Collaboration and Support: o Work closely with business analysts, data scientists, and other stakeholders to understand data requirements and deliver appropriate solutions. o Provide support and troubleshooting for data warehouse-related issues. 6. Documentation and Reporting: o Document data models, ETL processes, and data flows. o Generate and maintain reports, dashboards, and data visualizations as required. Added Advantage: Knowledge in mobile development. Domain knowledge in Airline PSS. Experience in onsite implementation of projects. Experience in report development tools like Power BI and Tableau.