AFIS System Operator (39508)
- Location
- Phoenix, AZ · On-site
- Job type
- Contract
- Level
- Mid-level
- Listed
- 23 days ago
Skills & highlights for this role
- ETL processes
- Windows PowerShell scripting
- SQL SELECT JOIN UNION queries
- XML file structure
Also useful
- Pervasive Data Integrator
- Control-M
- CGI Advantage ERP
About the role
Client has an ETL (Extract Transform Load) process that processes incoming flat files (text/csv, etc.) and loads them into an ERP system (CGI Advantage). It also extracts data from the system and sends them out as flat files. Sometimes the process does not produce the desired result. Typically, data received may not load into the system correctly or the extract may not contain the desired data. There can be various causes for this.
Candidate's main responsibilities will include determining the cause of data inconsistency (such as missing file, missing data in file, jobs that did not run..etc.), looking through log files and when needed, fixing the data. Fixing data will typically involve running or re running jobs inside the ETL workflow. Candidate may also be required to create ETL jobs from scratch that will involve Windows scripting/ SQL queries /use of an ETL tool.
Qualifications & Requirements
- Windows scripting:
- Be able to understand and write basic Windows PowerShell scripts. ETL jobs are basically windows script files and translation maps, and fluency in Windows scripting is important to understanding the workflow.
- Tasks candidate must be able to do with windows scripting - FTP / SFTP /Move/ Copy/ Delete/ Rename/ PGP encryption/decryption (with key).
- Candidate maybe shown windows scripts and asked to explain what they do and/or make modifications.
- SQL:
- SQL queries are used to extract data from the ERP system. Candidate should be able to write basic SQL queries involving Selects, Joins, Unions, etc. Candidate may be asked to write simple queries on the board.
- We use MS SQLSERVER, so experience with SQLSERVER and SQL Server Management Studio is a plus.
- XML:
- Flat files are translated into XML which are then imported into the system. Quite often we have to look at the XML to check for data correctness.
- Candidate should have thorough understanding of XML file structure.
- Basic knowledge of an ETL process
Nice to have
- Prior experience with an ETL tool and/or ETL workflow. We use a tool called PDI (Pervasive Data Integrator) Map Designer. Knowledge of PDI Map Designer will be a big plus.
- Experience with Control-M. Control-M is a windows job scheduler and data fixes will typically involve running jobs from Control-M. This requirement is not a necessity as candidate can be trained on its use.
- Any experience with ERP systems.
Knowledge, Skills, and Abilities
- Excellent analytical, critical thinking and problem solving skills.
- Proficiency with computer software such as MS Office Excel, Word and Outlook.
- Skill in oral and written communications, establishing working relationships with others, effective decision making and conflict resolution.
Additional Information
Additional Information
- "All your information will be kept confidential according to EEO guidelines".
- All candidates who are authorized to work in US are encouraged to apply.
- Candidates must clear the Background check prior to commencing the assignment.
Third Party Candidates
Email your candidate/s resume to joseph dot shelton at idealforce.com along with the following details: Rate, Current location and Availability.
About the Company
IDEALFORCE has a CONTRACT position available immediately for a AFIS System Operator to join our customer in Phoenix AZ. This is an ONSITE position. Please find below additional details about this job. Kindly respond with your most up to date resume if you would like to pursue this opportunity. Client is considering only LOCAL CANDIDATES for this position.
Equal opportunity and legal notices
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.
From IDEALFORCE LLC's careers page, first listed on Rolev.ai on October 17, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this AFIS System Operator (39508) role at IDEALFORCE LLC, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
More at IDEALFORCE LLC
All IDEALFORCE LLC jobsCommon questions
Where is the AFIS System Operator (39508) job at IDEALFORCE LLC located?
This AFIS System Operator (39508) position at IDEALFORCE LLC is located in Phoenix, AZ (On-site). Always check IDEALFORCE LLC's application page for specific state eligibility or relocation policies.
What qualifications are required for AFIS System Operator (39508) at IDEALFORCE LLC?
For the AFIS System Operator (39508) role, IDEALFORCE LLC highlights experience with ETL processes, Windows PowerShell scripting, SQL SELECT JOIN UNION queries, XML file structure. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the AFIS System Operator (39508) position at IDEALFORCE LLC?
This listing links directly to IDEALFORCE LLC's SmartRecruiters application page. You can apply directly on IDEALFORCE LLC's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.