Job Description :
Position Description:
Background: The Ford Credit Enterprise Data Warehouse/Global Data Warehouse (EDW/GDW) is a special repository of data organized from an enterprise perspective and used for informational, operational and analytical purposes. Extract Transform and Load (ETL) processes move large volumes of data from multiple source systems into EDW/GDW and within various layers of the warehouse. The Ford Credit Management Information Systems (MIS) department is experiencing unprecedented demand for its services and at the same time is evolving from a legacy regional EDW structure to a common GDW structure. This position is for a software engineer with experience in delivering ETL solutions. The software engineer will have significant opportunity to contribute to Ford Credit’s migration to a GDW and an opportunity to learn various aspects of the Ford Credit business and IT processes. Specific position duties include: • Work with Business teams to understand requirements for PDO Backlog features and deliver ETL solutions with high business value using Agile. • Work with Data Architects (DAs) to define, create and modify EDW/GDW data models • Assist with analyzing commonality in EDW/GDW information models and identify needs for Extract, Transform and Load (ETL • Participate in PDO product team ceremonies such as Standups, Iteration Planning, Demo Days and Release Planning
Skills Required:
Must Have Skills: • ETL development experience with IBM InfoSphere (DataStage v11. 5) • ETL and development experience with Informatica PowerCenter • SQL experience involving multiple, complex queries • Good understanding of data modeling and data quality solutions for large programs • Exceptional analytical experience of complex applications and data relationships • Team oriented with strong interpersonal skills and able to work as part of a product team • Strong written/oral communication skills • Strong drive for results and ability to work independently • Self-starter with proven innovation skills • Demonstrated commitment to quality and project timing • Demonstrated ability to document complex systems • Demonstrated ability to multi-task and adjust resources/assignments based on changing priorities • Experience in creating and executing detailed test plans
Skills Preferred:
Must Have Skills: • ETL development experience with IBM InfoSphere (DataStage v11. 5) • ETL and development experience with Informatica PowerCenter • SQL experience involving multiple, complex queries • Good understanding of data modeling and data quality solutions for large programs • Exceptional analytical experience of complex applications and data relationships • Team oriented with strong interpersonal skills and able to work as part of a product team • Strong written/oral communication skills • Strong drive for results and ability to work independently • Self-starter with proven innovation skills • Demonstrated commitment to quality and project timing • Demonstrated ability to document complex systems • Demonstrated ability to multi-task and adjust resources/assignments based on changing priorities • Experience in creating and executing detailed test plans
Experience Required:
5+ years ETL development and integration experience with IBM InfoSphere (DataStage v11. 5) • 5+ years ETL development experience with Informatica PowerCenter • 5+ years SQL development experience
Experience Preferred:
Ford Credit experience a plus.
Education Required:
Bachelors degree in Information Technology or a related discipline
Education Preferred:
Additional Safety Training/Licensing/Personal Protection Requirements:
Additional Information :
"All Software Engineers are required to take HackerRank Coding Assessment: https://www. hackerrank. com/work/tests/325251/settings/access with a 60% score or 180+ out of a potential 300 points. "
Screen reader support enabled. To enable screen reader support, press Ctrl+Alt+Z To learn about keyboard shortcuts, press Ctrl+slash