*Need - Local Candidates* *Direct client*
*Position: ETL Developer* *Location: Phoenix AZ* *Duration: 6+ Months* *Project Background:* 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. *Required skills/knowledge:* *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. Thanks & regards, Ankush Chaudhary Team Lead Recruitment Email: [email protected] Advent Global Solutions, Inc. 12777 Jones Road, Suite 445, Houston, TX 77070 -- You received this message because you are subscribed to the Google Groups "Exact Match" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/exact-match. For more options, visit https://groups.google.com/d/optout.
