Job Description :
Job Summary

Employer: SAVANTIS

Location : Mills Road Owings Mills Maryland 21117

Job Title : Informatica Developer

Responsible for the development of ETL (Extract, Transform and Load) code.
Designing and developing ETL code to load large amounts of data from various data sources to the T. Rowe Price target sources.
Designing and Developing ETL Interfaces using Informatica ETL tools
Developing and Implementing Informatica mappings for different stages of ETL. Move staging table to the target table.
Design, coding, and unit testing of ETL packages, triggers, stored procedures, views, and SQL transactions
Understanding and comply with T. Rowe Price development standards to ensure consistency across projects.

REQUIRED SKILLS:
- Experience with Informatica Power Center; SQL (5+ years)
- Experience using Oracle Exadata database as a source and familiar in writing complex SQL queries
- Must be able to write clear and concise technical design documents
- Exposure to writing in Python scripting languages for custom ETL processes

Nice to have:
Review existing and write new shell scripts in Red hat Linux operating system
IICS
DB2 Mainframe
Salesforce

Duties:

The Informatica Developer is responsible for the development of ETL (Extract, Transform and Load) code. The developer will collaborate with TEKsystems Global Services project teams to design and develop ETL code to load large amounts of data from various data sources to the target sources.
- Design/Develop ETL Interfaces using Informatica ETL tools
- Develop/Implement Informatica mappings for different stages of ETL. Move staging table to the target table.
- Design, coding, and unit testing of ETL packages, triggers, stored procedures, views, and SQL transactions

Client : T-Row