(Zensoft IT Solutions, Inc. has openings in Northborough, MA) ETL Application Developer: Develop, create, and modify computer applications software and specialized utility programs. Design and create database objects in Oracle and Teradata. Develop the transformations using Informatica Power Center, Ab Initio and Teradata tools and utilities – BTEQ, FLOAD, MLOAD and TPUMP. Interact with business users, gather requirements, and translate user needs into functional and technical specifications. Implement ETL source to target mappings as per business requirements. Write unix scripts to automate the ETL code and automate the ETL process using Autosys or Tidal. Load data into Hadoop hive tables from Teradata warehouse. Support business during the UAT (User Acceptance Testing). Responsible for SIT (System Integration Testing), ETL objects, database object migration from Dev to QAT, and production deployment activities. Performance tune and optimize complex SQL queries, stored procedures and macros. Document issues resolved during different phases of the software development life cycle process. Will work in unanticipated locations. Requires Masters in Computer Science, Computer Engineering, Electrical Engineering, or related and 1 year experience or Bachelors in Computer Science, Computer Engineering, Electrical Engineering, or related and 5 years progressive experience. Send resume to Zensoft IT Solutions Inc., 27 South St Ste. 2B, Northborough, MA 01532.