Data Modeler

Required Skill Set : Hands on experience with ERWIN Data Modeler and Working on the Enterprise Data Mart. Understanding Metadata Management principles ( Data Dictionary activities ). Hands on experience with Creating the ETL Mapping. Should understand impacts of model changes on databases and to validate that a model supports straight-forward requirements. Hands on experience with 3NF Data Modeling and NORMALIZED schema. Should be able to analyze business requirements to develop data models with minimal oversight. Hands on experience implementing Data Warehouse presentation layer – including design and definition of logical tables, physical sources, columns, aggregation rules. Hands on experience in writing SQL queries, views, and optimization of SQL queries. Comprehensive Knowledge of Bill Inmon’s Data Modeling Concepts (Logical and Physical) including 3NF, Supertypes, Subtypes, Abstraction, Associative entities / tables. Requires strong decision-making, organizational, planning and problem-solving skills. Nice to have : Knowledge on other Data Modeling tools like Power Designer , Visio , ER studio. Comprehensive Knowledge of Ralph Kimball’s Data Modeling Concepts including Transaction dimensions, conformed dimensions and facts, slowly changing dimension, multi-Star/ Snowflake Schema Modeling, different types of Fact tables. Implementing a virtual semantic layer (virtual star schema) using views on a multi-tiered normalized Integrated Operational Data Store is a huge plus. 3NF (Relational) Logical and Physical Modeling. Mail Resume to career@intsof.com in the format [First name]_[Job Title].Pdf or [First name]_[Job Title].docx Location – India Development Centre Benefits What makes Intersoft the Best Place to Work Work-Life Balance Your work-life balance matters to us. Freedom and flexibility are an integral part of our work culture. Flexibility encourages emergence of new ideas and we would give you the creative freedom to bring your ideas to life. Recognition Everyone doing a little extra to make our organization achieve new heights is an asset for us. We admire their efforts in every possible way. Rest assured; you will find that your hard work never goes unnoticed! . . Inclusive Environment Becoming an Intersoftian is about embracing a culture of openness, collaboration, trust and having a voice. We foster an environment of openness and transparency, emboldening each individual to share their thoughts & ideas. Challenging Projects Technology is ever-changing, and we are looking for dynamic individuals who can keep up with the latest trends and are motivated to master new skills and use them to creatively provide cutting- edge solutions for our customers. Fun @ Work Happy Employees are engaged and productive. We like to have fun while we work and make each day an enjoyable experience, celebrating festivals as well as professional milestones with equal fervour. . . Learning & Growth With the technology space constantly evolving we ensure that our people stay ahead of the current trends. We want our employees to learn and evolve as they grow with us. . . Life @ Intersoft Everything we do – our people are at the centre of it. We believe that our people are the building blocks of our success. We are not just a workplace, but a community that harnesses talent and nurtures creativity. If you have passion for technology and the drive to make an impact, we are just the place for you. Come along and discover brilliant, enthusiastic people just like yourself who are making enterprising choices for our clients every day. Bring along your uniqueness, creativity, and resolve to make a difference, and together we’ll solve some of the greatest challenges.