Experience in developing Hadoop
Required Data Modeling experience
Required experience in Hive, Oozie, Ambari, and Hive SQL
Required data warehousing experience
System Integration knowledge required
Netezza experience preferred
Retail experience preferred
Extract Transform Load (ETL) experience, bash scripting
Knowledge in Master Data Management (MDM) desirable
Experience with a BI reporting framework (such MicroStrategy,
MicroSoft, etc.) is a plus.
ESSENTIAL DUTIES AND RESPONSIBILITIES & CORE
Work with stakeholders to understand their information needs and
translate these into business functional and technical requirements
Design and develop service oriented applications that encompass
both ETL processes in the backend and the web service presentation
layer that are performant and scalable.
Analyze complex data systems and document data elements, data
flow, relationships and dependencies to contribute to conceptual,
logical and physical data models.
Perform thorough testing and validation to ensure the accuracy
of reports and transformations.
Ensure data quality and data governance create/maintain data
dictionary and related metadata.
Collaborate in the planning, design, development, test, and
deployment of new BI solutions.
Provide production support for new and existing BI solutions.
Resolve issues with reports and data as identified by users.
Ability to understand and effectively communicate at both a
business and technical level.
Good understanding of the challenge and various solutions in
handling large data volume, whether in terms of complex SQL queries
and stored procedures, or brute-force caching, or paradigms of
Experience in designing and deploying production supported
dimensional models, star schemas, and/or data marts.
Able to find creative solutions and move quickly to deliver
Strong ability to collaborate with team members throughout the
process and consult with other project teams on the design and use
of enterprise data.
Good written and oral communication skills and a desire to
educate co-workers and business users about our data and how to
Participates in systems design, working within an established
Performs coding and/or configuration to meet documented needs,
utilizing standard procedures and techniques.
Interfaces with business analysts and/or customers to clarify
Contributes to the development of test plans and participates in
Provide daily operational support for production systems
including providing on-call support.
"As a Lead, you are responsible for managing a small team of
analysts, developers, testers or engineers and drive delivery of a
small module within a project (Delivery/Maintenence/Testing) You
may serve as entry level specialist with expertise in particular
technology/industry domain/a process / application / product. You
are responsible for functionalechnical track of a project."