Job Location: Pune, Maharashtra, India
DATA MODELER
9-12 YRS
PUNE/BANGALORE/HYDERABAD
What’s this role about?
As Data Modeler, you will be responsible for translating the enterprise business needs into conceptual, logical and physical data models and providing advisory and thought leadership on data modelling tools, techniques and best practices for the design and implementation of the data architecture and data modelling solutions supporting enterprise information management, business intelligence, machine learning, data science, and other business interests across relational, dimensional and NoSQL databases.
Here’s how you’ll contribute:
The Data modeler at Zensar participates in end to end cycle from opportunity identification to its closure and takes up complete ownerships of project execution and provide valuable expertise in the project. You will do this by:
- Responding to client RFI, RFP documents with proper solution design including cost estimates
- Understanding customer requirements and create technical proposition
- Contributing to SoWs, technical project roadmaps, etc required for successful execution of projects leveraging Technical Scoping & Solutioning approach
- Managing and owning all aspects of technical development and delivery
- Understanding requirements and writing technical documents
- Ensuring code review and developing best practises
- Planning end to end technical scope of the project and customer engagement area including planning sprint and delivery
- Estimating effort, identifying risk and providing technical support whenever needed
- Demonstrating the ability to multitask and re-prioritizing responsibility based on dynamic requirements
- Leading and mentoring teams as needed
Skills required to contribute:
9-12 Years of Data and Analytics experience in Data Warehouse, Data Architecture, Design, Analysis, Modeling, Development, Testing, Implementation, Training and Documentation
- Excellent communication and presentation skills.
- Extensive experience in creating, and maintaining conceptual, logical and physical data models defining information requirements for data management and business intelligence purposes.
- Extensive Experience OLTP/OLAP System and E – R modeling, Forward and Reverse Engineering, Publishing Erwin diagrams, analyzing data sources and creating interface documents, developing database Schemas like Star schema and Snowflake schema, identifying the dimensions, measures, Hierarchy levels for Fact and Dimension tables, designing for late arriving data and factless facts, defining and maintaining accurate functional data definitions and taxonomies for entities and attributes.
- Excellent experience of working with business and application/solution teams to implement data strategies, build data flows and document Business Process Modeling, Process Flow Modeling, Data flow modeling
- Strong exposure in data governance strategy, policies and best practices including data quality, accuracy, security, master data management, metadata management and data cataloging, developing Data dictionary and Metadata for each model.
- Expert in Data modeling using various methodologies such as Data Vault 2.0, Dimensional modeling & 3NF modeling
- Has good experience in data cleansing, data manipulations and transformations and data auditing including data model evaluation for variances & discrepancies.
- Strong and Excellent experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification, identifying data mismatch, Data Import, and Data Export through the use of multiple ETL tools such as Pentaho, Talend and Informatica PowerCenter and Informatica BDE or cloud ETL technologies and cloud ETL frameworks as necessary.
- Good experience on multiple RDBMS such as SQL Server, Oracle, PostgreSQL, Cloud databases such as Snowflake, Redshift, Synapse etc. including Performance Tuning and running diagnostics for optimization
- Hands-on development experience in developing database objects like PL/SQL packages, tables, stored procedures , triggers that are used for meeting the business objectives.
- Demonstrable experience using data modeling tools – e.g., Erwin, Erwin Studio, System Architect, Visio
- Experience working on cloud platforms (AWS/Azure/Google Cloud) to analyze, re-architect and re-platform on-premise data warehouses to cloud using native or 3rd party services.
- Good experience in designing & delivering data analytics solutions using Azure, AWS or GCP Cloud native services.
- Well versed with Waterfall, Agile, Scrum and similar project delivery methodologies.
- Experienced in internal as well as external stakeholder management
- Azure / AWS / GCP Cloud Data certification will be added advantage.
- Nice to have skills: Working experience with Snowflake, Databricks, Unix etc.
Advantage Zensar
We are a technology consulting and services company with 11, 500+ associates in 30+ global locations. More than 145 leading enterprises depend on our expertise to be more disruptive, agile, and competitive. We focus on conceptualizing, designing, engineering, marketing, and managing digital products and experiences for high-growth companies looking to disrupt through innovation and velocity.
Zensar Technologies is an Equal Employment Opportunity (EEO) and Affirmative Action Employer, encouraging diversity in the workplace. Please be assured that we will consider all qualified applicants fairly, regardless of race, creed, color, ancestry, religion, sex, national origin, citizen status, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteransโ status.
Zensar is a place where you are free to express yourself in an environment that values individuality, nurtures development and is mindful of wellbeing. We put our people and customers at the center of everything that we do. Our core values include:
- โฏโฏโฏโฏโฏโฏโฏโฏโฏโฏโฏโฏ Putting people first
- โฏโฏโฏโฏโฏโฏโฏโฏโฏโฏโฏโฏ Client-centricity
- โฏโฏโฏโฏโฏโฏโฏโฏโฏโฏโฏโฏ Collaboration
Grow. Own. Achieve. Learn. with Zensar: www.youtube.com/watch?v=i2NZsiQqVnU โฏโฏโฏ
Visit www.zensar.com to know more.
Ready to think velocity?
Put in details of how you want the candidate to apply. Add links to the portals, mention email ID. Can we also have links to a process guide, that we can direct the candidate to?
Primary Location
India-Maharashtra-Pune
Job Posting
Jul 1, 2022
Experience Required (In Years)
7
Submit CV To All Data Science Job Consultants Across Bharat For Free

Leave a Reply