Responsibilities
- Provide data integration architecture leadership 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, andpliance 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.
- Ensurespliance with applicable federal, state and local laws and all requiredpliance training. Maintains knowledge of and adhere to Flagstar's internalpliance policies and procedures.
Takes responsibility to keep up to date with changing regulations and policies.
Job Requirements :
- Bachelor's inputer Science, Mathematics or related field + 7 years of development experience preferred, or 10 yearsparable work experience required.
- 7 year's experience designing, developing, testing, and implementing Extract, Transform and Load (ETL) solutions using enterprise ETL tools or 10 years ofparable work experience reuired.
- 6 year's experience developing and implementing data integration and data warehouse solutions in an Oracle 11g / 12c database environment
- 2 year's experience working with Business Intelligence tools (IBM Cognos is preferred)
- 2 year's experience working in a Service- Oriented Architecture (SOA) environment
- 1 year experience in 10+ TB data environment.
- Expertise in Relational Database Management System, Data Mart and Data Warehouse design.
- Expert-level SQL and PL / SQL development skills in a multi-tier environment.
- Expertise in flat file formats, XML within PL / SQL, and file format conversion.
- Strong understanding of SDLC and Agile Methodologies.
- Strong understanding of model driven development.
- 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 tomunicate 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.
Job ID 14898
30+ days ago