Skip to main content
Header Autotrader

202202774

Senior Data Engineer, Informatica ETL

  • Hybrid work
  • Full time, Day
  • Travel: No

Job Category: Engineering / Product Development

Job Level: Individual Contributor

Division: Cox Enterprises

Location:

  • Atlanta GA
Apply Now

Description

Senior ETL Data Engineer
 

The Senior ETL Data Engineer is responsible for supporting the Cox Enterprises Data Platforms & Services team through the lifecycle of multiple large-scale data engineering projects for the company’s Human Capital Management (HCM) portfolio.  This role will drive a solution-based approach for the development of standardized Informatica Power Center solutions for the enterprise.  This role will help build and enforce ETL and Data Warehousing standards, guidelines, and processes to support the Business Intelligence Reporting and Analytics needs for the company’s HCM reporting function.  The Senior ETL Data Engineer will partner closely with Project Managers, Enterprise Architects, and Business Users to deliver solutions in support of the reporting and analysis needs for the HCM portfolio.

Core Technology Requirements:

  • Informatica Power Center (five years) with recent hands-on experience with:
    • Informatica PowerCenter
    • Informatica Developer
    • Informatica Data Management Cloud (IDMC)
    • Analytical SQL functions and PL SQL/SQL expertise (five years) of recent hands-on experience as individual contributor
    • Oracle Application Express (APEX)
    • Python, JavaScript, UNIX shell scripting
    • Data modeling

Specific Responsibilities:

  • Work closely with BI Architects & Development Teams to estimate levels of effort for ETL platform changes and work with the business community to set priorities
  • Help prepare requirements documents, functional and technical designs, test scenarios, and deployment plans related to ETL
  • Perform gap analysis as related to ETL processes and database table structures that populate based upon reporting and analytics requirements
  • Construct, manage, monitor, and support data integrations between multiple systems
  • Learn, understand, and apply enterprise architecture methods to ensure the proper use of ETL applications, platforms, patterns, technology stacks, etc.
  • Identify ETL architectural issues and propose alternative solutions as needed
  • Provide expert ETL knowledge of Business Intelligence solutions and Data Warehousing best practices
  • Incorporate vision as well as practicality in developing future state ETL designs
  • Design/build/support/monitor/tune ETL Execution Plans
  • Design/build/support/monitor/tune ETL and Data conversions and Data loads
 
  • Provide day-to-day production ETL support:
    • Perform release migrations
    • Tune and troubleshoot Informatica/ODI ETL processes
    • Modify, create, and customize mappings, workflows, and interfaces in Informatica Power Center
    • Help solve day-to-day problems with ETL stack as users submit problem tickets
  • Escalate issues to leadership appropriately
  • Follow SDLC processes and standards
  • Mentor team members

Required Qualifications:

  • Bachelor's degree in Computer Science, Engineering, or related discipline
  • Minimum five years IT experience
  • Minimum five years supporting ETL implementations using Informatica Power Center and IDQ
  • Knowledge of Peoplesoft and Workday HCM data subject areas, preferred
  • Data Warehousing:  Kimball methodology (five years)
  • Minimum five years of experience in a complex Enterprise Data Warehouse/Business Intelligence development environment
  • Understanding of Agile Software Development methodology
  • Experience in application design and implementation, distributed architecture and concepts, data manipulation and analysis using PL/SQL and SQL
  • Experience in developing code, test plans, expected results, and test data at a program level
  • Proven analytical and technical problem-solving skills
  • Proven track record of deploying large scale ETL/Data Warehouse/Business Intelligence systems
  • Demonstrated technical leadership in an IT organization 
  • Possess strong architectural leadership skills, and have a demonstrated ability to produce results in a large application environment
  • Excellent verbal and written communication skills for interaction with business users, solution owners, and development team members
  • Extensive technical knowledge of Business Solutions & ETL Architecture/Design
  • Experience with relevant office software, including Microsoft Office applications, MS Project, Visio, and MS PowerPoint
  • Solution-minded
  • ERP/Business Intelligence systems background

About Cox

Cox empowers employees to build a better future and has been doing so for over 120 years. With exciting investments and innovations across transportation, communications, cleantech and healthcare, our family of businesses – which includes Cox Automotive and Cox Communications – is forging a better future for us all. Ready to make your mark? Join us today! 

------------

Benefits of working at Cox may include health care insurance (medical, dental, vision), retirement planning (401(k)), and paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO). For more details on what benefits you may be offered, visit our benefits page.

Cox is an Equal Employment Opportunity employer - All qualified applicants/employees will receive consideration for employment without regard to that individual’s age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law.

Statement to ALL Third-Party Agencies and Similar Organizations: Cox accepts resumes only from agencies with which we formally engage their services. Please do not forward resumes to our applicant tracking system, Cox employees, Cox hiring manager, or send to any Cox facility. Cox is not responsible for any fees or charges associated with unsolicited resumes.

Apply Now

Our Benefits

We think you'll like what we have to offer. Here's just a sampling:

Our Awards

17x

National Workplace Awards

20x

Inclusion & Diversity Awards

16x

Regional Workplace Awards

8x

Environment & Sustainability Awards

There's a place for you

join our talent community

Sign Up