TSR Consulting
Enterprise System Integration Developer Senior
TSR Consulting, Brooklyn, New York, United States, 11210
About TSR:
TSR is a relationship-based, customer-focused IT and technical services staffing company.
For over 40 years TSR, Inc. and its wholly owned subsidiary, TSR Consulting Services, have prospered in the Information Technology staffing business, earning the respect of companies both large and small with well refined candidate screening, timely placement, and a real understanding of the right skill sets required by our clients.
Mission & Vision
We do not believe in building a vision around the company but building a company around our vision, which is simply;
Every employee's voice matters, their effort is appreciated, and their talent is rewarded.
We challenge each employee daily, to raise the bar on how we treat our consultants and candidates. For far too long in this industry, candidates have been ghosted, lied to, or placed at a client and then forgotten about. Each day our staff works tirelessly at qualifying and placing, top talent with our clients, in a compassionate and caring manner.
Not every candidate is a match for the job, but every candidate and consultant will be treated with respect and professionalism.
Enterprise System Integration Developer Senior
Job Description
Location: Brooklyn, New York Type: Contract Job #81104 Our client, a leading utility company, is hiring an Enterprise System Integration Developer Senior on a contract basis
Job ID #:
Work Location:
Brooklyn, NY/Hybrid
Summary:
Must Have
3rd Party Software Integration
administration and troubleshooting of Oracle and MySQL
advanced SQL development in Oracle SQL Developer
CGI WMS
Data ETL
develop ETL interfaces
Experience integrating with BizTalk Nice To Have
3+ years of experience with API/REST web services and data sources
Able to work independently and have good communication skills
account administration troubleshooting
API
IBM WebSphere
Unix Shell Scripting
writing Unix Shell scripts
DESCRIPTION:
We are seeking a highly skilled Senior Enterprise Integration Developer with strong expertise in Oracle PL/SQL and a proven ability to design, develop, and support integration applications. The ideal candidate will have experience working in the utility industry, supporting Work Management Systems (WMS) for assets, and utilizing integration tools such as BizTalk. This role requires bi-weekly reporting to the New York City office and offers the opportunity to work on impactful utility industry projects, leveraging advanced integration and database technologies to drive operational efficiency.
Key Responsibilities:
1. Integration Development and Support:
Design, develop, and maintain enterprise integrations using Oracle PL/SQL, BizTalk, and UNIX shell scripts.
Implement ETL processes to ensure seamless data exchange between enterprise applications, such as WMS, Oracle CIS, GIS, and Designer XI.
Collaborate with cross-functional teams to integrate utility systems for improved data flow and business operations.
2. Work Management System (WMS) Integration:
Support and enhance integrations with WMS for asset management, ensuring data consistency and reliability.
Troubleshoot and resolve issues related to WMS integrations and workflows.
3. Database Management:
Develop and optimize Oracle PL/SQL packages, functions, stored procedures, and triggers to support integration and application needs.
Design and maintain database schemas, table partitioning, and indexing for performance optimization.
Perform data validation and ensure the integrity of enterprise data across systems.
4.Middleware and Application Integration:
Utilize BizTalk for enterprise application integration, including designing workflows and managing message processing.
Develop APIs and web services to enable communication between internal and external systems.
Leverage middleware platforms like WebSphere MQ for reliable data delivery.
5.Technical Leadership:
Mentor junior developers and provide guidance on integration best practices.
Lead technical discussions and collaborate with stakeholders to ensure solutions meet business needs.
Document integration workflows, system configurations, and data mappings for ongoing reference and support.
6.Troubleshooting and Problem-Solving:
Analyze and resolve complex integration issues, including those related to WMS, CIS, GIS, and other enterprise systems.
Perform root cause analysis and implement preventative measures to ensure system reliability.
7.Utility Industry Expertise:
Work on utility-focused projects, including WMS asset tracking, compatible units, GIS integration, and reporting solutions.
Collaborate with business users to understand requirements and deliver solutions aligned with industry standards.
Required Skills and Qualifications:
Technical Expertise:
Strong proficiency in Oracle PL/SQL development, including stored procedures, triggers, and performance tuning.
Hands-on experience with BizTalk for integration workflows and message processing.
Familiarity with Work Management Systems (WMS) for assets and their integration into enterprise systems.
Proficient in ETL processes, data migration, and data integration tools.
Experience with middleware platforms, such as WebSphere MQ, and API development (REST/SOAP).
Strong UNIX/Linux shell scripting skills for automation and troubleshooting.
Knowledge of Oracle 19c/12c, SQL*Loader, and database design best practices.
Soft Skills:
Excellent problem-solving and troubleshooting abilities.
Strong documentation skills to create detailed technical and user documentation.
Effective communication and collaboration with cross-functional teams.
Ability to manage multiple priorities and deliver results within deadlines.
Preferred Industry Experience:
Experience in the utility industry, specifically with WMS, GIS, and asset management workflows.
Familiarity with
applications like Oracle CIS.
Education and Certification:
Bachelor's degree in Computer Science, Information Systems, or a related field.
Certification in Oracle PL/SQL or BizTalk is a plus.
Work Requirements:
Bi-weekly reporting to the NYC office.
Availability for after-hours support when required to ensure system reliability and uptime.
Pay Range: $75-85
TSR is a relationship-based, customer-focused IT and technical services staffing company.
For over 40 years TSR, Inc. and its wholly owned subsidiary, TSR Consulting Services, have prospered in the Information Technology staffing business, earning the respect of companies both large and small with well refined candidate screening, timely placement, and a real understanding of the right skill sets required by our clients.
Mission & Vision
We do not believe in building a vision around the company but building a company around our vision, which is simply;
Every employee's voice matters, their effort is appreciated, and their talent is rewarded.
We challenge each employee daily, to raise the bar on how we treat our consultants and candidates. For far too long in this industry, candidates have been ghosted, lied to, or placed at a client and then forgotten about. Each day our staff works tirelessly at qualifying and placing, top talent with our clients, in a compassionate and caring manner.
Not every candidate is a match for the job, but every candidate and consultant will be treated with respect and professionalism.
Enterprise System Integration Developer Senior
Job Description
Location: Brooklyn, New York Type: Contract Job #81104 Our client, a leading utility company, is hiring an Enterprise System Integration Developer Senior on a contract basis
Job ID #:
Work Location:
Brooklyn, NY/Hybrid
Summary:
Must Have
3rd Party Software Integration
administration and troubleshooting of Oracle and MySQL
advanced SQL development in Oracle SQL Developer
CGI WMS
Data ETL
develop ETL interfaces
Experience integrating with BizTalk Nice To Have
3+ years of experience with API/REST web services and data sources
Able to work independently and have good communication skills
account administration troubleshooting
API
IBM WebSphere
Unix Shell Scripting
writing Unix Shell scripts
DESCRIPTION:
We are seeking a highly skilled Senior Enterprise Integration Developer with strong expertise in Oracle PL/SQL and a proven ability to design, develop, and support integration applications. The ideal candidate will have experience working in the utility industry, supporting Work Management Systems (WMS) for assets, and utilizing integration tools such as BizTalk. This role requires bi-weekly reporting to the New York City office and offers the opportunity to work on impactful utility industry projects, leveraging advanced integration and database technologies to drive operational efficiency.
Key Responsibilities:
1. Integration Development and Support:
Design, develop, and maintain enterprise integrations using Oracle PL/SQL, BizTalk, and UNIX shell scripts.
Implement ETL processes to ensure seamless data exchange between enterprise applications, such as WMS, Oracle CIS, GIS, and Designer XI.
Collaborate with cross-functional teams to integrate utility systems for improved data flow and business operations.
2. Work Management System (WMS) Integration:
Support and enhance integrations with WMS for asset management, ensuring data consistency and reliability.
Troubleshoot and resolve issues related to WMS integrations and workflows.
3. Database Management:
Develop and optimize Oracle PL/SQL packages, functions, stored procedures, and triggers to support integration and application needs.
Design and maintain database schemas, table partitioning, and indexing for performance optimization.
Perform data validation and ensure the integrity of enterprise data across systems.
4.Middleware and Application Integration:
Utilize BizTalk for enterprise application integration, including designing workflows and managing message processing.
Develop APIs and web services to enable communication between internal and external systems.
Leverage middleware platforms like WebSphere MQ for reliable data delivery.
5.Technical Leadership:
Mentor junior developers and provide guidance on integration best practices.
Lead technical discussions and collaborate with stakeholders to ensure solutions meet business needs.
Document integration workflows, system configurations, and data mappings for ongoing reference and support.
6.Troubleshooting and Problem-Solving:
Analyze and resolve complex integration issues, including those related to WMS, CIS, GIS, and other enterprise systems.
Perform root cause analysis and implement preventative measures to ensure system reliability.
7.Utility Industry Expertise:
Work on utility-focused projects, including WMS asset tracking, compatible units, GIS integration, and reporting solutions.
Collaborate with business users to understand requirements and deliver solutions aligned with industry standards.
Required Skills and Qualifications:
Technical Expertise:
Strong proficiency in Oracle PL/SQL development, including stored procedures, triggers, and performance tuning.
Hands-on experience with BizTalk for integration workflows and message processing.
Familiarity with Work Management Systems (WMS) for assets and their integration into enterprise systems.
Proficient in ETL processes, data migration, and data integration tools.
Experience with middleware platforms, such as WebSphere MQ, and API development (REST/SOAP).
Strong UNIX/Linux shell scripting skills for automation and troubleshooting.
Knowledge of Oracle 19c/12c, SQL*Loader, and database design best practices.
Soft Skills:
Excellent problem-solving and troubleshooting abilities.
Strong documentation skills to create detailed technical and user documentation.
Effective communication and collaboration with cross-functional teams.
Ability to manage multiple priorities and deliver results within deadlines.
Preferred Industry Experience:
Experience in the utility industry, specifically with WMS, GIS, and asset management workflows.
Familiarity with
applications like Oracle CIS.
Education and Certification:
Bachelor's degree in Computer Science, Information Systems, or a related field.
Certification in Oracle PL/SQL or BizTalk is a plus.
Work Requirements:
Bi-weekly reporting to the NYC office.
Availability for after-hours support when required to ensure system reliability and uptime.
Pay Range: $75-85