Sr. Data Developer
Flagstar Bank FSB

Troy, Michigan

Posted in Banking

This job has expired.

Job Info

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.

Job 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 (Data Stage/ETL Informatica Cloud) development solutions.
  • Responsible for the design, development, and execution of automated and manual data Extract, Transform, and Load (ETL Data Stage/ETL Informatica Cloud),
  • Responsible for administrating Snowflake Database.
  • Responsible in creating schema structure and all DDL/DML process in Snowflake Database.
  • Providing access to users to connect to Snowflake Database.
  • Responsible for the design, development and testing of Snowflake database
  • Responsible in Leading the team.
  • 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.
  • Ensures compliance with applicable federal, state and local laws and regulations. Completes all required compliance training. Maintains knowledge of and adhere to Flagstar's internal compliance policies and procedures. Takes responsibility to keep up to date with changing regulations and policies.

Job Requirements:
  • Bachelor's Degree or comparable work experience require.
  • 7 year's experience designing, developing, testing, and implementing Extract, Transform and Load (ETL) solutions using enterprise ETL tools (ETL Data Stage and ETL Informatica Cloud) or 10 years of comparable work experience.
  • 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.
  • 2 years' experience working as Snowflake administrator and Snowflake developer.
  • Complete understanding of ETL tools (Data Stage and Informatica using parameterization values designed to pass as variables to Jobs) and business intelligence reporting, with some exposure to Cognos and PowerBI.
  • Experience in bring Data market place data to Snowflake.
  • Knowledge in Cloud Solutions Architect.
  • Knowledge in tools like Power BI, AWS Sage maker, Dataiku, Snowpark and Alteryx.
  • 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 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.

For internal use only: Job Band D

This job has expired.

More Banking jobs

Wsfs Financial
Philadelphia, Pennsylvania
Posted 12 minutes ago

Wsfs Financial
Philadelphia, Pennsylvania
Posted 12 minutes ago

Wsfs Financial
Lansdowne, Pennsylvania
Posted 12 minutes ago

Improve Job Search

Subscribe to job alerts and add your resume to our resume database for employers!

Sign up now