ETL Developer - Washington, United States - ITCO Solutions, Inc.

ITCO Solutions, Inc. Washington, United States

3 weeks ago

Technology / Internet

Description

100% onsite location G St, NW Washington, DC 20006.

Does not want SQL ETL developers

Want only Oracle ETL Developers

Requires Bachelors degree

Professional Level Information:

As an Engineer 1, your duties may include assisting in the design, development, and testing project components, identifying problems and discovering solutions, working on ongoing projects based on specifications or drawings, and collaborating with teams of other engineers. Typically performs multiple engineering-related tasks in various assignments within the project and firm. An Engineer, 1 has strong technical skills and background, a knack for learning new technologies, and a blend of good problem-solving and innovation needed to resolve a wide variety of technical production challenges.

Functional Job (LCAT) Information:

Develops, implements, refines, and supports a data warehouse used for analytics and reporting, optimizing ETL processes while working closely with Business Analysts, Business Managers, Project Managers, and internal customers.
Designs, codes, runs tests, and implements complex programs and scripts, and performs source-to-target data mapping.
Reviews and implements project plans and business rules via stored procedures, middleware, or other technologies.
Backs up the Senior ETL developer with providing rotational after-hours support. The ETL Developer may be required to work evenings or weekends.

Responsibilities:

Be available on government site in Washington DC Monday – Friday during normal working hours and support after-hours remotely when needed.
Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.
Data Modeling design, analysis and implementation - conceptual, logical, and physical data modeling, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence.
Installing, configuring, developing, supporting and maintaining of the BI APPS. Environment or higher: OBIEE 12c, BI Apps.9.6.3, Web Logic Server, Informatica 9.0.1, Oracle , SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP.
Developing ETL's using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
Designing schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Building Business Model and established relationships & Foreign Keys (Physical & Logical) between tables.
Creating LDAP authentication to enable Single-Sign on for Users in Development environment leveraging Analytics Repository.
Using Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
Providing recommendations and identifying critical issues and processing faults as it pertains to data modeling, ETLs and Informatica.

Requirements:

Bachelor's Degree in technical discipline, 8 additional years of experience considered in lieu of degree.
5+ years' experience in ETL tools, especially Informatica and data warehousing applications.
5+ years' experience developing and tuning complex SQL queries in Oracle relational database. Ability to work collaboratively with cross-functional teams and adapt to changing requirements.
Prior experience in a federal data warehouse and understanding of government procedures and regulations is preferred.
Must be authorized to work for any employer in the U.S.
Must be able to obtain and maintain the required security clearance.

ETL Developer

3 weeks ago

Amida Technology Solutions Washington, United States

Amida Technology Solutions is a DC-based software services company focused on the most difficult problems in data interoperability, exchange, governance, and security. We design, develop, and deploy software solutions that collect, reconcile, and transform data for business intel ...
ETL Developer

2 weeks ago

iTCO Solutions Washington, United States

100% onsite location G St, NW Washington, DC 20006. · Does not want SQL ETL developers · Want only Oracle ETL Developers with Informatica and Oracle 19c · Requires Bachelors degree · Professional Level Information: · As an Engineer 1, your duties may include assisting in the des ...
ETL Developer

3 weeks ago

iTCO Solutions Washington, United States

100% onsite location G St, NW Washington, DC · Does not want SQL ETL developers · Want only Oracle ETL Developers · Requires Bachelors degree · Professional Level Information: · As an Engineer 1, your duties may include assisting in the design, development, and testing proje ...
ETL Developer

3 weeks ago

Amida Technology Solutions Washington, United States

Amida Technology Solutions is a DC-based software services company focused on the most difficult problems in data interoperability, exchange, governance, and security. We design, develop, and deploy software solutions that collect, reconcile, and transform data for business intel ...
Sr. ETL Developer

3 weeks ago

Onyx Government Services,LLC Washington, United States

Onyx Government Services, LLC., is a Service-Disable Veteran-Owned Small Business (SDVOSB), headquartered in Fairfax, Virginia. We specialize in data management, integration, and analysis solutions to provide decision-ready information to Command and Control (C2) and Decision Sup ...
SQL/Informatica ETL Developer

23 hours ago

Fusion Technology Washington, United States

SQL/Informatica ETL Developer · Who is Fusion Technology? · Fusion Technology is a performance-driven HUBZone Small Business concern residing in the heart of the beautiful mountainsides of West Virginia, steps away from the Federal Bureau of Investigation's Criminal Justice Inf ...
Jr. ETL Developer

