AFIS System Operator

Job Description

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

1. 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.

2. 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.

3. 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.

4. 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.

Disclaimer : 

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.