dimensional modeling jobs in raichur, raichur

70 Dimensional Modeling Jobs in Raichur

Toggle to save search
posted 2 months ago

Data Management Lead

Takeda Pharmaceutical
experience8 to 12 Yrs
location
Karnataka
skills
  • Data Management
  • AWS
  • Informatica
  • Software Engineering
  • System Design
  • Architecture
  • Leadership
  • Data Quality
  • Governance
  • Security
  • DevOps
  • Stakeholder Management
  • Data Integration
  • Data Modeling
  • Agile Methodologies
  • Data Governance
  • Cloud Technologies
  • Databricks
  • Infrastructure as Code
  • Testing Automation
  • Crossfunctional Collaboration
  • Database Technologies
  • DBA
  • Schema Design
  • SQL Optimization
Job Description
As a highly skilled and experienced Data Management Lead at our company, you will play a crucial role in overseeing the design, implementation, and maintenance of data infrastructure and pipelines. Your responsibilities will include leading and managing a team of approximately 10 members, ensuring adherence to data management principles, utilizing cloud platforms and tools for data processing and storage solutions, applying software engineering best practices, designing scalable system architectures, collaborating with stakeholders, and monitoring system performance and cost-effectiveness. Key Responsibilities: - Lead and manage a data management team of approximately 10 members, fostering growth and collaboration. - Oversee the design, implementation, and maintenance of data infrastructure and pipelines. - Ensure adherence to data management principles, including data quality, governance, and security. - Utilize cloud platforms like AWS, and tools such as Databricks & Informatica for data processing and storage solutions. - Apply software engineering best practices, including DevOps, Infrastructure as Code (IaC), and testing automation, to streamline workflows. - Design scalable and robust system architectures aligned with business needs. - Collaborate with cross-functional stakeholders to ensure the seamless integration of data systems. - Monitor and optimize system performance, reliability, and cost-effectiveness. Qualifications Required: - Bachelors or Masters degree in Computer Science, Information Technology, or related fields. - 8+ years of experience in data management, with a strong understanding of cloud-based technologies like AWS, Databricks, and Informatica. - Expertise in software engineering best practices such as IaC, DevOps pipelines, and comprehensive testing methods. - Experience in system design & architecture, including distributed systems and integration patterns. - Proven ability to lead and manage a team (~10 people), fostering an inclusive and high-performance culture. - Strong problem-solving, communication, and stakeholder management skills. - Strong expertise in data integration, data modeling, and modern database technologies (Graph, SQL, No-SQL) and AWS cloud technologies. - Extensive experience in DBA, schema design & dimensional modeling, and SQL optimization. - Excellent written and verbal communication skills, with the ability to collaborate effectively with cross-functional teams. By clicking the Apply button, you acknowledge that your employment application process with Takeda will start, and the information provided by you will be processed in line with Takeda's Privacy Notice and Terms of Use. You further confirm that all information submitted in your employment application is true to the best of your knowledge.,
ACTIVELY HIRING

Top Companies are Hiring in Your City

For Multiple Roles

Jio Platforms Ltd
Jio Platforms Ltdslide-preview-Genpact
posted 2 months ago
experience9 to 13 Yrs
location
Karnataka
skills
  • SQL
  • AWS
  • Airflow
  • Hive
  • EMR
  • Presto
  • Jenkins
  • Snowflake
  • Data Modeling
  • Git
  • BI Tools
  • PySpark
  • Datadog
  • ETLELT Design
  • CICD
Job Description
As a Principal Data Engineer at Autodesk, you will play a crucial role in the Product Access and Compliance team. Your primary responsibility will be to develop best practices and make architectural decisions to enhance critical data processing & analytics pipelines. Here are the key responsibilities associated with this role: - Modernizing and expanding existing systems to meet business requirements - Architecting systems that can scale and extend to accommodate evolving needs - Documenting technical solutions for complex problems and implementing fast, iterative improvements - Building and scaling data infrastructure for batch and real-time data processing of large volumes of records - Developing CI/CD ETL pipelines using Jenkins for deployment and automation testing - Owning ETL pipelines, ensuring data quality, and meeting SLAs - Collaborating with data engineers, data scientists, product managers, and other stakeholders to understand needs and promote best practices - Leading the design and implementation of complex data processing systems - Managing and coordinating a team of data engineers, ensuring alignment with project goals and timelines - Providing technical guidance and mentorship to junior engineers to foster continuous learning and improvement Qualifications required for this role include: - Bachelors degree with 9+ years of relevant industry experience in big data systems, data processing, and SQL data warehouses - 5+ years of experience working with large Hadoop projects and building scalable applications using PySpark - 2+ years of experience in optimizing Spark applications and spark memory management - Strong programming skills in Python & SQL - Knowledge of distributed data processing systems, storage mechanisms, and compression techniques - Experience building code-driven infrastructure on public cloud platforms, particularly AWS - Understanding of SQL, dimensional modeling, and analytical data warehouses like Snowflake and Redshift - Familiarity with workflow management tools such as Airflow and Oozie - Proficiency in CI and code management tools like Git and Jenkins - Exposure to BI tools like Power BI, Looker, Qlikview Autodesk is a company that takes pride in its culture, values, and ways of working. The Culture Code is at the core of everything they do, fostering an environment where people thrive and realize their potential. If you join Autodesk, you can be your authentic self and contribute to meaningful work that shapes a better future for all. Autodeskers benefit from a competitive compensation package, including base salaries, annual cash bonuses, commissions, stock grants, and comprehensive benefits. The company also emphasizes diversity, belonging, and equity in the workplace. Join Autodesk and be part of a team that creates amazing things every day!,
ACTIVELY HIRING
posted 6 days ago
experience3 to 7 Yrs
location
Karnataka
skills
  • SQL
  • NoSQL
  • Apache Spark
  • Python
  • Java
  • Scala
  • Kafka
  • Control M
  • Snowflake
  • Data pipelines
  • AWS services
  • Lambda
  • AWS Athena
  • AWS Glue
  • AWS S3
  • Redshift
  • Kinesis
  • PySpark
  • Apache Airflow
  • Databricks
  • Dimensional Data Modelling
  • AgileScrum
