SUMMARY:

• Over 7+ years of Data Warehousing experience using Informatica Power center 10x, Power Connect, Power Exchange and Power Analyzer.
• Extensively worked on various Data warehouse projects using Informatica Client Tools - Source Analyzer, Transformation Developer, Workflow Manager, Workflow Monitor, Server Manager, Mapping Designer, Mapplet Designer and Warehouse Designer.
• Excellent knowledge of OLTP and OLAP System Study, Analysis and E-R modeling.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Prominent experience in Data Integration, Extraction, Transformation and Loading data from multiple heterogeneous data source systems like Oracle, SYBASE, SQL Server, DB2, Teradata, XML and Flat files into Data warehouse by using Informatica tool.
• Hands on experience to conduct scrum meetings and sprint planning by using tools like JIRA, Confluence & HP-ALM to track the progress of projects.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations using Informatica debugger.
• Used Informatica Power Connect for SAP to pull data from SAP R/3.
• Exposure and experience in different methodologies like Agile and Waterfall.
• Experience Informatica upgrade from V8.6.1 to 9.0.1, 9.1.0 and 9.6.1 and 10.x.
• Extensively designed and worked on Real-time CDC job and batch job using InformaticaPowerExchange.
• Developed UNIX scripts for dynamic generation of Files & for FTP/SFTP transmission.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Good working knowledge in querying Salesforce.com database using SOQL & SOSL queries using Force.com Explorer & Workbench.
• Highly proficient in the integration of various data sources involving multiple relational databases like Oracle SQL Server, DB2, COBOL Files and Flat File.
• Prominent experience in Data Integration, Extraction, Transformation and Loading data from multiple heterogeneous data source systems like Oracle, SYBASE, SQL Server, DB2, Teradata, XML and Flat files into Data warehouse by using Informatica tool.

TECHNICAL SKILLS:

Software: SQL, PL/SQL, HTML, XML, UNIX Shell Script, Putty, JCL, COBOL, DB2. Web Services, Java, JavaScript, CSS, HTML, XML, SOAP. MS Office, Eclipse IDE, Policy Admin System. TOAD, SQL Developer, PL/SQL, SQL, PL/SQL, UNIX Shell Scripts, JCL, REXX, Easytrieve. Senior Informatica Developer (6 years), SQL, PL/SQL, Unix Shell Scripting, Oracle 11g/10g/9i, MS SQL Server 2005/2008, Teradata, Sybase, DB2, Mainframe, Informatica Power Center 10x/9.x/8.x/7.x (Repository Manager, Mapping Designer, Workflow Designer and Workflow Monitor)

Database:: Oracle 11g/10g, MS SQL Server MS Access 5.0, My SQL, DB2 9.0.

Data Modeling tools:: Oracle Toad Data Modeler

Scheduling Tools:: ESP Scheduler, Control-M

Operating Systems:: Windows UNIX, IBM z/OS.

WORK EXPERIENCE:

Informatica Developer

Confidential, MI

Responsibilities:

• Worked extensively on Informatica workflows, to process the data extract and uploads.
• All the tasks had been assigned in the form of tickets and used JIRA to track them.
• Delivered all the assigned tasks on time, Work had been divided into sprints which is for two weeks.
• Developed complex Aggregate, Join, Router, Lookup and Update transformation rules involved in the development of Informatica Mappings and also performed tuning for better performance
• Maintain all documents current and available in the SharePoint.
• Created Informatica mappings to build business rules to load data.
• Built Data Integration Components using Informatica power center following locally DI Framework and recipes (i.e ETL Cookbook) like Netezza, Oracle, sql server on Unix/Linux and Windows operating systems.
• Wrote complex SQL overrides to join heterogenous databases.
• Identifies and fixed bottlenecks and turned the Informatica mappings for better performance.
• Was involved in ETL production support once in every 3 weeks and used to work on issues which had been assigned.
• Worked on Informatica tools like Power Center Designer, Workflow Manager and Workflow Monitor.
• Actively participated in code migration with DBA and admins.
• Maintain all documents current and available in the SharePoint.
• Extracted data from our cloud sources(Hive HUE). HDFS system would dump the files into our cloud known as kafka que which is called as Hive Prod HUE.

Environment: Informatica 10x, HUE-2.6.1-2, Aginity AMP, Hive, Oracle, Netezza, Autosys, JIRA.

ETL/Informatica Developer

Confidential, NY

Responsibilities:

