Vacancy expired!
The Conversion Engineer is responsible for assisting in implementing effective conversions with direction from more experienced technical staff on the team. Work with our innovative software solutions that help local government and school districts centralize data and connect their organizations. By working to develop and support our financial management solutions, you can help integrate our solutions with human resources, revenue management, tax billing, and asset management.
LocationYarmouth, MaineTravel0-5%Responsibilities- Design, develop, troubleshoot and execute packages to convert client data using stored procedures, functions, and scripts (i.e. SQL, etc.) in a database environment (such as Oracle, SQL Server, etc.).
- Assist development staff, project management, business/implementation analysts and other relevant parties to provide conversion support relevant to experience so that client business rules/requirements are met.
- Design, implement, and maintain new and existing database objects including tables, indexes, constraints, stored procedures, and user-defined functions in support of data conversion utilities and projects.
- Ensure data conversion solutions are appropriate, technically sound and successfully meet client requirements.
- Obtain data conversion specifications from implementation, project manager or another internal technology resource. May occasionally interface with clients directly.
- Perform basic data analysis to identify data patterns and anomalies.
- Troubleshoot conversion logic involving resolving data verification and related issues (i.e. identifying and resolving missing/incorrect data elements; issues involving data balancing, data transporting, data corruption and other data conversion and related issues).
- Maintain issue resolution logs as appropriate.
- Perform basic level data verification and balancing between old and new systems.
- Create and update conversion logic to resolve client issues in test and production environments.
- Understand and implement test scripts and plans, assess results and identify effective data conversion solutions.
- Perform database administration activities (i.e. backup, restore, DBCC commands, indexing, shrink, etc.).
- May install converted data at the client site.
- Engage in query performance tuning.
- Support on-site Implementation as needed.
- Manage workload to meet strict deadlines and communicates status regularly to team.
- Maintain, and document conversion programs and processes.
- May occasionally travel to client sites.
- Perform other duties as assigned.
- Bachelor's Degree in Computer Science or related field.
- Understanding of full life cycle development preferred.
- Ability to work well within deadline-oriented development structure.
- Ability to work well both independently and within a team environment.
- Adequate technical abilities and desire to learn new things.
- Strong attention to detail.
- Demonstrable problem solving skills.
- Excellent interpersonal skills including verbal and written communication skill, teamwork and customer service skills.
- Programming knowledge requirements - SQL or related technology:
- Create databases using T-SQL or SQL Management Studio 2005 and/or 2008
- Create stored procedures
- Create SQL database backups
- Perform SQL database restores
- Use aggregate functions in SQL
- Create simple queries using T-SQL
- Develop, maintain, and trouble-shoot conversion packages using SQL Server Business
- Intelligence Design Studio
Vacancy expired!