Job Description
In your role as a Data Analytics Engineer at Fractal.ai, you will be responsible for implementing complex data pipelines and analytics solutions to support key decision-making business processes in the client's domain. You will have the opportunity to work with cutting-edge AWS technology that applies Big Data and Machine Learning to solve new and emerging problems for clients. Additionally, you will collaborate closely with AWS Professional Services teams to tackle complex business challenges for Enterprises. Key Responsibilities: - Work closely with Product Owners and AWS Professional Service Architects to understand requirements, formulate solutions, and implement them. - Implement scalable data transformation pipelines as per design, including Data model and Data Architecture. - Evaluate new capabilities of AWS analytics services, develop prototypes, and assist in drawing POVs, participate in design discussions. Qualifications Required: - Minimum 3 years of experience implementing transformation and loading of data from various sources using SQL, NoSQL, and data pipelines for real-time, streaming, batch, and on-demand workloads. - At least 2 years of experience implementing solutions using AWS services such as Lambda, AWS Athena, Glue, S3, Redshift, Kinesis, Lambda, Apache Spark. - Experience with data warehousing, data lakes, or Lakehouse concepts on AWS. - Experience with batch processing using AWS Glue/Lake formation, & Data Pipeline. - Experience in EMR/MSK and exposure to AWS Dynamo DB will be a plus. - Proficiency in Python, PySpark, SQL, and one other language (Java or Scala preferred). - Experience with Streaming technologies like Kafka, Kinesis. - Experience building pipelines and orchestration of workflows using Apache Airflow/Control M. - Experience with Redshift on AWS, Databricks on AWS, or Snowflake on AWS. - Good understanding of Dimensional Data Modeling will be a plus. - Ability to multitask, prioritize deadlines, work independently or as part of a team. - Excellent verbal and written communication skills with great attention to detail and accuracy. - Experience working in an Agile/Scrum environment. If you are someone who enjoys working with passionate and customer-focused individuals, and if you are interested in being part of a team that powers every human decision in the enterprise, this role at Fractal.ai could be the perfect fit for you.,
ACTIVELY HIRING
question

Are these jobs relevant for you?

posted 6 days ago
experience6 to 10 Yrs
location
Karnataka
skills
  • Data modeling
  • Power BI
  • DAX
  • Relational databases
  • Dimensional modeling
  • Data integration
  • ETL tools
  • ADF
  • SSIS
  • SQL
  • Analytical skills
  • Communication skills
  • Data visualization
  • Data Modeler
  • Data Architect
  • Data platform design
  • Power Query
  • Power BI Service
  • Problemsolving abilities
  • Collaboration skills
  • UIUX design
Job Description
As a Data Modeler at our company, you will play a crucial role in designing and modeling data platforms. Your expertise in data modeling techniques, including conceptual, logical, and physical data modeling, will be essential for the success of our projects. You will need to have a Bachelor's or Master's degree in Computer Science, Information Systems, or a related field, along with 6+ years of experience in a similar role. Key Responsibilities: - Utilize your strong expertise in data modeling techniques to create effective conceptual, logical, and physical data models. - Demonstrate proficiency in Power BI and its various components, including Power Query, DAX, and Power BI Service. - Apply your hands-on experience with Power BI to create semantic layers for self-service reporting. - Collaborate with cross-functional teams to effectively work on data integration and ETL processes using tools such as ADF, SSIS, or other relevant platforms. - Utilize your solid SQL skills for data querying and manipulation to support various data modeling tasks. - Stay updated with data visualization best practices and UI/UX design principles to enhance the reporting experience. Qualifications Required: - Bachelor's or master's degree in Computer Science, Information Systems, or a related field. - 6+ years of experience as a Data Modeler, Data Architect, or similar role, with a focus on data platform design and modeling. - Strong expertise in data modeling techniques, including conceptual, logical, and physical data modeling. - Proficiency in Power BI and its various components, including Power Query, DAX, and Power BI Service. - Strong understanding of data modeling concepts and techniques, relational databases, and dimensional modeling. - Hands-on experience with Power BI and creating semantic layers for self-service reporting. - Experience with data integration and ETL tools, such as ADF, SSIS or other relevant platforms. - Solid SQL skills for data querying and manipulation. - Excellent analytical and problem-solving abilities. - Strong communication and collaboration skills to work effectively with cross-functional teams. - Familiarity with data visualization best practices and UI/UX design principles is a plus.,
ACTIVELY HIRING
posted 0 days ago
experience8 to 12 Yrs
location
Karnataka
skills
  • dbt
  • Snowflake
  • SQL
  • dimensional modeling
  • data governance
  • metadata management
  • Azure DevOps
  • Azure cloud platforms
  • medallion architecture
  • ELT principles
  • Azure Data Factory
  • Blob Storage
  • data quality frameworks
  • CICD implementation
  • GitHub Actions
  • Apache Airflow
