Informatica Developer Resume

SUMMARY

Having 13 + years of overall experience in IT including 6+ years of ETL experience in data warehousing, analysis, design, development, Unit testing, implementation, enhancements and support of business applications using MS SQL Server, DB2, Oracle, Informatica PowerCenter and IICS - Informatica Intelligent cloud services.
6+ years of experience in Developing Windows/Web and client-server VB.net, C#.net, Asp.net, MS SQL Server.
Expert in Data integration/monitor and Administrator services on IICS.
Extensive Experience on Different Asset like Task, mapping task, mapping, Task flows and Components on IICS.
Extensive experience in design and development of Complex Mappings, Reusable Objects (Mapplets, Lookups, Transformations, Tasks and Sessions), transformations, extractions and loads.
Expert level development skills with Informatica Client Tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets Designer, Informatica Repository Manager and Workflow Manager.
Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM
Experience in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules
Strong experience working with scheduling tool like Autosys.
Very good experience in debugging the Code and Optimize the Transaction Data Flow Good experience with performance optimization techniques in complex code using complex mappings, transformations and validations.
Involved in the creation of mappings/sessions/workflows Informatica Confidential development phase based on the specifications
Good experience in Unix scripting, handled runtime parameter update, ftp using shell scripting.
Involved in the development of enhancements based on the specification.
Worked on ECM tool IBM FileNet Data Capture.
Good Knowledge on Oracle, DB2, SQL server, Data warehouse, Relational Database management concepts and MicroStrategy.
Under gone Informatica developer for BDM training.
Been in On-shore assignment in US from Dec 2014 till May 2019 working for Citi Bank.

TECHNICAL SKILLS

ETL Tools: IICS, Informatica PC, Informatica MDM, Ab Initio

RDBMS: MS-SQL Server, Oracle, DB2, Teradata

Scheduler: Autosys

Languages: C#, VB.NET

Operating System: Windows, RHEL, UNIX

Web Technologies: Dot Net Framework, ASP.Net, IIS

Scripting Language: VB Script, Unix Shell Script & HTML

Tools: & Utilities: RLM, Hermes, ServiceNow

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

Design and develop integration patterns for IICS
Create architecture/design documentation for Business Transformation project using IICS Data/Application Integration, B2B DX, MFT, Powercenter.
Create technical specifications from business & functional requirements
Provides guidance to development team working on the Informatica IICS Application Integration.
Experience in connecting SAP Systems using (Webservices/RFC BAPI, IDOC) to various third party system like salesforce, Bloomberg, Datamatic etc
Worked on SOAP and Rest API connections.
Created and implemented job schedule using Autosys.
Worked on synchronous real time integration.
Worked on Elements, relationship, lookup in data model using MDM Hub console schema tool.
Setting trust, validation rules, Match & Merge process.
Configure Hierarchies, Relationship, profiles, load data and test implementation.

Confidential

Informatica Developer

Responsibilities:

Design and develop integration patterns for IICS
Create architecture/design documentation for IICS for Claim care system/Claim Connect system.
Create technical specifications from business & functional requirements
Provides guidance to development team working on the Informatica IICS ETL platform
Created and implemented job schedule using Autosys.
Took ownership to retrieve all data from different system like Claim connect /Claim care built complex views on top of the retrieved data and load the target system using Historical load / Incremental load for each process.
Took Care for ABC audit Balance process for Both Historical and Incremental loads.
Took care of Back up and Recovery Process for the Failure occurred Durring the loads.
Attended Daily Scrum calls /Plan and review meeting and Grooming of the user story.

Confidential

Informatica Developer

Responsibilities:

Design, Develop and Test ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.2.
Worked on fixed width file for with different section attributes, count and target household STBs, it is used to deliver target based adds, helping advertisers reach the right audience.
Develop the SQL test scripts to validate the complex transformation logic implemented in Hadoop
Created and implemented job schedule using Autosys.
Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship