Job Description:
Design high volume, repeatable data integration processes for large enterprise software and develop very complex data transformations.
Design, develop and support of secure and efficient data integration components, which will be used to move large amounts of data from source data and software application data stores into the optimized operational SQL databases.
Extract and document data integration/exchange requirements utilizing ETL tools SQL, Actian and Pervasive.
Provide ETL solution design during the data migration and data integration processes using SQL, Actian and Pervasive.
Develop systems documentation necessary to support ETL integration processes.
Troubleshoot development problems.
Create SQL, PL/SQL stored procedures, views and triggers in a high availability environment. Create processes for data validation and management using ETL tools and batch scripting.
Design high volume repeatable data integration processes for large enterprise software and develop very complex data transformations.
Work with an ETL development team throughout the SDLC process by developing LOE, solution design, monitoring deliverable milestones, code deployment and release sign off to SIT, SIT/UAT defect root cause analysis; leading the development of a data migration program for over 6 million borrowers and their relevant data in more than 250 tables to implement a data archival process; and creating processes for processing financial, new business, and other application related transaction using ETL, SQL SSIS, existing SOP and REST Web Services.
Create complex SQL, T-SQL, stored procedures, triggers, and functions; provide solutions approach to business and system requirements; create various processes for data validation, data management, data governance and file management using ETL SQL SSIS, T SQL, VB, Power Shell, Java and batch scripts; and design, development and support of secure and efficient data integration components, which will be used to move large amounts of data from source data and software application data stores into the optimized operational SQL and Oracle databases.
Extract and document data integration/exchange requirements utilizing ETL tools SQL, Pentaho, Informatica, Actian and Pervasive; provide ETL solution design during the data migration and data integration processes using SQL, Informatica, Actian and Pervasive; develop systems documentation necessary to support ETL integration processes; troubleshoot development and production problems across SQL and Oracle databases; create SQL, PL/SQL stored procedures, views and triggers in a high availability environment; monitor daily data transmission status from various sources and ETL loading activity into both ODS and data warehouse environments and ensure data governance and data quality; and create processes for data validation and management using ETL tools and batch scripting.
*Remote working benefits/telecommuting position. Can work from anywhere within the U.S.
More About Jonas Software:
Jonas Software is the leading provider of enterprise management software solutions to the Country and Golf Clubs, Foodservice, Construction, Fitness & Sports, Attractions, Salon & Spa, Education, Radiology/Laboratory Information Systems, and Product Licensing industries. Within these vertical markets, Jonas is made up of over 65 distinct brands, which are respected and leaders within their own domain.
Jonas' vision is to be the branded global leader across the aforementioned vertical markets and to be recognized by customers and respective industry stakeholders as the trusted provider of 'Software for Life' and as an ambassador for technology, product innovation, quality, and customer service.
Jonas Software is the valued technology partner of over 60,000 customers worldwide in more than 30 countries. Jonas employs over 2,000 skilled individuals consisting of a cross-section of industry experts and technology professionals. Jonas is headquartered in Canada and also operates offices throughout North America, the United Kingdom, Europe, Australia New Zealand and Africa. Jonas is a 100% owned subsidiary of Constellation Software Inc., headquartered in Toronto and traded on the S&P/TSX 60.
Business Unit:
Jonas Collections and Recovery - USA
Worker Type:
Regular
#J-18808-Ljbffr
