Back to Jobs
                    
                    
                        
                    
                    
                         
                    
                
                                    
                        6 Days ago 
                    
                    Interesting Job Opportunity: Kogta Finance - Data Engineer - ETL/Data Warehousing
                                
                                Information Technology
                            
                        
                        
                                                    
                                
                                Full-Time
                            
                        
                                                    
                                
                                KOGTA FINANCIAL (INDIA) LIMITED
                            
                                            Overview
 Job Description
Kogta Financial Ltd is seeking an experienced and highly skilled ETL & Data Warehouse Developer with expertise in utilizing AWS services to join our dynamic team. As a key member of our data engineering team, you will be responsible for designing, developing, and optimizing ETL processes and data warehousing solutions on the AWS platform. The ideal candidate should have a solid background in ETL development, data modeling, and a deep understanding of AWS services and hands-on experience in crafting complex SQL queries and optimizing data workflows.
Responsibilities
                    
                Kogta Financial Ltd is seeking an experienced and highly skilled ETL & Data Warehouse Developer with expertise in utilizing AWS services to join our dynamic team. As a key member of our data engineering team, you will be responsible for designing, developing, and optimizing ETL processes and data warehousing solutions on the AWS platform. The ideal candidate should have a solid background in ETL development, data modeling, and a deep understanding of AWS services and hands-on experience in crafting complex SQL queries and optimizing data workflows.
Responsibilities
- ETL Development :
- Design, develop, and implement robust ETL processes using AWS Glue, AWS Data Pipeline, or custom scripts as needed.
- Ensure the efficient extraction, transformation, and loading of data from diverse sources into our data warehouse.
- Data Warehousing :
- Design and maintain data warehouse solutions on AWS, with a focus on scalability, performance, and reliability.
- Implement and optimize data models for efficient storage and retrieval in AWS Redshift.
- AWS Service Utilization :
- Leverage AWS services such as S3, Lambda, Glue, Redshift, and others to build end-to-end data solutions.
- Stay abreast of AWS developments and recommend the adoption of new services to enhance our data architecture.
- SQL Expertise :
- Craft complex SQL queries to support data analysis, reporting, and business intelligence requirements.
- Optimize SQL code for performance and efficiency, and troubleshoot any issues related to data retrieval.
- Performance Optimization :
- Optimize ETL workflows and data warehouse queries to ensure optimal performance.
- Identify and resolve bottlenecks in data processing and storage.
- Data Integration :
- Collaborate with cross-functional teams to integrate data from various sources into the data warehouse.
- Work closely with business stakeholders to understand data requirements.
- Security and Compliance :
- Implement and maintain security measures to protect data integrity and ensure compliance with industry standards and regulations.
- Collaborate with the security and compliance teams to implement best practices.
- Documentation :
- Document ETL processes, data models, and system configurations for future reference.
-  Ensure comprehensive documentation of the developed solutions for knowledge transfer.
 
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience as an ETL & Data Warehouse Developer with a focus 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.
 
                            Similar Jobs
                        
                        
                            View All
                        
                    Talk to us
                    Feel free to call, email, or hit us up on our social media accounts.
                
                
            
                                    Email
                                    info@antaltechjobs.in