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
Shubham Vishwakarma
Full Stack Developer - Averlon
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.
Company social profiles
Similar jobs
Google AnalyticsWe are seeking an experienced SEO Executive to join our team. The ideal candidate should have a minimum of 1-3 years of experience in SEO and must possess expertise in ecommerce SEO. As an SEO Executive, you will be responsible for analyzing, reviewing, and implementing changes to our websites to ensure they are optimized for search engines.
Responsibilities:
- Conduct keyword research and analysis, and create content strategies based on the analysis.
- Optimize website content and structure for search engines.
- Work with developers to implement on-page SEO changes.
- Conduct regular audits of our websites and identify areas for improvement.
- Monitor and analyze website traffic, rankings, and other metrics to identify opportunities for improvement.
- Keep up-to-date with the latest trends and best practices in SEO and ecommerce.
- Provide SEO guidance and recommendations to other departments, including marketing and development teams.
Requirements:
- A minimum of 2-3 years of experience in SEO.
- Must have knowledge and experience in ecommerce SEO.
- Strong understanding of on-page and off-page SEO.
- Experience with website analytics tools, such as Google Analytics.
- Excellent written and verbal communication skills.
- Ability to work independently and in a team environment.
- Detail-oriented and able to prioritize tasks effectively.
Javascript
React.js
Redux/FluxAbout Company: Spica Systems (https://spicasys.com )
Spica Systems is a Silicon Valley based start-up, established in 2019 and are recognized as experts in building products and providing R& DandSoftware Development services in wide range of leading-edge technologies such as LTE, 5G, Cloud Services (Public -AWS, AZURE, GCP, Private -Openstack) and Kubernetes. Ithasa highly scalable and secured 5G Packet Core Network, orchestrated by ML powered Kubernetes platform, which can be deployed in various multi cloud modealong with a test tool. Headquartered in San Jose, California, we have our R& D centre in Sector V, Salt Lake Kolkata.
- Looking for a Software developer who will work on the product's Web UI side
- Hands on and working experience with React JS
- Experience in WebUI using Javascript technology.
- Experience: 2-4 years of React development in a team environment
- In-depth knowledge of JavaScript, CSS, HTML, and front-end languages.
- Knowledge of REACT tools including React.js, Webpack, Redux.
- Experience with user interface design. Knowledge of performance testing frameworks including Mocha and Jest.
- Experience with browser-based debugging and performance testing software.
Education: Bachelors/Masters in Computer Science, IT or Mathematics or Engineering
Traits: Quick learner, open minded, willing to learn
Software Development Engineer
Bengaluru/Hyderabad/Gurgaon/Chennai
As a Software Development Engineer at Amazon, you have industry-leading technical abilities and demonstrate breadth and depth of knowledge. You build software to deliver business impact, making smart technology choices. You work in a team and drive things forward.
Top Skills
- You write high quality, maintainable, and robust code, often in Java or C++ or C#
- You recognize and adopt best practices in software engineering: design, testing, version control, documentation, build, deployment, and operations.
- You have experience building scalable software systems that are high-performance, highly-available, highly transactional, low latency and massively distributed.
Roles & Responsibilities
- You solve problems at their root, stepping back to understand the broader context.
- You develop pragmatic solutions and build flexible systems that balance engineering complexity and timely delivery, creating business impact.
- You understand a broad range of data structures and algorithms and apply them to deliver high-performing applications.
- You recognize and use design patterns to solve business problems.
- You understand how operating systems work, perform and scale.
- You continually align your work with Amazon’s business objectives and seek to deliver business value.
- You collaborate to ensure that decisions are based on the merit of the proposal, not the proposer.
- You proactively support knowledge-sharing and build good working relationships within the team and with others in Amazon.
- You communicate clearly with your team and with other groups and listen effectively.
Skills & Experience
- Bachelors or Masters in Computer Science or relevant technical field.
- Experience in software development and full product life-cycle.
- Excellent programming skills in any object oriented programming languages - preferably Java, C/C++/C#, Perl, Python, or Ruby.
- Strong knowledge of data structures, algorithms, and designing for performance, scalability, and availability.
- Proficiency in SQL and data modeling.
About Amazon.com
“Many of the problems we face have no textbook solution, and so we-happily-invent new ones.” – Jeff Bezos
Amazon.com – a place where builders can build. We hire the world's brightest minds and offer them an environment in which they can invent and innovate to improve the experience for our customers. A Fortune 100 company based in Seattle, Washington, Amazon is the global leader in e-commerce. Amazon offers everything from books and electronics to apparel and diamond jewelry. We operate sites in Australia, Brazil, Canada, China, France, Germany, India, Italy, Japan, Mexico, Netherlands, Spain, United Kingdom and United States, and maintain dozens of fulfillment centers around the world which encompass more than 26 million square feet.
Technological innovation drives the growth of Amazon, offering our customers more selection, convenient shopping, and low prices. Amazon Web Services provides developers and small to large businesses access to the horizontally scalable state of the art cloud infrastructure like S3, EC2, AMI, CloudFront and SimpleDB, that powers Amazon.com. Developers can build any type of business on Amazon Web Services and scale their application with growing business needs.
We want you to help share and shape our mission to be Earth's most customer-centric company. Amazon's evolution from Web site to e-commerce partner to development platform is driven by the spirit of invention that is part of our DNA. We do this every day by inventing elegant and simple solutions to complex technical and business problems. We're making history and the good news is that we've only just begun.
About Amazon India
Amazon teams in India work on complex business challenges to innovate and create efficient solutions that enable various Amazon businesses, including Amazon websites across the world as well as support Payments, Transportation, and Digital products and services like the Kindle family of tablets, e-readers and the store. We are proud to have some of the finest talent and strong leaders with proven experience working to make Amazon the Earth’s most customer-centric company.
We made our foray into the Indian market with the launch of Junglee.com, enabling retailers in India to advertise their products to millions of Indian shoppers and drive targeted traffic to their stores. In June 2013, we launched http://www.amazon.in">www.amazon.in for shoppers in India. With www.amazon.in, we endeavor to give customers more of what they want – low prices, vast selection, fast and reliable delivery, and a trusted and convenient online shopping experience. In just over a year of launching our India operations, we have expanded our offering to over 18 million products across 36 departments and 100s of categories! Our philosophy of working backwards from the customers is what drives our growth and success.
We will continue to strive to become a trusted and meaningful sales and logistics channel for retailers of all sizes across India and a fast, reliable and convenient online shopping destination for consumers. For us, it is always “Day 1” and we are committed to aggressively invest over the long-term and relentlessly focus on raising the bar for customer experience in India.
Amazon India offers opportunities where you can dive right in, work with smart people on challenging problems and make an impact that contributes to the lives of millions. Join us so you can - Work Hard, Have Fun and Make History.
Machine Learning (ML)
Deep LearningJob Description :
Sr. Machine Learning Engineer will support our various business vertical teams with insights gained from analyzing company data. The ideal candidate is adept at using large data sets to find opportunities for product and process optimization and using models to test the effectiveness of different courses of action. They must have strong experience using a variety of data mining/data analysis methods, using a variety of data tools, building and implementing models, using/creating algorithms and creating/running simulations. They must have a proven ability to drive business results with their data-based insights. They must be comfortable working with a wide range of stakeholders and functional teams. The right candidate will have a passion for discovering solutions hidden in large data sets and working with stakeholders to improve business outcomes.
Accountabilities :
- Collaborate with product management and engineering departments to understand company needs and devise possible solutions
- Keep up-to-date with latest technology trends
- Communicate results and ideas to key decision makers
- Implement new statistical or other mathematical methodologies as needed for specific models or analysis
- Optimize joint development efforts through appropriate database use and project design
Skills & Requirements :
Technical Skills :
- Demonstrated skill in the use of one or more analytic software tools or languages (e.g., R, Python, Pyomo, Julia/Jump, Matlab, SAS,SQL)
- Demonstrated skill at data cleansing, data quality assessment, and using analytics for data assessment
- End-to-end system design: data analysis, feature engineering, technique selection & implementation, debugging, and maintenance in production.
- Profound understanding of skills like outlier handling, data imputation, bias, variance, cross validation etc.
- Demonstrated skill in modeling techniques, including but not limited to Predictive modeling, Supervised learning, Unsupervised learning, Machine Learning, Statistical Modeling, Natural language processing, Recommendation engines,
- Demonstrated skill in analytic prototyping, analytic scaling, and solutions integration
- Developing hypotheses and set up your own problem frameworks to test for the best solutions
- Knowledge of data visualization tools - ggplot, Dash, d3.js and Matplottlib (or any other data visualization like Tableau, Qlikview)
- Generating insights for a business context
Desirable :
- Experience with cloud technologies for building, deploying and delivering data science applications is desired (preferably in Microsoft Azure)
- Experience in Tensorflow, Keras, Theano, Text Mining is desirable but not mandatory
- Experience to work in Agile and DevOps processes.
Core Skills :
- Bachelor or master degree in information technology, computer science, business administration or a related discipline.
- Certified in Agile Product Owner / SCRUM master and/or other Agile techniques
Leadership Skills :
- Strong stakeholder management and influencing skills. Able to articulate a vision and build support for that vision in the wider team and organization.
- Ability to self-start and direct efforts based on high-level business objectives
- Strong collaboration and leadership skills with the ability to coach and develop teams to meet new challenges.
- Strong interpersonal, communication, facilitation and presentation skills.
- Work through complex interfaces across organizational and geographic boundaries
- Excellent analytical, planning and problem solving skills
Job Experience Requirements :
- Utilize an advanced knowledge level of the Data Science Toolbox to participate in the entire Data Science Project Life cycle and execute end-to-end Data Science project
- Work end-to-end on Data Science developments contributing to all aspects of the project life cycle
- Keep customers as focus of analysis insight and recommendation.
- Help define business objectives/customer needs by capturing the right requirements from the right customers.
- Can take defined problems and identify resolution paths and opportunities to solve them; which you validate by defining hypotheses and driving experiments
- Can identify unstructured problems and articulate opportunities to form new analytics project ideas
- Use and understand the key performance indicators (KPIs) and diagnostics to measure performance against business goals
- Compile integrate and analyze data from multiple sources to identify trends expose new opportunities and answer ongoing business questions
- Execute hypothesis-driven analysis to address business questions issues and opportunities
- Build validate and manage advanced models (e.g. explanatory predictive) using statistical and/or other analytical methods
- Are familiar working within Agile Project Management methodologies / structures
- Analyze results using statistical methods and work with senior team members to make recommendations to improve customer experience and business results
- Have the ability to conceptualize formulate prototype and implement algorithms to capture customer behavior and solve business problems
- Analyze results using statistical methods to make recommendations to improve customer experience and business results
Jenkins
Amazon Web Services (AWS)
We are looking for a Sr. Engineer DevOps and SysOps, who is responsible for managing AWS and Azure cloud computing. Your primary focus would be to help multiple projects with various cloud service implementation, create and manage CI/CD pipelines for deployment, explore new services on cloud and help projects to implement them.
Technical Requirements & Responsibilities
- Have 4+ years’ experience as a DevOps and SysOps Engineer.
- Apply cloud computing skills to deploy upgrades and fixes on AWS and Azure (GCP is optional / Good to have).
- Design, develop, and implement software integrations based on user feedback.
- Troubleshoot production issues and coordinate with the development team to streamline code deployment.
- Implement automation tools and frameworks (CI/CD pipelines).
- Analyze code and communicate detailed reviews to development teams to ensure a marked improvement in applications and the timely completion of projects.
- Collaborate with team members to improve the company’s engineering tools, systems and procedures, and data security.
- Optimize the company’s computing architecture.
- Conduct systems tests for security, performance, and availability.
- Develop and maintain design and troubleshooting documentation.
- Expert in code deployment tools (Puppet, Ansible, and Chef).
- Can maintain Java / PHP / Ruby on Rail / DotNet web applications.
- Experience in network, server, and application-status monitoring.
- Possess a strong command of software-automation production systems (Jenkins and Selenium).
- Expertise in software development methodologies.
- You have working knowledge of known DevOps tools like Git and GitHub.
- Possess a problem-solving attitude.
- Can work independently and as part of a team.
Soft Skills Requirements
- Strong communication skills
- Agility and quick learner
- Attention to detail
- Organizational skills
- Understanding of the Software development life cycle
- Good Analytical and problem-solving skills
- Self-motivated with the ability to prioritize, meet deadlines, and manage changing priorities
- Should have a high level of energy working as an individual contributor and as a part of team.
- Good command over verbal and written English communication
Laravel
AngularJS (1.x)
Angular (2+)
MongoDB
Google Analytics
PHPAngular (2+)
NodeJS (Node.js)MongoDBJavascript
HTML/CSSAngularJS (1.x)
Vue.js
Git
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon