Designation : Associate Lead Architect
10 years’ hands-on experience creating and maintaining Relational and Dimensional data models; Experience using IDA - Infosphere Data Architect / Erwin Data Modeler / Embarcadero ER / Studio / Sybase Power Designer software tools.
Experience with Logical and Physical database design and development, data conversion, normalization, data modeling (with IDA or like products);
Data Consolidation, and associated documentation including diagrams, data dictionary, source to target mappings. Perform reverse engineering of physical data models from databases and SQL scripts.
Evaluate data models and physical databases for variances and discrepancies.
Background in implementing and using naming standards to apply consistency to models; Experience in collecting and managing Metadata in Metadata Repositories;
Develop conceptual subject area data models and data flow diagrams. Maintain metadata definitions for sourcing data stores and all evolutions of the Data Lake from ingested sources to consumers.
Experience with and strong understanding of Data Warehousing and Big Data Hadoop ecosystems. Experience working with large amounts of complex data in order to identify issues, patterns, trends, irregularities, etc
Architect, design, and Conceptual, Logical, and Physical models - In sourcing systems, data lakes, data warehouses, and data marts supporting the Big Data Hadoop ecosystem supported solutions.