Certified Woman & Minority Owned

Data Warehouse Developer


Reference Number: BTWIDW022

Data Warehouse Developer
experience  Not Disclosed
location  Madison, WI
duration  12 Months
salary  Not Disclosed
jobtype  Not Disclosed
Industry  Government - State
duration  $58.2/hour - $63.2/hour
Job Description

90-100% remote but can require staff to come onsite as necessary with sufficient notice. Onsite work is not likely, but candidate should be prepared to come onsite if required.


Job Description:

The client is looking for Data Warehouse Developer III

Project details: This role is responsible for designing, developing, testing, and implementing ETL solutions using Informatica Data Management Cloud (IDMC). This role requires strong hands-on experience with Data Integration (DI), Taskflows, Mappings, parameter files, and reusable transformations to build scalable, secure, and high-performing data pipelines. The candidate will manage metadata, ensure data accuracy and integrity, and drive continuous optimization within the IDMC and data warehouse environment.

The recruitment is being used to fill one (1) Data Warehouse Developer III position within the client


The candidate will be responsible for ETL design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. Understand user requirements, and implement solutions that ensure requirements can be achieved through high quality deliverables. Develop ETL mapping specifications for loading information into the data warehouse and for ensuring reliability of information loaded. Seek continuous improvement in performance & tuning of data warehouse and ensure security of data. Monitor technological advancements to ensure that solutions are continuously improved, supported, and aligned with industry and company standards.
Conducts highly complex work critical to the organization. Works with other IT technical teams and Business users to understand requirements and recommend/ implement solutions. Works with moderate supervision with latitude for independent judgment. Assist less experienced peers by providing technical guidance. Requires advanced skill sets and developing proficiency within discipline. Typically requires 6 - 9 years' experience or equivalent education.

Ideal candidate will have additional skills and experience in the following areas:

Demonstrated skills in establishing data warehouse best practice standards

Strong skills working with relational and dimensional data models

Strong skills working with slowly changing dimensions

Strong data management and data analysis using SQL

Strong verbal and written communication skills, including facilitation of meetings with customers and technical staff

Demonstrated knowledge and skills in requirements gathering

Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team

Skills in navigating a large organization in order to accomplish results

Ability to initiate and follow through on complex projects of both short and long term duration

Excellent organizational and time management skills.

Excellent analytical and problem solving skills

Ability to work independently, assume responsibility for job development and training, researching and resolving questions and problems, requesting supervisor input and keeping supervisor informed

Ability to complete projects of substantial depth and complexity, and work with customers at many levels in the organization

Design, develop, and maintain relational databases for data storage and data mining. Perform data warehouse design and testing, including data design, database architecture, metadata, and repository creation. Develop processes and procedures for entering information into data warehousing systems and for ensuring reliability of information entered. Seek continuous improvement in performance of data warehouse and ensure security of data. Career-Level position within field. Requires experience and proficiency in discipline. Conducts complex work important to the organization. Works with minimal supervision with wide latitude for independent judgment. Typically requires six to nine years’ experience or equivalent education.



Qualification - Experience
Problem resolution (development and implementation) - 7 Yrs.
Respond to customer requests (verbally and in writing) - 7 Yrs.
Ability to be self-directed - 7 Yrs.
Able to work independently - 7 Yrs.
Analytical/problem solving skills - 7 Yrs.
Experience in technical writing and documentation - 7 Yrs.
Excellent oral and written communication skills - 7 Yrs.
Expertise in implementation of large complicated models and processes - 5+ Yrs.
Excellent organization, analytical and communication skills - 5 of 5
Data analysis - 7 Yrs.
Data Warehouse - Experience in data warehouse design and development - 7 Yrs.
Data Warehouse - Experience in requirements gathering for data warehouse - 7 Yrs.
Data Warehouse - Performance tuning - 7 Yrs.
DB2 - 3 Yrs.
Experience in extract, transform, and load coding using Informatica - 7 Yrs.
Knowledge of Oracle PL/SQL - 7 Yrs.
Ability to navigate and query a relational database (Oracle) to both develop reports - 7+ Yrs.
Develop design specifications - 7 Yrs.
Knowledge of Kimball data warehouse design principals - 5+ Yrs.
Conduct unit and system tests - 7 Yrs.
Develop Test Plans, Test Cases, and Test Procedures - 7 Yrs.
Identify defects - 7 Yrs.
Interpret test results - 7 Yrs.
Business Objects or other BI tools - 5+ years
Demonstrated experience in the design and utilization of performance measures and reports - 2+ Yrs.
Client privacy Regulations - Yes

Top Skills:

Expert level experience using Informatica

Excellent skills in the architecture of data warehouse and data integration strategies and solutions

Expert level skills in data warehouse design and development


Notes:
90-100% remote but can require staff to come onsite as necessary with sufficient notice. Onsite work is not likely, but candidate should be prepared to come onsite if required.


VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status

Apply for this Job





(Please ensure email matches your resume email)



(document types allowed: doc/docx/rtf/pdf/txt) (max 20MB)

By submitting this form, you are consenting to the VIVA team contacting you via Phone/Email

Related Jobs

Join VIVA and grow

VIVA is faster, easier and you still have complete control