Software Engineer III

Job Description:Description: • Automation using shell scripting/BTEQ/Autosys to enhance ETL, data integrity and data processing to support the creation of Campaign and Marketing data marts• Support Data feeds with third party business partners that provides Marketing and data solution services.• Design and Architect solutions• Advanced knowledge of Mortgage systems• Develop SQL scripts using Teradata Utilities to integrate data from different sources such as Oracle, DB2, SQLServer.• Create and Execute detail test plan.• Coordinate with external teams to assure data quality and conduct integration testing.• Perform data analysis and data validation.• Participate in design review sessions.Required Skills: • 10+ years of experience with Reporting and Analytics to support Marketing• 10+ years of experience in the Finance Industry• Proficiency in Teradata - Experience in Shell scripting(BTEQ/Unix)• Strong SQL Skills.• Knowledge in DB2, Oracle and SQL Server.• Understanding of data modeling, database design and data warehousing.• Experience in working on development methodologies (Agile/SDLC) and application maintenance tools such as BTconverge, AIT, Maximo , Nexus, ALM and RequestNetDesired Skills: • Experience in reporting/data visualization tools Tableau, Business Objects and Qlikview.• Architect and SME(Subject matter Expert) for complex initiatives that can deliver end to end solutions.• Data Science certification or experience• Experience in Data ModelingShift:1st shift (United States of America)Hours Per Week:40Learn more about this role