Data Modelling - Software Engineer

Experience :- 4-6 years

JD for Data modelling role :

- Experience working as a data modeler in business intelligence, analytics and Enterprise Data Warehousing environments

- Work with Business Analysts and potentially business customers to verify requirements

- Design/model tables to meet architectural requirements for dimensional/star schema and other modeling approaches

- Construct mapping documents involving source and destination and extract/transform/load rules for the ETL

- ETL development and reporting for BI Tools (SSAS, SSRS/Power BI, etc)

- Extensive experience developing with SQL

- Experience with Kimball (Dimensional Modeling)

- Experience in analyzing data profiling, data mining, data cleansing, data content and translating data via rules from one database to another

- Good amount of Experience with STAR Schema structures, theories, principles, and best practices, Data Governance, Data Quality Management, Metadata Management, and Conceptual and Logical Data Design.

- Strong Data Modeling skills to include data quality, source systems analysis (SQLServer, Oracle etc), business rules validation, source to target mapping design, prepare sample data example and data validation with ETL team (SCD types tables and Fact tables)

- Good to have experience with any modeling tool

- Exposure in designing for Hadoop/Spark