Job Description: The IT Monitoring Solutions team is looking for an ETL developer to help bridge the gap between a flexible set of monitoring tools with diverse storage technologies, and a consolidated service metrics portal that we are developing over an Oracle database. This role will involve reviewing requirements for data presentation, and from there designing an output schema in an Oracle database, as well as designing and writing the code to populate that schema and writing the SQL for the UI layer to consume the data. It also requires clear documentation skills for the schema and code generated, and good communication skills to carry projects from requirements gathering through execution and documentation.
Primary Duties and Responsibilities:
Designs and develops internal and external business systems/applications, systems interfaces, databases, reporting, or business intelligence systems, as required to deliver new systems functionality supporting corporate business objectives
Team with and support Business and Systems Analysts responsible for completing detailed functional specifications.
Translate business and functional specifications into detailed technical specifications.
Document technical impact assessments to include details about applications impacts and resource requirements for developing and unit testing new software solutions.
Develop and unit test software solutions based on detailed technical specifications. Document detailed unit test cases and test results.
Team with Project Managers, Release Planning, Management, and other stakeholders to ensure project deliverables are completed on time, within budget, and meet or exceed customer expectations.
Conduct code reviews with peers and technical specifications reviews with project stakeholders.
Assist Test teams responsible for test environment configuration management duties. Assist Test teams with identifying, prioritizing, and correcting software solutions defects.
Document detailed implementation steps for deploying software solutions into production.
Document detailed application support documentation. Train Operations and Application Support personnel responsible for supporting new software solutions.
Assist Data Quality Analysts, Business and Systems Analysts, Business users, and Application Support Analysts with identifying, analyzing, prioritizing, and correcting production systems defects.
Minimum Required Skills / Competencies: Functional/Technical Skills:
4-6 years of experience designing and developing large-scale and complex Oracle SQL and PL/SQL
4-6 years Unix development experience.
4-6 years experience designing and developing Data Warehouse / Business Intelligence systems >= 5 Terabytes.
Oracle expertise in performance tuning concepts and practices involving large-scale complex databases:
Ability to interpret Oracle trace files
Experience with performance tuning utilities
Experience in SQL optimization techniques
Education: B.S. Computer Science or Management Information Systems or equivalent experience.
Preferred skills: Wireless and Retail Industry experience is a plus.
Sybase IQ or other columnar databases
Monitoring tools, especially HP BSM, Extrahop, Splunk, Wily
JMA - 6 months ago
About JM&A Group For more than 30 years, JM&A Group has helped automobile dealers achieve unsurpassed levels of finance and...