Send me more jobs like this

Sr Data Warehouse Data Modeler

Keywords / Skills : Bteq, data modeling, teradata, bi, TPump, data structures, data mapping, erwin, etl, data integration

7 - 12 years
Posted: 2019-11-14

Industry
Recruitment/Staffing/RPO
Function
IT
Role
Datawarehousing Consultants
Posted On
14th Nov 2019
Job Ref code
131119006567
Job Description
This position is to establish and maintain Enterprise Data Model that describes how data is processed, stored, and utilized. Manage the data structures required to support the enterprise through the BI/Analytics program. Provide the means of system integration by understanding the source and target data and build the data mapping. Determine architectural approaches for data environments and help ensure that the data needs of the enterprise are being met. Responsible for developing and maintaining a formal description of the data and data structures - this can include data definitions / dictionary and data models. In addition, this position requires good understanding of the ETL/ELT development and architectural principles of data integration and data warehousing.
Required Candidate profile
Position Summary
This position is to establish and maintain Enterprise Data Model that describes how data is processed, stored, and utilized. Manage the data structures required to support the enterprise through the BI/Analytics program. Provide the means of system integration by understanding the source and target data and build the data mapping. Determine architectural approaches for data environments and help ensure that the data needs of the enterprise are being met. Responsible for developing and maintaining a formal description of the data and data structures - this can include data definitions / dictionary and data models. In addition, this position requires good understanding of the ETL/ELT development and architectural principles of data integration and data warehousing

Job Requirements:
  • Work with the Development / BI team to implement data strategies, build data flows and develop conceptual, logical and physical data models using best practices and company standards to ensure high data quality and reduced redundancy.
  • Maintain conceptual, logical and physical data models/ETL mappings along with corresponding metadata for new and existing projects.
  • Perform reverse engineering of physical data models from databases and SQL scripts.
  • Demonstrable experience using data modeling tool Erwin / Erwin model mart and its related tools.
  • Hands-on experience with relational and dimensional modeling practices preferably on Retail domain.
  • Evaluate data models and physical database for variances and discrepancies

Full life cycle experience in Data Integration, Data Warehousing, and Master Data Management.
Works with on/off shore teams to ensure 'best practice' standards and process.
Excellent in providing Solutions for data driven applications involving large and complex data and providing reconciliation and test cases.
Qualifications:
  • 7+ years of overall IT experience.
  • 3+ years in a direct role as a data modeler in data warehousing environment with ERWIN tool.
  • 2+ designer and/or ELT with Teradata.
  • 5+ years of Data Warehousing experience.
  • Should have very good experience in Teradata stored procedures, macros, and functions.
  • Should be very strong in writing SQL, code reviews, and performance tuning techniques.
  • Knowledge of Unix and understanding shell scripts is required.
  • Good understanding on Teradata architecture and its utilities like Fast Load, Multi Load, Fast Export, TPump and BTEQ.
  • Broad and Deep Data Warehousing and Data Integration exposure.
  • Strong conceptual and analytical skills: SQL, Problem Solving, Performance tuning, Test case analysis.
  • Solid understanding of data modeling and design considerations for analytical systems.
  • Good to have - understanding on Cloud technologies.


About Company

IDC Technologies Solutions India Private Limited
Similar Jobs
View All Similar Jobs
Walkin for you