ETL Developer

  • location: Roseville, CA
  • type: Permanent
  • salary: $85,000 - $105,000 per year
easy apply

job description

ETL Developer

job summary:
Our client is looking for an ETL Developer for a permanent opportunity in Roseville, CA.

This person will help with designs, develops, tests, documents, and explains the CLIENT's data movement processes within the context of a team that is designing and implementing an integrated robust data warehouse. Works closely and cooperatively with business users (i.e. non-technical subject matter experts) and technical team members and vendors. Uses modern tools and standards when documenting business rules, data models and data flows. Uses strong understanding of dimensional and relational databases, including: stored procedures, constraints, normalization, indexes, and security.

 
location: Roseville, California
job type: Permanent
salary: $85,000 - 105,000 per year
work hours: 9 to 5
education: Bachelors
 
responsibilities:
Responsibilities will include and are not limited to the following:

Develops data movement processes for the data warehouse

Includes preparing and executing thorough testing

Works closely with IT and business team members in the design and implementation of the data warehouse

Analyzes data structures in existing legacy systems in order to design extract, transform and load processes and data warehouse data structures

Makes recommendations, based on data profiling and data analysis, for changes to existing/legacy systems particularly in the area of automated data validations

Uses standard data modeling, data flow, and data documentation tools to analyze, document and present data analysis work

Works cooperatively with others to resolve data and process issues

Works with non-technical, subject matter experts to understand underlying data behavior and characteristics in ways that will be new for such non-technical people

Performs all other duties assigned by supervisor

 
qualifications:
The successful candidate will possess the following:

Bachelor's Degree in Computer Science or a related field required with 6 years related data warehouse experience required and one year of ETL development experience preferred

Data modeling, data analysis, and database development experience required and extract transform and load (ETL) development experience preferred

Familiarity with business intelligence tools such as with Business Objects, Tableau, SSRS, or Cognos is desirable, but not required

Good knowledge of ETL development

Good knowledge of data warehousing

Good knowledge of database stored procedures

Familiarity with dimensional data modeling

Expert SQL skills

Good knowledge of Linux/UNIX

Knowledge of shell scripting

Clear understanding of RDBMS fundamentals

Understands data profiling and data analytics

Proficient with MS Word, MS Excel, MS PowerPoint, MS Outlook, Internet, and Visio

Possess excellent human relations and oral and written communication skills

Ability to support and work within standard software development life cycle practices

Demonstrates teamwork in facilitating workflow

High level of cooperation with others and is responsive to the CLIENT's needs

Able to put forward ideas for consideration and work toward foal irrespective of whether their ideas are adopted

Must have excellent problem solving skills, and work cooperatively and collaboratively to bring issues to successful resolution

Very detailed oriented and quality focused; able to follow clear methodologies for troubleshooting and development

Exemplary motivation, enthusiasm, professionalism, and team skills

Must be highly organized and able to work under pressure and tight deadlines

Must be willing to accept responsibility and to show good judgment, initiative, and resourcefulness

Must have "can do" attitude with a great deal of ownership and accountability

Exhibit high degree of professionalism and confidentiality in handling and having access to sensitive customer or employee information

Ability to handle constant use of tact, discretion, and good judgment

SKILLS AND CERTIFICATIONS

Informatica experience preferred

Security Clearance Required: No

Visa Candidate Considered: No

CANDIDATE DETAILS

5+ to 7 years' experience

Seniority Level - Associate

Management Experience Required - No

Minimum Education - Bachelor's Degree

Willingness to Travel - Occasionally

 
skills: This person will help with designs, develops, tests, documents, and explains the CLIENT's data movement processes within the context of a team that is designing and implementing an integrated robust data warehouse. Works closely and cooperatively with business users (i.e. non-technical subject matter experts) and technical team members and vendors. Uses modern tools and standards when documenting business rules, data models and data flows. Uses strong understanding of dimensional and relational databases, including: stored procedures, constraints, normalization, indexes, and security.


Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.

We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

easy apply

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    ETL Developer

  • location: Roseville, CA
  • job type: Permanent
  • salary: $85,000 - $105,000 per year
  • date posted: 12/4/2018

    ETL Informatica Developer

  • location: Roseville, CA
  • job type: Permanent
  • salary: $70,000 - $85,000 per year
  • date posted: 10/19/2018

    Windows Developer

  • location: Sacramento, CA
  • job type: Contract
  • date posted: 11/6/2018