10 Warehouse Design Jobs

9-11 years experience developing data management solutions, including warehouse design, building, and data ingestion/ETL Experience leading a team of multi-disciplined developers to deliver data analytics solutions using Agile processes 5-7 years of relevant experience in experience inSql, PL/SQL,Python,ETL/ELT ,Data modeling 3-5 years experience working with Cloud data platforms such as Snowflake, Redshift, Databricks etc 2-3 years experience in AWS (DMS,Glue,Lambda) Experience with Life Sciences related business process domains, such as R&D, manufacturing, quality, and supply chain is beneficial Strong data analysis skills Experience with data modelling, especially for warehouses and repositories Experience with SQL and relational databases Development expertise with data management design principles Ability to communicate well with both business owners and technical staffs, at the appropriate level for both Team management experience Scrum Master experience in Agile (SAFe experience a plus) Experience with Snowflake, Oracle databases, and Information PowerCenter and/or IICS Experience with analytics business intelligence solution

Be part of ODI/GCP development team, Develop ODI/GCP packages/interfaces as per business requirement. (ODI). GCP (Google Cloud Platform) knowledge (Big Query, DAG s, Airflow, Composer and other GCP components) Develop ODI scripts to promote scenarios and packages from dev to test to production. Experience writing complex & analytical SQL queries and performance tuning ELT Process and bottle neck SQL queries Experience with writing technical documentation to ensure business requirements are met through the data warehouse design. Strong professional oral and written communication skills and the ability to interact with people at all organizational levels. Ability to get up to speed quickly on a project that is underway Working Experience on Google Big Query. ( Good to have) Qualifications Required: (Education, experience, skills, etc Please be specific) At least 5 years hands-on experience working with ODI ETL tool 3 plus years Data Warehouse experience Expertise using Topology, Knowledge Modules, Change Data Capture, Metadata Bachelors or Masters in Computer Science is preferred. Strong understanding of ETL technology and processes. Proficient in Netezza database management tools/utilities. Qualifications Required: (Education, experience, skills, etc Please be specific) Education : BE/M.C.A

Roles and Responsibilities Manage warehouse operations, including inventory management, stock control, and stocking processes. Coordinate with logistics team for timely delivery of products and services to customers. Looking for warehouse set up, plan for new warehouse set up.

Skill - Azure Data Engineer Designation- Module Leader/Technical Leader/ Technical Architect Experience - 8-15 years Location - Chennai, Kochi and Bangalore Roles & Responsibilities Design, develop, and maintain robust data pipelines and ETL processes. Implement and optimize data storage solutions in data warehouses and data lakes. Collaborate with cross-functional teams to understand data requirements and deliver high-quality data solutions. Utilize Microsoft Azure tools for data integration, transformation, and analysis. Develop and maintain reports and dashboards using Power BI and other analytics tools. Ensure data integrity, consistency, and security across all data systems. Optimize database and query performance to support data-driven decision-making. Qualifications: 8-15 years of professional experience in data engineering or a related field. Profound expertise in SQL, T-SQL, database design, and data warehousing principles. Strong experience with Microsoft Azure tools, including SQL Azure, Azure Data Factory, Azure Databricks, Data Fabric and Azure Data Lake. Proficiency in Python, PySpark, and PySQL for data processing and analytics tasks. Experience with Power BI and other reporting and analytics tools. Demonstrated knowledge of OLAP, data warehouse design concepts, and performance optimizations in database and query processing. Excellent problem-solving, analytical, and communication skills. Interested candidates can share their updated resume at megha.chattopadhyay@aspiresys.com

Proficient in MicroStrategy Schema design Developing Schema and Public Objects in MicroStrategy Developing Intelligent Cubes, Dashboards and Dossiers in MicroStrategy Experience with MicroStrategy Object Manager Proficiency in SQL Good understanding on warehouse design Understanding on DB2 Knowledge on Cognos is a plus Migrating Reports and Dashboards from Cognos to MicroStrategy ( desirable) Ability to troubleshoot and have good client facing skills Should be able to suggest changes / enhancements on the existing Cognos Reports and Dashboards

Level of skills and experience: 5 years of hands-on experience in using Python, JVM and Shell Scripting with production experience. 3 years of proven experience on building cloud native data intensive applications, Amazon Web Service experience is a must and good to have experience in GCP. Experience on Data Warehouse design and development per the business nature using any of the modern data warehouses. Having experience in Databricks and dbt experience is required. Highly proficient in architecting and implementing workflow management systems, Airflow is a must. Familiarity with containerization and orchestration technologies (e.g., Docker, Kubernetes). Hands-on experience of building and maintaining Spark applications. Fundamental understanding of Parquet, Delta Lake and other OTFs file formats. Proficiency on an IaC tool such as Terraform, CDK or CloudFormation is a must. Experience with observability systems (such as Datadog or Prometheus/Grafana) Strong experience on building CI/CD processes, experience with GitHub Actions, ArgoCD or Jenkins is good to have. Experience with unit testing and test automation frameworks. Comfortable providing, receiving constructive feedback, particularly while participating in code reviews and ability to not only code, but also provide good quality readable business documentation. Focus on business value vs engineering interest and focus on business value vs engineering interest. Pro-active / service-oriented towards our internal customers Strong written and verbal English communication skill and proficient in communication with non-technical stakeholders.

Job Description Education/training: Bachelors/Master degree in computer science, management, or a relevant field. Work Experience: 7+ years experience in ETL and Database development Experience with data modeling and ETL. Strong hands on experience in ETL process preferably Incorta solution . Experience in data warehouse design and maintenance is plus Knowledge and experience in Azure Synapse, Data Bricks, building pipelines in AZURE Synapse platform. plus. Skills and languages: Proficiency in written and spoken English; working knowledge of another UN language would be an asset. Expected Deliverables: Candidate should help IST in data extraction process from Quantum to Datawarehouse. Should help building data models in different area of Quantum based data sets. Candidate should build pipeline to establish integration of data flow among different sources of IT applications.

? ?Job Description ?Key Tech stack 1) Power BI 2) Microsoft SQL Server (SQL Programming) 3) SAP BODS or any ETL Experience 4) SAP BO Reporting (Basic hands on is fine) Experience: 10+ years experience with BI Experience in T-SQL, Performance Tuning, ETL SAP BODS (Preferred, But Any ETL tool is fine) 3+ years experience Power BI 2+ years experience in SAP BO (Optional) Key Responsibilities: Formulate automated reports and dashboards using Power BI and other reporting tools. Understand business requirements to set functional specifications for reporting applications. You should be familiar with TSQL, Power Query, MDX, Power BI, and DAX. Exhibit a foundational understanding of database concepts such relational database architecture, multidimensional database design, and Data Warehouse Design data models that transform raw data into insightful knowledge by understanding business requirements in the context of BI. Developing Power BI desktop to create dashboards, KPI scorecards, and visual reports. Establish row-level security on data and comprehend Power BI`s application security layer models. Power BI Admin (Scheduling, Manage Workspace, User access Management, Security) Good Experience in any ETL tool Hands on experience in SAP BO reporting tool. Actively seek opportunities to improve processes. Provide 24x7 on call support for critical production systems. (This is optional, but above Three skills are mandatory)

Preferred skills and qualifications 7 or more years of experience in building and delivering analytical applications.BE/BTech or higher degree in Computer Science, Computer Engineering.Excellent knowledge on OBIEE/OAC RPD development.Experience in OBIEE/OAC Reports Dashboard and/or Data Visualization Projects development.Exposure to Data Warehouse design, Star Schema modeling. Build and manage the OAC RPD models to optimize data accessibility and performance. Create dynamic, user-friendly OAC dashboards and visualizations that turn data into insights. Set up alerts and automate data flows to keep business teams informed in real-time. Collaborate on data warehouse design, data pipelines, helping shape how we store and manage data. Use ETL tools (Oracle Data Integrator) to move and transform data, ensuring it s ready for analysis. Have a good broader business understanding and mindset, while technically leading efforts in specific areas. Make effective judgments and choices on design and roadmap based on various considerations. Work with business and technical teams to understand needs and deliver effective OAC solutions. Troubleshoot and solve any issues that come up with data flows, dashboards, or OAC configurations. Stay current with OAC updates and best practices, continually improving our analytics capabilities. Excellent knowledge in development of repository at all the three layers including Physical Layer, Business Model and Mapping Layer and Presentation Layer. Knowledge in creating Logical columns, Hierarchies (Level Based, Parent Child), Measures, Aggregation Rules, Aggregations, Time Series in Business Model and Catalog Folders in Presentation layers. Good Knowledge in security set up for reports and dashboards, and OBIEE administrative activities. Experience on Oracle SQL, database performance tuning by implementing Views, Materialized views, creating indexes. Strong interpersonal and team leadership skills

Preferred skills and qualifications 7 or more years of experience in building and delivering analytical applications.BE/BTech or higher degree in Computer Science, Computer Engineering.Excellent knowledge on OBIEE/OAC RPD development.Experience in OBIEE/OAC Reports Dashboard and/or Data Visualization Projects development.Exposure to Data Warehouse design, Star Schema modeling. Build and manage the OAC RPD models to optimize data accessibility and performance. Create dynamic, user-friendly OAC dashboards and visualizations that turn data into insights. Set up alerts and automate data flows to keep business teams informed in real-time. Collaborate on data warehouse design, data pipelines, helping shape how we store and manage data. Use ETL tools (Oracle Data Integrator) to move and transform data, ensuring it s ready for analysis. Have a good broader business understanding and mindset, while technically leading efforts in specific areas. Make effective judgments and choices on design and roadmap based on various considerations. Work with business and technical teams to understand needs and deliver effective OAC solutions. Troubleshoot and solve any issues that come up with data flows, dashboards, or OAC configurations. Stay current with OAC updates and best practices, continually improving our analytics capabilities. Excellent knowledge in development of repository at all the three layers including Physical Layer, Business Model and Mapping Layer and Presentation Layer. Knowledge in creating Logical columns, Hierarchies (Level Based, Parent Child), Measures, Aggregation Rules, Aggregations, Time Series in Business Model and Catalog Folders in Presentation layers. Good Knowledge in security set up for reports and dashboards, and OBIEE administrative activities. Experience on Oracle SQL, database performance tuning by implementing Views, Materialized views, creating indexes. Strong interpersonal and team leadership skills