Software Engineer Senior


Website Application Development

Position: ETL Developer

Duration: 24 months

Target Start Date: 01-JUL-2020 

Location Address: 1 American Rd.,DEARBORN, MI, 48126


Position Description:

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 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 migration to a GDW and an opportunity to learn various aspectsand 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:

  • ETL development experience with IBM InfoSphere (DataStage v11.5)
  • ETL 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



Nice to Have Skills:

  • Experience with Informatica MDM and IDQ
  • Experience in extract, transform and load (ETL) development with Teradata
  • Experience with AutoSys scheduling and Unix Shell scripting
  • Knowledge and experience with DB2/SQL, FTP, Connect Direct
  • Experience with mainframe languages/tools including COBOL, JCL, CA7
  • Experience with Java and API development
  • Experience with Rally



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



Education Required:

  • Bachelors degree in Information Technology or a related discipline


“All Software Engineers are required to take HackerRank Coding Assessment: with a 60% score or 180+ out of a potential 300 points.”

Upload your CV/resume or any other relevant file. Max. file size: 300 MB.

Recent Posts