*Title: ** ETL Developer* *Location: * * Washington, DC**Duration: **12 months with possible extension*
*Must-have skills: * SAS, ETL, Linux, Python, Perl, Amazon Redshift, Postgres, AWS Glue, Amazon S3 *Requirements:* - Experience using SAS to perform ETL (5+ years); - Experience developing and maintaining Linux shell scripting (5+ years); - Experience using Python to perform ETL functions (3+ years); - Experience using Perl to perform ETL functions (3+ years); - Experience working with applications using Amazon Redshift (or other Postgres- based databases) (2+ years); - Experience working with applications using AWS Glue (or similar) (2+ years); - Experience working with applications using Amazon S3 (or similar) (2+ years). *Responsibilities *include but are not limited to the following: - Update the delimited files using a text editor (e.g., WordPad or Excel); - Review the logs for any errors during execution; - Follow the instructions in the runbook to remediate the error; - Update the data refresh job schedule, if needed; - Execute the Bash scripts on a Linux terminal (provided by the OCC); - Copy data from the source location to the destination location; - Execute the data validation scripts; - Execute the SAS scripts to prepare the final product; - Output summary data (from the previous step) into either the existing Excel or Tableau format, based on the instructions in the runbook; - Update job schedule (using the IBM Process Manager) if needed; - Review the log on the Linux server for the server-side execution; - Re-start the process after addressing any issues (related to access, missing data, or lack of space); - Create a test plan if the scripts change (Bash, Perl and SAS); - Create unit, system, integration, and regression test scripts when modifying scripts. Thanks... Uday Varanganti Recruiting Specialist [email protected] O: (785)380 8559 -- You received this message because you are subscribed to "rtc-linux". Membership options at http://groups.google.com/group/rtc-linux . Please read http://groups.google.com/group/rtc-linux/web/checklist before submitting a driver. --- You received this message because you are subscribed to the Google Groups "rtc-linux" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rtc-linux/CAEmiLYu%3DunAe%3Dq-%3DDb3Of0ssXpPsGOv02sQ-2dtsChNEzFUZoA%40mail.gmail.com.
