Jobs
>
Chicago

    ETL Developer - Chicago, United States - Hirewell

    Hirewell background
    Retail
    Description

    Senior ETL Developer Job Description

    We are seeking an experienced Senior ETL Developer to design, implement, and optimize ETL processes for multiple data sources using SQL, SSIS, or similar ETL tools. The ideal candidate will have strong communication, analytical, and problem-solving skills to ensure successful project outcomes within specified timelines.

    Key Responsibilities:

    • Design, develop, and analyze data integration projects across different stages of the product lifecycle.
    • Locate, evaluate, and profile source data to assess quality and guide business logic.
    • Develop and execute complex data integration workflows that span various business and technical areas.
    • Contribute to database design and data modeling initiatives.
    • Develop queries optimized for high performance and adjust SQL queries for peak efficiency.
    • Oversee deployment and monitoring of data integration projects.
    • Offer guidance on performance improvements for ETL processes.
    • Identify data quality issues and suggest solutions to cleanse or enhance data quality.
    • Troubleshoot data-related problems, validate results, and propose process improvements.
    • Update and maintain relevant documentation.
    • Be available for operational support during non-standard hours and participate in on-call rotations for production support.

    Qualifications and Skills:

    • Bachelor's degree in Computer Science or a related field.
    • 7-10 years of industry experience in ETL development.
    • Expertise in SQL Server Integration Services (SSIS) and project design.
    • Experience with performance tuning for SSIS packages.
    • Proficiency with most SSIS components, tasks, and transformations.
    • Ability to execute scripts using .NET and stored procedures.
    • Strong general ETL skills, including incremental and full data loads, deduplication, and data transformation.
    • Familiarity with junk dimensions, bridge tables, and degenerate dimensions.
    • Experience with various ETL frameworks and architectural models.
    • Knowledge of SQL Server 2014, 2016, and above.
    • Skills in database performance tuning and query analysis.
    • Strong communication skills, both verbal and written.
    • Experience working on large-scale enterprise projects with diverse teams.

  • The University of Chicago

    Etl Developer

    1 week ago


    The University of Chicago Chicago, United States

    Department · BSD CRI - Data Warehouse · About the Department · We are committed to increasing diversity, equity, and inclusion for the benefit of our team members, our institution, our clients, and our community. We will accomplish this by incorporating our values into hiring pra ...

  • University of Illinois

    Etl Developer

    1 day ago


    University of Illinois Chicago, United States

    **ETL Developer - Office of the Vice Chancellor for Research** · **Hiring Department**: Office of the Vice Chancellor for Research · **Location**: Chicago, IL USA · **Requisition ID**: · **Posting Close Date**: 6/14/2024 · **About the University of Illinois Chicago** · UIC is am ...

  • Vanator

    Etl Developer only W2

    2 weeks ago


    Vanator Chicago, United States

    **ETL Developer [ONLY W2 Remote]** · **Description**: · - Hands on experience in Ab Initio ETL Projects, Ab Initio solution design and development. Ab initio experience including GDE, Plans, EME, m-hub and DQE. · - Strong knowledge and hands-on experience in SQL, Unix shell scrip ...

  • CyberTec

    ETL Developer

    2 weeks ago


    CyberTec Chicago, United States

    Let me know if you have a candidate currently living in one of the approved states (attached form), and willing to perform a 100% remote position supporting our client Client Cross Association (BCBSA) in Chicago, IL starting on February 26, 2024. · Our client only accepts candid ...

  • Hexaware Technologies

    ETL Developer

    5 days ago


    Hexaware Technologies Chicago, United States

    Role:- ETL Developer · FTE · Chicago IL · Job Description · 8+ years of Strong ETL & Data warehousing concepts · DB2 and MongoDB database working experience. · AWS service utilization experience with services like EC2, EMR, S3, Step Functions Glue and Dynamo · Control M experien ...

  • w3r Consulting

    ETL Developer

    2 weeks ago


    w3r Consulting Chicago, United States

    :Hands on experience in Ab Initio ETL Projects, Ab Initio solution design and development. Ab initio experience including GDE, Plans, EME, m-hub and DQE. · Strong knowledge and hands-on experience in SQL, Unix shell scripting. · Excellent grasp on all Components of Ab Initio - ...

  • CyberTec

    ETL Developer

    1 week ago


    CyberTec Chicago, United States

    · Let me know if you have a candidate currently living in one of the approved states (attached form), and willing to perform a 100% remote position supporting our client Client Cross Association (BCBSA) in Chicago, IL starting on February 26, 2024. · Our client only accepts can ...

  • Hexaware Technologies

    ETL Developer

    5 days ago


    Hexaware Technologies Chicago, United States

    About the job · What Working at Hexaware offers: · Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member ...

  • Saxon Global

    ETL Developer

    4 days ago


    Saxon Global Chicago, United States

    Work Location: Prefer local to Chicago (Hybrid work schedule 3 days/week), but open to Remote for the right candidate · Project Overview: · Looking for an experienced DataStage ETL developer responsible for enhancing and supporting data ingestegress integrations with Risk & Com ...

  • Saxon Global

    ETL Developer

    6 days ago


    Saxon Global Chicago, United States

    Work Location: Prefer local to Chicago (Hybrid work schedule 3 days/week), but open to Remote for the right candidate Project Overview: Looking for an experienced DataStage ETL developer responsible for enhancing and supporting data ingest\egress integrations with Risk & Complian ...

  • Ask Staffing

    ETL Developer

    2 weeks ago


    Ask Staffing Chicago, United States

    Pay Range - $75 to $79 · Location: Remote Chicago, IL · ETL Developer · Qualifications: · • Must have strong experience ETL Tools, Oracle Data Integrator (1-5 years) · • Must have strong experience Oracle SQL, PL/SQL (1-5 years) · • Should have strong understanding in BI/ ...

  • Revive Staffing Solutions Inc

    Sr. ETL Developer

    3 weeks ago


    Revive Staffing Solutions Inc Chicago, United States

    Senior ETL Developer · The Senior ETL Developer will be held accountable for the following responsibilities: · Maintain and Manage the existing Client Enterprise Data Warehouse and ODS builds. · Model extensions to the existing Data Warehouse · Builds ETL components according to ...


  • TalentRupt Inc. Chicago, United States

    Job Description: · The ideal candidate will have hands-on experience in Ab Initio ETL projects, solution design, and development. Specific qualifications include: · Ab Initio Experience: Proficiency with GDE, Plans, EME, m-hub, and DQE. · Technical Skills: Strong knowledge and ha ...

  • Barrow Wise Consulting, LLC

    Senior ETL Developer

    2 weeks ago


    Barrow Wise Consulting, LLC Chicago, United States

    Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you understand the gifts that set you apart from everyone else. Demonstrate innovative solu ...

  • Barrow Wise Consulting, LLC

    Senior ETL Developer

    2 weeks ago


    Barrow Wise Consulting, LLC Chicago, United States

    Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you understand the gifts that set you apart from everyone else. Demonstrate innovative solu ...

  • Saxon Global

    ETL Developer IV

    3 weeks ago


    Saxon Global Chicago, United States

    le: ETL Developer IV - UALJP Location: Chicago, IL Client: United Airlines Duration: 12+ Months Rate: 85/hr Note: Need a Power BI developer Top 5 Skill sets 1. Power BI yrs experience 3. Experience with any other BI tool 4. Datewarehouse ETL concepts 5. AWS/Cloud/Finance is add o ...


  • Saransh Inc Chicago, United States

    Role: ETL Snowflake Developer (SQL Database) · Location: Chicago, IL (Onsite from Day 1) · Job Type: Contract · Job Description: · 10+ years of strong Data warehouse experience. · Strong database (Oracle, MS SQL) skills in writing and optimizing SQL queries. · 4+ years of experie ...

  • Diverse Lynx

    ETL Lead Developer

    3 weeks ago


    Diverse Lynx Chicago, United States

    Job Description ::Min. 6-7 years exp in ETL development. · Strong technical skills in DataStage 11.7, Oracle 19c, PL/SQL, unix/Shell scripting and Ctrl M scheduling. · Good work experience in Financial Services domain (preferably in Compliance business). · Good analytical and pro ...

  • ShiftCode Analytics

    ETL Developer/BigData

    2 weeks ago


    ShiftCode Analytics Chicago, United States

    Client Location - Chicago (will go to office 2nd and 4th Wednesdays of the month - Could change to once a week) · -Duration - 6+ months (need 6 months conversion waiver) · -Interview Process - 2 video interview · -Visa - USC,GC,GC-EAD,H4, L2 · Must Have - Requirements: · Re ...


  • Daltics Chicago, United States

    We are seeking an experienced ETL Developer with a strong background in Snowflake and IBM DataStage to join our dynamic team. The ideal candidate will have proven expertise in designing and implementing end-to-end solutions, writing and debugging complex SQL queries, and construc ...