Job Description
As an experienced Senior dbt Engineer with a strong background in Snowflake and Azure cloud platforms, your primary responsibility will be to lead the design and development of scalable, governed, and efficient data transformation pipelines using dbt. You will collaborate across functions to deliver business-ready data solutions. **Key Responsibilities:** - Lead the design, development, and maintenance of dbt models and transformation layers. - Define and enforce data modeling standards, best practices, and development guidelines. - Drive the end-to-end ELT process to ensure reliability and data quality across all layers. - Collaborate with data product owners, analysts, and stakeholders to translate complex business needs into clean, reusable data assets. - Utilize best practices on Snowflake to build scalable and robust dbt models. - Integrate dbt workflows with orchestration tools like Azure Data Factory, Apache Airflow, or dbt Cloud for robust monitoring and alerting. - Support CI/CD implementation for dbt deployments using tools like GitHub Actions, Azure DevOps, or similar. **Qualifications Required:** - At least 8 years of experience in data engineering, analytics engineering, or similar roles. - Proven expertise in dbt (Data Build Tool) and modern data transformation practices. - Advanced proficiency in SQL and deep understanding of dimensional modeling, medallion architecture, and ELT principles. - Strong hands-on experience with Snowflake, including query optimization. - Proficiency with Azure cloud services such as Azure Data Factory and Blob Storage. - Strong communication and collaboration skills. - Familiarity with data governance, metadata management, and data quality frameworks. If you are looking for a challenging opportunity to leverage your expertise in dbt, Snowflake, and Azure cloud platforms to drive digital transformation and deliver impactful data solutions, this role is perfect for you.,
ACTIVELY HIRING
posted 1 week ago
experience2 to 6 Yrs
location
Bangalore, Karnataka
skills
  • FPA
  • MIS reporting
  • VBNET
  • C
  • dimensional modeling
  • data integration
  • SAP
  • OneStream
  • cube design
Job Description
You will be joining a global leader in food & beverage ingredients, operating at the forefront of consumer trends to provide manufacturers with delightful products. Making a positive impact on people and the planet is a core part of our mission. With a deep presence in ingredient-growing countries, we ensure better quality and transparency in our supply chain. Your role as an EPM FP&A Lead will involve designing, building, and supporting scalable FP&A and MIS solutions on the OneStream platform. This position is ideal for technically skilled professionals who excel in collaborative environments and enjoy solving complex business challenges through digital innovation. **Key Responsibilities:** - Configure and enhance OneStream solutions for budgeting, forecasting, and reporting. - Translate requirements from FP&A and business teams into driver-based models, dashboards, and planning templates. - Develop and maintain business rules using VB.NET or C# for financial modeling and allocations. - Design dimensional models and automate reporting for MIS and variance analysis. - Support rolling forecasts, scenario planning, and monthly/quarterly cycles. - Integrate data from SAP and other ERPs using OneStream's data management tools. - Create intuitive dashboards and self-service reports for finance and business users. - Document technical configurations and ensure long-term maintainability. - Provide post-go-live support and contribute to continuous improvement. **Experience, Qualifications, And Skills:** - 2+ years of hands-on experience with OneStream, including at least one full-cycle implementation. - Strong understanding of FP&A processes: budgeting, forecasting, and MIS reporting. - Proficiency in VB.NET or C# for business rule development. - Experience with cube design, dimensional modeling, and OneStream MarketPlace solutions. - Familiarity with data integration from SAP or similar systems. - Strong analytical mindset and ability to collaborate cross-functionally. - Clear communication skills and a solution-oriented approach. In this role, you will collaborate closely with key stakeholders such as Finance Teams (FP&A, Business Finance, MIS), IT Teams (OneStream Technical Leads, SAP Integration), Transformation Office (Process Leads, Change Management), and External Partners (OneStream Implementation Vendors). Apply now with your resume/CV to be considered for this exciting opportunity.,
ACTIVELY HIRING
posted 1 week ago
experience4 to 8 Yrs
location
Karnataka
skills
  • Snowflake
  • DBT
  • Airflow
  • Data modeling
  • Data warehousing
  • SQL
  • Python
  • Data integration
  • Data governance
  • Security
  • Airbyte
  • Kimball dimensional modeling
  • ETLELT pipelines
  • DBT transformations
Job Description
As a Snowflake Data Engineer, your role will involve designing and implementing scalable data pipelines, integrating diverse data sources, and building a robust data warehouse to support business intelligence and analytics initiatives. Your expertise in DBT, Airbyte, and Airflow, along with experience in Kimball dimensional modeling, will be crucial for this position. Key Responsibilities: - Develop and maintain ETL/ELT pipelines using Airbyte and Airflow. - Extract data from multiple sources like APIs, direct database connections, and flat files while ensuring data quality, consistency, and reliability. - Design and implement Kimball-style dimensional models in Snowflake, optimizing fact and dimension tables for analytical workloads. - Use DBT to create modular, testable, and version-controlled transformations, implementing data quality checks and documentation within DBT workflows. - Collaborate with business teams to define and maintain the BUS Matrix for subject areas. - Work closely with business stakeholders to translate requirements into technical solutions, ensuring compliance with data governance, security, and privacy standards. Required Skills & Qualifications: - Strong proficiency in Snowflake architecture and performance tuning. - Hands-on experience with DBT, Airbyte, and Airflow. - Solid understanding of Kimball methodology for data warehousing. - Advanced SQL skills and familiarity with Python for ETL scripting. - Experience integrating data from APIs and relational databases. - Excellent communication and collaboration skills. - Ability to work in an agile environment and manage multiple priorities. Additional Company Details: Experience with cloud platforms (AWS, Azure, or GCP), familiarity with BI tools (e.g., Tableau, Power BI), and knowledge of data governance and security best practices are preferred qualifications for this role.,
ACTIVELY HIRING
posted 2 weeks ago

Datawarehouse Solution Architect

Germane Analytics Pvt Ltd
experience10 to 15 Yrs
location
Bangalore, Karnataka
skills
  • Dimensional Modeling
  • ETL
  • Data modeling
  • IT skills
  • Programming
  • Server architecture
  • Data management
  • Client interaction
  • Big Data
  • Modeling tools
  • Communication skills
  • DWH concepts
  • Datawarehouse design
  • Database performance optimization
  • Code migration
  • Database change management
  • Industry trends in DWHBI Solutions
  • Soft Skills Team contribution
  • Team play
Job Description
As a Data Warehouse Architect, your role will involve hands-on Dimensional Modeling exposure across conceptual, logical, and physical dimensions with a good understanding of Data Warehouse (DWH) concepts. You will work closely with the business to gather functional requirements and lead the development of a strategy to support current and future needs. Your responsibilities will include collaborating with the customer's technical team to gather technical requirements, producing design documentation, setting development standards, and leading ETL/data warehouse design. You will be responsible for building Data Warehouse solutions, ensuring architectural alignment of designs and development, and managing the approval and acceptance process for the technical architecture, designs, and implementation in cooperation with the client. Additionally, you will establish quality processes to deliver a stable and reliable solution and establish networking within the client organization. Key Responsibilities: - Hands-on Dimensional Modeling exposure across conceptual, logical, and physical dimensions - Working with the business to gather functional requirements and lead the development of a strategy - Collaborating with the customer's technical team to gather technical requirements - Producing design documentation and setting development standards - Leading ETL/data warehouse design and building Data Warehouse solutions - Ensuring architectural alignment of designs and development - Managing the approval and acceptance process for the technical architecture, designs, and implementation - Establishing quality processes and networking within the client organization Qualifications Required: - Awareness of end-to-end Data Warehouse lifecycle - Good in developing dimensional models for business analytics initiatives - Demonstrated knowledge of data warehousing concepts and experience of data modeling - Strong IT skills and programming aptitude - Experience in managing server architecture, storage, services, and backup routines - Ability to monitor and optimize database performance and capacity utilization - Experience in code migration, database change management, and data management through various stages of the development life cycle - Contributor/lead for a minimum of three end-to-end data warehousing initiatives from conception to cutover - Ability to present yourself as a point-of-contact to clients and front-end the engagement Additional Company Details: (Omit as no additional details were provided in the job description) Soft Skills: - Strong believer in team contribution and team play - Good verbal and written communication skills Educational Background: - B.E. / B.Tech / MCA / B.Sc Experience Range: - 10 years to 15 years Number of Positions: - 1 Timeline: - Immediate Location: - Bangalore, India Travel Needs: - To be flexible as per organizational needs,
ACTIVELY HIRING
posted 2 weeks ago
experience5 to 9 Yrs
location
Karnataka
skills
  • SQL
  • Data modeling
  • Dimensional modeling
  • Hadoop
  • Spark
  • Azure Data Systems
  • Azure SQL Database
  • Azure Synapse Analytics
  • Azure Data Lake
  • Azure Data Factory
  • ETLELT processes
  • Data integration techniques
  • Data warehousing concepts
  • Data governance principles
  • Big data technologies
  • Databricks
Job Description
As a Data Architect/Lead specializing in Azure Data Systems, your role will involve designing and implementing scalable, high-performance data solutions using Azure data services. You will play a crucial part in shaping the data architecture strategy of the organization and work on cutting-edge projects. **Key Responsibilities:** - Design, develop, and implement scalable and robust data architectures using Azure data services like Azure SQL Database, Azure Synapse Analytics, Azure Data Lake, and Azure Data Factory. - Collaborate with cross-functional teams to gather requirements and translate them into data architecture designs and technical specifications. - Evaluate and recommend appropriate Azure data services and technologies based on business needs, performance requirements, and scalability considerations. - Develop data models, schemas, and data integration strategies to support business analytics, reporting, and data-driven decision-making. - Design and implement data pipelines for ingesting, transforming, and loading data from various sources into Azure data platforms. - Optimize data storage, processing, and retrieval mechanisms to ensure optimal performance and cost efficiency. - Define and enforce data governance policies, standards, and best practices to ensure data quality, security, and compliance. - Provide technical leadership and mentorship to data engineers and team members, promoting knowledge sharing and collaboration. - Stay updated on emerging trends and technologies in data management and analytics, assessing their potential impact on the data architecture strategy. **Qualifications Required:** - Bachelor's degree in Computer Science, Engineering, or related field. Masters degree preferred. - X years of experience in data architecture, data engineering, or related roles. - Strong expertise in designing and implementing data solutions using Azure data services. - Proficiency in SQL and experience with database technologies such as Azure SQL Database, SQL Server, or similar. - Hands-on experience with data modeling, ETL/ELT processes, and data integration techniques. - Solid understanding of data warehousing concepts, dimensional modeling, and data governance principles. - Experience with big data technologies such as Hadoop, Spark, or Databricks is a plus. - Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions. - Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams. - Azure certifications such as Azure Data Engineer or Azure Solutions Architect are highly desirable.,
ACTIVELY HIRING
posted 2 weeks ago
experience5 to 9 Yrs
location
Karnataka
skills
  • MySQL
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
  • Git
  • ETL
  • Data Engineering
  • Query Optimization
  • Data Governance
  • Data Stewardship
  • Data Modeling
  • Data Flow Diagrams
  • Dimensional Modeling
  • SQL
  • Data Warehousing
  • Data Architecture
  • Data Transformation
  • Data Strategies
  • Data Stewardship
  • Indexing
  • Normalization
  • Leadership
  • Innovation
  • Strategic Communication
  • Change Management
  • Conflict Resolution
  • Emotional Intelligence
  • Negotiation
  • Thought Leadership
  • Data Cataloging
  • EntityRelationship Diagrams
  • Version Control Systems
  • BigQuery
  • Data Governance Principles
  • Data Cataloging
  • Query Performance Optimization
  • Caching Strategies
  • Multidimensional Modeling
  • Mentorship
  • DecisionMaking
Job Description
As the Lead IT Data Modeler, you will play a crucial role in designing data models and architectures that not only address current business requirements but are also scalable for future challenges. Your primary responsibility will be to provide advanced mentorship to both junior and senior data modelers, fostering a culture of continuous improvement and innovation in data management practices. You must have a deep understanding of query optimization, execution plans, and complex SQL for handling large datasets. Your proficiency should extend to various database systems such as MySQL, PostgreSQL, Oracle, and Microsoft SQL Server, along with utilizing version control systems like Git for efficient change management. Additionally, you will be integrating data engineering practices such as ETL, job orchestration, and monitoring to enhance data transformation processes, ensuring the development of robust data systems that support critical business functions. **Key Responsibilities:** - Proficiency in using and managing relational database systems such as BigQuery, MySQL, PostgreSQL, Oracle, or Microsoft SQL Server. - Knowledge of SQL for querying and manipulating data, including creating, modifying, and optimizing database queries. - Proficiency in data modeling fundamentals, including entity-relationship diagrams (ERDs), data flow diagrams, and dimensional modeling. - Strong documentation skills for maintaining clear and up-to-date data model diagrams, schema descriptions, and metadata. - Familiarity with version control systems like Git for tracking changes to data models and related code. - Proficient in complex SQL queries, common table expressions, and optimization techniques for managing and querying large datasets. - Understanding of data governance principles, data stewardship, and data cataloging. - Skill in optimizing database and query performance, including query execution plans, indexing, and caching strategies. - Capability to mentor junior data modelers and provide leadership in data modeling initiatives. - Ability to design comprehensive data architectures aligning with business needs and long-term data strategies. - Expertise in designing data models covering the entire enterprise for data consistency and alignment with business processes. **Qualifications:** - Education: Bachelor's Degree or relevant experience. - Preferred Certification(s): Any relevant IT Certification. - Experience: 5+ years of relevant and practical experience. **Additional Company Details:** The organization values visionary leadership, mentorship, innovation, strategic communication, change management, conflict resolution, decision-making, emotional intelligence, negotiation, and thought leadership in driving industry best practices in data modeling and architecture. (Note: Relocation assistance is not eligible for this position) In summary, as the Lead IT Data Modeler, you will be at the forefront of crafting scalable data models, providing advanced mentorship, fostering innovation in data management, and designing comprehensive data architectures that align with business needs and long-term strategies.,
ACTIVELY HIRING
posted 2 months ago

ERWin Data Modeler

NTT DATA Services
experience10 to 14 Yrs
location
Karnataka
skills
  • ERWin
  • conceptual data modeling
  • logical data modeling
  • dimensional modeling
  • collaboration
  • 3NF
  • dimensional data modeling
  • assetheavy industries
  • EDWanalytics
Job Description
As an ERWin Data Modeler at NTT DATA, your responsibilities will include: - Building Conceptual Data Model (CDM) for Asset and sub-domains. - Building Logical Data Model (LDM) for Asset and sub-domains. - Creating and maintaining Asset Data Dictionary (covering attributes, entities, relationships). - Ensuring models are suitable for alignment with the Enterprise Data Warehouse (EDW). Minimum Skills Required: - 10+ years of experience in 3NF and dimensional data modeling. - Strong proficiency with ERWin (or equivalent modeling tools). - Experience in conceptual and logical data modeling for large enterprises. - Knowledge of asset-heavy industries (utilities, energy, manufacturing). - Familiarity with dimensional modeling for EDW/analytics. - Ability to collaborate with business SMEs and governance teams to validate models. About NTT DATA: NTT DATA is a $30 billion trusted global innovator of business and technology services. They serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize, and transform for long-term success. NTT DATA has diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Their services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation, and management of applications, infrastructure, and connectivity. NTT DATA is one of the leading providers of digital and AI infrastructure in the world. As a part of NTT Group, they invest over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit them at us.nttdata.com.,
ACTIVELY HIRING
posted 1 day ago
experience6 to 10 Yrs
location
Karnataka
skills
  • Power BI
  • Tableau
  • SQL
  • Version Control
  • BI Solutions Architecture
  • Dimensional Data Modeling
  • SAP HANA Cloud
  • HANA Database XS
  • HANA Application Cloud
  • SAP Business Application Studio BAS
  • Smart Data Integration SDI
  • Cloud Connector
  • SAP SDI Smart Data Integration
  • CICD Pipelines
Job Description
As an experienced professional with over 6 years of experience, you should possess the following mandatory skills: - Power BI - Tableau - BI Solutions Architecture - Dimensional Data Modeling Your responsibilities in this role will include: - Proven experience working with SAP HANA Cloud, including HANA Cloud services like HANA Database XS and HANA Application Cloud. - Hands-on experience in SAP Business Application Studio (BAS) for SAP Cloud Platform development. - Strong background in creating and optimizing calculation views, stored procedures, and SQL-based solutions. - In-depth understanding and experience with Smart Data Integration (SDI) for data integration and transformation. - Familiarity with Cloud Connector for secure integration of on-premise systems with SAP Cloud solutions. - Knowledge about database triggers, constraints, and maintaining data integrity. - Solid understanding of SAP HANA development concepts and best practices. - Experience with SAP SDI Smart Data Integration and cloud-based data connectivity is preferred. - Proficiency in version control, CI/CD pipelines, and deployment processes in cloud environments is an advantage. Additionally, excellent analytical and problem-solving skills are essential for success in this role. You are expected to be a team player with excellent communication skills to effectively collaborate with colleagues and stakeholders.,
ACTIVELY HIRING
posted 4 days ago
experience3 to 7 Yrs
location
Karnataka
skills
  • Data Modeling
  • SQL
  • DAX
  • Data Visualization
  • ETL
  • Project Management
  • Stakeholder Management
  • Azure Cloud
Job Description
Role Overview: NTT DATA is looking for an Application Manager BI Tools to join their team in Bangalore, Karnataka, India. As an Application Manager BI Tools, you will be responsible for designing, building, and implementing BI solutions based on business requirements. You will play a crucial role in translating business needs into technical specifications, implementing best practices for BI development, and troubleshooting issues in the reporting environment. Additionally, you will collaborate with specialists to identify appropriate solutions and ensure the quality of delivered services and solutions. Key Responsibilities: - Design, build, and implement BI solutions based on business requirements - Translate business needs into technical specifications - Implement standardized best practices for BI development - Identify, troubleshoot, and resolve issues in the reporting environment - Monitor reporting environment performance and optimize queries - Collaborate with specialists to determine appropriate solutions - Coordinate process and system requirements with business partners - Ensure the quality of delivered services and solutions Qualifications Required: - Data Modeling: Dimensional modeling, snowflakes, multi-fact/grain models - SQL: Advanced custom calculations, aggregations, and joins - DAX: Write and interpret DAX expressions - Data Visualization: User-story driven layout design - ETL: Understanding of ETL processes, jobstreams, and error identification - Azure Cloud: Proficiency with data science tools in Azure - Project Management: SAFe, Houston, or Prince2 - Stakeholder Management About NTT DATA: NTT DATA is a $30+ billion business and technology services leader, serving 75% of the Fortune Global 100. They are committed to accelerating client success and positively impacting society through responsible innovation. NTT DATA is one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers, and application services. Their consulting and industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, NTT DATA has experts in more than 50 countries and offers clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is part of NTT Group, which invests over $3 billion each year in R&D.,
ACTIVELY HIRING
posted 1 day ago
experience4 to 8 Yrs
location
Karnataka
skills
  • Data Modeling
  • SQL
  • DAX
  • Data Visualization
  • ETL
  • Project Management
  • Stakeholder Management
  • Azure Cloud
Job Description
As a Sr. Application Engineer BI Tools at NTT DATA, your role involves designing, building, and implementing BI solutions based on business requirements. You will be translating business needs into technical specifications, implementing standardized best practices for BI development, and identifying, troubleshooting, and resolving issues in the reporting environment. Monitoring reporting environment performance, optimizing queries, collaborating with specialists for solutions, and coordinating process and system requirements with business partners are also part of your responsibilities. Ensuring the quality of delivered services and solutions is essential. **Key Responsibilities:** - Data Modeling: Dimensional modeling, snowflakes, multi-fact/grain models - SQL: Advanced custom calculations, aggregations, and joins - DAX: Writing and interpreting DAX expressions - Data Visualization: User-story driven layout design - ETL: Understanding ETL processes, job streams, and error identification - Azure Cloud: Proficiency with data science tools in Azure - Project Management: SAFe, Houston, or Prince2 - Stakeholder Management **Qualifications Required:** - Experience in data modeling and BI solutions - Proficiency in SQL, DAX, and data visualization - Understanding of ETL processes and Azure Cloud - Knowledge of project management methodologies - Strong stakeholder management skills About NTT DATA: NTT DATA is a $30+ billion business and technology services leader, serving 75% of the Fortune Global 100. Committed to accelerating client success and positively impacting society through responsible innovation, NTT DATA is one of the world's leading AI and digital infrastructure providers. With unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers, and application services, NTT DATA's consulting and industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, NTT DATA has experts in more than 50 countries and offers clients access to a robust ecosystem of innovation centers, as well as established and start-up partners. NTT DATA is part of NTT Group, which invests over $3 billion each year in R&D.,
ACTIVELY HIRING
posted 2 days ago

Data Architect

Codilar Technologies
experience5 to 10 Yrs
location
Karnataka
skills
  • data transformation
  • ETL
  • Data Modeling
  • SQL
  • NoSQL
  • ETL tools
  • Reporting Technologies
  • Digital Analytics
  • Digital Marketing
  • Software Development
  • Scripting
  • structured analysis
  • process design
  • Adobe Experience Platform
  • Data Warehouse
  • Big Data technologies
  • Adobe Experience Cloud solutions
  • Business Requirements definition
  • use case documentation
  • verbal written communication
  • organizational skills
Job Description
As an experienced Data Engineer, you will play a crucial role in transforming and manipulating large datasets using various ETL processes. Your responsibilities will include: - Utilizing your 6 to 8 years of relevant experience to handle data transformation & ETL tasks efficiently. - Demonstrating your 10+ years of expertise in working with large datasets for data transformation. - Applying your 5+ years of experience in Data Modeling across different types such as Relational, Dimensional, Columnar, and Big Data. - Leveraging your 5+ years of proficiency in complex SQL or NoSQL for effective data handling. - Utilizing your 5+ years of hands-on experience with industry-standard ETL tools like Informatica and Unifi. Moreover, you will bring your knowledge and expertise in the following areas: - Designing customer-centric datasets related to CRM, Call Center, Marketing, and Point of Sale. - Mandatory familiarity with Adobe Experience Platform (AEP) for seamless data operations. - Advanced understanding of Data Warehouse concepts to enhance data processing. - Working knowledge of Big Data technologies including Hadoop, Spark, Redshift, Snowflake, Hive, and Pig. - Experience with Reporting Technologies like Tableau and PowerBI for data visualization. - Familiarity with Adobe Experience Cloud solutions for comprehensive data management. - Proficiency in Digital Analytics and Digital Marketing to support business strategies effectively. Your role will also involve: - Applying professional software development skills to enhance data processing efficiency. - Utilizing programming languages such as Python, Java, or Bash scripting for scripting tasks. - Engaging in Business Requirements definition, structured analysis, and process design. - Demonstrating strong verbal & written communication skills to liaise with Sales teams and customers. - Showcasing exceptional organizational skills to manage multiple customer projects simultaneously. - Being self-managed, proactive, and customer-focused to ensure successful project outcomes.,
ACTIVELY HIRING
posted 6 days ago
experience10 to 14 Yrs
location
Karnataka
skills
  • Data Modeling
  • Data Governance
  • Pharma Domain Expertise
  • Architecture Design
  • SQL proficiency
  • Experience with cloud data platforms
  • Understanding of ETLELT modern data engineering practices
  • Exposure to data lake technologies
Job Description
As an experienced Data Architect with strong expertise in the Pharma domain, enterprise data modelling, and modern data architecture frameworks, you will play a crucial role in designing and governing data across a complex, large-scale environment. Key Responsibilities: - Lead the design of scalable, domain-oriented data architecture for Pharma use cases. - Build conceptual, logical, and physical data models using ERwin Data Modeler. - Define and implement data governance, metadata, and classification frameworks. - Develop and maintain data blueprints, enterprise landscape maps, and end-to-end data flows. - Architect solutions based on Data Mesh principles and domain-driven design. - Work with medallion/lakehouse architectures to support analytics and data engineering teams. - Partner with business and technology stakeholders to translate complex Pharma processes into data entities and models. Qualifications Required: - Pharma Domain Expertise with a strong understanding of Pharma business processes such as R&D, clinical operations, manufacturing, regulatory, or supply chain. - Data Modeling skills including hands-on experience with ERwin Data Modeler, ability to build dimensional, flattened, canonical, and domain-specific data models, and a strong understanding of entity relationships aligned with business processes. - Data Governance experience with governance frameworks (DAMA, stewardship, lineage, metadata) and knowledge of data classification standards including PHI/PII. - Architecture & Design expertise with proven experience in Data Mesh or domain-oriented architecture, medallion/lakehouse architecture (Bronze/Silver/Gold layers), and the ability to develop enterprise-level data architecture blueprints and system landscape maps. Additional Technical Skills (Preferred): - SQL proficiency - Experience with cloud data platforms (Azure/AWS/GCP) - Understanding of ETL/ELT & modern data engineering practices - Exposure to data lake technologies (Delta Lake, Databricks, or equivalents),
ACTIVELY HIRING
posted 0 days ago

Snowflake Lead

NTT DATA Services
experience8 to 12 Yrs
location
Karnataka
skills
  • Snowflake
  • Azure
  • ADF
  • Data Modeling
  • ETL
  • SQL
  • Python
  • Spark
  • Scala
  • BI Tools
  • Leadership
  • Communication
  • Synapse pipelines
  • Key Vault
  • ADLS
  • CICD
Job Description
As a Snowflake Lead at NTT DATA, you will play a crucial role in architecting and designing Snowflake-based data platforms on Azure. Your responsibilities will include: - Leading the end-to-end architecture and design of Snowflake-based data platforms on Azure, integrating with Azure services such as ADF, Synapse pipelines, Azure Functions, Key Vault, and ADLS. - Defining and implementing data modeling standards tailored for analytics, BI, and downstream data products, including star/snowflake schema, data vault, and dimensional modeling. - Designing secure, scalable, and cost-efficient Snowflake environments, including warehouses, databases, schemas, roles, resource monitors, and virtual warehouses. - Leading migration strategy and roadmap for moving data from legacy/on-prem systems to Snowflake on Azure. - Working with stakeholders to assess current state and design target-state architecture on Snowflake. - Overseeing and implementing data ingestion pipelines from various sources into Snowflake using tools like Azure Data Factory, Synapse pipelines, or Databricks. - Managing data reconciliation and validation to ensure completeness, accuracy, and performance parity compared to legacy platforms. - Leading a team of data engineers/ETL developers delivering Snowflake-based solutions and migration workstreams. - Defining and enforcing coding standards, code review practices, and CI/CD pipelines for Snowflake objects. - Designing and building ELT/ETL patterns using tools such as dbt, ADF, Synapse, Databricks, or other orchestration tools. - Implementing automated testing frameworks and monitoring to ensure data quality and SLAs. - Monitoring query performance and optimizing Snowflake workloads using query profiling, clustering, partitioning, and warehouse sizing strategies. - Implementing resource monitors, auto-scaling, and auto-suspend policies to optimize compute usage and manage Snowflake consumption costs. Qualifications Required: - 8+ years of overall experience in Data Engineering/Data Warehousing/Analytics. - 5+ years of hands-on experience with Snowflake in production environments. - Proven experience leading at least one large end-to-end migration to Snowflake on Azure. - Strong experience with Azure cloud services and technical skills in SQL, Snowflake features, ELT/ETL tools, data modeling, and CI/CD pipelines. - Familiarity with BI tools like Power BI, Tableau, Looker, and soft skills including leadership, communication, problem-solving, and decision-making. NTT DATA is a $30 billion business and technology services leader, committed to accelerating client success and positively impacting society through responsible innovation. With expertise in AI, cloud, security, and more, we help organizations move confidently into the digital future. Join us as we shape the digital landscape and drive innovation globally.,
ACTIVELY HIRING
posted 2 months ago
experience5 to 9 Yrs
location
Karnataka
skills
  • Scala
  • TSQL
  • Python
  • Data Modeling
  • Git
  • Azure Data Factory
  • PySpark
  • CICD
Job Description
Role Overview: You will be responsible for hands-on migration and development tasks, including pipeline translation, stored procedure conversion, data modeling, large data handling, unit & integration testing, and performance tuning. Additionally, you will collaborate with the Technical Lead to optimize Spark code and Warehouse queries. Key Responsibilities: - Directly develop and migrate 20+ complex data pipelines from Azure Data Factory (ADF) into optimized Fabric Data Pipelines and Spark Notebooks (PySpark/Scala). - Rewrite and optimize 30+ complex stored procedures into robust, scalable transformations using PySpark in Fabric Lakehouses or high-performance T-SQL in Fabric Data Warehouses. - Implement the designed data architecture (Medallion layers: Bronze, Silver, Gold) within OneLake, focusing on Delta Lake best practices and V-Order optimization for efficient querying. - Execute the migration of 30+ TB of historical data efficiently and accurately, ensuring data integrity and reconciliation between legacy and Fabric environments. - Develop and execute comprehensive unit and integration tests to validate the correctness and performance of migrated data pipelines and stored procedures. - Work closely with the Technical Lead to identify and resolve data bottlenecks and optimize Spark code and Warehouse queries to meet latency requirements. - Operate within the established DevOps pipeline, ensuring all code changes, notebooks, and object definitions are managed under Git version control and deployed via the automated CI/CD framework. Qualifications Required: - 5+ years of dedicated experience in ETL/ELT development and data warehousing, with involvement in at least one major cloud data migration. - Strong, demonstrable experience with the Azure Data Stack (ADF, Synapse) and hands-on development experience in Microsoft Fabric. - Highly proficient in T-SQL for querying and procedural logic, and mandatory expertise in Python (PySpark) for data transformation. - Solid understanding of Kimball-style data warehousing, dimensional modeling, and modern Lakehouse concepts (Delta Lake, Parquet). - Experience working with Git for source control and familiarity with the principles of CI/CD deployment.,
ACTIVELY HIRING
posted 2 weeks ago
experience6 to 10 Yrs
location
Karnataka
skills
  • SQL
  • Data modeling
  • Communication skills
  • Data validation
  • Python
  • Excel
  • Web Analytics
  • ETL optimization techniques
  • Data ingestion tools
  • Data visualization tools
Job Description
As a Manager, Analytics Engineering at GALE, your role will be crucial in owning the data end-to-end for a portfolio of clients. Your responsibilities will include: - Managing data import/export, transformation, and visualization in collaboration with the Data Engineering team - Supporting the evolution of data architecture and reporting across cross-functional teams - Ensuring well-audited data aligned with best practices in coordination with the Technical Quality Assurance (QA) team - Assisting the Director in strategic and technical process improvements and innovation roadmap - Translating stakeholder needs into ETL/ELT and dashboard requirements based on the business context - Handling data ingestion, transformation, modeling, and aggregation to empower teams company-wide and clients for data analysis and storytelling - Providing mentorship and guidance to junior team members Qualifications required for this role include: - 6+ years of experience in analytics engineering, business intelligence, data engineering, software development, or related roles supporting marketing or sales organizations - Proficiency in SQL and ETL optimization techniques, particularly in cloud-based data warehouses like Redshift, Snowflake, and BigQuery - Familiarity with data ingestion tools such as Funnel, Fivetran, and Stitch - Experience working with data feeds from platforms like Google Marketing Platforms, Meta, Tiktok, and Trade Desk - Expertise in ETL/ELT pipelines, analytical data modeling, schema design, and dimensional data modeling - Knowledge of Data Visualization tools like Tableau, PowerBI, or Looker for reporting and analysis - Strong communication skills to explain technical matters clearly to both senior leaders and less technical partners - Ability to ensure data validation and QA with attention to detail - Proven technical leadership in project delivery - Motivation to be proactive and exceed expectations Nice to have qualifications include a BS degree in Engineering, Computer Science, Math, or related field, experience in consulting or advertising industry, proficiency in Python and Excel, and familiarity with leading Web Analytics platforms like Adobe Analytics. Note: Hybrid work in the office is an essential function of the job.,
ACTIVELY HIRING
posted 0 days ago

Manager Data Scientist Finance Solutions

PwC Acceleration Center India
experience10 to 15 Yrs
location
Karnataka
skills
  • Financial Management
  • Financial Strategy
  • Process Automation
  • Financial Systems Implementation
  • ERP Implementations
  • Performance Management
  • Business Development
  • People Development
  • Data Modeling
  • Data Governance
  • Project Management
  • Communication Skills
  • Problem Solving
  • Analytical Skills
  • Financial Solutions
  • Financial Performance Optimization
  • Decisionmaking
  • Financial Operations Improvement
  • Financial Process Assessment
  • Analytic Applications
  • Vendor
  • Software Selection
  • Enterprise Cloud Platforms
  • ERP Tools
  • EPM Tools
  • Client Service Orientation
Job Description
Role Overview: At PwC, as a Manager in the Finance Transformation practice, you will play a crucial role in helping clients improve their finance functions" performance. This involves transforming processes, people, and analytic tools to effectively manage changes and enhance the efficiency and effectiveness of finance operations. Your responsibilities will include engaging in ERP implementations, conducting organizational diagnostics, analyzing financial and operational data, and contributing to business development activities. Key Responsibilities: - Work and lead engagements with multidisciplinary teams, focusing on ERP implementations and integrating technology with finance processes - Conduct organizational diagnostics across all finance processes and perform analyses to support improvement initiatives - Establish credibility with clients by demonstrating expertise in finance, strategy, and EPM - Support engagement management by managing risk, project economics, and reviewing deliverable content - Participate in proposal development, contribute to proposal writing, and collaborate with colleagues to support client needs - Act as a coach, participate in staff recruitment and retention activities, and share knowledge across the PwC network - Stay updated with technology and market developments to provide guidance and support to clients Qualifications Required: - 10-15 years of professional experience, with over four years in consulting/professional services - Background in Big 4 consulting or boutique consulting is advantageous - Extensive experience in financial services, managing complex projects, and building financial data models - Proficiency in dimensional data modeling and designing data models aligned with business rules and governance standards - Familiarity with enterprise cloud platforms such as AWS, GCP, or MS Azure and interfacing with modern ERP and EPM tools - Strong communication, problem-solving, and project management skills - Ability to lead teams, build relationships with clients and vendors, and adapt to changing priorities Location: Bangalore, India Additional Company Details: Join PwC's thriving Finance consulting practice to work on challenging projects with global clients across various industries. Experience continuous learning, growth, and career advancement opportunities within the PwC network. Be inspired to excel every day and seize the opportunity to apply for roles that align with your professional goals.,
ACTIVELY HIRING
logo

@ 2025 Shine.com | All Right Reserved

Connect with us:
  • LinkedIn
  • Instagram
  • Facebook
  • YouTube
  • Twitter