Talent.com
W2 - Data Warehouse Developer III (Performance tuning, Informatica, Oracle, DA, SQL) - Remote in WI
W2 - Data Warehouse Developer III (Performance tuning, Informatica, Oracle, DA, SQL) - Remote in WITanson Corp • Madison, WI, United States
W2 - Data Warehouse Developer III (Performance tuning, Informatica, Oracle, DA, SQL) - Remote in WI

W2 - Data Warehouse Developer III (Performance tuning, Informatica, Oracle, DA, SQL) - Remote in WI

Tanson Corp • Madison, WI, United States
4 days ago
Job type
  • Full-time
  • Remote
  • Quick Apply
Job description

Description :

WISCONSIN ONLY POSTING :

POSTING IS FOR WISCONSIN BASED CANDIDATES ONLY (OR THOSE WILLING TO RELOCATE TO WISCONSIN WITHIN 30 DAYS OF THE START DATE). Candidates that are NOT located IN WISCONSIN or NOT willing TO RELOCATE within that timeframe will NOT be considered and should not be submitted. ALL WORK MUST BE DONE IN WISCONSIN

The client is looking for One (1) Data Warehouse Developer III

Will close to submissions on 2 / 19 / 2026 at 4 : 00PM CST.

Top Skills :

Moderate experience in data warehousing process design and development (4+ years)

Data warehouse - performance tuning using the Informatica data warehousing tool suite (4+ years)

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

Knowledge in relational database technologies, e.g. Oracle, DB2, SQL Server (3+ years)

Strong data management and data analysis using SQL (4+ years)

INTERVIEW NOTES : PLEASE NOTE : A real-time screenshot photo of the candidate MUST be uploaded to candidate's bid upon confirming the interview. Please see "DCF Realtime Photo Requirement & Instructions" document in the Attachments section of this posting for details.

Interviews will be set up shortly after the posting close date.

MUST provide three (3) business references for the interview. (One reference must be a supervisory level.)

IMPORTANT NOTES :

Candidate MUST be physically located in the United States. International candidates / phone numbers will not be accepted.

Candidate must follow ALL DCF work rules

Candidate must be available to perform all work during the Central Standard Time (CST) business hours 9 : 00 am 3 pm (or CST hours as defined by the hiring manager)

Candidate will be required to provide their own equipment for this position (See job description for required specifications.)

Interview process : via Zoom / Teams

Duration : 6 / 30 / 2026, with the potential to extend for an additional term(s)

Candidate MUST be a WI resident or willing to relocate to WI prior to starting the role at their own expense. Local candidates preferred. This position is currently remote . However, position status is subject to change. (95% remote 5% onsite as needed) Onsite work is not likely, but candidate should be prepared to come onsite if required.

Project details : The candidate will be responsible for assisting in ETL design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. Works with other IT technical teams and Business users to understand requirements and recommend & implement solutions. Closely supervised with some latitude for independent judgment.

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. Works with other IT technical teams and Business users to understand requirements and recommend & implement solutions. Closely supervised with some latitude for independent judgment. Typically requires at least 4 to 5 years of experience or equivalent education.

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

  • Knowledge in data warehouse best practice standards
  • Experience with IDMC (Informatica Intelligent Data Management Cloud)
  • Moderate skills working with relational and dimensional data models
  • Moderate skills working with slowly changing dimensions
  • Strong verbal and written communication skills, including facilitation of meetings with customers and technical staff
  • Knowledge and skills in the project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support)
  • 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
  • Proficiency with MS Office suite, MS Visio, and MS Outlook
  • Experience programming mainframe applications using technologies such as COBOL and
  • DB2 databases to implement maintenance and enhance mainframe functionality

