Software Engineer Resume
Baltimore, MD
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