Senior Informatica Developer

JD:
•       Development of ETL mappings and Task flows in IDMC for data movement with different type of sources and targets. Sources include IMS database, VSAM, Oracle, SQL servers.

•       Refactoring of database ETL scripts from mainframe IMS databases to Oracle RDBMS.

•       Able to create data maps (application extraction and registration groups) in Power Exchange (PWX) Navigator or similar Real Time CDC products.

•       Develop Data Quality / Data Governance modules using Informatica DQ / Data Governance or similar products.

•       Develop data pipelines in Snowflake using PL/SQL procedures with different type of source / targets like Oracle, Salesforce, SQL Server.

•       Determines database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems.

•       Obtains data model requirements, develops, and implements data models for new projects, and maintains existing data models and data architectures.

•       Performs root cause analyses (RDA) related to information issues and non-conformance to published data standards based on review of technical metadata of various source systems.

•       Creates graphics and other flow diagrams (including ERD) to show complex database design and database modeling more simply.

•       Performs related work as assigned.

•       Creation of technical documentation for process and interface documentation is a key element of this role, as the Team is working on release two of a multiple release effort.

•       Ability to review the work of others, troubleshoot, and provide feedback and guidance to meet tight deliverable deadlines is required.

•       Ability to promote the code from development environments to test and production environments using DevOps CI/CD pipelines..