Informatica Developer III

Description:

Our client is seeking an Informatica Developer to work with the Enterprise Information Management team to administer, develop, implement, and maintain Enterprise Data Warehouse (EDW) and related Operational Data Stores (ODS). The candidate will contribute throughout the data management lifecycle process areas such as data acquisition, management, manipulation, and analysis of data and report results from an Enterprise Data Warehouse environment. The candidate will support activity to create data marts and ETL development for loading data to the data mart.

Responsibilities:

1. Work with Informatica Tech Lead, IT database administrators, systems administrators, and development team.
2. Work with the team to create a new data mart.
3. Support development, migration of data through ETL processes, revision, and update of DataMarts, procedure development, troubleshooting, system configuration, security administration, and account setup.
4. Support the lifecycle of physical data models and data maps for data warehouse system.
5. Aid end users and programmers regarding data warehouse related problems and issues.
6. Provide technical expertise to end-users who create complex queries and reports.
7. Coordinate, schedule, and test upgrades to the data warehouse system.

Experience Requirements:

1. 5+ years' experience in Enterprise Data Warehouse, Business Intelligence, analytic computing, data analysis, and pattern identification with various forms of data.
2. 2+ years' experience with Oracle RDBMS, PL/SQL & SQL Server platforms.
3. 2+ years' experience in Informatica IICS.
4. Excellent communication and organizational skills.
5. Ability to perform data analysis, troubleshoot data integrity issues and strong analytical/problem solving skills.

Desired Qualifications:

1. Experience in documenting and mapping interaction (source-to-target, source-to-ETL mapping) between business processes, information, and data for projects which are of medium to high complexity and moderate to high risk.
2. Experience with reporting tools such as Cognos, Oracle Analytics Cloud & Microsoft Power BI.
3. Experience with Snowflake.
4. Familiarity with development methodology such as Agile, Waterfall, and Systems Engineering.

Education Requirements:

A minimum of a bachelor's degree coupled with 5+ years' experience in the information technology arena.