Comcast's Technology & Product organization works at the intersection of media and technology. Our innovative teams are continually developing and delivering products that transform the customer experience. From creating apps like TVGo to new features such as the Talking Guide on the X1 platform, we work every day to make a positive impact through innovation in the pursuit of building amazing products that are enjoyable, easy to use and accessible across all platforms. The team also develops and supports our evolving network architecture, including next-generation consumer systems and technologies, infrastructure and engineering, network integration and management tools, and technical standards.
Comcast Reliability Engineering is looking for a Senior ETL (extract-transform-load) developer (MuleSoft experience preferred) responsible for the design, development, and delivery of data from operational systems and files into a ServiceNow CMDB, ODSs (operational data stores), NoSQL Data Warehouses, and other downstream Data Marts. Familiarity with Network Principles (Devices, Topology, Transport, etc.) and related ITIL Foundations concepts are required.
This senior ETL developer will implement quality logical and physical ETL designs in the MuleSoft framework that have been optimized to meet the operational performance requirements for the ServiceNow CMDB as well as multiple other operational tools. Data accuracy, quality, and timeliness are critical KPI measurements for this role. This will include the implementation of sound architecture, design, and development standards. He/she has the experience to design the optimal performance strategy, and manage the technical metadata across all ETL jobs.
Develop and deploy ETL job workflow with reliable error/exception handling and rollback within the MuleSoft framework
Perform the unit testing, system integration testing and assist with user acceptance testing
Adapt ETL code to accommodate changes in source data and new business requirements
Document the ETL detailed design and test results
Prioritize development and enhancement requests
Spearheads development of ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures
Manages automation of file processing as well as all ETL processes within a job workflow
Ensures data quality throughout entire ETL process, including audits and feedback loops to sources of truth
Ensures compatible integration with the ServiceNow CMDB and other operational systems
Collaborates with subject matter experts, department leaders and consultants to define and execute cross-functional data movements for all aspects of Reliability Engineering
Knowledge and Skill Requirements:
Excellent ETL design and documentation skills
5 years' experience in managing data lineage and content creation pipelines
5 years' experience with ETL tool development; MuleSoft is preferred but will consider an individual with Informatica experience with an ITIL CMDB.
Expert ability in SQL, PL/SQL, NoSQL
Ability to handle multiple tasks and adapt to a constantly changing environment
Self-starter with the ability to work independently and take initiative
Ability to translate ideas and business requirements into fully functioning ETL workflows
Strong organizational, analytical, and problem-solving skills
Excellent written and oral communication skills, with the ability to articulate and document processes and workflows for use by various individuals of varying technical abilities
Knowledge of Network principles (Devices, Topology, Transport, etc.) required
- Bachelors Degree or Equivalent-Engineering, Computer Science
- Generally requires 7-11 years related experience
Comcast is an EOE/Veterans/Disabled/LGBT employer and all qualified applicants will receive consideration for employment without regard to age, race, creed, color, national origin, ancestry, marital status, affectional or sexual orientation, gender identity or expression, disability, nationality, sex or any other legally protected category.