ETL Informatica Developer

Description

Job Description
Duties Perform analysis, design and programming to solve business and systems problems focusing on ETL, database usage and warehousing. Prepare detailed specifications from which programs are written to enhance the Banks IT processes. Submit specifications to senior staff members or management for review, and act as a resource to junior staff members. To be an independent contributor and manage assigned projects. Job Requirements 5 years plus experience in ETL programming and proficient in creating program specifications , to write, test, debug, document, and implement processes to extract data from a variety of data sources, transform the data, and load the data to specified destinations.
Must have some lead project/development experience.
Experience must include recent ETL SAP BODS experience. Additional ETL tools a plus.
Requires experience with RDBMS and Dimensional databases. Strong SQL experience. Any Data modeling experience is a plus.
Requires knowledge on multiple data sources/targets like (Excel, CSV, Flat file, Xml, Web services).
Requires knowledge in Change Data Capture (CDC) techniques like Slowly Changing dimension dimensions (type1, type2 & type3) and simple pass through mapping.
Knowledge and Strong Experience with the following databases MS SQL Server; Oracle; and Sybase IQ Requires experience in coordinating with Business Analysts, QA team, DBA team and End Users and systems admins at various stages of Software life cycle.
Technologies ETL tools SAP BODS (Data Services), Informatica, Data Stage
Databases MS SQL Server, Sybase, Oracle and Hadoop OS Unix, Linux, Windows
Scripting Languages Shell, Perl, Python
General Qualifications.