This job was posted by https://illinoisjoblink.illinois.gov : For moreinformation, please see:https://illinoisjoblink.illinois.gov/jobs/11568026 Date Posted:01/03/2024

　　Hiring Organization: Rose International

　　Position Number: 456021

　　Job Title: ETL Developer

　　Job Location: Chicago, IL, USA, 60601

　　Employment Type: Temporary

　　Estimated Duration (In months): 13

　　Min Hourly Rate(\$): 68.00

　　Max Hourly Rate(\$): 72.00

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

　　Job Description

　　Project Overview:

　　Looking for an experienced DataStage ETL developer responsible forenhancing and supporting data ingestegress integrations with Risk &Compliance Applications.

　　Contractors Role:

　　The role will revolve around the building and supporting of theDataStage ETL(s) as well as working with current application developmentteam to drive superior business value, enhanced customer experience andcompliance with NT standards.

　　Experience Level:

　　Senior resource: 5+ years

　　Qualifications:

　　Strong in PL/SQL and UNIX shell scripting.

　　Experience working with XML transformation and consumption of messagesfrom queues will be a big plus.

　　Hands-on improve operational stability via automation, such asautohealing where possible, and raise design changes to Data analyst,SMEs and/or architects, as well as opportunities to application /servicemanagers.

　　Work some off hours as demanded by projects, operations, and need of theon-shore team and stakeholders, such as release, testing and/or criticalbug resolutions.

　　Provide US/EMEA overnight support on critical processes in FinancialRisk applications (Murex, Adenza) and/or risk program, such as data feedbatch jobs, reports, etc in a follow the sun model, and able to addresstickets escalated by L1/L2 teams.

　　Expertise with the following skills:

　　1) Datastage

　　2) SQL, Oracle Stored Procedures

　　3) Python

　　4) 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 IBMDataStage jobs to the requirements.

　　Participate in peer design reviews and provide recommendations.

　　Construct DataStage jobs to implement the requirements:

　　o Extract the data from and to Oracle and other databases, flat files(csv, text, excel)

　　o Build JSON files using Hierarchical stage

　　o Perform structural validation

　　o Data type/allowable values validations and reporting

　　Ensure all data mapping, data lineage, functional spec, and any othertechnical documentation are detailed and up to date.

　　Ensure runbooks are fully up-to date and consistently improving theefficiency derived from automation.

　　Ensure handover of issues region to region with precise and concisehandover daily shift notes.

　　Support incidents management during incident lifecycle by resolvingservice stoppage and remediation activities, as well as any postmortemactions.

　　Support management in operational reporting on vendor issues, internalissues, and partner team issues, and respective root causes.

　　Responsible for development and maintenance of ETL code using DataStage11.7.

　　Benefits:

　　For information and details on employment benefits offered with thisposition, please visit here. Should you have any questions/concerns,please contact our HR Department via our secure website.

　　California Pay Equity:

　　For information and details on pay equity laws in California, pleasevisit the State of California Department of Industrial Relations\'website here.

　　Rose International is an Equal Opportunity Employer. All qualifiedapplicants will receive consideration for employment without regard torace, color religion, age, sex, sexual orientation, gender (expressionor identity), national origin, arrest and conviction records,disability, veteran status or any other characteristic protected by law.Positions located in San Francisco and Los Angeles, California will beadministered in accordance with their respective Fair Chance Ordinances.

　　If you need assistance in completing this application, or during anyphase of the application, interview, hiring, or employment process,whether due to a disability or otherwise, please contact our HRDepartment.

　　Rose International has an official agreement (ID #132522), effectiveJune 30, 2008, with the U.S. Department of Homeland Security, U.S.Citizenship and Immigration Services, Employment Verification Program(E-Verify). (Posting required by OCGA 13/10-91.).