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

　　Hiring Organization: Rose International

　　Position Number: 456087

　　Job Title: ETL Developer

　　Job Location: Chicago, IL, USA, 60604

　　Employment Type: Temporary

　　Estimated Duration (In months): 13

　　Min Hourly Rate(\$): 65.00

　　Max Hourly Rate(\$): 80.00

　　Must Have Skills/Attributes: DataStage, ETL

　　Job Description

　　**Only those lawfully authorized to work in the designated countryassociated with the position will be considered.**

　　**Please note that all Position start dates and duration are estimatesand may be reduced or lengthened based upon a clients business needs andrequirements.**

　　Normal Hours: 8:30am 5pm CST

　　Anchor Days: W (flexible on other 2 days)

　　Responsible for application maintenance and support, identifying andimplementing preventive measures proactively, evaluates and makesrecommendation on techniques, practices, or technologies that wouldenhance business needs. Also does work to ensure continuous processimprovements. The individual needs to have a good understanding ofapplication topography and the ability to collaborate between allparties involved to maintain a stable application environment.

　　The PFS-IS(Personal Financial Services Investment Solutions) platform isa showcase product for clients Wealth Management business and we mustdemonstrate our ability to deliver and support innovative technologysolutions. We count on our site reliability engineers to run theproduction environment by monitoring availability and taking a holisticview of system health.

　　Major Duties:

　　Ensure near-zero downtime with monitoring and alerting, self-healingautomation, and continuous improvement

　　Leads troubleshooting, analysis, and solution of unexpected systemsbehaviors that impact the quality of service

　　Provide a proactive approach to our clients workloads, anticipatingfailures, automating tasks, ensuring availability, and providing a greatcustomer experience

　　Communicate issue/resolution status (written and verbal) to project teamand management

　　Work with senior staff and management on service delivery improvements

　　Partner with the development team, business support and end users tosupport and implement end to end solutions.

　　Use the IBM DataStage and PL/SQL to create or modify scripts andprograms.

　　Constantly look for better ways of solving technical problems anddesigning the solution by not being afraid of challenging the statusquo.

　　Support existing software systems and platforms and hook in applicationsto applicable data sources

　　Create and maintain Disaster Recovery plans and participate in DRTesting and Infra patching.

　　Knowledge/Skills:

　　Extensive knowledge of IBM Infosphere DataStage ETL is required

　　Extensive knowledge on building and supporting ETL Code using InfosphereDataStage to load enterprise data warehouses using relational database(Oracle, DB2, Sybase) applying transformations and business rules asdefined in requirements is a MUST.

　　Extensive Knowledge of oracle SQL and PL/SQL (cursors, triggers,packages, stored procedures)

　　Knowledge in integrating data from multiple sources- MQ, Solace, XML,Excel files, unstructured data and loading them into staging/warehousetables

　　Understanding of dimensional data modeling - star schema and snowflakeschema

　　Extensive experience in creating jobs, routines and sequences to createend to end ETL framework in DataStage

　　Experienced in maintaining DataStage code version using Github/MicrosoftAzure Knowledge of code migration and production deployment usingautomated migration process

　　Experienced in performance tuning DataStage ETL processes usingappropriate data partitioning algorithms

　　Must have extensive Knowledge of Unix/Linux Commands and shell scripti g

　　Knowledge on scheduling tools like Control-M.

　　Knowledge on Azure DevOps and Agile methodology.

　　Nice to have some knowledge on Service now and ITSM concepts.

　　Understanding of enterprise architecture patterns and best practices

　　Excellent oral and written communication skills are required

　　Analytical and problem solving skills

　　A positive goal orientated attitude with a focus on service delivery

　　Experience Required:

　　A College or University degree in Computer Science and/or relevant 6-8years proven work experience.

　　Related Industry qualification is preferred.

　　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