We are seeking applicants for the following position:
Financial Senior Data Integration/ETL Lead (Community Loans of America): Primary duty to use Informatica v9.6 or later for data integration of complex queries, data flows and export/load mechanisms to consolidate and distribute business information for OLTP and warehouse platforms running on DB2 v9.7 or later, SQL Server 2008 R2, and Mysql v5.5. Secondary duties include designing, developing, and testing Actuate v11 reports in both E-Report and E-Spreadsheet forms and being team lead providing both business and technical guidance for 3 other people in a fast-paced environment. Additional duties include: Ability to quickly identify root cause and perform resolution for production issues. Work with external vendors on requirement gathering and issue resolution. Send, receive and post electronic communication methods such as email and text. Send, receive and post electronic payment methods such as ACH and Debit Cards. Will be on call one week every 4 weeks and always provide backup for on call support person.
Minimum requirements: Bachelor’s Degree or foreign degree equivalent in Computer Science, technology or a related engineering field and 5 years of experience in the job offered or 5 years of experience in a data management position. Experience may have been obtained concurrently and must include: (i) 5 years of exp designing, developing, and testing Informatica v10 flows, (ii) 4 years of exp writing complex SQL queries including full joins, correlated subqueries, and stored procedures, (iii) 4 years exp with Unix command line and shell scripts, (iv) 4 years of exp leveraging Kimball or Inmon Methodologies for dimensional modeling , (v) 3 years of exp being a technical team lead, (vi) 3 years of exp creating technical system software specification documentation, (vii) 1 year of exp working with each: JSON and XML, (viii) 2 years of exp designing, developing, and testing Actuate v11 reports in both E-Report and E-Spreadsheet, (ix) 2 years of experience in the financial lending reconciling general ledger data inconsistency issues.
Must have legal authority to work in U.S. Mail resume to: c/o C. Case, Community Loans of America, 8601 Dunwoody Place Suite 406, Atlanta, Georgia 30350
© Copyright 2019 CLA All Rights Reserved.