6+ Snow flake schema Jobs in Mumbai | Snow flake schema Job openings in Mumbai

About Oneture Technologies

Founded in 2016, Oneture is a cloud-first, full-service digital solutions company, helping clients harness the power of Digital Technologies and Data to drive transformations and turning ideas into business realities. Our team is full of curious, full-stack, innovative thought leaders who are dedicated to providing outstanding customer experiences and building authentic relationships.

We are compelled by our core values to drive transformational results from Ideas to Reality for clients across all company sizes, geographies, and industries. The Oneture team delivers full lifecycle solutions—from ideation, project inception, planning through deployment to ongoing support and maintenance.

Our core competencies and technical expertise includes Cloud powered: Product Engineering, Big Data and AI ML. Our deep commitment to value creation for our clients and partners and “Startups-like agility with Enterprises-like maturity” philosophy has helped us establish long- term relationships with our clients and enabled us to build and manage mission-critical platforms for them.

About The Role

As a Data Platform Lead, you will utilize your strong technical background and hands-on development skills to design, develop, and maintain data platforms.

Leading a team of skilled data engineers, you will create scalable and robust data solutions that enhance business intelligence and decision-making. You will ensure the reliability, efficiency, and scalability of data systems while mentoring your team to achieve excellence.

Collaborating closely with our client’s CXO-level stakeholders, you will oversee pre-sales activities, solution architecture, and project execution. Your ability to stay ahead of industry trends and integrate the latest technologies will be crucial in maintaining our competitive edge.

Key Responsibilities

• Client-Centric Approach: Understand client requirements deeply and translate them into robust technical specifications, ensuring solutions meet their business needs.
• Architect for Success: Design scalable, reliable, and high-performance systems that exceed client expectations and drive business success.
• Lead with Innovation: Provide technical guidance, support, and mentorship to the development team, driving the adoption of cutting-edge technologies and best practices.
• Champion Best Practices: Ensure excellence in software development and IT service delivery, constantly assessing and evaluating new technologies, tools, and platforms for project suitability.
• Be the Go-To Expert: Serve as the primary point of contact for clients throughout the project lifecycle, ensuring clear communication and high levels of satisfaction.
• Build Strong Relationships: Cultivate and manage relationships with CxO/VP level stakeholders, positioning yourself as a trusted advisor.
• Deliver Excellence: Manage end-to-end delivery of multiple projects, ensuring timely and high-quality outcomes that align with business goals.
• Report with Clarity: Prepare and present regular project status reports to stakeholders, ensuring transparency and alignment.
• Collaborate Seamlessly: Coordinate with cross-functional teams to ensure smooth and efficient project execution, breaking down silos and fostering collaboration.
• Grow the Team: Provide timely and constructive feedback to support the professional growth of team members, creating a high-performance culture.

Qualifications

• Master’s (M. Tech., M.S.) in Computer Science or equivalent from reputed institutes like IIT, NIT preferred
• Overall 6-8 years of experience with minimum 2 years of relevant experience and a strong technical background.
• Experience working in mid size IT Services company is preferred

Location : Mumbai / Pune (Hybrid)

Technical Expertise:

• Advanced knowledge of distributed architectures and data modeling practices.
• Extensive experience with Data Lakehouse systems like Databricks and data warehousing solutions such as Redshift and Snowflake.
• Hands-on experience with data technologies such as Apache Spark, SQL, Airflow, Kafka, Jenkins, Hadoop, Flink, Hive, Pig, HBase, Presto, and Cassandra.
• Knowledge in BI tools including PowerBi, Tableau, Quicksight and open source equivalent like Superset and Metabase is good to have
• Strong knowledge of data storage formats including Iceberg, Hudi, and Delta.
• Proficient programming skills in Python, Scala, Go, or Java.
• Ability to architect end-to-end solutions from data ingestion to insights, including designing data integrations using ETL and other data integration patterns.
• Experience working with multi-cloud environments, particularly AWS and Azure.
• Excellent teamwork and communication skills, with the ability to thrive in a fast-paced, agile environment.

Role Overview:

