TRQ25-0347-01-Engineer L3

Technology Skill Set:
    Data Modelling
    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.