Senior ODI Developer

Summit2Sea Consulting
Arlington, VA
May 14, 2022
May 17, 2022
Full Time
Have you been looking to shift your career into high gear? This is your opportunity to take your ambitions and convert them into a solid career in a supportive and innovative environment!Summit2Sea is looking for a Senior ODI Developer.Summit2Sea is a technology consulting firm run by hands on technologists that combines people, process and technology to deliver innovative solutions to our clients. Summit2Sea has been included in The Washington Post's annual list of top workplaces for the 2nd year in a row. We invest in our biggest asset - our people! You can be a part of a winning team that will support your career growth.Impactful Work You'll Do:Provide guidance and architecture development work for ODI workflowsDefine and execute a robust development and testing plan to ensure all client requirements are met, while encouraging the team to continuously innovate and streamline the data quality assurance/testing processesLead our business owners/experts and the project team through structured analysis, testing, validation, and review processes for the solutions being implementedAdminister change management configurations needed throughout the developed applicationsCollaborate with small, dedicated team to improve overall agency financial reportingDeep dive with the team on necessary deliverables and enjoy the challenge of teaching and learning from others around you Role is currently remote due to COVID-19RequirementsMust Have:Ability to represent and uphold our core values of integrity, client service, expertise, adaptability, communication, and teamwork3+ years experience with Oracle Data Integrator (ODI) and ETL tools and procedures, Oracle Business Intelligence (OBIEE), business process review, testing and data quality assurance activities Strong experience with ODI, mapping, integration, etc Demonstrable experience with Oracle ODI development tools with extensive experience in PL/SQL coding, troubleshooting, and performance tuning and Oracle 19cExtensive development experience in ODI to Extract/Load/Transform data from multiple sources such as Oracle, MS SQL Server,DB2, Legacy systems, Flat Files, JSON and XML Files into ODS and EDW (Enterprise Data Warehouse) systemsGood knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis ServicesAbility to create necessary database schemas and users with proper privileges assigned leveraging scripting mechanismDirect hands on system administration experience with EPM software during implementation and post production support (OneStream, Anaplan, Hyperion) Experience implementing and administering EPM software platforms (OneStream, Anaplan, Hyperion)Experience with Windows server configurations for EPM foundational elementsFinancial Systems administration, maintenance, and training of Hyperion Financial Management and Hyperion Planning ModuleUnderstanding of one or more of the following technologies: Hyperion Financial Reporting, Calc Manager, Smart View, Essbase Admin Studio (EAS), Hyperion Planning, Data Relationship Manager (DRM)Build, deploy & provide back-end and user support for infrastructure, including: Linux workstations and servers, networking equipment, firewalls, VMware based virtualization clustersExperience with Federal Planning, Programming, Budgeting and Execution (PPBE) processAbility to obtain a Public Trust clearanceNice to Have:The ability to lead people, process and technology changeMicrosoft Azure Managed Cloud Services experienceAWS experienceOracle and SAP experience a plusData conversion experienceBenefitsUpper Tier Compensation includes a base salary and bonuses based upon: performance, business development, employee referrals and knowledge sharing. We value the individual and share our company's success across our team.Summit2Sea is committed to offering our employees a benefits package that is competitive and comprehensive enough to meet their goals and needs. As a valued member of the S2S team, employees are provided with a collection of benefits to include paid holidays, health and dental care to name a few.?Compensation ComponentsCompetitive Base SalaryQuarterly Recruiting BonusNew Sales BonusKnowledge Contribution BonusBenefit ComponentsPaid HolidaysVacation/Sick Leave/Personal Time OffHealth InsuranceDental InsuranceLife Insurance401KSummit2Sea Consulting is an Equal Opportunity Employer (EOE) and E-Verify employer. Qualified applicants are considered for employment without regard to age, race, color, religion, sex, national origin, sexual orientation, disability, or veteran status. If you need assistance or an accommodation during the application process because of a disability, it is available upon request. The company is pleased to provide such assistance, and no applicant will be penalized as a result of such a request.