Sr. Informatica Developer Resume

SUMMARY:

Around 10+ years of overall experience in IT Industry, extensively worked in Business Intelligence and Data warehouse. 6+ years of strong development experience in creating
ETL procedures to load data from different sources into data warehouse using Informatica Powercenter, Data Integration Hub (DIH). 1 year of experience as Teradata Developer and 2+ years of experience on JDA product support
SKILLSInformatica Power Center 9.x, 10.x Informatica Data Integration Hub IDQ
IICS
Snowflake
Teradata
UNIX Shell Scripting
TOOLS Putty, FileZilla, TWS, Sql Developer, Toad.

PROFESSIONAL EXPERIENCE:

Sr. Informatica Developer

Confidential

Responsibilities:

As Sr. Informatica Developer in Aftersales DataMart Snowflake Migration project, my core activities include:
Developing/Modifying ETL Mapping to load data from various source systems into Snowflake Data warehouse.
Optimizing mappings and workflows to reduce job runtimes.
Clone tables, Schemas to move data wifin Snowflake environments.
Load data from S3 into Snowflake using ETL mapping.
Create Test cases and validate the data between Oracle and Snowflake.
Prepared Technical Design, Production Support Doc, Deployment Documents.

Sr. Informatica Developer

Confidential

Responsibilities:

As Sr. Informatica Developer in Total Customer Satisfaction Survey project, my core activities include:
Participate in business requirement review meetings wif BA’s, Solution Architect and users and to develop ETL design specifications.
Developing ETL Mapping to load data from various source systems like Flat file, Oracle and XML etc. to Oracle/Snowflake Data warehouse.
Creating complex mappings using Informatica Developer/Powercenter to implement complex business requirements like Levenshtein distance algorithm. Prepared Technical Design, Production Support Doc, Deployment Documents.
Working on Agile environment for rapidly changing or highly emergent requirements and following parallel development and testing.

Sr. Informatica Developer

Confidential

Responsibilities:

As Sr. Informatica Developer in Total Customer Satisfaction Survey project, my core activities include:Gathering and analyzing business requirement and writing requirement specification documents and identified data sources and targets.
Creating automatic/customized Publications and Subscriptions using Informatica DIH to extract data from various source systems like Oracle, SQL Server, and flat files and loaded into BDE environments.
Modified the existing worklets and workflows to accommodate for the new sessions and mappings.
Provided 24x7 production support for business users and documented problems and solutions for running the workflows.
Used Tableau 10.x to modify and publish custom SQL Data sources and workbooks.

Informatica Developer

Confidential

Responsibilities:

As Informatica Developer in ICAR/NCAR Reports project, my core activities include:
Created Design Specification Documents including source to target mappings Translated Business Requirements into Informatica mappings to build Data warehouse by using Informatica Designer, which populated the data into the target Star Schema.
Extracted data from various source systems like Oracle, XML and flat files and loaded into relational data warehouse.
Provided 24x7 production support for business users and documented problems and solutions for running the workflows.

Support Analyst

Responsibilities:

As JDA Support Analyst in MARS SCP Global Support, my core activities include:Resolving data integrity issues and JDA Application issues.
Installation of Manugistics Patch upgrades for Version 7.6.x and 8.1 for demand and supply wifin agreed SLA.
Coordinated and worked wif technical team on resolving issues. Acted as liaison between key users and Manugistics Expert center.
Resolved technical issues in oracle SQL, PL/SQL, windows and UNIX scripts, SQL loader control file by modifying existing scripts and developing new scripts/procedures for regional Continuous Improvement Process (CIPs).
Developing and maintaining custom JDA batch scripts through Tivoli work scheduler.

Teradata Developer

Confidential

Responsibilities:

As Teradata developer in COLLECT 2B project, my core activities include:
Worked exclusively on Mloads, Insert, Update and delete Macros to load data into the target tables in Teradata Database.
Performed impact analysis from source table to target table for new requirements and presented model flow diagram to understand the flow of data.
Creating and modifying MULTI LOADS using UNIX and Loading data into IDW. Handled issues while performing loading of data from Source directory to staging table.
Identifying the populations of wrong data into Target table and resolving the issue.