Solution Engineer (Data Warehouse)

Description

Job Summary Individual contributor responsible for administration, configuration and management of Teradata Databases and application servers environments that may include multiple operating system platforms and network topologies. Job Requirements Responsibilities The Sr. Technical Consultant Solution Engineer (Data Warehouse) will Work with BAs to analyze functional requirements as well as the functional design processDesign an endtoend solution to enable the functional process. Lead and work closely with ETL and BI development team to implement the solutionTake ownership of creating Logical and Physical data model during solution design phaseLead the development strategy to support current and future needsWork closely with App DBA, BI Admins, ETL Leads to achieve maximum efficiency and performance of the EDW ecosystem.Ensuring architectural alignment of the designs and developmentEstablish quality processes to deliver a reliable, stable and supportable solutionRecommend and participates in EDW system upgrades, migrations and retirement.Evangelize selfservice BI and visual discovery while helping to cultivate and nurture mobile/dashboard culture.Champion data quality, integrity and reliability throughout the department by designing and promoting best practices.Work closely with EDW manager to ensure prioritization of organizational and departmental objectives and projects.Provide assistance to EDW team members with issues needing technical and/or functional expertise or complex systems and/or programming knowledge.Provide on the job training for new or less experienced team members. Required Skill Set 10+ years of experience delivering EDW Solutions using below toolsETL ODI, cron shell scripts, SSISDatabase Teradata, Oracle, SQL Server, Strong SQL skillsDistributed Storage Technologies Hadoop (Hortonworks), Map Reduce and HiveBI tools Microstrategy, TableauProgramming Languages C++, C#.NET (3.0 and later), JAVAIDE Visual Studio (2010 or later), Eclipse (Mars or later versions)Strong experience of data modelling techniques for ETL design and BI MetadataMust be knowledgeable of S/W as Service, H/W as Service delivery modelMust have experience of architecting and implementing mobile solution for analytics and reportingMust be knowledgeable in software development lifecycles/methodologies (SDLC) (agile and waterfall)Must have strong presentation and collaboration skills and can communicate all aspects of the job requirements, including the creation of formal documentationMust have strong problem solving, time management and organizational skillsMust able to work handson ETL and BI technologies