Software Developer

at Ecclesiastes Inc in Newark, Delaware, United States

Job Description


Analyze clients’ data storage needs and current business logic, by reviewing their mainframe COBOL programs, CRM Data, Salesforce system, other existing data, etc. Develop and enhance data solutions for delivery of data. Collect, parse, manage and analyze large sets of data using Data Modeling Tools: ERWIN, Toad; Data Lineage Tools: IBM Metacenter; ETL tool: Informatica 10.2, SSIS 2016, Snowflake data Utilities latest in market, Database products: Snowflake cloud, Oracle 12g, SQL Server 2016 & Netezza, Scripting – UNIX, Python, Scheduling tools – Control-m; Programming Languages: Oracle PLSQL 12g, T-SQL SQL Server; Code Automation: Source Tree, GIT, Jenkins; Project Methodologies: Agile, KANBAN- Board, and Deployment components: UDeploy. Build and support snowflake infrastructure to drive and support business growth. Migrate Informatica - Netezza code base to Snowflake Infrastructure. Develop, automate and support complex applications to extract, transform and load data using Informatica, Oracle, Netezza, SQL Server & Snowflake infrastructure. Conduct preliminary testing of the warehousing environment before data is extracted. Deploy the code in lower environments and test the quality of the data and performance of the code. Conduct various tests on the new storage system once all the data has been transferred to ensure data migration integrity. Troubleshoot any issues and resolve performance of loads using tuning techniques in Informatica, Snowflake, Oracle & SQL Server. Provide maintenance/production support. Collaborate with the offshore team on development/maintenance activities for projects. Run monthly production releases, which involve analysis, development and execution of the data warehouse components. Use the service now tool to manage change requests. Code migrations using DEVOPS techniques like GIT, Jenkins & UDeploy tools.

HOURS: 40 hours/week; 9:00 a.m. - 5.30 p.m.


200 Continental Drive, Suite 401, Newark, DE 19713. Travel is not required but candidates must be willing to relocate to unanticipated work locations throughout the U.S. as required.

Copy Link

Job Posting: 1005324

Posted On: Jul 17, 2022

Updated On: Aug 17, 2022