AVP, Senior ETL Developer Cit
Pasadena, CA

Job Description

Overview

Founded in 1908, CIT (NYSE: CIT) is a leading national bank empowering businesses and personal savers with the financial agility to navigate their goals. We believe in helping customers turn their ideas into outcomes. Whether those customers are building a business or building their savings, CIT has the experience and agility to empower them to achieve their goals. At CIT, how we do business is just as important as what we do. Our social responsibility programs focus on driving financial and personal empowerment, supporting the environment and advancing wellness. CIT contributes to communities where we live, work and do business through charitable donations, community investments and employee volunteerism.

Responsibilities

The SQL/ETL developer will serve as a lead developer and data analyst who will be responsible for leading development team to understand business requirements, data analysis, design, build , test and implement functionalities for various business consumers. This role also includes supporting existing applications, enhancing existing applications, and implementing new feature functionality. Candidate will be responsible for leading and coordinating work with offshore development team on day to day basis. Individual will also be responsible for partnering will business analysts, project managers, SME's and QA team throughout the SDLC of the project for successful implementation. The candidate for this role will be expected to understand the business requirement documents to design and architect the processes and document the technical specification, test cases and deployment plans.

Qualifications

* 7+ years professional experience in database development using SQL Server 2008/2012(T-SQL, SSIS, SSRS)
* In-depth knowledge of relational database design, T-SQL, creating stored procedures, views, user defined functions and triggers
* Strong analytical and critical thinking skills, with ability to analyze business requirements to determine processing flow, user requirements and inter-dependencies of multiple information systems
* Strong problem solving skill with the ability to analyze and break down a problem to identify root cause
* Experience with SDLC required
* Experience with Agile methodology a plus
* Excellent verbal and written communication skills
* Strong in performance tuning especially tuning complex queries, procedures and indexing strategies
* Adapting ETL processes to accommodate changes in source systems and new business user requirements
* Working with both technical staff and business partners to translate requirements into technical implementations
* Bachelor's in Computer Science, related engineering discipline, or other related field

#LI-NK1

#LI-TD1