Bangalore, Karnataka, India
Information Technology
Full-Time
ThoughtFocus
Overview
Role Overview:
The Data Warehouse (DWH) Developer/Engineer is responsible for designing, developing, and maintaining data warehouse solutions that support business intelligence, reporting, and analytics. The role involves working with large datasets, optimizing data models, and ensuring data accuracy and security.
Key Responsibilities:
AWS – Redshift is must
Data Warehouse Design & Development
- Design and implement scalable and efficient data warehouse architectures.
- Develop ETL (Extract, Transform, Load) pipelines to ingest and process data from multiple sources.
- Optimize data models to improve query performance and storage efficiency.
Data Integration & Management
- Ensure seamless data integration across databases, cloud platforms, and third-party applications.
- Maintain and enhance data pipelines using tools like Apache Spark, Talend, Informatica, or SSIS.
- Ensure data consistency, quality, and integrity by implementing validation processes.
Performance Optimization & Security
- Optimize database queries, indexing, and storage strategies for better performance.
- Implement security best practices, including data encryption, access control, and compliance with regulatory requirements.
- Monitor system performance and troubleshoot data-related issues.
Collaboration & Reporting
- Work closely with business analysts, data scientists, and BI teams to understand data needs.
- Develop and maintain dashboards and reports using tools like Power BI, Tableau, or Looker.
- Document data warehouse processes, workflows, and data governance policies.
Required Skills & Qualifications:
- Experience: 5+ years in data warehousing, ETL development, or database management.
- AWS – Redshift is must.
- Education: Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
- Technical Skills:
§ Strong SQL and database skills (MySQL, PostgreSQL, SQL Server, Oracle, etc.).
§ Hands-on experience with ETL tools (Informatica, Talend, SSIS, or Apache Nifi).
§ Experience with cloud-based DWH solutions (AWS Redshift, Google BigQuery, Snowflake, or Azure Synapse).
§ Knowledge of data modeling techniques (star schema, snowflake schema).
- Soft Skills: Strong analytical thinking, problem-solving, and communication skills.
Preferred Qualifications:
- Experience working with big data frameworks like Hadoop, Spark, or Kafka.
- Knowledge of scripting languages (Python, Shell, or Scala).
- Familiarity with data governance and compliance standards (GDPR, HIPAA, etc.).
Similar Jobs
View All
1 Day ago
TrueFan - Senior Machine Learning Engineer
Information Technology
- Thiruvananthapuram, Kerala, India
About UsTrueFan is at the forefront of AI-driven content generation, leveraging cutting-edge generative models to build next-generation products. Our mission is to redefine content generation space through advanced AI technologies, including deep ge...
1 Day ago
Salesforce commerce cloud consultant
Information Technology
- Thiruvananthapuram, Kerala, India
Salesforce Commerce Cloud consultant 5+ Years of Experience 6 to 12 months Mode - Remote 1.1LPM - 1.2LPM Max Key Responsibilities Translate business requirements into scalable Salesforce Service Cloud solutions, in collaboration with CAE's technic...
1 Day ago
Cloud Infrastructure Engineer
Information Technology
- Thiruvananthapuram, Kerala, India
DescriptionInvent the future with us. Recognized by Fast Company’s 2023 100 Best Workplaces for Innovators List, Ampere is a semiconductor design company for a new era, leading the future of computing with an innovative approach to CPU design focuse...
1 Day ago
Devops Engineer- Intermetiate
Information Technology
- Thiruvananthapuram, Kerala, India
BackJD: Dev ops Engineer:As a DevOps Specialist- should be able to take ownership of the entire DevOps process, including Automated CI/CD pipelines and deployment to production.They should also be comfortable with risk analysis and prioritization.Le...
1 Day ago
Sr Data Scientist (London)
Information Technology
- Thiruvananthapuram, Kerala, India
AryaXAI stands at the forefront of AI innovation, revolutionizing AI for mission-critical, highly regulated industries by building explainable, safe, and aligned systems that scale responsibly. Our mission is to create AI tools that empower research...
1 Day ago
Software Test Engineer
Information Technology
- Thiruvananthapuram, Kerala, India
By clicking the “Apply” button, I understand that my employment application process with Takeda will commence and that the information I provide in my application will be processed in line with Takeda’s Privacy Notice and Terms of Use. I further att...
1 Day ago
Software Developer 5 (Java Fullstack)
Information Technology
- Thiruvananthapuram, Kerala, India
Job DescriptionBuilding off our Cloud momentum, Oracle has formed a new organization - Oracle Health Applications & Infrastructure. This team focuses on product development and product strategy for Oracle Health, while building out a complete platfo...
1 Day ago
Java Developer - Spring Frameworks
Information Technology
- Thiruvananthapuram, Kerala, India
Java DescriptionWe are looking for a passionate and talented Java Developer with 2-3 years of hands-on experience to join our growing development team.The ideal candidate should have a strong foundation in Java technologies and the ability to develo...
Talk to us
Feel free to call, email, or hit us up on our social media accounts.
Email
info@antaltechjobs.in