This job offer is not available in your country.
Enterprise Data Warehouse (EDW) Designer
Unison Groupbangalore, India21 hours ago
Job descriptionContribute to the overall architecture and design of the EDW, focusing on scalability, performance, and data integrity. Incorporate data integration and transformation processes to ensure seamless data flow between source systems and the EDW. Develop data integration strategies to extract, transform, and load (ETL) data from various source systems into the EDW. Implement data quality checks and transformations to ensure data accuracy and consistency. Identify and address performance bottlenecks within the EDW environment. Optimize queries and data access patterns to enhance query performance and overall system responsiveness. Document data models, design decisions, and ETL processes for reference and future development. Collaborate with cross-functional teams, including data analysts, developers, and business users, to ensure a cohesive and well-aligned data strategy. Stay up to date with industry trends and advancements in data modelling, ETL processes, and OFSAA FSDF data model. Identify opportunities for process improvements and contribute to the enhancement of the EDW ecosystem. Bachelor's or master’s degree in Computer Science, Information Systems, or related field. Proven experience 6 Years as a data modeler or EDW designer (10 years overall), with a focus on financial data. Strong understanding of the (OFSAA) Financial Services Data Foundation (FSDF) data model. Proficiency in data modelling tools (e.g., ERwin, ER / Studio) and ETL tools - ODI. Solid knowledge of SQL and database technologies. Experience with performance tuning and optimization of database queries and ETL processes. Excellent problem-solving and analytical skills. Strong communication and collaboration abilities, with the capacity to interact effectively with technical and non-technical stakeholders. Take part in requirement discussions with Business Analyst team. Data Profiling & OFSAA (FSDF) Data modelling. Prepare ETL architecture. Prepare mapping specifications. Prepare HLA. Prepare DSD / DSD review with development team. Develop Feeder views for critical tables.
Data Modelling and Design :
- Collaborate with business stakeholders, data architects, and development teams to understand business requirements and translate them into effective data models for the EDW.
- Utilize expertise in OFSAA FSDF data model to design and map data structures, ensuring alignment with industry best practices and regulatory standards.
EDW Architecture :
Data Integration :
Performance Optimization :
Documentation and Collaboration :
Continuous Improvement :
Requirements
Create a job alert for this search
Enterprise Warehouse • bangalore, India
Related jobs
![Advanced Engineer Data [T500-20298]](https://cdn-logos.talent.com/v1/logo/image?feedcode=jobtraffic-in&company_name=Albertsons%20Companies%20India)
![Senior Engineer Data [T500-20496]](https://cdn-logos.talent.com/v1/logo/image?feedcode=whatjobs-in&company_name=ANSR)
Collaborate with business stakeholders, data architects, and development teams to understand business requirements and translate them into effective data models for the EDW.Utilize expertise in OFS...Show moreLast updated: 20 days ago
- Promoted
Elanco - Senior Data Engineer - ETL / Azure Data Factory
ElancoBangalore At Elanco (NYSE : ELAN) it all starts with animals!.As a global leader in animal health, we are dedicated to innovation and delivering products and services to prevent and treat disease in farm an...Show moreLast updated: 30+ days ago
- Promoted
Data Engineer
Insight GlobalBangalore, IN Notice Period : This is a ASAP hire - only apply if you can start 2 weeks after offer is extended!.Priority scheduling for candidates who message on with resume.
Design, develop, and maintain robust...Show moreLast updated: 30+ days ago
- Promoted
Principal Data Engineer
Xebiabangalore, karnataka, in We’re Hiring : Principal Data Engineer | Any Xebia Location (Hybrid, 3 days in office per week).Any Xebia Location (Hybrid – 3 days in office per week).
Data Engineering with 4+ years team leadership...Show moreLast updated: 23 days ago
- Promoted
Data Engineering Lead - ETL / Data Warehousing
GEGA BUSINESS SOLUTIONS LLPBangalore Job Title : Data Engineering Lead AgriTech / Agri Background Preferred Location : : 6 to 15 Type : Full-time <...Show moreLast updated: 19 days ago
- Promoted
Advanced Engineer Data [T500-20298]
Albertsons Companies IndiaBengaluru, Karnataka, India About Albertsons Companies Inc.As a leading food and drug retailer in the United States, Albertsons Companies, Inc.Our well-known banners across the United States, including Albertsons, Safeway, Vo...Show moreLast updated: 9 days ago
- Promoted
Senior Data Engineer
Publicis ProductionBengaluru, Karnataka, India We are seeking a proactive and self-motivated Senior Data Engineer with a proven track record in building scalable cloud-based data solutions across multiple cloud platforms to support our work in ...Show moreLast updated: 22 days ago
- Promoted
Senior Engineer Data [T500-20496]
ANSRBengaluru, Karnataka, India ANSR is hiring for one of its clients.About Albertsons Companies Inc.As a leading food and drug retailer in the United States, Albertsons Companies, Inc.
Our well-known banners across the United Sta...Show moreLast updated: 8 days ago
- Promoted
Senior Data Engineer
IGT Solutionsbangalore, karnataka, in Primary Skills : Advanced SQL Server, ETL development using SSIS, Azure Data Factory, and Databricks, Power BI, Data warehousing, Data quality and validation, General Microsoft technology stack.We a...Show moreLast updated: 26 days ago
Enterprise Data Warehouse (EDW) Designer
Unison GroupBengaluru, KA, INQuick Apply
- Promoted
Senior Data Engineer - ETL / Azure Databricks
ORANGEMINT TECHNOLOGIES PRIVATE LIMITEDBangalore Job Description : This role is responsible for the design, development, and maintenance of data integration and reporting solutions.The ideal candida...Show moreLast updated: 30+ days ago
- Promoted
Data Architect - ETL / Data Warehousing
TalproBangalore About the Role : We are seeking an experienced Data Architect to design and oversee the architecture of our enterprise data ecosystem.This role requi...Show moreLast updated: 27 days ago
- Promoted
Data Warehouse Architect
CventBengaluru, Karnataka, India Cvent is a leading meetings, events, and hospitality technology provider with more than 4,800 employees and ~22,000 customers worldwide, including 53% of the Fortune 500.
Founded in 1999, Cvent deli...Show moreLast updated: 1 day ago
- Promoted
Senior Data Engineer
CybleBengaluru, Karnataka, India We are a fast-growing technology company building scalable, data-driven solutions across multiple domains.Our teams leverage modern pipelines, cloud-native infrastructure, and advanced analytics to...Show moreLast updated: 30+ days ago
- Promoted
Senior Engineer Data [T500-20299]
Albertsons Companies IndiaBengaluru, Karnataka, India About Albertsons Companies Inc.As a leading food and drug retailer in the United States, Albertsons Companies, Inc.Our well-known banners across the United States, including Albertsons, Safeway, Vo...Show moreLast updated: 9 days ago
- Promoted
Data Architect - ETL / Data Warehousing
NS Global CorporationBangalore Job Description : We are seeking an experienced Data Architect to design, build, and maintain robust data engineering solutions and data pipelines to support our bus...Show moreLast updated: 30+ days ago
- Promoted
Senior Data Engineer
SMC Squared IndiaBengaluru, Karnataka, India This position is responsible for the design, development, and deployment of extraction, transformation, and load (ETL) processes and methodologies to satisfy corporate data movements across various...Show moreLast updated: 30+ days ago
- Promoted
Senior Data Engineer
Grid DynamicsBengaluru, Karnataka, India Grid Dynamics (Nasdaq : GDYN) is a digital-native technology services provider that accelerates growth and bolsters competitive advantage for Fortune 1000 companies.
Grid Dynamics provides digital tra...Show moreLast updated: 7 days ago
- Promoted
Senior Data Architect- SNOWFLAKE
ComfNet Solutions GmbHbangalore district, karnataka, in PM to 9 PM (with a few hours overlap in EST time zone – mandatory).A minimum of 8–10 years of experience in data engineering, encompassing the development and scaling of data warehouse and data lak...Show moreLast updated: 6 days ago
- Promoted
Senior Big Data Engineer - ETL / Data Warehousing
BCFORWARD INDIA TECHNOLOGIES PRIVATE LIMITEDBangalore We are seeking a highly skilled Senior Big Data Engineer with 6+ years of relevant experience in Big Data, ETL / Data Warehousing, GCP, and Java.
The ideal candidate will design, develop, and optimize...Show moreLast updated: 30+ days ago
- Promoted
Lead Data Engineer
Eucloid Data Solutionshosur, tamil nadu, in Eucloid is looking for a Lead Data Engineer to join our Data Platform team supporting various business applications.The ideal candidate will support development of data infrastructure on Databricks...Show moreLast updated: 9 days ago