ETL Developer @Chicago, IL, USA,

23 hours ago


Chicago, United States Maintec Technologies Full time

Hi,

Greetings for the day.

Hope you are doing great.

We are hiring ETL Developer for one of our clients. Please go through the below requirement and reply with an updated resume.

ROLE: - ETL Developer

LOCATION: - Chicago, IL, USA, 60601

DURATION: - 1+ yrs contract

JD: -

Looking for an experienced DataStage ETL developer responsible for enhancing and supporting data ingest\egress integrations with Risk & Compliance Applications.

Experience Level:

Senior resource: 5+ years

Skills/Attributes: Data Analysis, Oracle, Python, SQL

Qualifications:

  • Strong in PL/SQL and UNIX shell scripting.
  • Experience working with XML transformation and consumption of messages from queues will be a big plus.
  • Hands-on improve operational stability via automation, such as autohealing where possible, and raise design changes to Data analyst, SMEs and/or architects, as well as opportunities to application /service managers.
  • Work some off hours as demanded by projects, operations, and need of the on-shore team and stakeholders, such as release, testing and/or critical bug resolutions.
  • Provide US/EMEA overnight support on critical processes in Financial Risk applications (Murex, Adenza) and/or risk program, such as data feed batch jobs, reports, etc in a follow the sun model, and able to address tickets escalated by L1/L2 teams.
  • Expertise with the following skills:
  • DataStage
  • SQL, Oracle Stored Procedures
  • Python
  • Data Analysis
Nice to Haves:
  • Snowflake and PowerBI knowledge preferred.
