01Responsibilities
Responsible for all components related to ETL (Extract/Transform/Load) build project deliverables. Oversee Vendor work on build projects; review designs to ensure project requirements are met. Review and certify IT estimates, requirements, design, coding and testing deliverables. Oversee project validation (QA) and production promotion. Provide senior level expertise in technical disciplines used . Ensure compliance with Data Governance, architecture, technology and security standards set by SYF. Govern design strategy, production promotion processes, software change control specifically related to Ab Initio as well as DW technology. Drive effort to find ways to increase efficiency, minimize operating expense and improve performance of all data warehouses gather, store and deliver functions. Interface regularly with the SYF Data Warehouse applications. Proactive communication with regard to deliverable status, issues, barriers, or challenges. Ensure preparation and maintenance of appropriate technical documentation including but not limited to program design document, process flows and test plan. Participate in addressing IR's/ RCA's with Service Delivery team and provide direction in problem resolution. Qualifications/
02Requirements
Bachelors degree in IT, Computer Science or MCA with at least 6 years of experience in data management. Minimum of 6 years experience with ETL tools such as Abinitio. Working experience in Agile software development methodologies. Expertise and/or proficiency in the following: Unix Scripting, SQL, Software Version Control and Ab Initio. Preferred exposure to the following Ab Initio tools: GDE Graphical Development Environment; Co>Operating System; Control Center; Metadata Hub; Enterprise Meta>Setting; Enterprise Meta>Environment Portal; Acquire>It; Express>It; Conduct>It; Data Quality Environment; Query>It; Test Data Management. Solid understanding of Database and Datawarehouse concepts. Experience in Data Architecture and Data Modelling. Experience in Data Management within the financial services industry. Experience in Big Data and Cloud technologies. Excellent people skills with ability to influence clients, team members, management, and external groups. Superior oral and written communication, analytic and critical thinking skills . Desired Characteristics: Competent with data transmission protocols. Competent with data encryption methodologies. Competent with Agile methodologies. Ability to work independently and within a team setting. Ability to work in a dynamic environment and manage multiple assignments simultaneously. Robust working knowledge of Bank Card, PLCC and Consumer Lending Program Applications Expertise with Oracle/MySQL/Redshift databases. Familiarity with other ETL, Database, OS, Scheduling tools / languages. Willingness to learn new .
