ETL Developer

Comtech LLC; Lanham (MD); On-site; USD 70,000 - 90,000; Full time

Job summary

A woman-owned small business is seeking a JR. ETL Developer to develop ETL code for IRS data integration projects. Responsibilities include designing and coding ETL interfaces, working with Informatica tools, and collaborating with project teams. The ideal candidate should have strong experience with PostGres SQL and Informatica Power Center, as well as a solid understanding of ETL processes. This is a long-term position based in Maryland.

Qualifications

• 2 years of strong PostGres SQL experience.
• Experience with Informatica Power Center and SQL for 2 years.
• Advanced experience with Informatica Power Exchange and Control-M.
• 2 years of ETL development from diverse data sources.

Responsibilities

• Develop ETL code to load data from IRS internal sources.
• Design and develop ETL interfaces using Informatica.
• Collaborate with project teams for coding and testing of ETL packages.

Skills

PostGres SQL

Informatica Power Center

ETL development

Data Warehouse

Oracle

Linux

AIX

Job description

Comtech is a woman-owned small business founded in 1998 and headquartered in Reston, VA. We offer IT solutions across the disciplines of program/project management, applications development, infrastructure, Cyber security, and enterprise content/data management services. We have developed our methodologies and processes based on the IT Infrastructure Library (ITIL) v.3 Framework across enterprise infrastructure operations. These methodologies and processes are reinforced through our organization’s externally accredited certifications, which include ISO 9001:2008 Quality Management System (QMS), ISO/IEC 20000-1:2011 IT Service Management Systems (SMS, corporate ITIL certification), ISO 27001:2005 Information Security Management System (ISMS), and CMMI-DEV Level 3

Job Description

Job Title: JR. ETL Developer

Duration: Long Term

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:

• Strong oral and written business communication skills desired
• Knowledge of IRS business systems and data, is an extra plus

703-722-8126

Additional Information

Please share me your updated word copy of Resume.

I appreciate if you refer to someone who is looking for this position.