Responsible for programming on specific application subsets of the company's application portfolio, participating in all phases of the development and maintenance life cycle, typically for an assigned business unit, client program, or corporate department and utilizing various customer technology platforms.
Primary duties may include, but are not limited to:
- Develop reports and extracts using MS SQL, BI tools and Informatica by writing complex T-SQL and PLSQL queries
- Deploy reports and extracts using SSIS, SSRS, SSAS and Informatica technologies
- Create/schedule report subscriptions using a report scheduler
- Optimize reports by analyzing and standardizing code
- Make enhancements and conduct testing to ensure reports are optimized
- Conduct performance tuning of queries in order to improve execution time
- Research time critical report failures, make recommendations, develop corrective actions, and re-run the reports to support business needs
- Generate ad-hoc reports to support emergency and urgent business needs
- Work closely with the department’s systems analysts to ensure requirements are implemented in an automated fashion for reports
- Work closely with the database administrators to move code from development to QA and production environments
- Resolve issues; consult on log files; and optimize the processing of reports.
- Owns the change request process and may coordinate with other teams as necessary
- Develops and defines application scope and objectives and prepares technical and/or functional specifications from with programs will be written
- Collaborates with Product Architects for application design
- Performs technical design reviews and code reviews
- Ensures unit test is completed and meets the test plan requirements, system testing is completed and system is implemented according to plan
- Performs Defect Metrics tracking
Requires BA/BS degree in related field or technical institute training; 5 or more years related experience; multi platform experience; , expert level experience with business and technical applications, or any combination of education and experience, which would provide an equivalent background. Incumbent should also have the ability to mentor others, lead multiple small projects and provide troubleshooting support. Multi dimensional required. Multi database and/or multi language preferred.
- PEGA certification preferred
- Object oriented programming (.NET, JAVA)
- Working knowledge of database programming (SQL Server, Oracle)
"Infomatics Corp is an Equal Opportunity Employer. All qualified applicants will be considered for employment without regard to race, color, sex, religion, age, physical or mental disability, veteran status, citizenship status or any other status protected by federal, state or local law."