SUMMARY

• Experience in Information technology as a Software Engineer.
• Strong Working Experience in Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensively used Informatica to load data from Flat files, Relational databases like Oracle, Sybase, SQL Server, MS - Access and DB2, XML, XLS and Teradata.
• Worked on Informatica tools such as Source Analyzer, Warehouse Designer, Mapping Designer, Transformation Developer and Mapplet Designer.
• Experience in loading data from XML Files.
• Created mappings using Lookup, Router, Aggregator, Joiner, Expression, Filter, Update strategy and Normalizer Transformation.
• Experience in creating shell scripting.
• Developed common logic using Reusable transformations and mapplets.
• Very Strong Oracle skills that include build/maintain PL/SQL scripts, Stored Procedures, Triggers, Packages and Functions.
• Working experience on Web Services.
• Experience in Autosys tool.
• Experience in Teradata Utilities like TPUMP, Multi Load and Fast Load.
• Installing patches and Hot fixes.
• Manage Development, Test and SI Informatica Severs.
• Installed and configured Informatica Power Center on UNIX platform.
• Repository Service Backup, Recovery and Migration between Dev, TEST and Prod environments.
• Creation and maintenance of Informatica users and privileges.
• Expert in creating and executing SQL Queries, Stored Procedures and Functions.
• Shutdown and Restarting Informatica using web services.
• Enthusiastic to learn new skills and a quick learner.
• Validate data in files using Shell Scripting.
• Hands on experience in creating Deployment Groups and Applying Labels.
• Excellent Communication, Good Work Ethics and a Team Player.

TECHNICAL SKILLS

ETL tools: Informatica, Data Stage, ODI, SSIS

Languages: SQL, PL/SQL, Java, JCL, XML, HTML

Methodologies: E-R Modeling, Star Schema, Snow Flake

Operating Systems: UNIX, LINUX, Windows, MVS

Databases: ORACLE10/11, TERADATA, SQL Server, DB2, MS-Access.

Other: TOAD, OBIEE

ERP Technologies: Peoplesoft (HRMS), Oracle Apps(CRM)

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Software Engineer

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Involved into design the logical data model from the technical design documents and translating to a physical data model using Erwin.
• Participate in the business analysis sessions to obtain requirements for the data model.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Involved in Informatica Administration for creating new users, Repository Backups and restores and Migration of Informatica Mappings to TEST and Production Environments.
• Involved into gathering the attributes from different existing models, and write high level specifications for every data requirement.
• Manage Development, Test and SI Informatica Severs.
• Created ETL mapping documents using technical design documents.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, Connected and Un-connected lookup, sorter, Normalizer and sequence generator.
• Involved in performance tuning.
• Created ETL design and created DDLS using Erwin.
• Complete the ODS physical data model implementation by working with the DBA.
• Installing patches and Hot fixes.
• Installed and configured Informatica Power Center 9.0.1 and 9.1.0 on UNIX platform.
• Involved into Prepare the Use cases for high level specifications.
• Involved into creating the high level specs for every data requirement as well as business requirements.
• Repository Service Backup, Recovery and Migration between Dev, TEST and Prod environments.
• Created shell scripts to automate .
• Interacted with DBA and Source systems and resolved issues.
• Created ETL Mappings to load data from XML Files.
• Involved in gathering Business Requirements for New models.
• Interacting with Development and Management Teams.
• Created Error tables for Error handling.
• Created shell scripts to schedule jobs in Informatica.
• Involved into creating the database Stored Procedures and used Cursors to perform calculations when retrieving data from the database
• Restarting Informatica using web services.

Environment: Erwin, Informatica 10.2, ORACLE 12C, UNIX, Micro Strategy, xml, Windows NT, Python, AWS

Confidential, BALTIMORE, MD

Software Engineer

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Participate in the business analysis sessions to obtain requirements for the data model.
• Involved in gathering the attributes from different existing models, and write high level specifications for every data requirement.
• Created ETL mapping documents using technical design documents.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, Connected and Un-connected lookup, sorter, Normalizer and sequence generator.
• Involved in performance tuning.
• Worked on High Priority Trouble tickets and Service Requests.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked on Data Analysis, data cleansing, data matching, data conversion, address standardization, exception handling, and reporting and monitoring capabilities of IDQ
• Scheduled Informatica Workflows using DAC.
• Involved in Data lineage using Meta data Manager.
• Develop and/or update Technical documentations i.e. operational manual etc.
• Optimized ETL sessions in by applying different optimized techniques like Session portioning, by writing optimized query and changing session settings
• Extracted data from IMS DB and DB2 using Informatica Power Exchange.
• Involved into creating the high level specs for every data requirement as well as business requirements.
• Develop and execute test and implementation plans.
• Prepared deployment documents for deploy ETL code into different environments like TST, SI, FIT and Prod
• Integrated and migrated ETL code to different environment like TST, SI, FIT and PROD from Dev
• Involved in gathering Business Requirements for New models.
• Involved peer review meeting and code walkthrough meetings and suggested for optimized code and ETL coding standards
• Interacting with Development and Management Teams.
• Created Error tables for Error handling.
• Involved into creating the database Stored Procedures and used Cursors to perform calculations when retrieving data from the database

Environment: Erwin, Informatica 9.6.1/9.5, Informatica IDQ, DAC,OBIEE,Meta data Manager, ORACLE 11g/12c, UNIX, Micro Strategy, Windows NT, Informatica Power Exchange, DAC

Confidential

Software Engineer

Responsibilities:

• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Sorter, Aggregate, Filter, Update Strategy and Sequence Generator etc.
• Data Modelers analyze the data from different sources, design Data Models, and then generate scripts to create necessary tables and the corresponding records.
• DBAs create the databases and tables based on the scripts generated by the data modelers
• Data Modelers analyze the data from different sources, design Data Models, and then generate scripts to create necessary tables and the corresponding records.
• Performed backup and restorations of Repository.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Developed PL/SQL procedures for processing business logic in the database.
• Used ETL and Informatica Power Center for extracting data from Flat Files, Oracle, which was collected from upstream databases and loaded into the target Oracle 8i database, and Flat Files
• Extracted source data from Flat Files, Oracle and loaded into Staging area.
• Created Source and Target Definitions in the repository using Informatica Source Analyzer and Warehouse Designer.
• Created the Workflows by including various sessions, mappings, event wait, timer, source and target connections using Power Center 6.2
• Designed and developed Oracle PL/SQL Procedures.
• Involved in Performance Tuning of sources, targets, mappings and sessions.
• Experience in backup and restoring of Repository.
• Creation of Sessions and executing them to load the data from the source system using Informatica Server Manager.
• Created Enterprise reports and templates using Report Net.
• Developed and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and targets
• Tested the EIM process by activating the Error Flags, SQL Trace Flags and Trace flags. Based upon the log files the errors were corrected.
• Run EIM tasks to import data in convenient batches and checking and trouble-shooting failures.

Environment: Informatica Power Center, Oracle 9i,ODI, Siebel 7.5.2, eFinance, Business Objects, PL/SQL, SQL*Plus, JAVA, Windows 2000/XP, Control-M, Cobol,TIDAL