Jobs
>
Chicago

    Snowflake ETL Developer - Chicago, United States - Daltics

    Daltics
    Daltics Chicago, United States

    3 weeks ago

    Default job background
    Technology / Internet
    Description

    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 for data integration and a commitment to operational excellence, we invite you to apply.

    **Open for W2 Only**

    Tasks and Responsibilities:

    • Collaborate with SMEs and Business Analysts to build new end-to-end solutions, ensuring compliance with operational SLAs.
    • Write and debug complex SQL queries from databases, particularly Oracle.
    • Design and build IBM DataStage jobs based on mapping documents and requirements.
    • Participate in peer design reviews, providing valuable recommendations.
    • Construct DataStage jobs for data extraction and loading from/to Oracle and other databases, flat files (CSV, text, Excel), and build JSON files using the Hierarchical stage.
    • Perform structural validation and data type/allowable values validations, providing detailed reporting.
    • Maintain up-to-date documentation, including data mapping, data lineage, functional specs, and technical documentation.
    • Ensure runbooks are continually updated, enhancing efficiency through automation.
    • Provide precise and concise handover notes for daily shift transitions.
    • Support incident management, resolving service stoppages and conducting remediation activities, including postmortem actions.
    • Assist in operational reporting on vendor, internal, and partner team issues, along with respective root causes.
    • Responsible for the development and maintenance of ETL code using DataStage 11.7.

    Qualifications:

    • 5+ years of experience with IBM DataStage.
    • 5+ years of experience with Snowflake
    • SnowFlake Certified.
    • 5+ years of experience using SQL.
    • 5+ years of strong expertise in PL/SQL and UNIX shell scripting.
    • 5+ years of experience working with XML transformation and message consumption from queues (preferred).
    • 5+ years of hands-on experience improving operational stability through automation.
    • Work collaboratively with Data Analysts, SMEs, Architects, and Application/Service Managers for design changes and enhancements.
    • Ability to work off-hours as required by projects, operations, and the needs of the on-shore team and stakeholders.
    • Provide US/EMEA overnight support on critical processes in Financial Risk applications (Murex, Adenza), addressing escalated tickets from L1/L2 teams.
  • CyberTec

    ETL Developer

    3 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

    1 week 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 ...

  • Hexaware Technologies

    ETL Developer

    1 week 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 ...

  • Ask Staffing

    ETL Developer

    3 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/ ...

  • 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 can ...

  • Hirewell

    ETL Developer

    3 weeks ago

    Hirewell Chicago, United States

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

  • w3r Consulting

    ETL Developer

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

  • Saxon Global

    ETL Developer

    1 week 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 ...

  • Saxon Global

    ETL Developer

    1 week 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 ...

  • EmergencyMD

    Senior ETL Developer

    3 weeks ago

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

  • ShiftCode Analytics

    ETL Developer/BigData

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

  • University of Illinois

    Etl Developer

    1 week 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 ...

  • The University of Chicago

    Etl Developer

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

  • RBC Technology Solutions LLC

    Ab initio ETL developer

    2 weeks ago

    RBC Technology Solutions LLC Chicago, United States

    Ab initio ETL developer: Location: Chicago,IL 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 in various Ab-initio parallelism techniques. ...

  • The Midtown Group

    Ab initio ETL Developer

    4 hours ago

    The Midtown Group Chicago, United States

    Our insurance client is hiring a Ab initio ETL Developer at $70/hour (W2) to support their office in Chicago, IL. · Responsibilities: · - Perform hands on experience in Ab Initio ETL Projects, Ab Initio solution design and development in GDE, Plans, EME, m-hub and DQE. · - Wo ...

  • USG

    Sr. Informatica ETL Developer

    15 hours ago

    USG Chicago, United States

    USG is an industry-leading manufacturer of building products and innovative solutions. For over 120 years, Chicago-based USG has developed award-winning wall, ceiling, flooring, sheathing, and roofing products that enable customers to build outstanding spaces where people live, w ...

  • TalentRupt Inc.

    Senior ETL Developer

    1 week ago

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

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

  • Saransh Inc

    ETL Snowflake Developer

    3 weeks ago

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

  • Barrow Wise Consulting, LLC

    Senior ETL Developer

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