Hi Partners,
Please check the below requirement and let me know if you have any consultants available for this position. *Need Local consultants only.* *ETL/SQL Developer* *Location: Phoenix, AZ* *Duration: 1+ Years* *Client: State of AZ* *Required skills/knowledge:* 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. -- *Thanks & Regards,* Narendra Prasad IT Murals 214-556-5774 x123 *naren...@itmurals.com <naren...@itmurals.com>* *narendra.a...@gmail.com <narendra.a...@gmail.com>* -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at https://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.