01Overview
Hyderabad
Project Duties
Help lead and manage project ETL assignments across multiple projects and multiple ETL developers, both onshore and offshoreDesign, develop, and test ETL processes per project Business Decision Documents (BDDs), following the development standards and best practicesWork directly with ERP SMEs and business users to translate requirements into technical specifications, data definitions, transformation logic, data flows and ETL processesWork with data architects and BI developers to architect ETL solutions that meet the business needsParticipate in code peer reviews with peers and support teams to ensure ETL applications and code process comply with Gates best practicesWorking 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 practicesStrong understanding of entire BI Analytics Environments/Toolsets, Data Warehouse Architecture and Design and Master Data Management conceptsSome knowledge of BI reporting and dashboarding tools such as Power BI, Cognos, Tableau or like toolsAbility to engage both business and technical teamsStrong organizational skills, interpersonal skills, and global acumen necessary to work as a part of a global and diverse teamA high attention to detail along with solid problem solving and troubleshooting skillsAbility to manage multiple project deliverables at once without missing deadlinesStrong 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) .
