2+ Datawarehousing Jobs in Mumbai | Datawarehousing Job openings in Mumbai

We are looking for a skilled Data Engineer / Data Warehouse Engineer to design, develop, and maintain scalable data pipelines and enterprise data warehouse solutions. The role involves close collaboration with business stakeholders and BI teams to deliver high-quality data for analytics and reporting.

Key Responsibilities

• Collaborate with business users and stakeholders to understand business processes and data requirements
• Design and implement dimensional data models, including fact and dimension tables
• Identify, design, and implement data transformation and cleansing logic
• Build and maintain scalable, reliable, and high-performance ETL/ELT pipelines
• Extract, transform, and load data from multiple source systems into the Enterprise Data Warehouse
• Develop conceptual, logical, and physical data models, including metadata, data lineage, and technical definitions
• Design, develop, and maintain ETL workflows and mappings using appropriate data load techniques
• Provide high-level design, research, and effort estimates for data integration initiatives
• Provide production support for ETL processes to ensure data availability and SLA adherence
• Analyze and resolve data pipeline and performance issues
• Partner with BI teams to design and develop reports and dashboards while ensuring data integrity and quality
• Translate business requirements into well-defined technical data specifications
• Work with data from ERP, CRM, HRIS, and other transactional systems for analytics and reporting
• Define and document BI usage through use cases, prototypes, testing, and deployment
• Support and enhance data governance and data quality processes
• Identify trends, patterns, anomalies, and data quality issues, and recommend improvements
• Train and support business users, IT analysts, and developers
• Lead and collaborate with teams spread across multiple locations

Required Skills & Qualifications

• Bachelor’s degree in Computer Science or a related field, or equivalent work experience
• 3+ years of experience in Data Warehousing, Data Engineering, or Data Integration
• Strong expertise in data warehousing concepts, tools, and best practices
• Excellent SQL skills
• Strong knowledge of relational databases such as SQL Server, PostgreSQL, and MySQL
• Hands-on experience with Google Cloud Platform (GCP) services, including:

1. BigQuery
2. Cloud SQL
3. Cloud Composer (Airflow)
4. Dataflow
5. Dataproc
6. Cloud Functions
7. Google Cloud Storage (GCS)

• Experience with Informatica PowerExchange for Mainframe, Salesforce, and modern data sources
• Strong experience integrating data using APIs, XML, JSON, and similar formats
• In-depth understanding of OLAP, ETL frameworks, Data Warehousing, and Data Lakes
• Solid understanding of SDLC, Agile, and Scrum methodologies
• Strong problem-solving, multitasking, and organizational skills
• Experience handling large-scale datasets and database design
• Strong verbal and written communication skills
• Experience leading teams across multiple locations

Good to Have

• Experience with SSRS and SSIS
• Exposure to AWS and/or Azure cloud platforms
• Experience working with enterprise BI and analytics tools

Why Join Us

• Opportunity to work on large-scale, enterprise data platforms
• Exposure to modern cloud-native data engineering technologies
• Collaborative environment with strong stakeholder interaction
• Career growth and leadership opportunities

Role: Project Manager

Experience: 8-10 Years

Location: Mumbai

Company Profile:



Exponentia.ai is an AI tech organization with a presence across India, Singapore, the Middle East, and the UK. We are an innovative and disruptive organization, working on cutting-edge technology to help our clients transform into the enterprises of the future. We provide artificial intelligence-based products/platforms capable of automated cognitive decision-making to improve productivity, quality, and economics of the underlying business processes. Currently, we are rapidly expanding across machine learning, Data Engineering and Analytics functions. Exponentia.ai has developed long-term relationships with world-class clients such as PayPal, PayU, SBI Group, HDFC Life, Kotak Securities, Wockhardt and Adani Group amongst others.

One of the top partners of Data bricks, Azure, Cloudera (leading analytics player) and Qlik (leader in BI technologies), Exponentia.ai has recently been awarded the ‘Innovation Partner Award’ by Qlik and "Excellence in Business Process Automation Award" (IMEA) by Automation Anywhere.

Get to know more about us at http://www.exponentia.ai and https://in.linkedin.com/company/exponentiaai 

Role Overview:

·        Project manager shall be responsible to oversee and take responsibility for the successful delivery of a range of projects in Business Intelligence, Data warehousing, and Analytics/AI-ML.

·        Project manager is expected to manage the project and lead the teams of BI engineers, data engineers, data scientists and application developers.

Job Responsibilities:

·        Efforts estimation, creating a project plan, planning milestones, activities and tracking the progress.

·        Identify risks and issues. Come up with a mitigation plan.

·        Status reporting to both internal and external stakeholders.

·        Communicate with all stakeholders.

·        Manage end-to-end project lifecycle - requirements gathering, design, development, testing and go-live.

·        Manage end-to-end BI or data warehouse projects.

·        Must have experience in running Agile-based project development.

Technical skills

·        Experience in Business Intelligence Data warehousing or Analytics projects.

·        Understand data lake and data warehouse solutions including ETL pipelines.

·        Good to have - Knowledge of Azure blob storage, azure data factory and Synapse analytics.

·        Good to have - Knowledge of Qlik Sense or Power BI

·        Good to have - Certified in PMP/Prince 2 / Agile Project management.

·        Excellent written and verbal communication skills.

 Education:

MBA, B.E. or B. Tech. or MCA degree