EDW Data Engineer

Job Description / Skills Required

Requisition ID: R15836
Grow As a Developer by Building Data pipelines

You became an engineer because you believed in technology’s ability to make a difference in the world. So why would you spend your days building things that don’t matter? At Groupon, we spend our days developing tools that help small businesses thrive in their local communities. We’re a technology company building products that positively impact the lives of the 49.1MM people and Groupon merchants that use them every single day. With thousands of employees across 15 countries, we operate at a global scale but still maintain a culture that inspires innovation, rewards risk-taking, and celebrates successes.

Grow your career by working for an international, multicultural company with thousands of employees that run data pipelines with 2000+ jobs. Quality of code, test coverage and scaling are not just words to get you to sign join us, those things are essential to the success of our system. We are growing our Data engineering team. We are re-engineering our ETL pipelines to be based on event based Streaming data. We are looking for data engineers with strong scripting (Python+Shell), Spark and SQL skill.

Responsibilities

Analyze & translate functional specifications & change requests into technical specifications.

Design, Develop, Implement ETL framework for Enterprise DW system.

Executing unit tests and validating expected results; iterating until test conditions have passed Translate business needs into end user applications.

Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution.

Troubleshoot and remediate issues impacting processes in ETL framework.

Modifying existing code to provide defect fixes for existing ETLs.

Coordinate and Collaborate with ETL team and business users to implement all ETL procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.

Provide support to all ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.

Keep abreast of the tools, techniques and components being used in the industry through research and applies this knowledge to the system(s) being developed.

Requirements

Hands-on experience with all aspects of designing, developing, testing and implementing ETL solutions

Packaging and release management.

Working knowledge with MPP systems

Knowledge of data modeling and designing databases

Ability to work in a fast paced environment on several projects

Solid understanding of SDLC, software best practices and Agile development methodologies

Strong analytical and diagnostic skills

Good knowledge of metadata, and using/managing metadata

Ability to develop and organize high-quality documentation

Take responsibility for performance tuning

Experience with data warehousing and star-schema (dimensional) data models a plus.

Working knowledge on Linux/Unix Operating systems

Hands on experience in Database technologies like Oracle, Mysql , Teradata or likes.

Strong scripting skills – python ( a big plus ), Perl , shell etc.

Knowledge of Big data systems – Hadoop , pig, hive, shark/spark etc. a big plus.

Excellent verbal and written communication skills

Groupon provides a global marketplace where people can buy just about anything, anywhere, anytime. We’re enabling real-time commerce across an expanding range of categories including local businesses, travel destinations, consumer products, and live or lively events. At the same time, we are providing advertising options and tools that merchants can use to grow and manage their businesses. Culturally, we believe that great people make great companies and that starting with the customer and working backward moves us forward. Community matters to us on an internal, local and global scale—it’s fundamental to our company’s growth and to the well-being of the world at large. We also value self-awareness, candor, lunch and WiFi. If we match with you, please apply to join us.