List any special qualifications & years of experience :

  • Expertise in implementation of large, complicated models and processes - 2 years
  • Experience in technical writing and documentation - 3 years
  • Develop design specifications - 3+ years
  • Excellent organization, analytical and communication skills - 3+ years
  • Data analysis - 4+ years
  • Data Warehouse experience in data warehouse design and development - 4+ years
  • Data Warehouse - Experience in requirements gathering for data warehouse - 4+ years
  • Data Warehouse - Performance tuning - 4+ years
  • Informatica PowerCenter - 4+ years
  • IDMC (Informatica Intelligent Data Management Cloud) - 2+ years
  • DB2 - 2 years
  • Knowledge of Kimball data warehouse design principals - 2+ years
  • Ability to navigate and query a relational database (Oracle) to develop reports - 3+ years
  • Respond to customer requests (verbally and in writing) - 3+ years
  • Develop Test Plans, Test Cases, and Test Procedures - 3+ years
  • Identify defects - 3+ years
  • Ability to develop and implement quality assurance processes and procedures including test / use cases - 3+ years
  • In-depth knowledge of system development life cycle deliverables for each phase of development - 3+ years
  • Excellent oral and written communication skills - 5+ years
  • Demonstrated experience in the design and utilization of performance measures and reports (nice to have) - 2+ years
  • Business Objects or other BI tools (nice to have) - 3+ years
  • Dashboarding / Tableau (nice to have) - 2+ years
  • State of Wisconsin Privacy Regulations - Yes
  • Please note the qualifications for this position per the contract :

    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-Development position within field. Requires moderate skill sets and developing

    proficiency within discipline. Conducts tasks and assignments as directed. Works with moderate

    supervision with some latitude for independent judgment. Typically requires four to five years

    experience or equivalent education.

    Full job description attached

    Pay rate : $40 / hr on W2.

    Create a job alert for this search

    W2 Data Warehouse Developer III Performance tuning Informatica Oracle DA SQL Remote in WI • Madison, WI, United States

    Similar jobs
    Data Warehouse Developer - IDMC (Informatica Intelligent Data Management Cloud)

    Data Warehouse Developer - IDMC (Informatica Intelligent Data Management Cloud)

    Information Resource group, Inc. • Madison, WI, United States
    Full-time
    Quick Apply
    Role : Data Warehouse Developer - IDMC (Informatica Intelligent Data Management Cloud) Location : Madison, WI Interview process : via Zoom / Teams Show more
    Last updated: 3 days ago
    Data Warehouse Developer

    Data Warehouse Developer

    Novalink Solutions LLC • Madison, WI, us
    Full-time
    Quick Apply
    The candidate will be responsible for assisting in ETL design, development, testing,.Develop ETL mapping specifications for loading information into the data. Seek continuous improvement in.Business...Show more
    Last updated: 15 hours ago • New!
    Travel CT Tech - $3,256 per week in Portage, WI

    Travel CT Tech - $3,256 per week in Portage, WI

    AlliedTravelCareers • Madison, Wisconsin, US
    Full-time
    AlliedTravelCareers is working with talent4health to find a qualified CT Tech in Portage, Wisconsin, 53901!.Talent4Health is the most candidate-centric agency in the industry.Talent4Health has clie...Show more
    Last updated: 3 days ago • Promoted
    Compensated Surrogacy Opportunity - Make a Life Changing Impact and Earn $60,000+

    Compensated Surrogacy Opportunity - Make a Life Changing Impact and Earn $60,000+

    Newborn Advantage Surrogacy • Brodhead, WI, US
    Full-time
    Compensated Surrogacy Opportunity - Make a Life Changing Impact and Earn $60,000+.Newborn Advantage Surrogacy is seeking qualified women to become gestational surrogates and help intended parents g...Show more
    Last updated: 7 days ago • Promoted
    Web Engineer III

    Web Engineer III

    Johnson Health Tech Companies • Cottage Grove, Wisconsin, US
    Full-time
    Job Description Job Description Description : Position Overview Under the direction of Director of Web R&D, the Web Engineer is responsible for the design and development of a wide range of tools ...Show more
    Last updated: 5 days ago • Promoted
    Lead Warehouse Associate

    Lead Warehouse Associate

    Loffredo Fresh Foods • Madison, Wisconsin, US
    Full-time
    Job Description Job Description Job Title : Warehouse Associate - Lead Location : Deforest, WI Join Loffredo Fresh Foods as a Lead Warehouse Associate at our Deforest, WI facility.We are a family-...Show more
    Last updated: 3 days ago • Promoted
    1.20. Data Warehouse Developer

    1.20. Data Warehouse Developer

    Focused HR Solutions • Madison, Wisconsin, United States
    Full-time
    Quick Apply
    Our direct client has an opening for an Data Warehouse Developer 129720.This position is for up to 13 months with the option of extension, and the client is in Madison, WI.Alteryx experience...Show more
    Last updated: 30+ days ago
    Remote Insurance Sales - 4-Day Workweek

    Remote Insurance Sales - 4-Day Workweek

    Platinum Supplemental Insurance, Inc. • Rio, WI, US
    Remote
    Full-time
    Ready to jump-start your career and take charge of your earning potential?.At Platinum Supplemental Insurance, we’re looking for motivated individuals ready to learn, grow, and thrive in a fast-pac...Show more
    Last updated: 26 days ago • Promoted
    3rd shift Shipper I

    3rd shift Shipper I

    Bell Laboratories Inc • Windsor, Wisconsin, US
    Full-time
    Job Description Job Description 3rd shift, 11 : 00pm - 7 : 00am, Sunday - Thursday RESPONSIBILITIES AND JOB ACTIVITIES : 1. Skids must be properly stacked and wrapped after shipment.Follow all special ...Show more
    Last updated: 3 days ago • Promoted
    1st Shift Warehouse Operator

    1st Shift Warehouse Operator

    Hydrite • Cottage Grove, WI, US
    Full-time
    And we are looking for problem-solvers to join our growing team.Up to 10% Retirement Contribution.Two Weeks Starting Paid Time Off. The primary purpose of this position is to be responsible for the ...Show more
    Last updated: 30+ days ago • Promoted
    Senior Software Engineer - Data Infrastructure

    Senior Software Engineer - Data Infrastructure

    Rentable • Madison, Wisconsin, US
    Full-time
    Job Description Job Description We're Changing the Rentals Industry We're a profitable, growth-stage company building industry-leading martech and data products for the rentals industry.While or...Show more
    Last updated: 5 days ago • Promoted
    Warehouse Associate (part-time)

    Warehouse Associate (part-time)

    Swiss Cellars • Monona, Wisconsin, US
    Part-time
    Job Description Job Description About Us : Swiss Cellars is an independently owned importer and distributor of beverages serving primarily the Wisconsin market. Our customers are retailers, restaur...Show more
    Last updated: 3 days ago • Promoted
    Driver - Pick-up and Deliver

    Driver - Pick-up and Deliver

    DoorDash • Windsor village, WI, United States
    Full-time +1
    DoorDash is the #1 category leader in food delivery, food pickup, and convenience store delivery in the US, trusted by millions of customers every day. As a Dasher, you’ll stay busy with a variety o...Show more
    Last updated: 14 days ago • Promoted
    Packer Full-Time- 2nd shift

    Packer Full-Time- 2nd shift

    Express Employment • Village of DeForest, Wisconsin, US
    Full-time +1
    Job Description Job Description Top Job Located in DeForest , WI Salary : From $20.We are looking for Packager / Assembly workers in DeForest! In this job, you'll be ensuring products meet high-qua...Show more
    Last updated: 2 days ago • Promoted
    Warehouse Worker

    Warehouse Worker

    Aerotek • Madison, WI, US
    Full-time
    Join our team as a Warehouse Worker where you will spend 60% of your time operating a sit-down forklift and the remaining 40% wrapping pallets, loading / unloading trucks, and stacking pallets.This r...Show more
    Last updated: 13 days ago • Promoted
    Online Survey Participant : Work Remote and Earn Up To $25 Per Survey

    Online Survey Participant : Work Remote and Earn Up To $25 Per Survey

    Earn Haus • Waunakee, WI, US
    Remote
    Full-time +1
    Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion. You will help influence brand decisions on se...Show more
    Last updated: 30+ days ago • Promoted
    Travel Cath Lab Tech - $2,852 per week in Marshfield, WI

    Travel Cath Lab Tech - $2,852 per week in Marshfield, WI

    AlliedTravelCareers • Madison, Wisconsin, US
    Full-time
    AlliedTravelCareers is working with CrossMed Healthcare Staffing to find a qualified Cath Lab Tech in Marshfield, Wisconsin, 54449!. At CrossMed Healthcare Staffing, we aim to create lasting impress...Show more
    Last updated: 7 hours ago • Promoted • New!
    Copy of Warehouse Associate

    Copy of Warehouse Associate

    Jaeckle Distributors • Madison, Wisconsin, US
    Full-time
    Job Description Job Description Description : Job Summary The Branch Warehouse Associate Level 2 is a skilled functional position that is proficient in execution of all warehouse operations while up...Show more
    Last updated: 3 days ago • Promoted