• ETL Developer

    Job Location US-DC-Washington
    Posted Date 2 weeks ago(10/28/2019 11:08 AM)
    Job ID
    Clearance Requirement
    Public Trust
  • Overview

    The Steampunk team is looking for a dynamic and experienced ETL Developer to join our Agile teams. Our client is engaging in a significant overhaul of its legacy IT environment and approach. As the ETL Developer, the ideal candidate will play a pivotal role in the planning and execution of this modernization effort. While working closely with senior Federal staff, Data Architects and the Business Analysts, the candidate will design and implement ETL processes to support migration of legacy data to a redesigned modern application. The customer has embarked on a major Digital Transformation initiative to reimagine the Grants Lifecycle Management process inlcuding streamlining key business processes. Our team is providing an architecture and infrastructure that is agile, flexible, scalable, and able to accommodate innovation for this and all future initiatives.


    • Design and implement industry best ETL technologies to satisfy client requirements.
    • Design and develop optimal code to maintain exceptional performance in processing large volumes of data.
    • Translate business requirements into technical specification.
    • Design, develop, and test ETL solutions and automating data loading processes.
    • Establish ETL environments according to project requirements.
    • Develop and implement an efficient migration process to move ETL objects from development to test and production environments.
    • Support the project team throughout the design, development and testing process.
    • Participate in all design reviews and requirement sessions, as required.
    • Support project documentation, as required.
    • Understand database design, programming concepts, data modeling, and framework management.
    • Communicate ideas to both technical and non-technical people in all levels of the organization.
    • Work with Business Analysts, Data Architects, Enterprise Architects, and ETL Architects to ensure business requirements are being met with the solution being developed.
    • Identify and reuse of ETL components and services to avoid duplicative implementations.
    • Mentor other team members in developing, documenting and modifying ETL components.
    • Develop advanced and complex ETL processes in the AWS GovCloud using the tools such as AWS Glue, S3, Python, SQL , MySql.
    • Support and administer the MySql database in the migration environment on the cloud.


    • BS or equivalent +6 yrs related experience, or MS + 3 yrs related experience.
    • Excellent written and oral communication skills.
    • 5+ years of working experience working with some industry leading ETL tools such as Informatica, ODI
    • 2 years of working knowledge of the AWS S3, Glue and RDS(relational data service) services
    • 4+ Years of working experience on the MySql, Oracle or any other RDBMS database.
    • A demonstrated history of working in large enterprise level applications.
    • Experience in working with database applications and SQL.
    • Full comprehension of SQL, cardinality, levels of granularity, normalized vs de-normalized, database optimization techniques and other such data architecture best practices is required.
    • Ability to work with various stakeholders with different technical abilities to gather data requirements.
    • Experience working in cloud environments.
    • Experience working in Agile development environments.
    • A track record of delivery in challenging, face-paced environments
    • Contract Requires US Citizenship
    • Must be able to obtain and maintain an Agency specific Public Trust clearance

    About steampunk


    Steampunk is a Change Agent in the Federal contracting industry, bringing new thinking to clients in the Homeland, Federal Civilian, Health and DoD sectors.  Through our Human-Centered delivery methodology, we are fundamentally changing the expectations our Federal clients have for true shared accountability in solving their toughest mission challenges.  As an employee owned company, we focus on investing in our employees to enable them to do the greatest work of their careers – and rewarding them for outstanding contributions to our growth. If you want to learn more about our story, visit


    We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. Steampunk participates in the E-Verify program. 


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