Datamart developer – 4 to 10 years – Pune
Hands on experience designing, developing and implementing large scale data warehousing
Strong in dimensional modeling, design and implementation of star schema modeling.
Responsible for ETL/BI Reports development in a data warehouse environment performing design, development, testing, documentation and data analysis.
Develop BI reports dealing with predictive results from analytical trending and data modeling.
Support the analysis, design, development and implementation of new reporting requirements.
Develop detailed data mapping and end-to-end process flows
Develop and maintain ETL jobs for data warehouses/marts
Design ETL via source-to-target mapping and design documents that consider security, performance tuning and best practices
Document technical specifications, data models, process flows, etc.
Strong SQL knowledge with hands on experience, ability to run analysis and complex SQLs against large sets of data is a must.
Experience in Reporting & Dashboards ( aggregation logic, business rules etc.)
Knowledge of Data Quality Processes, Management, and Measurement
Good database design and modeling knowledge, deep understanding of data integrity and normalization.
Knowledge of data, reporting and analytic functions within a financial services organization