Job Description

: YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation. At YASH, we\'re a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth - bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future. We are looking forward to hireData Modelling Professionals in the following areas : Skills and Experience 5 to 8years of data modelling experience in a large enterprise.Dimensional data modeling is a key requirement. Should be good at translating business requirements into conceptual, logical, and physical data models. Knowledge of Star-Schema Modelling, Snowflake Schema Modelling, Fact, and Dimension tables. Demonstrable experience in modeling using a variety of techniques (3NF, dimensional, data vault, etc.) for different data stores and use cases using MS SQL SERVER / SNOWFLAKE. Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics). Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models. Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization. Design and implement reliable, scalable, robust, and extensible big data systems that support core products and business Own all data modeling efforts for an Analytic Theme within our Snowflake Analytic Platform, including the design of data structures and the identification of business transformation logic. Ensure the consistency, availability, understanding, and performance of data by following and improving best practices and standards for data modeling. Partner with data SMEs, data governance staff and architects and product owners to ensure that data meets consumption needs and conforms to governance standard methodologies. Roles and Responsibilities In this role, resource will primarily be responsible for Data Modeling activities. Performance improvements, technical documentation, provide updates on assigned tasks to team leads and customer. Develop ETL solutions as per defined ETL standards by client - Review requirements and provide effort estimates. Coordinate with team members to perform database programming based on project requirements. Develop stored procedures, complex SQL queries, scripts and database programming for systems. Perform quality assurance tests for ensuring data integrity across multiple databases. RCA and Bug fixes for issues reported by customer. Assist in identifying process improvements for database performance, reliability and stability. Perform troubleshooting and analysis to assess root cause of data issues in a timely manner. Understands best practices for data modelling, database programming and job scheduling and ETL package dependencies Required Technical Competencies Domain/ Industry Knowledge - Working knowledge of customer\'s business processes and relevant technology platform or product. Able to analyse current-state and define to-be processes in collaboration with SME and present recommendations with tangible benefits. Requirement Gathering and Analysis - Working knowledge of requirement management processes and requirement analysis processes, tools & methodologies. Able to analyse the impact of change requested/ enhancement/ defect fix and identify dependencies or interrelationships among requirements & transition requirements for engagement. Technology/Product Knowledge - Working knowledge of technology product/platform standards and specifications. Able to implement code or configure/customize products, analyse various frameworks/tools, review the code & provide inputs in design and architecture adhering to industry standards/ practices in implementation. Architecture tools and frameworks - Working knowledge of architecture Industry tools & frameworks. Able to identify pros/ cons of available tools & frameworks in market and use those as per Customer requirement and explore new tools/ framework for implementation. Architecture concepts and principles - Working knowledge of architectural elements, SDLC, methodologies. Able to provides architectural design/ documentation at an application or function capability level and implement architectural patterns in solution & engagements and communicates architecture direction to the business. Analytics Solution Design - Knowledge of statistical & machine learning techniques like classification, linear regression modelling, clustering & decision trees. Able to identify the cause of errors and their potential solutions. Tools & Platform Knowledge - Familiar with wide range of mainstream commercial & open-source data science/analytics software tools, their constraints, advantages, disadvantages, and areas of application. Required Behavioral Competencies Accountability - Takes responsibility for and ensures accuracy of own work, as well as the work and deadlines of the team. Collaboration - Shares information within team, participates in team activities, asks questions to understand other points of view. Agility - Demonstrates readiness for change, asking questions and determining how changes could impact own work. Customer Focus - Identifies trends and patterns emerging from customer preferences and works towards customizing/ refining existing services to exceed customer needs and expectations. Communication - Targets communications for the appropriate audience, clearly articulating and presenting his/her position or decision. Drives Results - Sets realistic stretch goals for self & others to achieve and exceed defined goals/targets. Resolves Conflict - Displays sensitivity in interactions and strives to understand others\' views and concerns. At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment.We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale. Our Hyperlearning workplace is grounded upon four principles Flexible work arrangements, Free spirit, and emotional positivity Agile self-determination, trust, transparency, and open collaboration All Support needed for the realization of business goals, Stable employment with a great atmosphere and ethical corporate culture

foundit