Data Modeler / Architect - Manager - J34807

Sampoorna Computer People
  • Bangalore
  • 10-15 lakh
  • 8-10 years
  • 20 Apr 2015

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

- Architect the overall data warehouse design - conceptual, logical, and physical representations
- Work with the Business Analysts, Developers and/or functional users to perform detailed data analysis to develop the data model for the data warehouse and data marts.
- Design physical data models for multi-generation, full life cycle Data Warehouse.
- Create physical Database objects including fact tables, dimensions, staging, materialized views, indexes in accordance with logical data model provided by DW functional leads
- Partner with the Data Access, Data acquisition, Database Administration on design, administration, and support activities. Work closely with Business Analysts to understand and document business needs for decision support data.
- Identify and implement technologies for ongoing database scalability, monitoring and performance improvement.

Desired Skills and Experience
- Bare minimum of 4-8 years Database / Data Warehouse development / architecture experience and a total of 8 to 10 years in IT. Strong SQL background and BI reporting is required.
- 5+ years of hands-on ETL experience, Experience using ETL packages such as Data Integrator, working with tools like Informatica/Abinito/ Mastercraft
- 2+ year experience in BI Reporting, Creating Complex and Decision Making reports
- Provide technical leadership for establishing and maintaining solid Data Warehouse solutions.
- Be able to work with both non-technical and technical client community to accurately define data requirements
- Worked on multiple databases like Oracle, Teradata, Sybase etc
- Demonstrated ability to design and implement physical Star Schemas.
- Should have comprehensive knowledge of Database systems and Concepts
- Good understanding of data warehousing project life cycle
- Must be a team player and be able to lead and mentor junior data warehouse developers.
- Good communication and presentation skills

Job Posted By

About Organisation

Sampoorna Computer People