
Advanced SQL, data modeling skills - designing Dimensional Layer, 3NF, denormalized views & semantic layer, Expertise in GCP services
Role & Responsibilities:
● Design and implement robust semantic layers for data systems on Google Cloud Platform (GCP)
● Develop and maintain complex data models, including dimensional models, 3NF structures, and denormalized views
● Write and optimize advanced SQL queries for data extraction, transformation, and analysis
● Utilize GCP services to create scalable and efficient data architectures
● Collaborate with cross-functional teams to translate business requirements(specified in mapping sheets or Legacy
Datastage jobs) into effective data models
● Implement and maintain data warehouses and data lakes on GCP
● Design and optimize ETL/ELT processes for large-scale data integration
● Ensure data quality, consistency, and integrity across all data models and semantic layers
● Develop and maintain documentation for data models, semantic layers, and data flows
● Participate in code reviews and implement best practices for data modeling and database design
● Optimize database performance and query execution on GCP
● Provide technical guidance and mentorship to junior team members
● Stay updated with the latest trends and advancements in data modeling, GCP services, and big data technologies
● Collaborate with data scientists and analysts to enable efficient data access and analysis
● Implement data governance and security measures within the semantic layer and data model

About Cymetrix Software
About
Cymetrix is a global CRM and Data Analytics consulting company. It has expertise across industries such as manufacturing, retail, BFSI, NPS, Pharma, and Healthcare. It has successfully implemented CRM and related business process integrations for more than 50+ clients.
Catalyzing Tangible Growth: Our pivotal role involves facilitating and driving actual growth for clients. We're committed to becoming a catalyst for dynamic transformation within the business landscape.
Niche focus, limitless growth: Cymetrix specializes in CRM, Data, and AI-powered technologies, offering tailored solutions and profound insights. This focused approach paves the way for exponential growth opportunities for clients.
A Digital Transformation Partner: Cymetrix aims to deliver the necessary support, expertise, and solutions that drive businesses to innovate with unwavering assurance. Our commitment fosters a culture of continuous improvement and growth, ensuring your innovation journey is successful.
The Cymetrix Software team is under the leadership of agile, entrepreneurial, and veteran technology experts who are devoted to augmenting the value of the solutions they are delivering.
Our certified team of 150+ consultants excels in Salesforce products. We have experience in designing and developing products and IPs on the Salesforce platform enables us to design industry-specific, customized solutions, with intuitive user interfaces.
Candid answers by the company
Cymetrix is a global CRM and Data Analytics consulting company. It has expertise across industries such as manufacturing, retail, BFSI, NPS, Pharma, and Healthcare. It has successfully implemented CRM and related business process integrations for more than 50+ clients.
Similar jobs
Job Title : Senior Node.js Developer
Experience : 5 to 10 Years
Location : Gurugram (5 days WFO) | Initial 15 days in Udaipur (expenses covered)
Notice Period : 1 Month or less
Role Overview :
We are hiring a Senior Node.js Developer to lead and deliver scalable solutions, drive best practices, and mentor engineers. Strong Node.js expertise is mandatory (MERN experience welcome with Node.js depth).
Mandatory Skills :
Node.js, Express.js, Data Structures & Algorithms, System Design (HLD/LLD), CI/CD, Git, Agile, Async programming, Debugging & Performance Optimization.
Key Responsibilities :
- Lead development and ensure high‑quality delivery.
- Gather requirements, design (HLD/LLD), and implement solutions.
- Optimize performance, scalability, and integrations.
- Mentor team members and support hiring.
- Collaborate in Agile teams and enforce coding best practices.
Required Skills :
- 5 to 10 Years in backend with Node.js/Express.js.
- Strong in DSA, problem‑solving, and system design.
- Experience with CI/CD, Git, and Agile methodologies.
- Expertise in async programming, debugging, and performance tuning.
- Excellent communication and collaboration skills.
Nice to Have : MERN stack exposure, cloud (AWS/Azure/GCP), Docker, caching/queues.
Interview Process :
- AI Technical Interview
- System Design Round (HLD & LLD)
- Data Structures & Algorithms
- HR Interview
Location :
- Primary : Gurugram (Digital Greens, Sector 61)
- Initial 15 days : Udaipur (A‑square, Shobhagpura)
Note : Preference for Gurugram/NCR candidates. Stable profiles only.
Key Responsibilities:
- Design, develop, and maintain ETL processes and data pipelines.
- Work with OLAP databases and ensure efficient data storage and retrieval.
- Utilize Apache Pinot for real-time data analytics.
- Implement and manage data integration using Airbyte.
- Orchestrate data workflows with Apache Airflow.
- Develop and maintain RESTful and GraphQL APIs for data services.
- Deploy and manage applications on Hausra Cloud.
- Collaborate with cross-functional teams to understand data requirements and provide scalable solutions.
- Ensure data quality, integrity, and security across all pipelines.
Required Skills and Experience:
- Proven experience in ETL development and data pipeline management.
- Strong understanding of OLAP systems.
- Hands-on experience with Apache Pinot.
- Proficiency in using Airbyte for data integration.
- Expertise in Apache Airflow for workflow orchestration.
- Experience in developing RESTful and GraphQL APIs.
- Familiarity with Hausra Cloud or similar cloud platforms.
- Excellent problem-solving skills and attention to detail.
- Strong communication skills and ability to work in a collaborative team environment.
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 3+ years of experience in backend engineering with a focus on data pipelines and ETL processes.
- Demonstrated ability to work in a fast-paced, dynamic environment.
Note: Contractual Job for 06 Months
Job Purpose
We work in the latest technology, and our foundations are data structures, algorithms, solid logical reasoning, and mathematics. We are looking for very strong engineers who love coding, optimizing, and ensuring their code is the most efficient.
You will be involved with hardcore development. If you are an assembler of code or packages from different places to build something, you may not find our team to be the right fit.
You must be someone who can build anything from the ground up. Programming language should not be any barrier for you, as you should be able to pick up any programming language or underlying technology within a week.
Key Areas of Responsibility
Core development. Ready to participate in the designing, brainstorming, and development process. You must give sleepless nights to meet deadlines whenever required.
Desired Candidate Profile
Essential Skills
- Reliable, Accountable, and Trustworthy
- Ability to understand software requirements based on a wireframe/program specification
- Familiarity with GoLang / PHP / Python / Java / C / C++ / Linux Shell and Scripting / HTML / CSS / JS / Node.js is a plus
- Effective communication skills to ensure smooth coordination of tasks with the Team Leader.
- Knowledge of MongoDB, MySQL, and PL/SQL is a plus
- Familiarity with ML, TensorFlow, and Keras is a plus
- Knowledge of web servers such as Apache, NGNIX, and the HTTP protocol is a plus.
- Knowledge of multi-process, threads, memory, and filesystem on Linux is desirable.
- Must Solve The Following
To consider you for the current opening, please make sure to understand the following question and solve it. A simple program in any programing language would do. If you cannot solve this, please do not apply.
Write a function foo(x) where foo(foo(x)) = -x (assume x to be an integer, and foo(x) has to be always real), any programming language would do. Before submitting the answers, please verify that the output of foo(foo(10)) should be -10 and foo(foo(-10)) should be 10.
• Experience in WooCommerce Development and payment gateway integration
• Experience in WordPress Theme Customization & Development
• Experience in WordPress Plugin Customization & Development
• Must have hands-on experience with Elementor Theme
• Good understanding of front-end technologies, including HTML5, CSS3, JavaScript, jQuery
• Experience building user interfaces for websites and/or web applications
• Experience designing and developing responsive design websites
• Comfortable working with debugging tools like Firebug, Chrome inspector, etc.
• Ability to understand CSS changes and their ramifications to ensure consistent style across platforms and browsers
• Strong understanding of PHP back-end development.
• Troubleshooting and error-solving attitude.
• Excellent written and verbal communication skills.
Tired of working endless hours on uninspiring products? Come work with AvanSaber (https://www.avansaber.com/" target="_blank">https://www.avansaber.com). An inclusive productive team that is changing the way that every customer manages their business!
Qualifications - Technical Skills Required:
Mandatory Skills:
Soft skills required
Strong collaborative skills
Excited by the thought of working with hard problems to solve
Focused on delivering software within the timeframes, we set collaboratively
Laravel
Optional:
VueJS, NuxtJS, React, and React Native
Mobile Frontend for Android or iOS
A little nerdy, tell us your passions. Show us your killer portfolio! Ideally, have some work currently used in the wild and be able to talk with us about your process, challenges, and what you've learned from it all.
Know more than us about your craft, and be able to use data to support your design decisions.

Responsibilities
- Technical Guidance: You will provide technical leadership to a team of excellent software engineers; this requires that you have the technical depth to make complex design decisions and the hands-on ability to lead by example.
- Execution and Delivery: You will be expected to instill and follow good software development practices and ensure timely delivery of high-quality products. You should be familiar with agile practices as well as be able to adapt these to the needs of the business, with a constant focus on product quality.
- Team management : You will be responsible for hiring and mentoring your team; helping individuals grow in their careers, having constant dialogue about their aspirations and sharing prompt, clear and actionable feedback about performance.
- Technical depth: You have the strong technical competence required to gain credibility. Ability to architect, design and code yourself. Technical experience in building and operating web-based applications. Deep understanding of all layers of the web-stack work (from the client interface to the database.) Knowledge of multiple technology stacks/languages/tools and their pros/cons.
- Execution ability: Focus on delivering products in a timely manner with high quality. Familiarity with multiple software development practices and tools, and the proven ability to adapt, champion and institute good practices and tools.
- You must have a degree in Computer Science or a related field. Strong understanding of object- oriented programming, concurrency and fundamentals of computer-science.
- Total of 9+ years’ experience building cutting edge products. Deep experience in building very large scale applications and 2 + years’ experience in team management.
- Strong problem solving skills, data structures and algorithms.
We are looking for a senior .NET Core professionals with 2+ years of development experience, who thrive on challenges and desires to make a real difference in the business world.
You are required to have skills in the following areas:
- 2 to 4 years of experience in. NET Core development.
- Knowledge and Hands-on experience of at least 2 years on ASP.Net, C#, MS SQL Server, Restful, C# 3.5/4.0, MVC
- Desirable Skills: Excellent written and verbal communication skills. Excellent analytical and troubleshooting abilities.
- Solid understanding of best practices in web application development.
- Exceptional attention to detail and design.
Skills Required:
- Must have strong exposure working on Java Script
- Proficient in Javascript frameworks (Vue Js / React Js) is a must
- Strong understanding of REST APIs
- Have experience with common front-end development tools such as Babel, Webpack, NPM is a definite advantage
- Good understanding of asynchronous request handling, partial page updates, and AJAX
- Proficient understanding of code versioning tools, such as GitHub
- Good to have working experience on CSS pre-processor either LESS or SASS
- Good understanding of BEM (Block, Element, Modifier) methodology
- Proficiency in Database (MySQL, MongoDB)
- Proficiency in best practices for building backend services like Session management, caching, authentication, etc
- Strong proficiency with JavaScript & ES6 or ECMA 2015 on the NodeJs platform.







