View Our Website View All Jobs

ETL Developer

ETL Developer

Lanham, MD

MUST have Active IRS MBI clearance - Permanent Resident (Green Card) or US Citizens Only

Primary Duties: 

·         The Informatica Developer is responsible for the development of ETL (Extract, Transform and Load) code. The candidate will collaborate with IRS and IBM Project teams to design and develop ETL code to load large amounts of data from other IRS internal data sources to the RRP system.  Duties include:

  • Job Duty 1 - Design/Develop ETL Interface using Informatica tool.  In addition, implement an Informatica based ETL solution fulfilling stringent performance requirements.
  • Job Duty 2 - Develop/Implement the coding of Informatica mappings for different stages of ETL.  Move staging table to the target table.
  • Job Duty 3 - Design, coding, unit testing of ETL packages, triggers, and stored procedures, views, SQL transactions
  • Job Duty 4 - Understand and comply with development standards and SDLC to ensure consistency across the project.
  • Job Duty 5 - Collaborate with Client SMEs, IBM team and other vendor teams.

Basic Qualifications:

 Please note these are the top technical skills that the Buyer feels a candidate MUST have. General knowledge of basic office software such as MS Office Suite as well as good communications skills are a given.   

  • Knowledge of IRS business systems and data,
  • Strong PostGres SQL experience (4+ years)
  • Experience with Informatica Power Center; SQL (4+ years)
  • Strong experience with ETL development and process from diverse data sources (4+years)
  • Advanced experience with Informatica Power Exchange, Control-M
  • Experience with data modeling concepts
  • Experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes (4+ years)
  • Experience with Data Warehouse; Oracle; Linux; AIX
Read More

Apply for this position

Required*
Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file

150
To comply with government Equal Employment Opportunity / Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Gender
Race/Ethnicity
Veteran/Disability status