With ITC Infotech India Ltd in Bengaluru - INMore jobs from ITC Infotech India Ltd
Posted on January 06, 2020
About this job
Job type: Full-time
Role: System Administrator
nosql, sysadmin, sql
Total 12-15 years of IT experience and minimum 6 years of Data modeler/architect experience
Thorough experience and understanding in Navitaire Data model, entities, attributes ( mandatory )
Good understanding of other GDS data models like Amadeus, Radixx etc
Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).
Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC.
Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks
Hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required.
Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required.
Experience in team management, communication, and presentation.
Examine and identify database structural necessities by evaluating client operations, applications, and programming.
Assess database implementation procedures to ensure they comply with internal and external regulations.
Install and organize information systems to guarantee company functionality.
Prepare accurate database design and architecture reports for management and executive teams.
Oversee the migration of data from legacy systems to new solutions
Monitor the system performance by performing regular tests, troubleshooting and integrating new features.
Recommend solutions to improve new and existing database systems.