• ETL Developer

    Job Locations US-DC
    Posted Date 7 months ago(1/3/2019 1:36 PM)
    Job ID
    # of Openings
    *Technical Consulting
  • Overview

    Acuity, Inc. seeks a dynamic, self-motivated ETL Developer to support our federal government client.  This role will be responsible for supporting and developing  ETL solutions across multiple verticals within the agency. They will be responsible for delivering high quality code. His/her work must be result oriented and focused on high quality, timeliness and scalability. The position will consult with end users to identify current reporting requirements in a fast paced team-oriented environment. This position could also include designing, coding, modifying, testing, debugging, documenting, installing, and deploying reporting systems.



    The ETL Developer's key duties and responsibilities include, but are not limited to, the following:

    • Develop ETL processes using DataStage v9.5+.
    • Work on enterprise datawarehousing environment to create ETL mappings, sessions and work flows using the ETL best practice methodology.
    • Understand multiple data sources like Teradata, Oracle, Sql server, xml and flat files and build ETL processes using the same.
    • Partner with different departments to understand processes and requirements to write ETL code.
    • Support DW ETL application across multiple verticals in the agency.
    • Help in creating documentation for application support for projects and new initiatives.
    • Prepare test cases and test ETL code to ensure high quality deliverables.






    • Bachelor’s degree (IT concentration), advanced degree.
    • At least 8 years’ experience with DataStage including administration and development (all components and stages) using DataStage v9.5+.
    • At least 5 years’ experience designing/implementing data warehouses and data marts (star schema, facts tables etc.).
    • At least 5 years’ experience in bash/shell scripting abilities on Linux variants.
    • Ability to reverse engineer undocumented and outdated designs, stored procedures, scripts and code.
    • Experienced in Developing DataStage jobs and coding using Java to support reporting and analytics.
    • Providing Tier III level support for the data warehouse environment (Data Stage, Oracle Stored Procedures (11g+), Unix Scripts).
    • Perform performance tuning and monitoring of the current architecture and daily loads. Recommend changes and improvements as identified and needed.
    • Contribute to the design and development of the Data warehouse system with up to date documentation including Data architecture, data model, DDL/DML scripts, stored procedures, and Standard Operating procedures etc.



    CLEARANCE:US Citizenship and the ability to obtain and maintain Public Trust suitability.


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed