Informatica Developer

A minimum of a bachelor’s degree coupled with 7+ years’ experience in the information technology arena
7+ years’ experience in Enterprise Data Warehouse, Business Intelligence, analytic computing, data analysis, and pattern identification with various forms of data.
2+ years’ experience with Oracle RDBMS, PL/SQL & SQL Server platforms
2+ years’ experience in Informatica IICS
Excellent communication and organizational skills.
Ability to perform data analysis, troubleshoot data integrity issues and strong analytical/problem solving skills.

Desired Qualifications

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.
Experience with reporting tools such as Cognos, Oracle Analytics Cloud & Microsoft Power BI
Experience with Snowflake
Familiarity with development methodology such as Agile, Waterfall and Systems Engineering

Essential Duties & Responsibilities Are

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