Find Jobs
ETL Developer
Minneapolis, Minnesota  |  Remote, Onsite
Contract to Hire Position
It appears that you have already applied to this job.
Applied on November 30, 2021
Job Id #52313 Posted November 23, 2021


Description:

  • The ETL Developer - Intermediate is responsible for supporting the information management architecture of the Data Warehouse.
  • This role is responsible for extracting, transforming and loading data into data staging, and the data warehouse.
  • This role will work closely with the data architect, data modeler, data analysts and other project team members to understand requirements regarding ETL design flows and data integration.
  • They will collaborate on definition, development, and maintenance of standards and processes.
  • The ETL Developer will develop ETL solutions following the well-defined data warehouse design and development best practices.

Experience:

  • Snowflake or Databricks experience.

Top Requirements:

  • Experience any ETL tool
  • Data Warehouse
  • Good SQL background

Essential Functions/Responsibilities:

  • Develop efficient and high performing ETL solutions using any ETL tools (SSIS, Informatica, DataStage, DataBricks..).
  • Design, develop, test and performance tune complex mappings, transforms, aggregations, joins, enrichment, validations for target data underpinnings.
  • Participate in design review sessions and peer ETL reviews.
  • Assess and profile source and target data (data structure, quality, completeness, schema, nulls, etc.) and requested business use cases.
  • Summarizes testing and validation results and is able to communicate and make recommendations/decisions on the best course of action to remediate.
  • Resourceful at coming up with solutions using existing or available resources based on knowledge of the organization and level of execution effort.
  • Participate in agile work environment, attending daily scrum meetings and completing sprint deliverables on time.
  • Supports practices, policies and operating procedures and ensures alignment to departmental objectives and strategy.
  • Teammate is able to make the complex seem less complex, is a consensus builder and brings people and teams together.?
  • Is able to calm tense situations by bringing clarity and organization to the forefront.?
  • Ensures each level of the organization has the information needed and the context needed to produce favorable results.
  • Builds strong relationship with IT operational leaders to ensure connectivity to the business.
  • Supports a work environment in which people are able to perform to the best of their abilities.? Holds self accountable for technical abilities, productive results and leadership attributes.

Job Scope:

  • Job involves a high degree of complexity and multitasking.
  • Incumbent collaborates with team of professionals and is responsible for ensuring high level of quality work by applying team best practices and standards.
  • Duties are performed semi-independently with general management oversight.
  • Decisions are made within established departmental guidelines, Errors in judgment or work performance could result in insufficient operation for the organization.
  • Must be able to remain in a stationary position at least 50% of the time.
  • Must have the ability to work 100% of the time in an indoor office setting.
  • The person in this role will occasionally move about inside the office to attend meetings, access office machinery, etc.
  • Constantly uses a computer and other office productivity machinery.

Specific Job Skills and Experience:

  • 5+ years experience in designing and developing ETL solutions.
  • 5+ years experience using Informatica PowerCenter.
  • 3+ years working knowledge in a Data Warehouse/BI environment.
  • 3+ years experience using Microsoft TSQL, SSIS, and SSAS
  • Strong RDBMS experience; Oracle PL/SQL & SQL Server.
  • Strong SQL skills including complex SQL constructs, DDL generation.
  • Windows batch PowerShell scripting and/or UNIX shell scripting experience.
  • Experience with Atlassian JIRA & Confluence preferred.
  • Demonstrated excellent organizational, analytical, writing, problem solving and interpersonal skills.

Education:

  • Bachelor’s degree in Computer Science, Information Management or similar required.

Job Conditions:

  • Job requires hours that may exceed 8 hours per day and/or 40 hours per week during times of peak activity.
  • Moderate to high job pressure exists in the balancing of several projects with conflicting and sometimes changing deadlines.
  • Less than 5% travel required

Horizontal is proud to be an Equal Opportunity and Affirmative Action Employer. We seek to provide employment opportunities to talented, qualified candidates regardless of race, color, sex/gender including gender identity and/or expression, national origin, religion, sexual orientation, disability, marital status, citizen status, veteran status, or any other protected classification under federal, state or local law.

In addition, Horizontal will provide reasonable accommodations for qualified individuals with disabilities. If you need to request a reasonable accommodation in order to complete the application or interview process, please contact hr@horizontal.com.

All applicants applying must be legally authorized to work in the country of employment.

EQUAL OPPORTUNITY EMPLOYMENT SURVEY

What is your gender?

What is your ethnicity?

What is your Veteran / U.S. Military Status?

Do you identify with one or more of the classifications of protected veterans below?

If yes, please indicate by checking the appropriate box below

Do you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Horizontal is proud to be an Equal Employment Opportunity/Affirmative Action Employer providing a drug-free workplace.

Success!

You have saved your first job! To see all your Saved Jobs, click here. Or continue scrolling through jobs and bookmark openings that catch your eye and apply for those jobs later.

Return to Job Search
Close

We’re sorry!

There are currently no open positions in your location or accepting applications from out of the country

Return to Home
Close
X
Cookies help us improve your website experience.
By using our website, you agree to our use of cookies.
Confirm