We are seeking a talented and experienced Data Architect with strong data visualization capabilities to join our dynamic team in Mumbai. As a Data Architect, you will be responsible for designing, building, and managing our data infrastructure, ensuring its reliability, scalability, and performance. You will also play a crucial role in transforming complex data into insightful visualizations that drive business decisions. This role requires a deep understanding of data modeling, database technologies (particularly Oracle Cloud), data warehousing principles, and proficiency in data manipulation and visualization tools, including Python and SQL.

Responsibilities:

• Design and implement robust and scalable data architectures, including data warehouses, data lakes, and operational data stores, primarily leveraging Oracle Cloud services.
• Develop and maintain data models (conceptual, logical, and physical) that align with business requirements and ensure data integrity and consistency.
• Define data governance policies and procedures to ensure data quality, security, and compliance.
• Collaborate with data engineers to build and optimize ETL/ELT pipelines for efficient data ingestion, transformation, and loading.
• Develop and execute data migration strategies to Oracle Cloud.
• Utilize strong SQL skills to query, manipulate, and analyze large datasets from various sources.
• Leverage Python and relevant libraries (e.g., Pandas, NumPy) for data cleaning, transformation, and analysis.
• Design and develop interactive and insightful data visualizations using tools like [Specify Visualization Tools - e.g., Tableau, Power BI, Matplotlib, Seaborn, Plotly] to communicate data-driven insights to both technical and non-technical stakeholders.
• Work closely with business analysts and stakeholders to understand their data needs and translate them into effective data models and visualizations.
• Ensure the performance and reliability of data visualization dashboards and reports.
• Stay up-to-date with the latest trends and technologies in data architecture, cloud computing (especially Oracle Cloud), and data visualization.
• Troubleshoot data-related issues and provide timely resolutions.
• Document data architectures, data flows, and data visualization solutions.
• Participate in the evaluation and selection of new data technologies and tools.

Qualifications:

• Bachelor's or Master's degree in Computer Science, Data Science, Information Systems, or a related field.
• Proven experience (typically 5+ years) as a Data Architect, Data Modeler, or similar role. 
• 
  
• Deep understanding of data warehousing concepts, dimensional modeling (e.g., star schema, snowflake schema), and ETL/ELT processes.
• Extensive experience working with relational databases, particularly Oracle, and proficiency in SQL.
• Hands-on experience with Oracle Cloud data services (e.g., Autonomous Data Warehouse, Object Storage, Data Integration).
• Strong programming skills in Python and experience with data manipulation and analysis libraries (e.g., Pandas, NumPy).
• Demonstrated ability to create compelling and effective data visualizations using industry-standard tools (e.g., Tableau, Power BI, Matplotlib, Seaborn, Plotly).
• Excellent analytical and problem-solving skills with the ability to interpret complex data and translate it into actionable insights. 
• Strong communication and presentation skills, with the ability to effectively communicate technical concepts to non-technical audiences. 
• Experience with data governance and data quality principles.
• Familiarity with agile development methodologies.
• Ability to work independently and collaboratively within a team environment.
• 
  

Application Link- https://forms.gle/km7n2WipJhC2Lj2r5

• Strong Snowflake Cloud database experience Database developer.
• Knowledge of Spark and Databricks is desirable.
• Strong technical background in data modelling, database design and optimization for data warehouses, specifically on column oriented MPP architecture 
• Familiar with technologies relevant to data lakes such as Snowflake
• Candidate should have strong ETL & database design/modelling skills. 
• Experience creating data pipelines
• Strong SQL skills and debugging knowledge and Performance Tuning exp.
• Experience with Databricks / Azure is add on /good to have . 
• Experience working with global teams and global application environments
• Strong understanding of SDLC methodologies with track record of high quality deliverables and data quality, including detailed technical design documentation desired

• +2 years experience working as a react.js developer.
• In-depth knowledge of JavaScript, CSS, HTML, and front-end languages.
• Knowledge of REACT tools including React.js, Redux, Material UI.
• Experience with user interface design & user experience design
• Knowledge of performance testing frameworks including Mocha and Jest.
• Experience with browser-based debugging and performance testing software.
• Excellent troubleshooting skills.
• Good project management skills.
• Developing applications in React including component design and state management for specific use cases
• Experience working with at least one SQL and NoSQL Database (MongoDB, SQL Server, Snowflake, Postgres preferred)
• Basic experience with AWS platform