ETL Developer

2 weeks ago

Washington, United States iTCO Solutions Full time

100% onsite location - 1800 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 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 11.2.0.2, 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.

E-Verify: United States Employment Opportunities Only

E-Verify is an internet-based system operated by the Department of Homeland Security and the Social Security Administration and allows employers to confirm an individual s employment eligibility to work in the United States. Under the E-Verify rules, effective September 8, 2009, federal agencies subject to the Federal Acquisition Regulation are required to modify, and include in new contracts, a provision that requires federal contractors and subcontractors to use E-Verify. ITCO Solutions is required to adhere to these requirements.


Performance. Excellence, Value. Founded in 1997, our success is built on our relationships with our clients and our ability to deliver real value. ITCO Solutions is a technology services organization specializing in Workforce Solutions, Consulting Services, and Software Licensing.

At ITCO Solutions, our goal is to create a long-term relationship by providing quality service and delivering real value to our consultants and clients. We are not a staffing firm that will just submit resumes with little value. The ITCO team works directly with the hiring manager to understand requirements so we can deliver a consultant that fits.

Providing qualified IT talent to fill client resource needs, augment staff, and deliver projects on time. Engage ITCO Workforce Solutions to bolster the capacity of your IT staff and/or extend your capabilities beyond your existing skill sets.

Streamline your adoption of technology and ensure optimal investment with ITCO Consultants.
  • Turn-Key project delivery
  • Reduce complexity
  • Infrastructure, Virtualization, Cloud, and Managed services
Licensing Solutions has set a new standard of value in helping companies maximize their purchasing power across the software spectrum.
  • Hard-dollar costs savings by as much as 30% for enterprise software licensing
  • Simplify the management and maintenance of software purchases
  • Provide an assessment of your existing licensing

