{"schemaVersion":"jobsearcher.job.v1","id":"b8f5fbea5b010db8312295bb","url":"https://jobsearcher.com/jobs/b8f5fbea5b010db8312295bb","canonicalUrl":"https://jobsearcher.com/jobs/b8f5fbea5b010db8312295bb","title":"ETL Developer","description":"Position - ETL DEVELOPERPlease send Full Legal Name, LinkedIn, Location, Contact Details, C2C rate, and work authorization status with each submittal.Client: Northern TrustLocation: Hybrid Chicago 3x a week onsiteInterview Mode: VirtualType: Long term contract (potential CTH)Work authorization: Cannot work with OPT or CPTApplication Support Engineer - Northern Trust, Personal Financial Services/Investment SolutionsWork Location (Address): 333 S Wabash Ave, Chicago, IL 60604, United StatesNormal Hours: 8:30am - 5pm CSTAnchor Days: W (flexible on other 2 days)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 Northern Trust'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:Ensure near-zero downtime with monitoring and alerting, self-healing automation, and continuous improvementLeads troubleshooting, analysis, and solution of unexpected systems behaviors that impact the quality of serviceProvide a proactive approach to our clients' workloads, anticipating failures, automating tasks, ensuring availability, and providing a great customer experienceCommunicate issue/resolution status (written and verbal) to project team and managementWork with senior staff and management on service delivery improvementsPartner with the development team, business support and end users to support and implement end to end solutions.Use the IBM DataStage and PL/SQL to create or modify scripts and programs.Constantly look for better ways of solving technical problems and designing the solution by not being afraid of challenging the status quo.Support existing software systems and platforms and hook in applications to applicable data sourcesCreate and maintain Disaster Recovery plans and participate in DR Testing and Infra patching.Knowledge/Skills:Extensive knowledge of IBM Infosphere DataStage - ETL is requiredExtensive 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 tablesUnderstanding of dimensional data modeling - star schema and snowflake schemaExtensive experience in creating jobs, routines and sequences to create end to end ETL framework in DataStageExperienced in maintaining DataStage code version using Github/Microsoft Azure Knowledge of code migration and production deployment using automated migration processExperienced in performance tuning DataStage ETL processes using appropriate data partitioning algorithmsMust have extensive Knowledge of Unix/Linux Commands and shell scriptingKnowledge 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 practicesExcellent oral and written communication skills are requiredAnalytical and problem solving skillsA positive goal orientated attitude with a focus on service deliveryExperience Required:A College or University degree in Computer Science and/or relevant 6-8 years proven work experience. Related Industry qualification is preferred.","company":"Apex Informatics","rawCompany":"apex informatics","city":"Chicago","state":"IL","isRemote":false,"isActive":false,"createdAt":"2026-09-11T12:34:37.983Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"ETL Developer","description":"Position - ETL DEVELOPERPlease send Full Legal Name, LinkedIn, Location, Contact Details, C2C rate, and work authorization status with each submittal.Client: Northern TrustLocation: Hybrid Chicago 3x a week onsiteInterview Mode: VirtualType: Long term contract (potential CTH)Work authorization: Cannot work with OPT or CPTApplication Support Engineer - Northern Trust, Personal Financial Services/Investment SolutionsWork Location (Address): 333 S Wabash Ave, Chicago, IL 60604, United StatesNormal Hours: 8:30am - 5pm CSTAnchor Days: W (flexible on other 2 days)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 Northern Trust'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:Ensure near-zero downtime with monitoring and alerting, self-healing automation, and continuous improvementLeads troubleshooting, analysis, and solution of unexpected systems behaviors that impact the quality of serviceProvide a proactive approach to our clients' workloads, anticipating failures, automating tasks, ensuring availability, and providing a great customer experienceCommunicate issue/resolution status (written and verbal) to project team and managementWork with senior staff and management on service delivery improvementsPartner with the development team, business support and end users to support and implement end to end solutions.Use the IBM DataStage and PL/SQL to create or modify scripts and programs.Constantly look for better ways of solving technical problems and designing the solution by not being afraid of challenging the status quo.Support existing software systems and platforms and hook in applications to applicable data sourcesCreate and maintain Disaster Recovery plans and participate in DR Testing and Infra patching.Knowledge/Skills:Extensive knowledge of IBM Infosphere DataStage - ETL is requiredExtensive 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 tablesUnderstanding of dimensional data modeling - star schema and snowflake schemaExtensive experience in creating jobs, routines and sequences to create end to end ETL framework in DataStageExperienced in maintaining DataStage code version using Github/Microsoft Azure Knowledge of code migration and production deployment using automated migration processExperienced in performance tuning DataStage ETL processes using appropriate data partitioning algorithmsMust have extensive Knowledge of Unix/Linux Commands and shell scriptingKnowledge 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 practicesExcellent oral and written communication skills are requiredAnalytical and problem solving skillsA positive goal orientated attitude with a focus on service deliveryExperience Required:A College or University degree in Computer Science and/or relevant 6-8 years proven work experience. Related Industry qualification is preferred.","datePosted":"2026-09-11T12:34:37.983Z","dateModified":"2026-09-11T12:34:37.983Z","hiringOrganization":{"@type":"Organization","name":"Apex Informatics","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Chicago","addressRegion":"IL","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"b8f5fbea5b010db8312295bb"},"url":"https://jobsearcher.com/jobs/b8f5fbea5b010db8312295bb"}}