What are the responsibilities and job description for the Full Stack Software Engineer – Teradata/ETL/DATASTAGE position at Ford?
**Shape the Future of Mobility**
Enterprise Technology plays a critical part in shaping the future of mobility. If you're looking for the chance to leverage advanced technology to redefine the transportation landscape, enhance the customer experience and improve people's lives, this is the opportunity for you.
About the Role
As a Full Stack Software Engineer – Teradata/ETL/DataStage at Ford Motor Company, you will develop and maintain ETL jobs and workflows to extract, transform and load data from various sources into Teradata data warehouse.
You will customize views and macros using Teradata tools, develop Unix Shell scripts and complex SQL queries, and deploy ETL Jobs (Parallel Jobs, Sequencers) using DataStage.
Key Responsibilities
- Develop and maintain ETL jobs and workflows to extract, transform and load data from various sources into Teradata data warehouse.
- Customize views and macros using Teradata tools.
- Develop Unix Shell scripts and complex SQL queries.
- Deploy ETL Jobs (Parallel Jobs, Sequencers) using DataStage.
- Participate in database design and development projects, including data modeling, ETL processes and SQL programming.
- Collaborate with data architects, developers, and business stakeholders to design and develop efficient data models and schemas in Teradata.
- Perform system and data analysis, troubleshoot issues, and identify and implement solutions to ensure the data integrity and quality of the data, processing, and analytics.
- Provide technical guidance in the design, development, and implementation of Teradata data warehousing solutions using IBM Infosphere DataStage ETL tool.
- Monitor and analyze system performance metrics and logs to identify potential issues before they become critical.
- Develop and maintain documentation of ETL processes, data mappings, and data dictionaries.
- Participate in code reviews and contribute to the development of coding standards.
About You
We are looking for a highly skilled Full Stack Software Engineer with expertise in Teradata, ETL, DataStage, Unix Shell scripts, and complex SQL queries.
You should have a bachelor's or foreign equivalent degree in Computer Science, Engineering, or a related field and 5 years of experience in the position offered or 5 years of experience managing data in Teradata data warehousing, data migration and ETL development, using Teradata SQL, utilities, and the following tools: BTEQ, FastLoad, MultiLoad, and TPT.
You should also have 5 years of experience creating Teradata data warehousing concepts, data modeling, and schema design; 2 years of experience developing data integration and ETL processes, including data mapping, and data validation; and 1 year of experience developing cloud-based data warehousing technologies and platforms, including Google Cloud Platform, Amazon Web Services, or Microsoft Azure.
What We Offer
We offer a competitive salary range of $134,992 to $174,097 per year, as well as a comprehensive benefits package that includes immediate medical, dental, and prescription drug coverage, flexible family care, parental leave, new parent ramp-up programs, subsidized back-up child care and more.
We are an Equal Opportunity Employer committed to a culturally diverse workforce. All qualified applicants will receive consideration for employment without regard to race, religion, color, age, sex, national origin, sexual orientation, gender identity, disability status or protected veteran status.
In the United States, if you need a reasonable accommodation for the online application process due to a disability, please call 1-888-336-0660.
Salary : $134,992 - $174,097
