Database Integrator ICT Professionals
SaveWhat Does a {{ profession.preferred_title|title }} Do?
Database integrators perform integration among different databases. They maintain integration and ensure interoperability.
Resource recommendations may include affiliate links. Learn more
Where Do I Start?
Ict Debugging Tools
The ICT tools used to test and debug programs and software code, such as GNU Debugger (GDB), Intel Debugger (IDB), Microsoft Visual Studio Debugger, Valgrind and WinDbg.
Sign up to trackReady to go deeper? Pick up to 3 skills to focus on from the list below.
These are common skills for this role. Real-world experience matters more than ticking every box — use this as a guide, not a checklist.
Skills You Need to Become a Database Integrator
Essential Skills
Essential Skills
-
EssentialIct Debugging Tools knowledge
The ICT tools used to test and debug programs and software code, such as GNU Debugger (GDB), Intel Debugger (IDB), Microsoft Visual Studio Debugger, Valgrind and WinDbg.
No book recommendations available yet.
-
EssentialInformation Structure knowledge
The type of infrastructure which defines the format of data: semi-structured, unstructured and structured.
No book recommendations available yet.
-
EssentialDatabase Management Systems knowledge
The tools for creating, updating and managing databases, such as Oracle, MySQL and Microsoft SQL Server.
No book recommendations available yet.
-
EssentialQuery Languages knowledge
The field of standardised computer languages for retrieval of information from a database and of documents containing the needed information.
No book recommendations available yet.
-
EssentialResource Description Framework Query Language knowledge
The query languages such as SPARQL which are used to retrieve and manipulate data stored in Resource Description Framework format (RDF).
No book recommendations available yet.
-
EssentialData Extraction, Transformation And Loading Tools knowledge
The tools for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure.
No book recommendations available yet.
-
EssentialManage Data skill
Administer all types of data resources through their lifecycle by performing data profiling, parsing, standardisation, identity resolution, cleansing, enhancement and auditing. Ensure the data is fit for purpose, using specialised …
Course recommendations coming soon.
-
EssentialBalance Database Resources skill
Stabilise the workload and resources of a database, by controlling the demand of transactions, allocating disk spaces and ensuring reliability of the servers in order to optimise cost and risk …
Course recommendations coming soon.
-
EssentialCreate Database Diagrams skill
Develop the database design models and diagrams which establish the structure of a database by using modelling software tools to be implemented in further processes.
Course recommendations coming soon.
-
EssentialExecute Integration Testing skill
Perform testing of system or software components grouped in multiple ways to evaluate their ability to interconnect, their interface and their ability to provide global functionality.
Course recommendations coming soon.
-
EssentialImplement Data Warehousing Techniques skill
Apply models and tools such as online analytical processing (OLAP) and Online transaction processing (OLTP), to integrate structured or unstructured data from sources, in order to create a central depository …
Course recommendations coming soon.
-
EssentialIntegrate Ict Data skill
Combine data from sources to provide unified view of the set of these data.
Course recommendations coming soon.
-
EssentialManage Ict Legacy Implication skill
Oversee the transfer process from a legacy (an outdated system) to a current system by mapping, interfacing, migrating, documenting and transforming data.
Course recommendations coming soon.
-
EssentialPerform Data Cleansing skill
Detect and correct corrupt records from data sets, ensure that the data become and remain structured according to guidelines.
Course recommendations coming soon.
-
EssentialUse Interface Description Language skill
Utilise specification language, such as CORBA and WSDL, for describing interface connection among software components or programs in a programming-language-independent way.
Course recommendations coming soon.
-
EssentialVerify Formal Ict Specifications skill
Check capabilities, correctness and efficiency of intended algorithm or system to match certain formal specifications.
Course recommendations coming soon.
Optional Skills (5 of {{ profession.optional_skills|length }} displayed)
-
OptionalBusiness Intelligence knowledge
The tools used to transform large amounts of raw data into relevant and helpful business information.
Recommended Books
1 book{{ skill.books|length|pluralize }} -
OptionalLdap knowledge
The computer language LDAP is a query language for retrieval of information from a database and of documents containing the needed information.
No book recommendations available yet.
-
OptionalLinq knowledge
The computer language LINQ is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Microsoft.
No book recommendations available yet.
-
OptionalN1ql knowledge
The computer language N1QL is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Couchbase.
No book recommendations available yet.
-
OptionalSparql knowledge
The computer language SPARQL is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the international standards organisation …
No book recommendations available yet.
-
OptionalXquery knowledge
The computer language XQuery is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the international standards organisation …
No book recommendations available yet.
-
OptionalMicrosoft Access knowledge
The computer program Access is a tool for creating, updating and managing databases, developed by the software company Microsoft.
Recommended Books
3 book{{ skill.books|length|pluralize }} -
OptionalPostgresql knowledge
The computer program PostgreSQL is a free and open-source software tool for creating, updating and managing databases, developed by the PostgreSQL Global Development Group.
Recommended Books
2 book{{ skill.books|length|pluralize }}Introduction to PostgreSQL for the Data Professional. -
OptionalMysql knowledge
The computer program MySQL is a tool for creating, updating and managing databases, currently developed by the software company Oracle.
Recommended Books
2 book{{ skill.books|length|pluralize }} -
OptionalOracle Data Integrator knowledge
The computer program Oracle Data Integrator is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by …
Recommended Books
1 book{{ skill.books|length|pluralize }} -
OptionalOracle Warehouse Builder knowledge
The computer program Oracle Warehouse Builder is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by …
Recommended Books
1 book{{ skill.books|length|pluralize }}Oracle Warehouse Builder 11g R2 Complete Self-Assessment Guide -
OptionalDb2 knowledge
The computer program IBM DB2 is a tool for creating, updating and managing databases, developed by the software company IBM.
No book recommendations available yet.
-
OptionalIbm Infosphere Information Server knowledge
The software program IBM InfoSphere Information Server is a platform for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed …
No book recommendations available yet.
-
OptionalInformatica Powercenter knowledge
The computer program Informatica PowerCenter is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by the …
No book recommendations available yet.
-
OptionalObjectstore knowledge
The computer program ObjectStore is a tool for creating, updating and managing databases, developed by the software company Object Design, Incorporated.
No book recommendations available yet.
-
OptionalOpenedge Database knowledge
The computer program OpenEdge Database is a tool for creating, updating and managing databases, developed by the software company Progress Software Corporation.
No book recommendations available yet.
-
OptionalOracle Relational Database knowledge
The computer program Oracle Rdb is a tool for creating, updating and managing databases, developed by the software company Oracle.
No book recommendations available yet.
-
OptionalPentaho Data Integration knowledge
The computer program Pentaho Data Integration is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by …
No book recommendations available yet.
-
OptionalQlikview Expressor knowledge
The computer program QlikView Expressor is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by the …
No book recommendations available yet.
-
OptionalSap Data Services knowledge
The computer program SAP Data Services is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by …
No book recommendations available yet.
-
OptionalSystems Development Life-Cycle knowledge
The sequence of steps, such as planning, creating, testing and deploying and the models for the development and life-cycle management of a system.
No book recommendations available yet.
-
OptionalTeradata Database knowledge
The computer program Teradata Database is a tool for creating, updating and managing databases, developed by the software company Teradata Corporation.
No book recommendations available yet.
-
OptionalDatabase knowledge
The classification of databases, that includes their purpose, characteristics, terminology, models and use such as XML databases, document-oriented databases and full text databases.
No book recommendations available yet.
-
OptionalFilemaker (Database Management Systems) knowledge
The computer program FileMaker is a tool for creating, updating and managing databases, developed by the software company FileMaker Inc.
No book recommendations available yet.
-
OptionalIbm Informix knowledge
The computer program IBM Informix is a tool for creating, updating and managing databases, developed by the software company IBM.
No book recommendations available yet.
-
OptionalIbm Infosphere Datastage knowledge
The computer program IBM InfoSphere DataStage is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by …
No book recommendations available yet.
-
OptionalMdx knowledge
The computer language MDX is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Microsoft.
No book recommendations available yet.
-
OptionalSql Server knowledge
The computer program SQL Server is a tool for creating, updating and managing databases, developed by the software company Microsoft.
No book recommendations available yet.
-
OptionalSql Server Integration Services knowledge
The computer program SQL Server Integration Services is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed …
No book recommendations available yet.
-
OptionalSystems Theory knowledge
The principles that can be applied to all types of systems at all hierarchical levels, which describe the system's internal organisation, its mechanisms of maintaining identity and stability and achieving …
No book recommendations available yet.
-
OptionalCa Datacom/Db knowledge
The computer program CA Datacom/DB is a tool for creating, updating and managing databases, currently developed by the software company CA Technologies.
No book recommendations available yet.
-
OptionalCreate Solutions To Problems skill
Solve problems which arise in planning, prioritising, organising, directing/facilitating action and evaluating performance. Use systematic processes of collecting, analysing, and synthesising information to evaluate current practice and generate new understandings …
Course recommendations coming soon.
-
OptionalDefine Data Quality Criteria skill
Course recommendations coming soon.
-
OptionalExecute Ict Audits skill
Organise and execute audits in order to evaluate ICT systems, compliance of components of systems, information processing systems and information security. Identify and collect potential critical issues and recommend solutions …
Course recommendations coming soon.
-
OptionalPerform Data Mining skill
Explore large datasets to reveal patterns using statistics, database systems or artificial intelligence and present the information in a comprehensible way.
Course recommendations coming soon.
-
OptionalPerform Project Management skill
Manage and plan various resources, such as human resources, budget, deadline, results, and quality necessary for a specific project, and monitor the project's progress in order to achieve a specific …
Course recommendations coming soon.
-
OptionalUse Scripting Programming skill
Utilise specialised ICT tools to create computer code that is interpreted by the corresponding run-time environments in order to extend applications and automate common computer operations. Use programming languages which …
Course recommendations coming soon.
-
OptionalApply Ict Systems Theory skill
Implement principles of ICT systems theory in order to explain and document system characteristics that can be applied universally to other systems
Course recommendations coming soon.
-
OptionalDefine Integration Strategy skill
Specify strategies for system integration, incorporating the time schedule, the processes required to combine components into subsystems and systems, the means on how components will interface as well as the …
Course recommendations coming soon.
-
OptionalDesign Application Interfaces skill
Create and program application interfaces, their operations, inputs and outputs and underlying types.
Course recommendations coming soon.
-
OptionalManage Ict Semantic Integration skill
Oversee integration of public or internal databases and other data, by using semantic technologies to produce structured semantic output.
Course recommendations coming soon.
-
OptionalWrite Database Documentation skill
Develop documentation containing information about the database that is relevant to end users.
Course recommendations coming soon.