ETL Developer

Job Title: JR. ETL Developer

Duration: Long Term

Location: Lanham, MD

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:

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

REQUIRED SKILLS:

· Knowledge of IRS business systems and data,

· Strong PostGres SQL experience (2 years)

· Experience with Informatica Power Center; SQL (2 years)

· Strong experience with ETL development and process from diverse data sources (2 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 (2 years)

· Experience with Data Warehouse; Oracle; Linux; AIX

NICE TO HAVE SKILLS:

· Active IRS MBI

· Prior IRS experience

· Strong oral and written business communication skills desired

· Knowledge of IRS business systems and data, is an extra plus

Wasim Ahmed

703-722-8126

** Please share me your updated word copy of Resume.

*** I Appreciate, if you refer to someone who is looking for this position.