Home

NO H1B !! ETL Developer- Chicago, IL- hybrid onsite at Chicago, Illinois, USA
Email: [email protected]
http://bit.ly/4ey8w48
https://jobs.nvoids.com/job_details.jsp?id=988068&uid=

From:

Abhi Sharma,

Swastik IT Services

[email protected]

Reply to:   [email protected]

ETL Developer- Chicago, IL- hybrid onsite

1-2 rounds of interview

12 months initial contract

Job Description: Application Support Engineer - ***, Personal Financial Services/Investment Solutions

Responsible for application maintenance and support, identifying and implementing preventive measures proactively, evaluates and makes recommendation on techniques, practices, or technologies that would enhance business needs. Also does work to ensure continuous process improvements. The individual needs to have a good understanding of application topography and the ability to collaborate between all parties involved to maintain a stable application environment.

The PFS-IS(Personal Financial Services Investment Solutions) platform is a showcase product for ***s Wealth Management business and we must demonstrate our ability to deliver and support innovative technology solutions. We count on our site reliability engineers to run the production environment by monitoring availability and taking a holistic view of system health.

Major Duties:

1. Ensure near-zero downtime with monitoring and alerting, self-healing automation, and continuous improvement

2. Leads troubleshooting, analysis, and solution of unexpected systems behaviors that impact the quality of service

3. Provide a proactive approach to our clients workloads, anticipating failures, automating tasks, ensuring availability, and providing a great customer experience

4. Communicate issue/resolution status (written and verbal) to project team and management

5. Work with senior staff and management on service delivery improvements

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

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

8. Constantly look for better ways of solving technical problems and designing the solution by not being afraid of challenging the status quo.

9. Support existing software systems and platforms and hook in applications to applicable data sources

10. Create and maintain Disaster Recovery plans and participate in DR Testing and Infra patching.

Knowledge/Skills:

Extensive knowledge of IBM Infosphere DataStage ETL is required

Extensive knowledge on building and supporting ETL Code using Infosphere DataStage to load enterprise data warehouses using relational database (Oracle, DB2, Sybase) applying transformations and business rules as defined 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/warehouse tables

Understanding of dimensional data modeling - star schema and snowflake schema

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

Experienced in maintaining DataStage code version using Github/Microsoft Azure Knowledge of code migration and production deployment using automated migration process

Experienced in performance tuning DataStage ETL processes using appropriate data partitioning algorithms

Must have extensive Knowledge of Unix/Linux Commands and scripting

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-8 years proven work experience. Related Industry qualification is preferred.

Reason for Request:

Comments for Suppliers: Work Location (Address): 333 S Wabash Ave, Chicago, IL 60604, United States

Normal Hours: 8:30am 5pm CST

Anchor Days: W (flexible on other 2 days)

AbhI SHARMA.

Talent 

Acquisition 

Manager

.

Email:- 

[email protected] 

Swastik IT Services

61 Snowberry Ridge CT O'Fallon MO. 63366 

DISCLAIMER: 

This e-mail contains CONFIDENTIAL INFORMATION intended solely for the use of the recipient. If you are not the intended person, please notify me by reply REMOVE in the subject line. I will revise my list again. Apologies for inconvenience.

Keywords: message queue information technology procedural language Connecticut Illinois Missouri
http://bit.ly/4ey8w48
https://jobs.nvoids.com/job_details.jsp?id=988068&uid=
[email protected]
View All
12:16 AM 06-Jan-24


To remove this job post send "job_kill 988068" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.


Your reply to [email protected] -
To       

Subject   
Message -

Your email id:

Captcha Image:
Captcha Code:


Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]


Time Taken: 0

Location: ,