• We use Informatica 9.6.1 to load the data from Legacy tables to Netezza tables.
• Performed Informatica upgrade from V9.1 to 9.5.
• Played a main role in creating all the templates to create different status pages add our tasks and track them in Jira.
• Worked along with the Informatica professionalresolved Informatica upgrade issue.
• Used Jira and confluence as project tacking tool, where we used to have all the tasks built and updated.
• Built Mappings, work lets and workflows to load the data into staging area, and then into DW tables.
• Prepared all the designing documents consist of Data flow from Source to Target by mapping all the columns, which are required for reporting purpose.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created different (Detailed and High level) Data Model diagrams to explain the flow of the data by using Data Modular tool called ERwin.
• Extracted data high volume of data sets from SalesForce.com(SFDC) using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Warehouse.

Environment: Informatica 10x, SQL Server, Oracle, Netezza, Tidal and JIRA.

ETL/Informatica Developer

Confidential, TX

Responsibilities:

• Performed Informatica upgrade from V9.1 to 9.5.
• Involved in querying Salesforce tables using SQL queries using Force.com Explorer.
• Extracted data high volume of data sets from SalesForce.com(SFDC) using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Warehouse.
• Have good knowledge SOQL and Sales force governor limits.
• Worked on SQL Server including DDL, TSQL, Stored Procedures, etc. in large-scale relational databases.
• Documented the LDAP configuration process and worked closely with Informatica Technical support on some of the issues.
• Proficient in SDLC methodologies.
• Used UNIX scripts for scheduling and executing Informatica workflows.
• Worked on scheduler tools like Autosys and Control-M.
• Created UNIX scripts for FTP and SFTP files to different servers.
• Actively involved in creating Oracle Stored Procedures, Packages, Functions, Triggers, Records, Arrays and Exception handling using TOAD, SQL*PLUS and PL/SQL.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.

Environment: Informatica 10x, SQL Server 2008, Oracle, Teradata, Salesforce, Autosys, Shell Scripting, FTP/SFTP.

ETL/Informatica Developer

Confidential, VA

Responsibilities:

• Performed Informatica upgrade from V9.1 to 9.5.
• We use Informatica 9.6.1 to load the data from Legacy tables to Netezza tables.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Extracted data high volume of data sets from SalesForce.com(SFDC) using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Warehouse.
• Involved in requirement gathering for redesign candidates.
• Used UNIX scripts for scheduling and executing Informatica workflows.
• Used FTP services to retrieve Flat Files from the external sources and RDBMS sources Teradata and Oracle.
• Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica work flow manager.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
• Worked along with the Informatica professional to resolved Informatica upgrade issue.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.

Environment: Informatica Power Center 10x, Oracle 11g, PL/SQL, SAP R/3, Control-M, SQL, Teradata, SQL* LOADER, TOAD, Shell Scripting, UNIX, FTP/SFTP.

ETL / Informatica Developer

Confidential, NJ

Responsibilities:

• Involved in gathering requirements from end users and involved in modifying data according to the requirement.
• Worked with the end users to identify, create, and deliver reports according to requirements.
• Interacted with business users and source system (OLTP) IT teams to define, agree and document incoming data mapping specifications.
• Extensively involved in ETL code using Informatica tool in order to meet requirements for extract, cleansing, transformation and loading of data from source to target data structures.
• Created ETL Mappings, Sessions and Workflows using various transformations like Update Transformation, Lookups, Filters, Routers and XML etc.
• Worked on various issues on existing Informatica Mappings to produce correct output and used ETL debugger extensively to identify the performance bottlenecks within the mappings.
• Actively involved in creating Oracle Stored Procedures, Packages, Functions, Triggers, Records, Arrays and Exception handling using TOAD, SQL*PLUS and PL/SQL.
• Created Fast Load, Multi Load, and T Pump and BTEQ scripts to load data into Teradata.
• Created Data models for data warehouse development.
• Involved in identifying data discrepancies and data quality issues and worked to ensure data consistency and integrity.
• Worked with UNIX scripts for automation of ETL Jobs using Control-M Scheduler and Involved in migration/ conversion of ETL processes from development to production environment.
• Working experience using Push Down Optimization.
• Did performance tune of Informatica components for daily and monthly incremental loading.

Environment: Informatica Power Center 10x, IDQ, Oracle11gR2, DB2, SQL, PL/SQL, TERA DATA, UNIX shell scripting, Control-M and, TOAD 10.