Job Description: Job Summary Responsible for the design, development, and execution of automated and manual data Extract, Transform, and Load (ETL), integration, and exchange processes across the enterprise. Will recommend, implement, develop and utilize innovative tools and processes to efficiently, rapidly, and securely acquire, integrate, and provision large sets of data from and to thousands of sources. Responsible for the efficient, compliant, timely, and secure acquisition, integration, provision, and exchange of the enterprise data.
Provide data integration architecture assistance across the enterprise. Develop and document technical best practices for ETL-related activities including data movement, data aggregation, data quality, and data cleansing.
Work with the Data Warehousing and Business Intelligence team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations. Work with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models to determine appropriate ETL development solutions.
Create, execute, and document unit test plans for ETL and data integration processes and programs. Document ETL processes, programs and solutions as per established standards.
Monitor and administer automated and manual data integration and ETL jobs to verify execution and measure performance. Work with internal staff, vendors, consultants, and external partners to quickly identify and resolve data integration and ETL job issues. Assess and document the structure, quality, and compliance of data source data and coordinate with business and technology staff to identify and resolve issues.
Mentor other Data Management team members in the ETL tools, programs, processes, and best practices.
Ensure compliance with applicable federal, state and local laws and regulations. Complete all required compliance training. Maintain knowledge of and adhere to Flagstar's internal compliance policies and procedures. Take responsibility to keep up to date with changing regulations and policies.
Bachelor's in Computer Science, Mathematics or related field plus, 5 years of development experience preferred - OR - 9 years of comparable work experience
5 years' experience designing, developing, testing, and implementing Extract, Transform and Load (ETL) solutions using enterprise ETL tools
3 years' experience developing and implementing data integration and data warehouse solutions in an Oracle 11g/12c database environment
3 years' experience developing complex ETL jobs using a variety of stages from the IBM DataStage tool for large multidimensional data warehouses
1 year experience in 20+ TB data environment
Expertise in Relational Database Management System, Data Mart and Data Warehouse design
Expertise in flat file formats, XML and file format conversion
Strong understanding of SDLC and Agile Methodologies
Strong understanding of SQL and tuning of SQL queries
Strong understanding of ETL best practices
Proven strength in interpreting customer business needs and translating them into application and operational requirements
Strong problem solving skills and analytic skills with proven strength in applying root cause analysis
Expertise and hands-on experience in designing and building technical solutions using best practices and applicable technologies; an ability to demonstrate strong coding skills
Expertise in working with technical and business teams to extract and document data integration/exchange requirements
Ability to exhibit a strong understanding of business process
Ability to communicate verbally and in technical writing to all levels of the organization in a proactive, contextually appropriate manner
Strong teamwork and interpersonal skills at all levels
Dedicated to excellence in one's work; strong organizational skills; detail-oriented and thorough
Able to prioritize work by dividing time, attention and effort between current project workload and on-going support tasks
Must be willing to work overtime, including weekends, when required
Experience working with banking and/or mortgage data is preferred