Project Duties: 

Help lead and manage project ETL assignments across multiple projects and multiple ETL developers, both onshore and offshore

Design, develop, and test ETL processes per project Business Decision Documents (BDD’s), following the development standards and best practices

Work directly with ERP SME’s and business users to translate requirements into technical specifications, data definitions, transformation logic, data flows and ETL processes

Work with data architects and BI developers to architect ETL solutions that meet the business needs

Participate in code peer reviews with peers and support teams to ensure ETL applications and code process comply with Gates best practices

Working closely with other onshore and offshore project developers to collaborate on ETL solutions assist and mentor junior offshore developers as needed 

Qualifications/Skills: 

• Informatica PowerCenter Development: 10+ years of experience minimum but likely more (most recent experience should be with PowerCenter ver. 10.x)
• Strong database and SQL skills with relational databases such as Oracle, SQL Server and/or Teradata (Teradata preferred)
• Expert knowledge in developing ETL/ELT(using Informatica PDO) and data integration solutions using Informatica PowerCenter utilizing ETL standards and best practices
• Strong understanding of entire BI Analytics Environments/Toolsets, Data Warehouse Architecture and Design and Master Data Management concepts
• Some knowledge of BI reporting and dashboarding tools such as Power BI, Cognos, Tableau or like tools
• Ability to engage both business and technical teams
• Strong organizational skills, interpersonal skills, and global acumen necessary to work as a part of a global and diverse team
• A high attention to detail along with solid problem solving and troubleshooting skills
• Ability to manage multiple project deliverables at once without missing deadlines
• Strong communication skills and the ability to work directly with other teams at Gates to understand and troubleshoot issues (ex. working with Oracle SME to understand how to source and transform data to meet the requirements)

Project Duties: 

Help lead and manage project ETL assignments across multiple projects and multiple ETL developers, both onshore and offshore

Design, develop, and test ETL processes per project Business Decision Documents (BDD’s), following the development standards and best practices

Work directly with ERP SME’s and business users to translate requirements into technical specifications, data definitions, transformation logic, data flows and ETL processes

Work with data architects and BI developers to architect ETL solutions that meet the business needs

Participate in code peer reviews with peers and support teams to ensure ETL applications and code process comply with Gates best practices

Working closely with other onshore and offshore project developers to collaborate on ETL solutions assist and mentor junior offshore developers as needed 

Qualifications/Skills: 

• Informatica PowerCenter Development: 10+ years of experience minimum but likely more (most recent experience should be with PowerCenter ver. 10.x)
• Strong database and SQL skills with relational databases such as Oracle, SQL Server and/or Teradata (Teradata preferred)
• Expert knowledge in developing ETL/ELT(using Informatica PDO) and data integration solutions using Informatica PowerCenter utilizing ETL standards and best practices
• Strong understanding of entire BI Analytics Environments/Toolsets, Data Warehouse Architecture and Design and Master Data Management concepts
• Some knowledge of BI reporting and dashboarding tools such as Power BI, Cognos, Tableau or like tools
• Ability to engage both business and technical teams
• Strong organizational skills, interpersonal skills, and global acumen necessary to work as a part of a global and diverse team
• A high attention to detail along with solid problem solving and troubleshooting skills
• Ability to manage multiple project deliverables at once without missing deadlines
• Strong communication skills and the ability to work directly with other teams at Gates to understand and troubleshoot issues (ex. working with Oracle SME to understand how to source and transform data to meet the requirements)