ETL Developer

| Greater LA Area
Core Digital Media is a leader in online marketing and online consumer acquisition. Our websites LowerMyBills.com and ClassesUSA.com are fueled by an industry leading marketing platform which operates across a variety of financial and education markets working with more than 1,000 unique partners. We are focused on performance marketing and our infrastructure and process is second to none. We have a patented real-time optimization algorithm that allows for testing of over 1,000 creative per month and supports over 2 million decisions per day. We have also built out incredibly efficient proprietary deployment and tracking systems. Given the trajectory of the online advertising industry – towards more data elements being made available for modeling and more transactional channels becoming available – our Business Intelligence team is perfectly positioned. Core Digital Media continues to build on our analytical foundation, harnessing the power of a Teradata-based enterprise data warehouse.
We are currently seeking highly motivated DW/ETL Developer with a background in Business Intelligence/Data Warehouses and Informatica. The candidate will be responsible for supporting and developing DW ETL solutions across multiple verticals within the organization. The candidate will be responsible for delivering high quality code. His/her work must be result oriented and focused on high quality, timeliness and scalability.

Responsibilities:

  • Develop ETL processes using Informatica 8.x version or higher
  • Work on EDW environment to create ETL mappings, sessions and work flows using the ETL best practice methodology.
  • Support DW ETL application across multiple verticals in the organization to meet load SLA’s.
  • Understand multiple data sources like Teradata, Oracle, Sql server, xml and flat files and build ETL processes using the same.
  • Partner with different departments to understand processes and requirements to write ETL code.
  • Work on creating ETL processes using python for data processing, publishing/subscribing to Kafka and interacting with external API’s to download data as per business requirements.
  • Help in creating documentation for application support for projects and new initiatives.
  • Prepare test cases and test ETL code to ensure high quality deliverables
  • Provide data load support to all the data loads that happen in the EDW system. 

Required Skills:

  • Good knowledge in Informatica Powercenter
  • Good knowledge in Sql Programming
  • Good understanding of Data Warehouse methodologies
  • Able to produce business results in a fast-paced environment
  • Ability to translate the business process into effective ETL solutions
  • Experience in writing technical documentation for application support
  • Knowledge in Informatica Teradata load utilities is preferred.
  • Experience in Python is preferred.
  • Experience in languages like Scala and Java is a plus.
  • Knowledge of Apache Spark and Kafka framework is a plus.

Required Experience:

  • Bachelor’s degree is required
  • 2+ years of experience using Informatica Powercenter 8.x or higher
  • 2+ years of experience working in DW environments
  • Good to have knowledge in data profiling methodologies
  • Experience in working with Oracle and Teradata

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • GolangLanguages
    • JavaLanguages
    • JavascriptLanguages
    • PHPLanguages
    • PythonLanguages
    • ScalaLanguages
    • jQueryLibraries
    • jQuery UILibraries
    • Twitter BootstrapLibraries
    • AngularJSFrameworks
    • Node.jsFrameworks
    • SpringFrameworks
    • HibernateFrameworks
    • HiveDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • OracleDatabases
    • TeradataDatabases
    • KafkaDatabases
    • SparkDatabases
    • Google AnalyticsAnalytics
    • OptimizelyAnalytics
    • TableauAnalytics
    • R StudioAnalytics
    • MicrostrategyAnalytics
    • PythonAnalytics
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • After EffectsDesign
    • DreamweaverDesign
    • PremiereDesign
    • Adobe AnimateDesign
    • Adobe XDDesign
    • ConfluenceManagement
    • JIRAManagement
    • WordpressCMS
    • Microsoft DynamicsCRM

Location

We are located in West Los Angeles in the heart of Silicon Beach.
Playa Vista, CA 90094

Insider's spotlight

What’s the vibe like in the office?

CDM is unique in that it exists in a competitive, fast-paced, ever-changing industry and still maintains its collaborative, nurturing community spirit. People are encouraged to think creatively and take risks; the result is a group of people invested in and energized by the work they do.

Chelsea Fusco

Social Marketing Manager

What makes someone successful on your team?

The most successful people are flexible and open to new ideas. Our industry, and even our individual roles, are constantly changing, so an ability to adapt and pick up on new clients, new processes, and new company goals is essential. Successful teammates are constantly pushing themselves to do better and think of innovative ideas.

Tamara Newman

Campaign Manager

We are excited to be moving towards a micro services architecture which will allow us to create modular applications which are easier to build, maintain and deploy. We are re-architecting our front end to utilize newer UI frameworks. We are working on encrypting sensitive consumer data. We are also working on making our applications cloud ready.

Deepak Vashishtha

Sr. Director of Software Engineering

What are Core Digital Media Perks + Benefits

Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Child Care & Parental Leave Benefits
Flexible Work Schedule
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Perks & Discounts
Beer on Tap
Casual Dress
Company Outings
Game Room
Some Meals Provided
Parking
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
More Jobs at Core Digital Media10 open jobs
All Jobs
Dev + Engineer
Internships
Marketing
Product
Product
new
Core Digital Media
Developer
new
Core Digital Media
Marketing
new
Core Digital Media
Product
new
Core Digital Media
Product
new
Core Digital Media
Developer
new
Core Digital Media
Internships
new
Core Digital Media
Marketing
new
Core Digital Media
Marketing
new
Core Digital Media
Developer
new
Core Digital Media