Job Description :
Job Title: ETL Data Analyst
Location: San Ramon, CA
Duration: Long Term
W2 Only

Strong: SQL Loader, ETL, Oracle based SQL,PL/SQl,
Banking not needed.
Essential Job Functions
Analyzes complex SQL queries, tune them for performance and identifies data related issues
Performs Root Cause Analysis on data integrity issues that deviate from documented requirement specifications
Be well-versed in Oracle database, relational data models and tools like SQL*Plus, SQL*Loader, Toad etc.
Creates High Level and Detailed specification documents utilized for data transfer across various internal applications
Prepares and complies to Test Cases, Test Plans and follow defect/issue logging process.
Works with cross functional teams to understand requirements and perform all tasks related to Operations
Analyzes and recommends business, technology and process improvement opportunities.
Generates ad-hoc reports and regular datasets or report information for end-users using system tools and database or data warehouse queries
Ability to work with and support Senior Management and be accountable for disseminating and summarizing information into a format that can facilitate high level decision making processes
Familiar with working on audit compliant data systems and external reporting
Qualifications – Internal
Education Required Education or Equivalent Experience
Bachelor’s Degree in IS, Computer Science or a related field
Master’s/Advanced Degree in IS, Computer Science or a related field
5- 7 years information technology experience
5+ Years in Technology Development & Data Analytics
Alternative: Combination of education and experience (years /description) 3 - 5 years in Technology Development & Data Analytics
Field of Experience
Ability to solve analytical and data integrity problems while prioritizing and managing multiple tasks.
Experience in building relational data structures, including relationships between tables and grouping data.
-Technical skills to manipulate and analyze data in a variety of formats (e.g. PL/SQL, SQL, Oracle, Toad, SQL*Loader, Macros, Excel)
Experienced in working with Macros either in Excel or Macro Express.
Experienced with Excel, PowerPoint, and Visio.
The ability to conduct cost/benefit analysis.
A forward thinker, always thinking of solutions outside the box.
Provides recommendations to streamline tasks and create a more efficient working environment.
Up to date with the latest technological advances.
The ability to organize and prioritize multiple projects and tasks.
Level Supervised: None
Ability to solve complex analytical and data integrity problems while prioritizing and managing multiple tasks.
Administers continuous monitoring/auditing procedures.

Client : Confidential