Data Engineer - ETL/Data Warehousing

You will be working as an experienced ETL & Data Warehouse Developer at Kogta Financial Ltd, utilizing AWS services to design, develop, and optimize ETL processes and data warehousing solutions on the AWS platform. Your responsibilities will include: - Designing, developing, and implementing robust ETL processes using AWS Glue, AWS Data Pipeline, or custom scripts as needed. - Ensuring efficient extraction, transformation, and loading of data from diverse sources into the data warehouse. - Designing and maintaining data warehouse solutions on AWS, focusing on scalability, performance, and reliability. - Implementing and optimizing data models for efficient storage and retrieval in AWS Redshift. - Leveraging AWS services such as S3, Lambda, Glue, Redshift, and others to build end-to-end data solutions. - Crafting complex SQL queries to support data analysis, reporting, and business intelligence requirements. - Optimizing SQL code for performance and efficiency, troubleshooting any data retrieval issues. - Collaborating with cross-functional teams to integrate data from various sources into the data warehouse. - Implementing and maintaining security measures to protect data integrity and ensure compliance with industry standards. - Documenting ETL processes, data models, and system configurations for future reference. Qualifications required for this role include: - Bachelor's degree in Computer Science, Information Technology, or a related field. - Proven experience as an ETL & Data Warehouse Developer focusing on AWS services and SQL expertise. - Strong proficiency in SQL, stored procedures, and views. - In-depth understanding of AWS services related to data processing and storage. - Experience with data modeling and designing efficient data warehouses. - Familiarity with best practices in data security, compliance, and governance. - Strong problem-solving and analytical skills. - Excellent communication and collaboration skills. - Certification in AWS or relevant technologies. Please note that the above details are specific to the job description provided and do not include any additional information about the company.,