3 weeks ago

NuWave Solutions Washington, United States

Overview · is seeking a Jr. ETL Developer to join our data engineering team and help us deliver high-quality data solutions to our clients. You will be responsible for creating, maintaining, and optimizing ETL processes using PostgreSQL and other tools. · What you will doProvide ...
Senior ETL Developer

3 weeks ago

9 th Way Insignia Washington, United States

Company Introduction · 9th Way Insignia is a service-disabled, veteran-owned small business bringing transformative technology to our government customers so they can achieve their missions. Our specialties include cybersecurity, cloud modernization, software development, data a ...
Jr. ETL Developer

1 week ago

BigBear Inc Washington, United States

Overview · is seeking a · Jr. ETL Developer · to join our data engineering team and help us deliver high-quality data solutions to our clients. You will be responsible for creating, maintaining, and optimizing ETL processes using PostgreSQL and other tools. · What you will do ...
ETL Informatica Developer

3 weeks ago

ViedTech Washington, United States

Company Description · Incorporated in 2006; Headquartered in Chantilly, VA. Viedtech has established itself globally with its services and solution excellence. Viedtech offers fast, reliable, cost effective and value added IT and Staffing Services. · We constantly strive hard t ...
Lead ETL Developer

3 weeks ago

Universal Service Administrative Company Washington, United States

USAC's target compensation range for a new hire into this position is $105,000 - $145,000 USD per year. Actual salary may vary depending on job-related factors based on knowledge, skills, and experience, as evaluated throughout the interview process. In addition, this position ma ...
Junior SQL/ETL Developer

3 weeks ago

Arena Technical Resources Washington, United States

Junior SQL/ETL Developer · Location: Washington, DC, US · Job ID: 16213 · Job Description · Job · Description: · Job Title: Junior SQL/Informatica ETL Developer · Job Location: Washington, DC (1 day telework) · clearance: Top Secret · What you?ll do: You will support the ...
SQL/Informatica ETL Developer

3 weeks ago

Fusion Technology Washington, United States

SQL/Informatica ETL Developer · Who is Fusion Technology? · Fusion Technology is a performance-driven HUBZone Small Business concern residing in the heart of the beautiful mountainsides of West Virginia, steps away from the Federal Bureau of Investigation's Criminal Justice Infor ...
SQL/Informatica ETL Developer

3 days ago

Fusion Technology Washington, United States

SQL/Informatica ETL Developer · Who is Fusion Technology? · Fusion Technology is a performance-driven HUBZone Small Business concern residing in the heart of the beautiful mountainsides of West Virginia, steps away from the Federal Bureau of Investigation's Criminal Justice Inf ...
ETL Data Warehouse Developer

3 weeks ago

Perfict Global, Inc. Washington, United States

About Us: · Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies avail ...
ETL/Informatica Developer with Security Clearance

3 days ago

Northstrat Washington, United States

Northstrat is searching for personnel experienced in Extract, Transform and Load (ETL) with a focus on Informatica. Specific areas of interest are: Informatica Administrators, Architects and Developers. The preferred candidate will facilitate the identification, definition, and d ...
Sr Data Engineer

3 weeks ago

Serigor Inc Washington, United States

Title: Sr Data Engineer · Location: 100% Remote – EST Time zone · Duration: 12+ Months · Key Skills: AWS, Spark, Adobe Analytics/AEP(Adobe Experience Platform) platform experience, Glue, Lamda, Python, Scala, EMR, Talend, PostgreSQL, Redshift · Job Description:Looking for a Sr le ...
Database Analyst Senior

2 weeks ago

General Dynamics Information Technology Washington, United States

Job Description · GDIT is looking for a Database Analyst who thrives in a dynamic work environment. This role involves working across the entire Business Information (BI) lifecycle, from source data analysis, Extract Transform Load (ETL) development, through to Analysis and Repor ...
Big Data Architect IT Consultant Master

3 weeks ago

Serigor Inc Washington, United States

Job Title: Big Data Architect IT Consultant Master (ONSITE) · Location: Washington, DC · Duration:12 Months+ · Job Description: · The client seeks an experienced IT Consultant to support the design, development, implementation and maintenance of an enterprise Big Data solution as ...
Azure Databricks Engineer

4 weeks ago

Cognizant Washington, United States Full time

We are Cognizant Artificial Intelligence · Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude better than ever before. However, clients need new business models built from analyzing customers and busi ...