- Relational Databases
- Data Warehouse
- Software Development
Being thoughtful on the current situation that is impacting global business, at GM Financial we have decided to stay connected with talented professionals for future opportunities. Help us proactively identify your profile for upcoming opportunities by applying to this open pipelining requisition: ETL Developer
Whether you are available now or looking for opportunities in the upcoming months, we encourage you to apply!
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.
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
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 and 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.
Should be familiar with: Windows, Unix/Linux, PL/SQL, Shell Scripting