• Informatica Developer

    Job Locations US-VA-Herndon
    Posted Date 3 days ago(7/17/2018 2:22 PM)
    # of Openings
    Information Technology
  • Overview

    NikSoft Systems Corporation is a recognized Information Technology solutions provider. Founded in 1998 and based in Reston, Virginia, NikSoft is a CMMI Level 3 Certified company with an established reputation for excellence and on-time delivery with a consistently high customer satisfaction rating from its Federal Government and private consulting contracts.


    NikSoft is currently conducting a search for a professional and experienced Informatica Developer to join our team. 


    • Develop data profiling and quality assessment processes
    • Develop data filtering, transformation and loading requirements
    • Determine appropriate translations between source data and target databases
    • Capture metadata as it pertains to sources and targets
    • Load and transform data from data sources into target databases
    • Design and implement appropriate error handling procedures
    • Develop project, documentation and storage standards in conjunction with data architects
    • Monitor performance, troubleshoot and tune ETL processes as appropriate
    • Develop ETL workflows using Informatica for periodic data loads from source to target databases
    • Validate and verify the data in the target databases


    • Minimum of  7+ years' experience in the architecture, design and development of ETL programs using Informatica Power Center tools
    • Expert knowledge of Informatica version 8.5 and above
    • Experience working with large scale enterprise data warehouse  comprising of 10+ TB of data
    • Knowledge of reporting tools like Business Objects or OBIEE a plus
    • Minimum 2 full lifecycle project experience with small development groups, e.g., leading ground up development of Informatica standards in one or more previous projects.
    • Demonstrated ability to navigate through organizational and technical uncertainty
    • Mastery of Unix concepts and commands, including process management, directory structures, file permissions and editors
    • Solid background in Oracle database 9i, 10g or 11g preferably in Exadata environment with a focus on manipulating large volume data set
    • Stored procedure development experience
    • Solid experience building SQL queries, including creating sub-queries, minus/union, and inline queries and performance tuning of SQL in Oracle/Exadata environment
    • Fluency with business concepts related to relational and dimensional data models
    • Excellent oral and written communication skills
    • BA/BS in computer science or equivalent experience
    • Experience with large scale database application like Exadata would be a plus
    • Must be able to obtain a CBP Full BI (Customs Border Protection Full Background Investigation)

    **US Citizenship Status and Active DoD Secret Clearance (preferred), must successfully complete the government's security process (required).**




    NikSoft’s competitive benefits program includes comprehensive medical and dental care, matching 401K, paid time off, flexible spending accounts, disability coverage, and other benefits that help provide financial protection for you and your family.



    NikSoft Systems Corp is fully committed to the concept and practice of equal opportunity and affirmative action in all aspects of employment.  NikSoft is an EOE M/F/Disability/Veteran employer. For more information about our other openings, please visit


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed