ETL Developer

company banner
GM Financial
Developer, Architect, DataStage, Data Warehouse, Informatica, Tibco, Computer, Systems, IBM, Automotive, SQL, Oracle, Windows, Linux, PL/SQL, Shell Scripting
Full Time

Job Description

Overview

Reporting to the ETL Lead of Information technology, the ETL Developer is responsible for the loading, extraction, transformation, organization, and reporting of complex international data that spans 5 Latin American countries. The incumbent will have experience working with "large data" that spans several countries.

Responsibilities

  • Create complex data loading processes for Operational Data Stores, Data Warehouses and Data Marts that satisfy all functional and technical requirements.
  • Responsible for extracting data from various sources, transforming the data as required, and loading it to various target (ETL) database(s) and/or structures
  • Analyze and review complex object and data models and the metadata repository in order to structure processes and data for accuracy, efficiency, and maintainability
  • Work with various levels of project managers, data modelers, DBAs, and system administrators to design load processes and identify potential problem areas.
  • Collaborate with the Data Architect to understand, interpret, and implement complex data integration requirements.
  • Work with internal business clients to solve data integrity issues and ensure timely data availability.
  • Assist in data load monitoring and problem resolution. Take action to resolve recurring issues.
  • Serve as an expert for DataStage software development who can advise team on best practices, capabilities and limitations,
  • Act as SME to team in the plan, design, and delivery of BI and Data Warehouse solutions
  • Assess existing DataStage code and determine refactoring.
  • Advice on the application of standards/methodology practices to the project
  • Open to learn the new technologies like Informatica ,Tibco Data virtualization


Qualifications

Experience:
  • Bachelor's Degree or equivalent work experience in Computer Science, Information Systems, or other related field.
  • Minimum of Five years of experience with developing code using IBM's InfoSphere DataStage
  • Experience delivering BI and Data Warehouse solutions with both Dimensional and Relational modeling a plus.
  • Automotive Lending or Financial Services industry experience desired

Skills & Knowledge:
  • Minimum of Five years of DataStage (v8.5 and later versions)
  • Proven experience with SQL and relational databases (Oracle 11g preferred)
  • Solid design, coding, testing and debugging skills
  • Strong analytical and good communications skills
  • Knowledge of standards and practices in BI, Data Warehousing, ETL and DataStage
  • Ability to develop DataStage guidelines and standards
  • Excellent communication skills are essential.
  • Familiar with: Windows, Unix/Linux, PL/SQL, Shell Scripting

#LI-CH1



Company Information

GM Financial, a wholly owned subsidiary of General Motors, is a global provider of auto finance solutions, with operations in the U.S., Canada, China, and Latin America. We employ more than 9,000 hard-working team members in North America, and we're always looking for new people with diverse talents. GM Financial is a workplace where dedicated people have the opportunity to work together and celebrate our successes. Our culture is based on respect, integrity, innovation and personal development.
Dice Id : 10120555
Position Id : 2020-38024
Originally Posted : 1 month ago

Similar Positions at GM Financial

ETL Developer
  • Arlington, TX
  • 2 days ago