Data Engineer 4

Comcast brings together the best in media and technology. We drive innovation to create the world's best entertainment and online experiences. As a Fortune 50 leader, we set the pace in a variety of innovative and fascinating businesses and create career opportunities across a wide range of locations and disciplines. We are at the forefront of change and move at an amazing pace, thanks to our remarkable people, who bring cutting-edge products and services to life for millions of customers every day. If you share in our passion for teamwork, our vision to revolutionize industries and our goal to lead the future in media and technology, we want you to fast-forward your career at Comcast.

Job Summary

Responsible for designing, building and overseeing the deployment and operation of technology architecture, solutions and software to capture, manage, store and utilize structured and unstructured data from internal and external sources. Establishes and builds processes and structures based on business and technical requirements to channel data from multiple inputs, route appropriately and store using any combination of distributed (cloud) structures, local databases, and other applicable storage forms as required. Develops technical tools and programming that leverage artificial intelligence, machine learning and big-data techniques to cleanse, organize and transform data and to maintain, defend and update data structures and integrity on an automated basis. Creates and establishes design standards and assurance processes for software, systems and applications development to ensure compatibility and operability of data connections, flows and storage requirements. Reviews internal and external business and product requirements for data operations and activity and suggests changes and upgrades to systems and storage to accommodate ongoing needs. Work with data modelers/analysts to understand the business problems they are trying to solve then create or augment data assets to feed their analysis. Integrates knowledge of business and functional priorities. Acts as a key contributor in a complex and crucial environment. May lead teams or projects and shares expertise.

Job Description

Core Responsibilities
You work as a DWH Engineer on our DWH system

• You will migrate our current DWH system to the google cloud
• You will provide operational support of our DWH system in a 24/7 shift model ( on call support - including weekends and holidays) including CET timings daily.

• Experience in designing and developing Oracle objects such as Tables, Views, Indexes, Partitions, Stored Procedures, Triggers Functions in PL/SQL, Packages • You are developing, testing and maintaining DWH processes

• You participate in the planning and estimation, contributing to overall delivery • You actively document, record and share knowledge

• Working experience on collaboration tools like JIRA, Confluence • Should be able to troubleshoot issues around the application environment and come up with solutions.

• You are working in an international agile team
• You will be responsible for overall BI/DWH Production operations.
• Mentor Trainee Associate (Level 1) and Associate (Level 2/3)- Production Support to become more effective in their roles establish Ownership and Devops culture.

# DWH/SQL/PLSQL/Linux/Shell

• Must have very strong knowledge on DWH concepts.
• Must have very strong hands on experience in advanced SQL
• Must have very stong hands on experience in working with PL/SQL procedures
• Must have very strong hands on experience in writing and adjust complex sql,shell scripts

ODI (ETL or any Equivalent) • Must have strong experience in ODI Administration and Load Balancing. Should be able to configure Standalone and Java EE agents.

• Must have strong hands on experience in optimizing ETL processes using ODI's graphical interface.
• Must have strong experience in managing the ETL process, ETL control tables, error logging, auditing, data quality, etc Should be able to enrich/enhance
• reusability, parameterization, workflow design
• Must have strong experience in Fine tunning and enrich/enhance complex mappings, Process Flows and ETL scripts
• Must be well versed and have hands on experience in using and customizing Knowledge Modules KM
• Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents
• Must have strong hands on experience in using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects

Your Profile:

• University degree in Computer Science or equivalent work experience
• Strong knowledge of DWH concepts
• Strong experience in writing SQL/PLSQL queries
• Good knowledge in tools such as Jenkins, Git and Jira

• Strong knowledge of ODI • Knowledge on Big Data platform and tools Hadoop , Hive, Impala , scoop ,Spark is a plus

• Experience with the Google Cloud Platform (Composer, Dataflow, BigQuery) is a plus • Experience in working in an agile team is a plus

• Candidate must be capable of managing production issues independently and take ownership to resolve incidents end-to-end
• Should be able to interact across different teams for getting the task done.
• Knowledge of ITIL practices like Incident, Change, and Service and Problem management.
• Must be able to demonstrate the knowledge exchange through Reverse KT
• You are a team player, good in communication and love to work in an international team

Employees at all levels are expected to:
Understand our Operating Principles; make them the guidelines for how you do your job.
Own the customer experience - think and act in ways that put our customers first, give them seamless digital options at every touchpoint, and make them promoters of our products and services.
Know your stuff - be enthusiastic learners, users and advocates of our game-changing technology, products and services, especially our digital tools and experiences.
Win as a team - make big things happen by working together and being open to new ideas.
Be an active part of the Net Promoter System - a way of working that brings more employee and customer feedback into the company - by joining huddles, making call backs and helping us elevate opportunities to do better for our customers.
Drive results and growth.
Respect and promote inclusion & diversity.
Do what's right for each other, our customers, investors and our communities.

Disclaimer:This information has been designed to indicate the general nature and level of work performed by employees in this role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications.

Comcast is proud to be an equal opportunity workplace. We will consider all qualified applicants for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, genetic information, or any other basis protected by applicable law.

Base pay is one part of the Total Rewards that Comcast provides to compensate and recognize employees for their work. Most sales positions are eligible for a Commission under the terms of an applicable plan, while most non-sales positions are eligible for a Bonus. Additionally, Comcast provides best-in-class Benefits to eligible employees. We believe that benefits should connect you to the support you need when it matters most, and should help you care for those who matter most. That’s why we provide an array of options, expert guidance and always-on tools, that are personalized to meet the needs of your reality – to help support you physically, financially and emotionally through the big milestones and in your everyday life. Please visit the compensation and benefits summary on our careers site for more details.

Education

Bachelor's Degree

While possessing the stated degree is preferred, Comcast also may consider applicants who hold some combination of coursework and experience, or who have extensive related professional experience.

Relevant Work Experience

7-10 Years