Senior Oracle Analyst
Full Time
No Travel Required
Able to Sponsor
Hybrid
$85 - $90/hr
CTC USA, LLC
Fitment
Dice Job Match Score™
⏳ Almost there, hang tight...
Job Details
Skills
- SQL
- Oracle Exadata
- Stored Procedures
- PostgreSQL
- Trigger
- Cursor
- Denodo
- ODS
- OLAP
- OLTP
Summary
****Local to Texas candidates are applicable****
****Minimum 15+ years in IT is required*****
Primary responsibilities of the Senior Data Analyst 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 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.
- 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 pro-active 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:
- 15+ years of SQL experience working in OLTP, Data Warehouse and Big Data databases
- 4+ years of experience working with Exadata and SQL Server databases
- 4+ years in a Data Analyst role
- Strong attention to Detail
- 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
- Good Communication skills
- Self-Motivated
- Works well in a team environment
- Denodo Experience a plus
- Master Data Management a plus
- Big Data Experience a plus (Hadoop, MongoDB)
- Postgres and Cloud Experience a plus
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 10107640
- Position Id: 9014660
- Posted 1 day ago
Company Info
About CTC USA, LLC
CTC is a global IT services and consulting company dedicated to helping organizations innovate, optimize, and grow. With nearly three decades of experience and a team of over 2,000 professionals worldwide, CTC delivers end-to-end solutions across areas like AI and machine learning, cybersecurity, enterprise applications, and digital transformation. The company partners with organizations to solve complex business challenges, streamline operations, and drive measurable results, supported by a strong global presence and long-standing client relationships.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs