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

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

  • ETL Snowflake Developer

    1 month ago

    Chicago, United States Saransh Inc Full time

    Role: ETL Snowflake Developer (SQL Database)Location: Chicago, IL (Onsite from Day 1)Job Type: ContractJob Description:10+ years of strong Data warehouse experience.Strong database (Oracle, MS SQL) skills in writing and optimizing SQL queries.4+ years of experience in designing and developing cloud computing solutions using Snowflake technology.Experience in...

  • ETL Snowflake Developer

    1 month ago

    Chicago, United States Saransh Inc Full time

    Role: ETL Snowflake Developer (SQL Database)Location: Chicago, IL (Onsite from Day 1)Job Type: ContractJob Description:10+ years of strong Data warehouse experience.Strong database (Oracle, MS SQL) skills in writing and optimizing SQL queries.4+ years of experience in designing and developing cloud computing solutions using Snowflake technology.Experience in...

  • Snowflake Developer

    1 month ago

    Chicago, United States Ccube Full time

    **Snowflake Developer** **Chicago, IL (Onsite 3 Days a week)** **Full Time** **7+ Years experience** We are looking for a Snowflake Data Developer with experience in integration with Snowflake, knowledge of SQL, Data warehousing, data modeling, cloud based technologies and performance tuning. **Snowflake hands-on experience.** **Must have Strong SQL,...

  • Snowflake Developer

    4 weeks ago

    Chicago, United States Ccube Full time

    Job DescriptionJob DescriptionSnowflake DeveloperChicago, IL (Onsite 3 Days a week)Full Time***7+ Years experience***We are looking for a Snowflake Data Developer with experience in integration with Snowflake, knowledge of SQL, Data warehousing, data modeling, cloud based technologies and performance tuning.Snowflake hands-on experience.Must have...

  • Snowflake Developer

    3 weeks ago

    Chicago, United States Noblesoft Technologies Full time

    Job DescriptionJob DescriptionRole: Sr Snowflake Developer(Need 10+ years of Canddidate)Location: Chicago, IL(onsite) Rate: $70/hr on C2CJD for Onsite Snowflake Developers (Snowflake, Database SQL, Python Scripting): 10+ years of strong Data warehouse experience Strong database (Oracle, MS SQL) skills in writing and optimizing SQL queries 3+ years of...

  • Snowflake Developer

    2 weeks ago

    Chicago, United States MethodHub Full time

    Job Title: Snowflake Developer with strong Python Scripting Pay Rate: $Open/hr on C2C Location: Chicago, IL (Onsite Day 1)Client: DirectDuration: 12 MonthsRequired Skills:Onsite Snowflake Developers (Snowflake, Database SQL, Python Scripting)• 10+ years of strong Data warehouse experience• Strong database (Oracle, MS SQL) skills in writing and optimizing...

  • Snowflake Developer

    2 weeks ago

    Chicago, United States MethodHub Full time

    Job Title: Snowflake Developer with strong Python Scripting Pay Rate: $Open/hr on C2C Location: Chicago, IL (Onsite Day 1)Client: DirectDuration: 12 MonthsRequired Skills:Onsite Snowflake Developers (Snowflake, Database SQL, Python Scripting)• 10+ years of strong Data warehouse experience• Strong database (Oracle, MS SQL) skills in writing and optimizing...

  • Snowflake Developer with Python Scripting

    2 weeks ago

    Chicago, United States KASTECH Software Solutions Group Full time

    Job DescriptionJob DescriptionLocation: Chicago, ILRemote option : NoJD for Onsite Snowflake Developers (Snowflake, Database SQL, Python Scripting): 10+ years of strong Data warehouse experience Strong database (Oracle, MS SQL) skills in writing and optimizing SQL queries 3+ years of experience in designing and developing cloud computing solutions using...

  • Snowflake Admin

    3 weeks ago

    Chicago, United States HCL USAAvance Consulting Full time

    Job Title: Snowflake Admin Job ID: 1404456BR Position Type: TP/CTH Location: Chicago, IL Mandatory Skillset: Snowflake Administration, Snowflake Performance Twining, SQL Queries, ETL/Datastage, Job Responsibilities: Identify the various aspects of compute and storage management Illustrate administrative tasks within the detailed architecture of Snowflake ...

  • Solutions Architect

    1 month ago

    Chicago, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. Snowflake Professional Services is the implementation and strategy experts for the Snowflake platform. We engage with customers at all phases of the customer journey to optimize, accelerate, and achieve business outcomes. Our teams of Solutions Architects demonstrate technical leadership everyday by writing...

  • 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 Software Engineer

    1 month ago

    Chicago, United States Capgemini Full time

    Title - Senior Software Engineer - Snowflake Location - Chicago IL (Hybrid) Duration Fulltime Key Responsibilities Designing and implementing data warehouse solutions using Snowflake architecture Developing and optimizing data pipelines and ETL processes within Snowflake. Utilizing Snowflake features such as Snowpipe, SnowSQL, 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 Snowflake Developer In Chicago, IL(Local Needed) NO H1B

    2 weeks ago

    Chicago, United States McKinsol Consulting Inc Full time

    HI ,My Name is Dushyant Singh and I am a Senior Technical Recruiter at Intellicept. I am reaching out to you on an exciting job opportunity with one of our clients. Position Title: Sr. Snowflake Developer (w/ Python Scripting)Location: Chicago, ILInterview Mode: MS Teams Video CallApproximate Duration: 9+ months GC-EAD Onsite Day 1Local OnlyProof of location...

  • Snowflake Developer ONSITE

    6 days ago

    Chicago, United States CCS IT Full time

    Snowflake Developer with Python scripting: Job Description: Customer is looking for a proven experience as a Snowflake Developer with strong understanding of Snowflake architecture, SQL, and data warehousing concepts with Python scripting exp. 1. Able to configure and optimize Snowflake accounts, warehouses, and databases. 2. Monitor system performance and...

  • Snowflake Developer

    1 month ago

    Chicago, United States Laiba Technologies Full time

    **Position - Role - Snowflake + Java developer.** **Location - Chicago, IL (look for locals or open to relocate to Chicago, IL, alteast 3 days in a week )** **Description**: - Hands-on experience on Snowflake is a must along with Java skills. - Other tools and technologies used - GitHub, ADO (ActiveX Data Objects), Agile Scrum, DevOps. **Education**: -...

  • Senior Sales Engineer

    7 days ago

    Chicago, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. We are  looking for a Sales Engineer who is accustomed to solving customer’s most complex problems and closing large deals. In this role you will work directly with the sales team and channel partners to understand the needs of our customers, strategize on how to navigate winning sales cycles, provide...