Principal Engineer-DMP-Data Warehouse

Chennai, IN

Job Description / Skills Required

Build the best:

Would you enjoy working on one of the biggest and fastest ad-engines in the marketplace?

We are already serving audiences in the hundreds of millions and processing tens of billions of requests per month, and as the demand for our services is expected to multiply, you will be challenged with: scaling accordingly, developing new components, and seamless implementations allowing for zero downtime. (You code with the confidence, speed, and steadiness of a world class surgeon!)

You will be responsible for the lifeblood of the YuMe platform, and have the opportunity to be a superhero in the world of high-volume, real-time, open-source systems.

Responsibilities:
Contribute to new and ongoing data warehouse projects to achieve business goals.
Collaborate with engineers, product managers and product analysts to understand requirements and data needs and deliver them on time.
Ability to quickly adapt to changing priorities and generate innovative solutions in an extremely fast-paced environment.
Define and implement access control and security policies.
Design, develop, implement and maintain database objects like tables, views, and indexes; using normalization and de-normalization concepts.
Define/Adapt best practices; industry standards improve efficiency in operational and performance.
Develop & follow processes, policies and data security protocols.
Define and adhere to SLA for all data sets in allocated areas of ownership.
Ensure the quality and consistency of data and database systems by defining and following a defined set of procedures (change control, security procedures, access control, backups, etc)
Work with development teams or DBA's to review new databases changes or designs.
Propose and develop strategic database improvements in technical areas of database implementation, automated monitoring, support and enhancement

A Typical work day of an DMP Engineer
Work closely with PM Team to understand & analyze requirements
Create design documentation & review the same with the team
Collaborate with teams across geographies to finalize design documents
Create low level design & test case for the module/feature
Write code & work with version management tools
Own a feature/module & take it till go live
Should write & execute unit test cases
Should write & execute functional, integration test cases
Should write test cases for existing features (backlog)
Should contribute in code review & improve guideline documents
Should analyze & fix issues found post development
Actively contribute in supporting product on need basis
Participate in design review of other features
Needs to update & embrace self on latest happenings in the domain as well as the relevant technologies

Technical Skills
7+ years of Data warehousing, ETL, Reporting and administration experience working in an enterprise class production data warehouse environment and operations.
Hands on experience in fundamental of advanced enterprise data warehouse architectures.
Expert level experience and knowledge of advanced data warehousing database modeling (ERDs).
Excellence in SQL and experience of writing and optimizing complex queries.
Understand data discovery, data profiling, and source to target mapping methodologies.
Hands on and deep experience with dimensional data modeling and schema design.
Solid experience in custom ETL design, implementation and maintenance.
Experience in multiple database platforms Such as Oracle, MySQL etc).
Data warehouse appliances (Netezza, Greemplum,etc.) experience highly desirable.
Strong experience in Database development, DB Programming, Performance tuning, and Administration skills.
Proficiency in Linux is equally important with shell scripting experience.
Experience with Hadoop (MapReduce, Hive, and Pig).
Experience with Analytics suites like Tableau, MicroStrategy, Bussiness Objects, Cognos, etc.
Hands on experience with one or more of the following: Shell Scripting, Perl, Python, Java, BigData technologies and NoSQL Databases.
Experience in analyzing data, logs, and events to identify gaps, inconsistencies, and eventually opportunities.
Exceptional communication skills including the ability to identify and communicate data, and driven insights.
Ability to communicate back to business partners where data sources need to evolve and appropriate work around.
Ability and interest in managing and communicating data warehouse plans to internal users
Expert in root-cause analysis and issue resolution across complex database environments.
Proficiency in networking, IT infrastructure and enterprise security will be great advantage.
Experience in working with unstructured data, parsers would be great plus.

Education and Years of Experience

Bachelors in Computer Science or related field.
7+ years of experience in software development and full product life-cycles.
2+ years hands-on experience in Hadoop, Hive, Pig and/or other Big Data related technologies.

More Jobs at Yume