ETL Developer

---

Job description

job summary:

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.

Supervisory Responsibility: NA

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
• RDBMS experience; Oracle PL/SQL & SQL Server.
• 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

location: Minneapolis, Minnesota

job type: Contract

salary: $47.25 - 59.06 per hour

work hours: 8am to 5pm

education: No Degree Required

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 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.

qualifications:

• Experience level: Experienced
• Minimum 5 years of experience
• Education: No Degree Required

skills:

• ETL
• Data Warehouse
• SQL
• Snowflake
• Databricks
• Informatica PowerCenter
• RDBMS

For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.

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.

- provided by Dice