ETL Developer

1 month ago

Chicago, United States Hirewell Full time

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.

  • ETL Developer

    4 days ago

    Chicago, United States w3r Consulting Full time

    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 scripting. Excellent grasp on all Components of Ab Initio - GDE, PSETS, PDL Programming, Meta Programming etc. Good understanding...

  • ETL Developer

    3 weeks ago

    Chicago, United States Hexaware Technologies Full time

    Role:- ETL DeveloperFTEChicago IL Job Description8+ years of Strong ETL & Data warehousing conceptsDB2 and MongoDB database working experience.AWS service utilization experience with services like EC2, EMR, S3, Step Functions Glue and DynamoControl M experience.Atlassian suite(Jira, Confluence and Bitbucket) experienceExperience using CI/CD pipeline...

  • ETL Developer

    2 weeks ago

    Chicago, United States Hexaware Technologies Full time

    Role:- ETL DeveloperFTEChicago IL Job Description8+ years of Strong ETL & Data warehousing conceptsDB2 and MongoDB database working experience.AWS service utilization experience with services like EC2, EMR, S3, Step Functions Glue and DynamoControl M experience.Atlassian suite(Jira, Confluence and Bitbucket) experienceExperience using CI/CD pipeline...

  • Sr. ETL Developer

    4 weeks ago

    Chicago, United States Ageatia Global Solutions Full time

    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 ETL specifications. Code must address performance,dependency, auditing, error...

  • Sr. ETL Developer

    4 days ago

    Chicago, United States Ageatia Global Solutions Full time

    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 ETL specifications. Code must address performance,dependency, auditing, error...

  • ETL Developer

    3 weeks ago

    Chicago, United States Saxon Global Full time

    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 & Compliance Applications. Contractors Role: The role will revolve around the building and...

  • ETL Developer- W2

    19 hours ago

    Chicago, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionRole : ETL DeveloperLocation : Chicago ILExperience : 7+years& & & Job DescriptionProject Overview:Looking for an experienced Snowflake developer responsible for enhancing and supporting data ingest\egress integrations with Financial Risk Mart Solution.Contractors Role:The role will revolve around the building and supporting of...

  • Senior ETL Developer

    3 weeks ago

    Chicago, United States TalentRupt Inc. Full time

    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 hands-on experience in SQL and Unix shell scripting.Component Expertise: Excellent grasp on...

  • Senior ETL Developer

    3 weeks ago

    Chicago, United States TalentRupt Inc. Full time

    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 hands-on experience in SQL and Unix shell scripting.Component Expertise: Excellent grasp on...

  • Senior ETL Developer

    3 weeks ago

    Chicago, United States TalentRupt Inc. Full time

    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 hands-on experience in SQL and Unix shell scripting. Component Expertise: Excellent...

  • Senior ETL Developer

    3 weeks ago

    Chicago, United States TalentRupt Inc. Full time

    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 hands-on experience in SQL and Unix shell scripting.Component Expertise: Excellent grasp on...

  • Ab Initio ETL developer

    4 weeks ago

    Chicago, United States Deltaclass Technology Solutions Limited Full time

    Ab Initio ETL developerLocation: Chicago, IL Type: OnsiteDesign, develop, and implement ETL solutions using Ab Initio technologies to meet business requirements and ensure data integrity.Collaborate with business analysts, data architects, and other stakeholders to understand data requirements and translate them into technical specifications.Develop and...

  • ETL Developer

    2 weeks ago

    Chicago, United States Saxon Global Full time

    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 & Compliance Applications. Contractors Role: The role will revolve around the building...

  • ETL Developer

    6 days ago

    Chicago, United States Saxon Global Full time

    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 & Compliance Applications. Contractors Role: The role will revolve around the building...

  • Senior ETL Developer

    3 weeks ago

    Chicago, United States Barrow Wise Consulting, LLC Full time

    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 solutions to our clients. Join Barrow Wise Consulting, LLC today.Responsibilities:...

  • Sr ETL Developer

    5 days ago

    Chicago, United States codesbright Full time

    Responsibilities Develop workflows and mappings to integrate data from and into various systems and data stores. Troubleshooting and correcting existing ETL solutions. Create and unit test SQL as scripts or to be used within workflows / mappings. Understanding the data warehouse and data mart models as well as being familiar with the business information...

  • Sr ETL Developer

    4 days ago

    Chicago, Illinois, United States codesbright Full time

    Responsibilities Develop workflows and mappings to integrate data from and into various systems and data stores. Troubleshooting and correcting existing ETL solutions. Create and unit test SQL as scripts or to be used within workflows / mappings. Understanding the data warehouse and data mart models as well as being familiar with the business information...

  • Etl Developer

    5 days ago

    Chicago, United States Vanator Full time

    **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 scripting. - Excellent grasp on all Components of Ab Initio - GDE, PSETS, PDL...

  • ETL Developer- Chicago IL

    4 days ago

    Chicago, United States Georgia IT Inc Full time

    Position- ETL Developer Location- Chicago IL Duration- Contract Rate- DOEDescription: We are looking for someone strong in SQL, Datawarehouse, ETL, and be local to Chicago. Strong Data warehouse concepts - Hands on experience working in a datawarehouse environment Strong Complex SQL - analyzing data sets & etc, data flow diagrams, ETL (python framework -...

  • Senior ETL Developer

    3 weeks ago

    Chicago, United States EmergencyMD Full time

    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 solutions to our clients. Join Barrow Wise Consulting, LLC today. Responsibilities:...