Engineer L3 @ IBS Software Services

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.