Core Digital Media
Core Digital Media empowers you to make smart financial decisions related to life's biggest moments
Hybrid

ETL Developer

Sorry, this job was removed at 4:59 a.m. (PST) on Thursday, July 5, 2018
Find out who's hiring in Greater LA Area.
See all Developer + Engineer jobs in Greater LA Area
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

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

See More
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

What are Core Digital Media Perks + Benefits

Core Digital Media Benefits Overview

Core Digital Media provides its team members a comprehensive benefits package that includes medical, dental and vision coverage, 401K matching (we match 100% up to 3% of your contribution), Team Member Stock Purchase Plan, annual bonuses, unlimited PTO plan, in-office yoga and HIIT classes, in-office massages, lunch provided twice per week, healthy snack options, beer on tap and much, much more.

Culture
Volunteer in local community
Core Digital Media believes in giving back to the community where we live and work. We participate in a variety of charity efforts such as LA Food Bank, Wounded Warriors Project, Angel Tree Toy Drive
Partners with nonprofits
OKR operational model
Team based strategic planning
Open office floor plan
Employee resource groups
Employee-led culture committees
Quarterly engagement surveys
Hybrid work model
In-person all-hands meetings
Summer hours
Flexible work schedule
Remote work program
Diversity
Mandated unconscious bias training
Diversity employee resource groups
Hiring practices that promote diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability insurance
Dental insurance
Vision insurance
Health insurance
Life insurance
Pet insurance
Wellness programs
Team workouts
Mental health benefits
Wellness days
Financial & Retirement
401(K)
401(K) matching
We match 100% up to 3% of the employee's contribution with a 4 year vesting period
Employee stock purchase plan
Performance bonus
CDM's performance bonuses are paid quarterly or annually depending on the role you are in. We also give quarterly awards to those nominated by leadership as well as their peers
Charitable contribution matching
Child Care & Parental Leave Benefits
Childcare benefits
Generous parental leave
Vacation & Time Off Benefits
Unlimited vacation policy
Generous PTO
Paid volunteer time
Paid holidays
We offer 10 paid holidays
Paid sick days
Flexible time off
Office Perks
Company-sponsored outings
Free daily meals
Free snacks and drinks
Some meals provided
We bring in lunch on Wednesdays and breakfast every Thursday morning
Company-sponsored happy hours
Onsite office parking
Pet friendly
Recreational clubs
Home-office stipend for remote employees
Meditation space
Mother's room
Onsite gym
Professional Development Benefits
Job training & conferences
Tuition reimbursement
Lunch and learns
Promote from within
Continuing education available during work hours
Online course subscriptions available
Customized development tracks
Paid industry certifications

More Jobs at Core Digital Media

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about Core Digital MediaFind similar jobs like this