Lead analytics Engineer-ETL

People's United Bank Bridgeport, CT
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 Bank's IT processes. Document and maintain programs, utilizing knowledge and experience to confer with user representatives from across the Bank as well as vendors to gain an understanding of necessary changes to the Bank's applications. 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.

Employment Type

Full Time

Job Requirements

* Bachelor's degree in Computer Science, Engineering, Computer Applications, Software Engineering, or related field of study plus 5 years relevant experience.

* Experience must include use of an ETL tool and strong programming skills.

* Requires experience with RDBMS and Dimensional databases creating SQL queries. Experience with NoSQL databases 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.

* 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: SSIS, SAP Data Integrator, Informatica

* Databases: MongoDB, MS SQL Server, Sybase, and Oracle

* Programming Languages: Java, C++

* IDE: Eclipse

* OS: Unix, Linux, Windows

* Scripting Languages: JavaScript/JSON, XML, Perl, Python

* Methodologies: Agile, Design Patterns