WashingtonRecruiter Since 2001
the smart solution for Washington DC jobs

Informatica Developer

Company: Optimuss
Location: Fairfax
Posted on: August 17, 2019

Job Description:

Analyze business requirements and work with Business analyst on clarifications Develop Informatica Power center ETL Mapping, Sessions and workflows and perform Unit testing. Automated the Informatica process to update a status table in Teradata when maps are run successfully, following this a view will be run. Develop hive scripts to perform aggregations on extracted data and load the final tables. Develop complex mappings to load the data from multiple sources with functional logic as per business requirements. Working with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings implement data warehouse. Working on development of new requirements and enhancement of the existing ETL Jobs. Populate or refresh Teradata tables using TPT Fast load, Multi load Fast export utilities for user acceptance Used SSIS and T-SQL stored procedures to transfer data from source databases to staging area and finally transfer into data warehouse. Extensively used the Teradata utilities like BTEQ scripts, MLOAD and FLOAD scripts to load the huge volume of data. Designing the SCD type1 and type2 mappings and key fact tables. Also designed and developed code set tables that will assist the dimension tables. Create Deployment Scripts for production with RolloutRollback Instructions

Keywords: Optimuss, Washington DC , Informatica Developer, IT / Software / Systems , Fairfax, DC

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Senior Web and Human Interaction Developer with Security Clearance
Description: A. Background: br The Contractor Software Development team will work side-by-side with the Sponsor s Data Scientists, Developers, Program Managers, Systems Developers and Mission Analysts. The successful (more...)
Company: Thresher Corporation
Location: Chantilly
Posted on: 08/24/2019

Systems Engineer IV
Description: Business Group Highlights Intelligence The Intelligence group provides high-end systems engineering and integration products and services, data analytics and software development to national and military (more...)
Company: Perspecta
Location: Chantilly
Posted on: 08/24/2019

OBIEE Developer with Security Clearance
Description: Job Description Responsibilities: The desired candidate will work as a member of an Integrated Project Team, supporting Oracle Business Intelligence Enterprise Edition 12c enhancement and problem resolution (more...)
Company: CACI
Location: Chantilly
Posted on: 08/24/2019


M & S Software Developer with Security Clearance
Description: Description We are seeking an innovative and creative Software Developer to provide immediate impact developing a modeling and simulation platform that will significantly improve the TSA's security screening (more...)
Company: SAIC
Location: Chantilly
Posted on: 08/24/2019

M & S Software Architect/Developer with Security Clearance
Description: Description We are seeking an innovative and creative Software Architect/Developer to provide immediate impact developing a modeling and simulation platform that will significantly improve the TSA's security (more...)
Company: SAIC
Location: Chantilly
Posted on: 08/24/2019

Cloud Solutions Systems Administrator / AWS with Security Clearance
Description: Description SAIC is hiring a Systems Administrator with Amazon Web Services for a key role within our Space Sector You will create Amazon Virtual Private Cloud VPC resources e.g. subnets, network (more...)
Company: SAIC
Location: Chantilly
Posted on: 08/24/2019

Information Systems Security Officer with Security Clearance
Description: Business Group Highlights Defense The Defense group supports the Department of Defense DoD mission to keep our homeland and its citizens safe. We provide solutions to improve the Nations defense by (more...)
Company: Perspecta
Location: Chantilly
Posted on: 08/24/2019

Full stack .NET Developer
Description: Full stack .NET Developer Location: Windsor Mill, MD 21244 OR Lees burg, VA Duration: 6 months long term rolling contract .Net Developer in support of an enterprise level Government Integrator in Woodlawn, (more...)
Company: Apolis
Location: Leesburg
Posted on: 08/24/2019

Software Engineer (.Net) (Visa Independent Candidates Only)
Description: Direct Client Requirement Software Engineer .Net Contract to Hire Location Chantilly, VA Position Summary Software Engineer .Net with a full stack web application development experience. As Software (more...)
Company: APN Consulting Inc
Location: Chantilly
Posted on: 08/24/2019

Technical Targeter with Security Clearance
Description: Job Description If chosen, YOU will get to work with an agile, fast paced team focused on defending our client's global networks through threat hunting and tactical analysis of ongoing attacks. In this (more...)
Company: CACI
Location: Chantilly
Posted on: 08/24/2019

Log In or Create An Account