#LI-1269610_CJ1
#LI-BS1
#LI-IA1
#LI-BP1
#LI-NB1
#LI-AP1
#LI-DM1
#LI-PT1
#LI-NT1
#LI-SG1
#LI-RB1

  • Etl Developer

    7 days ago

    Washington, United States Incept Data Solutions, Inc Full time

    **ETL Developer** **Work Location: Veterans Affairs facilities located in the Washington, District Columbia (DC) region (onsite)** **Must be US Citizen.** **Responsibilities**: - Perform data warehousing, data modeling, data integration, data migration, and ETL process development to support organizational needs. - Install, configure, develop, support,...

  • ETL Developer

    3 weeks ago

    Washington, United States Amida Technology Solutions Full time

    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 intelligence, predictive analytics, and decision support. We specialize in taking...

  • ETL Developer

    1 month ago

    Washington, United States Outland Recruiting Full time

    Job DescriptionJob DescriptionJoin our dynamic team at the Office of Performance Analysis and Integrity, where we manage and enhance the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) and associated applications. Our responsibilities span Project Management, Data Warehouse Management, Advanced Analytics, Tableau Server Administration,...

  • ETL Developer

    1 month ago

    Washington, United States Outland Recruiting Full time

    Job DescriptionJob DescriptionJoin our dynamic team at the Office of Performance Analysis and Integrity, where we manage and enhance the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) and associated applications. Our responsibilities span Project Management, Data Warehouse Management, Advanced Analytics, Tableau Server Administration,...

  • ETL Developer

    3 days ago

    Washington, United States Amida Technology Solutions Full time

    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 intelligence, predictive analytics, and decision support. We specialize in taking...

  • ETL Developer

    2 months ago

    Washington, United States Amida Technology Solutions Full time

    Job DescriptionJob DescriptionAmida 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 intelligence, predictive analytics, and decision...

  • ETL Developer

    4 weeks ago

    Washington, United States Amida Technology Solutions Full time

    Job DescriptionJob DescriptionAmida 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 intelligence, predictive analytics, and decision...

  • ETL Developer

    1 month ago

    Washington, United States SynOpt LLC Full time

    Job DescriptionJob DescriptionThe right candidate will apply their technical knowledge in designing, implementing and maintaining Extract Transform Load (ETL) solutions. Responsibilities may include converting specifications into design and converting design into deliverables; design, documentation, development, modification, testing, installation,...

  • ETL Developer

    1 month ago

    Washington, United States SynOpt LLC Full time

    Job DescriptionJob DescriptionThe right candidate will apply their technical knowledge in designing, implementing and maintaining Extract Transform Load (ETL) solutions. Responsibilities may include converting specifications into design and converting design into deliverables; design, documentation, development, modification, testing, installation,...

  • Sr. ETL Developer

    1 month ago

    Washington, United States Outland Recruiting Full time

    Job DescriptionJob DescriptionJoin our dynamic team at the Office of Performance Analysis and Integrity, where we manage and enhance the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) and associated applications. Our responsibilities span Project Management, Data Warehouse Management, Advanced Analytics, Tableau Server Administration,...

  • Sr. ETL Developer

    2 days ago

    Washington, United States Onyx Government Services,LLC Full time

    Job DescriptionJob DescriptionOnyx 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 Support Systems.  We have demonstrated expertise in...

  • Sr. ETL Developer

    4 weeks ago

    Washington, United States Onyx Government Services,LLC Full time

    Job DescriptionJob DescriptionOnyx 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 Support Systems.  We have demonstrated expertise in...

  • AWS and ETL Developer

    4 weeks ago

    Washington, DC, United States RICEFW Technologies Full time

    Join our Data Cloud team in DC and embark on an exciting journey as an AWS and ETL Developer! We're seeking a skilled individual with expertise in Amazon Web Services (AWS) and Extract, Transform, Load (ETL) processes. Your role will involve crafting and maintaining ETL pipelines, implementing data integration solutions on AWS cloud services, and fine-tuning...

  • ETL Informatica Developer

    3 weeks ago

    Washington, United States ViedTech Full time

    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 to refine our quality, expand our capabilities, increase our efficiency, and elevate...

  • Database ETL Developer

    5 days ago

    Washington, United States Pyramid Consulting Full time

    Immediate need for a talented Database ETL Developer. This is a Fulltime opportunity with long-term potential and is located in Washington DC (Remote). Please review the job description below and contact me ASAP if you are interested. Job ID:24-20738 Pay Range: $120k - $130k/annum. Employee benefits include, but are not limited to, health insurance...

  • Database ETL Developer

    6 days ago

    Washington, United States Pyramid Consulting, Inc Full time

    Immediate need for a talented Database ETL Developer. This is a Fulltime opportunity with long-term potential and is located in Washington DC (Remote). Please review the job description below and contact me ASAP if you are interested.Job ID:24-20738Pay Range: $120k - $130k/annum. Employee benefits include, but are not limited to, health insurance (medical,...

  • ETL Developer Data Vault

    7 days ago

    Washington, United States Sylger Corporation Full time

    Job DescriptionJob DescriptionSylger Corporation is an administrative and technical support contractor to the federal government. We have immediate openings to provide BI and ETL support to a federal agency located in downtown DC.The candidate must be able to pass federal security background review. We are looking for a T-SQL, specialist and data management...

  • ETL Developer Data Vault

    1 day ago

    Washington, United States Sylger Corporation Full time

    Job DescriptionJob DescriptionSylger Corporation is an administrative and technical support contractor to the federal government. We have immediate openings to provide BI and ETL support to a federal agency located in downtown DC.The candidate must be able to pass federal security background review. We are looking for a T-SQL, specialist and data management...

  • Jr. ETL Developer with Security Clearance

    1 month ago

    Washington, United States BigBear.ai Full time

    Overview BigBear.ai 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 * Provide hands-on technical and functional support with PostgreSQL, including...

  • Senior Developer

    1 month ago

    Washington, United States Missing Link Security Full time

    - Senior Developer with expertise with Extract, Transform, Load ( ETL ) We are seeking a skilled Senior Developer to provide essential support for the ongoing operations of the VBA Enterprise Data Warehouse (EDW). The successful candidate will play a crucial role in ensuring the reliability, performance, and security of the EDW, as well as collaborating...