24 Nov
ETL Developer
Michigan, Dearborn , 48120 Dearborn USA

Vacancy expired!

  • FULL-TIME W2 or H-1B TRANSFERS ONLY. NO EXCEPTIONS!
  • NO THIRD-PARTY SUBCONTRACTORS OR EMPLOYERS, PLEASE!

Position Description: The Credit Management Information Systems (MIS) department is experiencing increased demand for its services and at the same time evolving from a legacy regional Enterprise Data Warehouse to a common Global Data Warehouse. MIS responsibilities include: • Development and support for the Enterprise Data Warehouse and the Global Data Warehouse • Providing integrated data services by loading data from multiple regions, applications and domains into one common format • Supporting data for Regulatory reporting and analytics that will enable data-driven decisions to create a competitive advantage for the company MIS has a Software Engineer position with experience in delivering ETL solutions. This is a terrific opportunity to become part of a global team, contribute to Credit’s migration to a GDW and to learn various aspects of the Credit business and IT processes.

Key Responsibilities: • Be a part of an Expedition product team and collaborate with a Product Owner, Product Manager, Anchor and software engineers • Work with Business teams to understand requirements for PDO Backlog features and deliver ETL solutions with high business value using Agile. • Assist with analyzing commonality in EDW/GDW information models and identify needs for Extract, Transform and Load (ETL). • Contribute to the migration from DataStage to Informatica Power Center, MDM/IDQ, and EDC • Work with Data Architects (DAs) to define, create and modify EDW/GDW data models • 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:• 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 .

Vacancy expired!


Related jobs

Report job