ETL Developer

Definitive Logic
Arlington, VA
Sep 26, 2021
Sep 29, 2021
Full Time
Overview: We are hiring for a seasoned ETL Developer to join an existing project team in McLean, Virginia. The candidate must be able to handle a variety of tasks to support maintenance and enhancements of the data pipelines that feed a cloud-based data warehouse. The current ingestion mechanisms use Informatica PowerCenter, SQL, Shell Scripts. The candidate must be able to clearly communicate data model designs and ETL processes to users, report developers and other ETL developers. Responsibilities: Support and develop ETL processes to support data warehouse and reporting requirements.Develop ETL processes using Informatica PowerCenter, SQL and shell scripting to extract data from source systems, transform the data into the necessaryformat and load it into the data warehouse.Assess current processes to identify areas to optimize, improve or reduce risk.Develop technical design documents clearly explaining modifications to existing ETL processes and data models.Maintain existing ETL code. Qualifications: 5-7years of overall experience.Active DoD SecretClearance from the Federal Government.5+ years of solid professional experience with ETL and data integrationFluent with SQL and PowerCenterExperience with Extract, Transform, Load (ETL) data processing.Experience with AWS and PythonUnderstanding of data modeling practices using third normal form.Understanding of data warehousing and data lake principles.Ability to analyze and understand existing enterprise applications and databasesAbility to analyze and understand existing SQL scripts and ETL processes.Excellent verbal and written communication skills.Ability to adapt quickly in a rapidly changing dynamic environment.Ability to prioritize and multi-task across numerous work streamsDetail oriented with excellent follow through.Ability to deal with and resolve ambiguity.Ability to anticipate problems and take decisive action.B.S. or MS in Computer Science, engineering, or comparable work experience.DESIRED:Experience with USAF environments and systemsInformatica PowerCenter Data Integration Certification