Oracle Data Analyst (Exadata)
6+ month contract
Downtown Dallas, TX (Onsite Day 1)
Overall 14+ years of experience candidates, Locals will be given first preference
LinkedIn must be created before 2018.
Must have worked on Exadata, OLTP, Data Warehouse, MDM, ODS, Data replication, Data Management.
Primary responsibilities of the Senior Oracle Data Analyst (Exadata) include supporting and analyzing data anomalies for multiple environments including but not limited to Data Warehouse, ODS, Data Replication/ETL Data Management initiatives. The candidate will be in a supporting role and will work closely with the Business, DBA, ETL and Data Management team providing analysis and support for complex Data related initiatives. This individual will also be responsible for assisting in initial setup and on-going documentation/configuration related to Data Governance and Master Data Management solutions. This candidate must have a passion for data, along with good SQL, analytical and communication skills.
Responsibilities:
Investigate and Analyze data anomalies and data issues reported by Business
Work with ETL, Replication and DBA teams to determine data transformations, data movement and derivations and document accordingly
Work with support teams to ensure consistent and proactive support methodologies are adhered to for all aspects of data movements and data transformations
Assist in break fix and production validation as it relates to data derivations, replication and structures
Assist in configuration and on-going setup of Data Virtualization and Master Data Management tools
Assist in keeping documentation up to date as it relates to Data Standardization definitions, Data Dictionary and Data Lineage
Gather information from various Sources and interpret Patterns and Trends
Ability to work in a team-oriented, fast-paced agile environment managing multiple
priorities
Qualifications
4+ years of experience working in OLTP, Data Warehouse and Big Data databases
4+ years of experience working with Oracle Exadata
4+ years in a Data Analyst role
2+ years writing medium to complex stored procedures a plus
Ability to collaborate effectively and work as part of a team
Extensive background in writing complex queries
Extensive working knowledge of all aspects of Data Movement and Processing, including ETL, API, OLAP and best practices for data tracking
Denodo Experience a plus
Master Data Management a plus
Big Data Experience a plus (Hadoop, MongoDB)
Postgres and Cloud Experience a plus