Tasks and Responsibilities:
  • Work with SME, Business Analyst to build new End-to-End solution, ensuring solutions meet all requirements, including operational SLAs.
  • Write and debug complex SQL queries from databases (such as Oracle).
  • Work with data analyst in mapping documents and design/build IBM DataStage jobs to the requirements.
  • Participate in peer design reviews and provide recommendations.
  • Construct DataStage jobs to implement the requirements:
  • Extract the data from and to Oracle and other databases, flat files (csv, text, excel)
  • Build JSON files using Hierarchical stage
  • Perform structural validation
  • Data type/allowable values validations and reporting
  • Ensure all data mapping, data lineage, functional spec, and any other technical documentation are detailed and up to date.
  • Ensure runbooks are fully up-to date and consistently improving the efficiency derived from automation.
  • Ensure handover of issues region to region with precise and concise handover daily shift notes.
  • Support incidents management during incident lifecycle by resolving service stoppage and remediation activities, as well as any postmortem actions.
  • Support management in operational reporting on vendor issues, internal issues, and partner team issues, and respective root causes.
  • Responsible for development and maintenance of ETL code using DataStage 11.7.


  • chicago, United States Sinai Chicago Full time

    Holy Cross HospitalDepartment HCT HCH C/T SCANJob Category Allied HealthShift DaysSchedule Full TimeReq #: 23426About Sinai Chicago Located on Chicago's West and Southwest Side, Sinai Chicago is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai Children's Hospital, Sinai Community Institute, Sinai Medical...


  • Chicago, United States Maintec Technologies Full time

    Job Title - Senior ETL Developer Duration - Long termLocation - Chicago, IL (Remote) Job Description: Key Required Skills- ETL design, processes, tools (e.g. Ab Initio, Informatica), scripting, programming languages (e.g. Python, R), data modeling, data warehousing, relational databases (e.g. PostgreSQL), SQL, Tableau, cloud-based data platforms (e.g. AWS),...


  • chicago, United States Sinai Chicago Full time

    Mount Sinai HospitalDepartment MSH MSH MAMMOGRAPHYJob Category Allied HealthShift DaysSchedule Full TimeReq #: 22523About Sinai ChicagoLocated on Chicago's West and Southwest Side, Sinai Chicago is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai Children's Hospital, Sinai Community Institute, Sinai Medical...


  • chicago, United States Sinai Chicago Full time

    Mount Sinai HospitalDepartment MSH MSH MAMMOGRAPHYJob Category Allied HealthShift DaysSchedule Full TimeReq #: 22523About Sinai ChicagoLocated on Chicago's West and Southwest Side, Sinai Chicago is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai Children's Hospital, Sinai Community Institute, Sinai Medical...


  • chicago, United States Sinai Chicago Full time

    Mount Sinai HospitalDepartment MSH MSH MAMMOGRAPHYJob Category Allied HealthShift DaysSchedule Full TimeReq #: 22523About Sinai ChicagoLocated on Chicago's West and Southwest Side, Sinai Chicago is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai Children's Hospital, Sinai Community Institute, Sinai Medical...


  • Chicago, United States Maintec Technologies Full time

    Hi, Greetings for the day. Hope you are doing great. We are hiring Data Architect for one of our clients. Please go through the below requirement and reply with an updated resume. ROLE: - Data Architect LOCATION: - Chicago, IL, USA, 60601 DURATION: - Long term contract Skills/Attributes: Analytical Skills, Docker, Jenkins, NoSQL Position Description:...


  • chicago, United States Sinai Chicago Full time

    Mount Sinai HospitalDepartmentMSH MSH CT SCANJob CategoryAllied HealthShiftVaried ShiftsScheduleCall/Registry/Per DiemReq #:22261About Sinai Health SystemLocated on Chicago's We st and Southwest Side, Sinai Health System is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai Children's Hospital, Sinai Community...


  • chicago, United States Sinai Chicago Full time

    Mount Sinai HospitalDepartmentMSH MSH CT SCANJob CategoryAllied HealthShiftVaried ShiftsScheduleCall/Registry/Per DiemReq #:22261About Sinai Health SystemLocated on Chicago's We st and Southwest Side, Sinai Health System is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai Children's Hospital, Sinai Community...


  • chicago, United States Vertex Elite LLC Full time

    Dear DataStage Developer - Snowflake , Vertex Elite is looking for DataStage Developer - Snowflake. Please share your profile, if you are looking for a job.Job Location : Chicago, IL (Hybrid 3 days office, No remote)Work Authorization : USC/GC/GC-EAD/H4-EAD/L2EAD/H1BRequired Skills Mandatory Skills DataStage + Data lineage + Snowflake +SQLMinimum 12+ years...

  • ETL Developer

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


  • chicago, United States Sinai Chicago Full time

    Mount Sinai HospitalDepartment MSH MSH NUCLEAR MEDICINEJob Category Allied HealthShift Varied ShiftsSchedule Call/Registry/Per DiemReq #: 22648About Sinai ChicagoLocated on Chicago's West and Southwest Side, Sinai Chicago is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai Children's Hospital, Sinai Community...


  • chicago, United States Sinai Chicago Full time

    Mount Sinai HospitalDepartment MSH MSH NUCLEAR MEDICINEJob Category Allied HealthShift Varied ShiftsSchedule Call/Registry/Per DiemReq #: 22648About Sinai ChicagoLocated on Chicago's West and Southwest Side, Sinai Chicago is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai Children's Hospital, Sinai Community...


  • chicago, United States Sinai Chicago Full time

    Mount Sinai HospitalDepartment MSH MSH RADIATION THERAPYJob Category Allied HealthShift DaysSchedule Call/Registry/Per DiemReq #: 23196APPLY NOWSAVE JOBCHAT WITH US About Sinai Health SystemLocated on Chicago's West and Southwest Side, Sinai Health System is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai...


  • chicago, United States Sinai Chicago Full time

    Mount Sinai HospitalDepartment MSH MSH RADIATION THERAPYJob Category Allied HealthShift DaysSchedule Call/Registry/Per DiemReq #: 23196APPLY NOWSAVE JOBCHAT WITH US About Sinai Health SystemLocated on Chicago's West and Southwest Side, Sinai Health System is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai...


  • chicago, United States Sinai Chicago Full time

    Mount Sinai HospitalDepartment MSH MSH RADIATION THERAPYJob Category Allied HealthShift DaysSchedule Call/Registry/Per DiemReq #: 23196APPLY NOWSAVE JOBCHAT WITH US About Sinai Health SystemLocated on Chicago's West and Southwest Side, Sinai Health System is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai...


  • chicago, United States Chicago Filmmakers Full time

    POSITION SUMMARYChicago Filmmakers is seeking an experienced and visionary Director of Education and Filmmaker Development to join our team and advance our expanding work in the film and TV sector. The ideal candidate will have a well-rounded understanding of film production, a passion for the organization’s mission and programs, a commitment to promoting...


  • chicago, United States AllianceIT Inc Full time

    Job Title: Business Analyst – Data Compliance & SQLLocation: Toronto, Canada or San Ramon, CA USA or Chicago, IL, USAMust Local to Toronto, Canada or San Ramon, CA USA or Chicago, IL, USAQualifications:• Bachelor’s degree in Business Analysis, Computer Science, Information Systems, or a related field.• 6+ years of experience working with SQL and data...


  • chicago, United States AllianceIT Inc Full time

    Job Title: Business Analyst – Data Compliance & SQLLocation: Toronto, Canada or San Ramon, CA USA or Chicago, IL, USAMust Local to Toronto, Canada or San Ramon, CA USA or Chicago, IL, USAQualifications:• Bachelor’s degree in Business Analysis, Computer Science, Information Systems, or a related field.• 6+ years of experience working with SQL and data...


  • chicago, United States Chicago Public Schools Full time

    Occupational Therapist at Chicago Public Schools summary: An Occupational Therapist at Chicago Public Schools supports students with special needs by enhancing their participation in educational activities and daily living skills. Responsibilities include evaluating student needs, developing individualized education plans, and collaborating with...


  • chicago, United States Chicago Public Schools Full time

    Occupational Therapist at Chicago Public Schools summary: An Occupational Therapist at Chicago Public Schools supports students with special needs by enhancing their participation in educational activities and daily living skills. Responsibilities include evaluating student needs, developing individualized education plans, and collaborating with...