ICF Consulting Group, Inc. ETL/Database Developer in Fairfax, Virginia
To support our growth, we re seeking an ETL/Database Developer who will extract, transform, and load (ETL) processing routines and data feeds to transmit data to and from clients and subcontractors; and create necessary data structures or data models to support data at all stages. The individual will work within a dynamic and fast paced environment to implement these solutions.
ICF s Information Insights (I2) team is comprised of experienced professionals with the skills required to unlock the power of governed data discovery. Our staff provides deep technical and business support for data acquisition, data analysis/data science, and interactive data visualizations. And with those skills, our team enables our clients to extract greater value from raw datasets that are varied in their composition, are growing at ever increasing rates, and can no longer be properly supported through legacy business intelligence and data visualization platforms. At its core, I2 helps our clients visualize their data in new and more informative ways than ever before by leveraging the latest in open source and commercial off the shelf technology stacks.
Citizenship is not a requirement for this position. A background check will be part of the process and employees may be asked to complete a Public Trust Clearance. The position is based in our Metro accessible Fairfax, VA office.
*Key Responsibilities:* * Design and develop ETL code as per requirements specifications and best practice guidelines * Unit testing ETL code to ensure it can be delivered and run in a system testing environment * Participation and contribution in quality assurance reviews of ETL components * Maintain accurate records related to data lineage * Perform tasks related to performance tuning of ETL jobs * Create data structures or data models that support data across all stages of the extract, transform and load (ETL) process.
*Basic Qualifications:* * Bachelor s degree(e.g., Computer Science, Engineering or related discipline) * 2 years experience developing database ETL environments with business intelligence applications such as Talend, Microsoft SQL Server Integration Services (SSIS), Informatica * 2 years experience in SQL and procedural programming * Understand ETL basic concepts of data flow, data enrichment, data consolidation, change data capture and transformation * Understand database concepts of referential integrity, indexes and keys and table metadata * Demonstrated experience showing strong critical thinking and problem solving skills paired with a desire to take initiative
*Preferred Skills/Experience:* * Proficient with data warehouse design and development and big data systems * Proficient with one or more programming languages such as Java or Python * Relevant MS or certification in relational database management system (RDMS) * Experience in reporting and data visualization technologies such as PowerBI, Tableau etc * Knowledge of Big Data integration tools such as Sqoop, Storm, and NIFI, Kafka a plus * Knowledge of DevOps tools like Jenkins/Git to assist development process * Familiarity with agile development process
*Professional Skills:* * Excellent listening, written, and oral communication skills * Ability to exercise independent judgment while effectively prioritizing and executing tasks while under pressure * Builds and maintains relationships with users to ensure buy-in and adoption of processes and solutions.ICF (NASDAQ:ICFI) is a global consulting and technology services provider with more than 5,000 professionals focused on making big things possible for our clients. We are business analysts, policy specialists, technologists, researchers, digital strategists, social scientists and creatives. Since 1969, government and commercial clients have worked with ICF to overcome their toughest challenges on issues that matter profoundly to their success. Come engage with us aticf.com. ICF is an equal opportunity employer that values diversity at all levels. (EOE Minorities/Females/ Protected Veterans Status/Disability Status/Sexual Orientation/Gender Identity).
Requisition ID: /1700001999/