Convert and migrate Oracle SQL code to IBM Db2 SQL, ensuring compatibility and functional equivalence.
Compensation
The expected base salary for this position ranges from $60.00 to $65.00/hour. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, market factors, and where applicable, licensure or certifications obtained. In addition to salary, a competitive benefit package is also offered.
Responsibilities
Convert and migrate Oracle SQL code to IBM Db2 SQL, ensuring compatibility and functional equivalence.
Identify and resolve differences in SQL syntax, functions, data types, and database-specific behavior.
Develop and execute SQL queries to validate data accuracy, application functionality, and migration results.
Troubleshoot conversion issues, investigate data discrepancies, and optimize migrated SQL code.
Document code changes, testing procedures, results, and technical findings.
Requirements
Bachelor's degree in Computer Science, Information Technology, or a related field
Quality control of payroll records from JET/PTS – Run interface, review data, work with business partners and supervisor with said data on regularly scheduled events, special projects and terminations. Perform audits and reconciliations. Participate in annual PwC control sampling.
JET/PTS Development Partner – Partner with IT/System Smith on all changes that require Oracle payroll testing.
Oracle Development Partner – Partner with EBS team on changes and upgrades to the Oracle functionally to include OTL, ESS, MSS and Payroll modules. Partner with EBS and business partners to assess new development and opportunities.
Benefit Billing – Create benefit billing reports using Oracle OBIEE and KBX. Track benefit rate changes to ensure integrity of billing and cost allocations.
Payroll Distribution – Maintain access database for cost withholding taxes, payroll distribution reports to Controllers and HRBP’s. Maintain libraries and user permissions in SharePoint.
Senior Application Support Engineer responsible for technical and business support of Citi applications, leading incident management, automation, and payment processing platform stability.
Responsibilities
Provide technical and business support for Citi applications
Maintain application systems in daily operations
Manage, maintain and support applications and operating environments
Perform start of day checks, continuous monitoring and regional handover
Perform same day risk reconciliations
Requirements
Bachelor’s/University degree or equivalent experience
Ejecutar la conversión del código mainframe (COBOL, JCL, CICS) hacia el target Java / Spring / Spring Batch / Oracle utilizando la plataforma de la Factoría.
Refinar y validar manualmente el código generado por la plataforma de IA: revisión de equivalencia funcional, refactor, tuning de rendimiento.
Reportar al Pod Lead gaps de la plataforma y proponer mejoras al Core Factoría.
Provide expert-level PeopleSoft Application Architect and Development support for current PeopleSoft Applications and assist with the design and implementation of solutions for the HCM Application PUM Upgrade Project.
Responsibilities
Possess a strong technical background in PeopleSoft to develop complex PeopleSoft programs and provide technical guidance to one or more developers and cross functional team members
Perform research and provide technical direction to meet business needs with a focus on the Human Capital Management module as well as PeopleSoft Interaction Hub (Portal)
Analyze and assess the need for customizations versus workaround with delivered functionality
Participate in Process Improvement work groups with customer agencies as needed
Analyze, research, and document Business rules for legacy application functions
Primary escalation point for Tier 2 technical and operational incidents, diagnosing and resolving complex platform, database, and system interface issues, and coordinating with Tier 3 engineering and development teams.
Responsibilities
Serve as the primary escalation point for complex Tier 2 technical and operational incidents, taking full ownership of resolution.
Diagnose, troubleshoot, and resolve multi-layered platform, database, and system interface issues that cannot be addressed at Tier 1.
Perform advanced root cause analysis on persistent or systemic issues, identifying underlying technical causes and documenting permanent resolutions or strategic workarounds.
Utilize enterprise monitoring and analysis platforms (such as SQL, Splunk, Dynatrace, CloudWatch) to extract logs, query databases, and analyze system performance during escalations.
Act as the critical liaison between front-line support and Tier 3 engineering/development teams, packaging complex technical findings into detailed escalations.
Requirements
Bachelor's Degree in Business/Information Systems or a related field
Develop and support custom Salesforce components, integration solutions, ETL processes, and automation scripts for Morgan Stanley’s Sales and Service teams.
Compensation
Expected base pay rates for the role will be between $171,000 and $171,000 per year at the commencement of employment.
Responsibilities
Customize and configure Salesforce platform
Build custom components and features for Sales and Service team
Design, implement, and maintain end-to-end integration solutions
Build and manage APIs, middleware, and batch jobs
Develop customized software solutions for Salesforce platform
Requirements
Master’s degree in Applied Computer Science, Information Technology, or a related field
Oracle to Db2 SQL Migration DeveloperNewComputer Task Group, Inc · Remote, US
Payroll Systems AnalystNewAdvantage Solutions · Remote, US
Service Desk Support SpecialistNewASM Research · Fairfax, US