ETL Developer

3 weeks 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

    6 days 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

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

  • ETL Developer

    7 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 ingest\egress integrations with Risk & Compliance Applications. Contractors Role: The role will revolve around the building and...

  • Senior ETL Developer

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

    5 days 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

    6 days 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

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

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

    5 days 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:...

  • Senior ETL Developer

    3 days 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: ...

  • Senior ETL Developer

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

  • Etl Developer

    3 days ago

    Chicago, United States University of Illinois Full time

    **ETL Developer - Office of the Vice Chancellor for Research** **Hiring Department**: Office of the Vice Chancellor for Research **Location**: Chicago, IL USA **Requisition ID**: 1025124 **Posting Close Date**: 6/14/2024 **About the University of Illinois Chicago** UIC is among the nation’s preeminent urban public research universities, a Carnegie...

  • ETL Informatica IICS Developer

    3 weeks ago

    Chicago, United States Diverse Lynx Full time

    Job Title: ETL Informatica IICS Developer Location: Chicago, IL/REMOTE Position Type: Full Time role 8 - 10 years of experience Job Function TECHNOLOGY Desired Skills Informatica | Unix Shell Scripting Job Description: Skill: ETL informatica IICS • Hands-on exp with Informatica 9.6 and above • 2 plus years of hands-on exp with cloud ETL (pre with IICS)...

  • ETL Developer

    6 days ago

    Chicago, United States Hexaware Technologies Full time

    About the jobWhat 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 is valued and empowered to succeed.Hexaware provides access to a vast array of tools...

  • Sr . ETL Informatica IICS developer

    3 weeks ago

    Chicago, United States Diverse Lynx Full time

    Role: Sr . ETL Informatica IICS developer Location: Chicago, IL (Remote) Duration: Full-time(No C2C/C2H) JD Job Description Skill: ETL informatica IICS • Hands-on exp with Informatica 9.6 and above • 2 plus years of hands-on exp with cloud ETL (pre with IICS) • Hands-on exp in unix commend and scripting • Develop data pipelines to ingest...

  • Snowflake ETL Developer

    2 weeks ago

    Chicago, United States Daltics Full time

    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 constructing DataStage jobs. If you are a detail-oriented professional with a passion...

  • Snowflake ETL Developer

    2 weeks ago

    Chicago, United States Daltics Full time

    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 constructing DataStage jobs. If you are a detail-oriented professional with a passion...

  • Snowflake ETL Developer

    2 weeks ago

    Chicago, United States Daltics Full time

    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 constructing DataStage jobs. If you are a detail-oriented professional with a passion...

  • Snowflake ETL Developer

    2 weeks ago

    Chicago, United States Daltics Full time

    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 constructing DataStage jobs. If you are a detail-oriented professional with a passion...