Overview
Skills
Job Details
Top Skills Details
It is more of a HEAVY Data Analyst role - less developer but more integration between teams to connect the data points (more of understanding the data and transfer knowledge to data governance team) - more functional than anything
Data governance platform primarily based out of informatica
Skills for informatica - data profiling, data quality, and data lineage
Data modeling around data governance ADDED skill
Definitely good in SQL
Mainly to help boost the option of the data governance platform
Trying to gather data assets from corporate and publish in internal website
Works with various teams in corporate
Some AWS redshift
SQL server
Not responsible for pulling data but is the in between the two teams
Get all data and meta data into the data governance platform so that data set is exposed to the platform
Communication is KEY (run point like data analyst kind of role)
50% of hands on with SQL tuning and performace optimization
- Not expecting them to develop code on database level but as long as they can query the table and how it is structured they will then send to the data governance team
5-7 years of experience working in Oracle and DB2 Databases.
Proven work experience as a Database developer.
In-depth understanding of data management (e.g. data discovery, data analysis, transformation, data quality, security and monitoring).
SQL Tuning techniques to prevent performance degradation and understanding on how to use Explain Plan/Query Analyzer/Optimization Tool is required.
Knowledge of software development and Agile delivery methodology.
Proficiency in working with specific database like DB2, Oracle & SQL server.
Working knowledge of ETL processes and tools (i.e., Informatica for data extraction, transformation, and loading from various sources into existing databases)
Excellent analytical and organizational skills.
Understanding the needs of front-end users and having a problem-solving mindset.
Excellent verbal and written communication skills.
Top Skills Details
It is more of a HEAVY Data Analyst role - less developer but more integration between teams to connect the data points (more of understanding the data and transfer knowledge to data governance team) - more functional than anything
Data governance platform primarily based out of informatica
Skills for informatica - data profiling, data quality, and data lineage
Data modeling around data governance ADDED skill
Definitely good in SQL
Mainly to help boost the option of the data governance platform
Trying to gather data assets from corporate and publish in internal website
Works with various teams in corporate
Some AWS redshift
SQL server
Not responsible for pulling data but is the in between the two teams
Get all data and meta data into the data governance platform so that data set is exposed to the platform
Communication is KEY (run point like data analyst kind of role)
50% of hands on with SQL tuning and performace optimization
- Not expecting them to develop code on database level but as long as they can query the table and how it is structured they will then send to the data governance team
5-7 years of experience working in Oracle and DB2 Databases.
Proven work experience as a Database developer.
In-depth understanding of data management (e.g. data discovery, data analysis, transformation, data quality, security and monitoring).
SQL Tuning techniques to prevent performance degradation and understanding on how to use Explain Plan/Query Analyzer/Optimization Tool is required.
Knowledge of software development and Agile delivery methodology.
Proficiency in working with specific database like DB2, Oracle & SQL server.
Working knowledge of ETL processes and tools (i.e., Informatica for data extraction, transformation, and loading from various sources into existing databases)
Excellent analytical and organizational skills.
Understanding the needs of front-end users and having a problem-solving mindset.
Excellent verbal and written communication skills.