Software Developer

Synapse Tech Services; Columbus (OH); On-site; USD 85,000 - 120,000; Full time

Job summary

Synapse Tech Services seeks a Software Developer to analyze and document business requirements from user stories, and participate in planning sessions. You will develop and modify code, perform DB2 queries, and design ETL processes using Informatica PowerCenter.

Responsibilities include production support, CI/CD deployments, and thorough testing with Business Objects BI tools in a Unix environment. Willingness to travel within the U.S. is required.

Qualifications

• Bachelor's degree in Computer Science, Engineering, or its equivalent.
• 24 months of experience in the job offered or a closely related occupation.
• Experience with Informatica PowerCenter.
• Experience with SQL and PL/SQL.
• Experience with Business Intelligence and Business Objects Reporting Tool.
• Experience with Unix, Data Warehousing, ETL concepts.
• Willingness to travel/relocate within the U.S.

Responsibilities

• Analyze and document business requirements from user stories.
• Participate in requirements meetings, backlog grooming, and sprint planning.
• Provide production support by identifying and resolving issues in lower environments.
• Develop and modify application code, SQL, PL/SQL, and stored procedures.
• Perform DB2 database development and querying.
• Design and support ETL concepts using Informatica PowerCenter.
• Deploy code changes to testing and UAT via CI/CD tools.
• Create and execute test cases and report defects.
• Use BI tools such as Business Objects Reporting Tool and Unix as required.

Job description

The Software Developer will analyze and document business requirements by reviewing user stories and acceptance criteria. Participate in business requirement meetings, backlog grooming, and sprint planning activities. Provide production support by identifying, reproducing, and resolving application and data issues in lower environments. Develop and modify application code, SQL, PL/SQL, and stored procedures based on documented business requirements. Perform database development and querying using DB2, including DDL, DML, and joins. Design, develop, and support ETL concepts using Informatica PowerCenter and apply data warehousing concepts. Deploy code changes to testing and user acceptance environments using CI/CD tools. Create and execute test cases, document test results, and report defects to business teams. Use Business Intelligence tools, including Business Objects Reporting Tool, and Unix environments as required. Must be willing to travel and/or relocate to various unanticipated locations throughout the U.S.; however, travel is not an inherent function of the position.

Education: Bachelor's degree in Computer Science, Engineering, or its equivalent.

Experience: 24 months in the job offered or in a closely related occupation.

Special Requirements: 24 months of experience in the following:

1. Informatica PowerCenter
2. SQL
3. PL/SQL
4. Business Intelligence
5. Business Objects Reporting Tool
6. Unix
7. Data Warehousing
8. ETL Concepts
9. Must be willing to travel and/or relocate to various unanticipated locations throughout the U.S.; however, travel is not an inherent function of the position.

Months of experience are inclusive in the months of experience required above.

EOE