24 Nov
ETL Software Engineer Senior
Vacancy expired!
- 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
- 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
- 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 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
- 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
- Bachelor’s degree in Information Technology or a related discipline.
- Medical and Dental (Fast Switch pays majority of the medical program)
- Vision
- Personal Time Off (PTO) Program
- Long Term Disability (100% paid)
- Life Insurance (100% paid)
- 401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match
Vacancy expired!