We provide IT Staff Augmentation Services!

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

Hire Now