Senior Oracle Developer

Overview

Analyst III - ABS Data Analytics & Reporting, Finance is a critical technical role within the GMF North America Securitization and Conduit Reporting team. This position will design process improvements, create SQL reports, write functional specifications, develop and test system plans, document processes and programs, advise users on program use, and resolve production problems. This position involves a high level of coordination with other departments and third-party software vendors.

Responsibilities

Job Duties

• Analyze Data to troubleshoot process problems and drive process improvement
• Define functional requirements including requests for new reports or system enhancements
• Translate complex requirements into business requirements/functional specifications documents in coordination with the data warehouse teams
• Understand data warehouse design and data modeling
• Develop SQL,PL SQL, Access, Cognos queries to manipulate analyze and report on large data sets
• Data extraction, creation, manipulation of multiple files and or databases
• SQL/PL SQL code tuning and Query optimization
• Responsible for the analysis, design, development and maintenance of ETL processes and applications using SQL and ETL tools
• Responsible for evaluating the use of data, ensures the accuracy and accessibility of all important data following enterprise data standards
• Responsible for supporting the design/construction using data modeling concepts and implementation phases of a system and/or upgrade project
• Responsible for creating ad hoc queries or reports to extract data from disparate databases or data sources and analyzes data to produce dashboards, metrics, or insights and identify trends or anomalies
• Responsible for interprets data, analyzes results using statistical techniques and provides ongoing reports
• Responsible to acquires data from primary or secondary data sources and maintains databases/data systems
• Involve in SIT/UAT testing and identifying data quality issues
• Monitor the production reporting environment on daily and monthly basis
• Find and correct operational errors, determine how to design system enhancements and test programs and systems
• Keep up to date on current technology through training and outside materials
• Data Analytics to analyze data and make business decisions based on the data
• Perform other duties as assigned
• Conform with all company policies and procedures

Reporting RelationshipsABS Reporting Systems Manager

Qualifications

Knowledge

• Advanced working knowledge of developing Oracle PL SQL
• Advanced working knowledge of ETL/Data warehousing Concepts
• Advantage working knowledge on design, testing and implementation on Oracle/Cognos objects
• Advanced working knowledge of Oracle accounting software
• Working knowledge on Data mining/analysis, Data governance and data architecture and reporting
• Working knowledge on Azure services such as GIT preferred
• Experience with translating business requirements into system functional and non-functional requirements
• Knowledge of big data concepts and cloud technologies preferred
• Knowledge of data virtualization concepts
• Knowledge of GM Financial's core business functions
• Working knowledge of the consumer loan business
• Working knowledge of all system applications
• Working knowledge of the corporate business solution environment
• Significant experience in a large and complex business environment
• Knowledge on enterprise IT infrastructure

Skills

• Ability to establish priorities and meet tight deadlines
• Solid design, coding, testing and debugging skills
• Excellent problem-solving skill
• Advanced oral and written communication skills
• Ability to interact collaboratively with internal customers
• Capable of managing multiple and varied projects, including ability to coordinate and balance numerous tasks in a time-sensitive environment, under pressure, meeting deadlines
• Demonstrated quantitative skills and data Analytical skills
• Proven ability to quickly learn new applications, processes, and procedures

Education

• Bachelor’s Degree in Information Systems, Computer Science, Finance, Business, related field or equivalent work experience required

Experience

• 5-7 years Oracle PL-SQL/SQL required
• 3-5 years Informatica or ETL tool required
• 2-3 years Cognos or any BI reporting tool preferred
• 0-2 years UNIX shell scripting preferred
• Automotive Lending or Financial Services industry experience preferred
• Experience delivering BI and Data Warehouse solutions with both Dimensional and Relational modeling preferred