ETL Architect - Chase Auto Finance Job Listing at Chase in NJ, New Jersey

Finance

Chase is a leader in the financial services industry, providing banking, mortgages, credit cards, loans, payment processing and investment services to 50 million customers - 1 out of every 6 Americans. As a division of JPMorgan Chase Co. (NYSE:JPM), we:

• Serve 21 million households with consumer banking relationships
• Lent $17 billion to small businesses in 2011
• Are one of the nation's largest credit card issuers, with more than 64 million credit cards in circulation
• Service 8 million mortgage and home equity loans

While we operate across a broad range of businesses, our mission at Chase is quite simple: to be the industry leader in customer service. Our employees put the firm's resources to work every day for our customers. Chase offers a dynamic environment and the training and support to meet your full potential. Our company is widely recognized as a great place to work, to grow and to invest for the future. Join our team. The Chase Auto Finance (CAF) Data Management Program is a multi-year technology initiative to support CAF and enterprise data management processes addressing operational, financial, regulatory and analytical reporting requirements. The program includes the long term development of a strategic platform for CAF with data sourcing, data enrichment, analytical, monitoring and reporting capabilities. This platform will also integrate with cross-LOB efforts to create a single consolidated customer view. The CAF Data Management team is looking for a highly motivated and experiencedETL Architect. The candidate must have solid understanding of data warehousing principles especially conceptual, logical and physical models as well as the business requirements.ETL Architectis responsible for designing and developingdata integration blueprint and adjusting ETL infrastructure (working with ICDW shared services team)to support the data warehousing solutions. The ETL Architect will be develop ETL standards and ensure adherence to the design.Will examine and understand of the business data requirements for creation of the appropriate ETL architecture deliverables. The individual will work with IT development teams to understand project requirements and their implication to Informatica Common Components. You will prioritize and manage development and implementation of enhancements/changes for all the ICDW informatica common components. Maintain and manage the enhancement and issues list for ICDW informatica common components. Also will manage the issue resolution process for any application production problems impacted by informatica common components. You will also assist the Application Development teams in day to day issues related to informatica development and answer the ICDW ETL Architecture questions. The role is heavily collaborative, working closely with several internal business units as well as a firm-wide organization driving standards and best practices and the candidate will have several years experience working in client-focused roles. Deployment will be on a Teradata platform so experience with this technology is essential. Knowledgeability of financial products, particularly those in the retail segment, is highly desirable. Key Areas of Responsibility: 1.Teradata specific ETL design a.PDO - Push Down Optimization b. Review all table definitions from TD tables from ETL perspective 2.Define Rules 3.Oversee SOR engagement 4.Define the end-to-end ETLSolutioning includingremediation processes 5.Define logical components a.Design Common components (icdw or for Auto) b. Design New components 6. Performance Tuning 7.Integration with Hadoop with Informatica, Kettle, Talend 8.Perform design reviews 9.ETL Automation