We provide IT Staff Augmentation Services!

Informatica Resume

New Carrolton, MD

Summary:

  • Dynamic, result orientedTechnical design developerwith14 yearsofsoftware life-cycleexperienceData Warehouse, Business IntelligenceandClient Server applications.
  • Strong working experience in the Data Analysis, Design, Development, Implementation and Testing ofData Warehousing,DataMarts and IODSusing Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
  • Team player, Excellent Interpersonal Skills and self-starter, capable of working independently and motivate a team of professional.
  • Over 11 yearsof strong data processing experience indesigningandimplementing Data Warehouse and Data Martapplications, mainlyTransformation processesusingETL tool INFORMATICAPOWER CENTER 1.6/1.7/5.1/6.2/7.1.4/8.x/9.0.1,B2B Data Transformation 9.0.1,Test Data Management 9.0.1,Data Quality 9.0.1,POWER EXCHANGE 8.5(CDC),ORACLE 10g/ 9i/ 8.x,Sybase, SQL Server6.5/7.0,MS Access,DB2 UDB, SQL, PL/SQL, SQL*Plus, SQL*Loader, SQL Navigator,UNIX Shell Scripting,Crystal ReportsandDeveloper 2000.
  • Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box(Vanilla mappings) prebuilt mappings, Designing ETL and metadata management using DAC
  • Extensively work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
  • Proficient in understanding business processes / requirements and translating them into technical requirements.
  • Good Experience in software development of application software in areas ofFinance, Insurance, Education, Federal
  • Government, HealthandManufacturingEnvironments

Informatica Certified Professional
PUBLIC TRUST CLEARANCE (BI LEVEL6)

Technical Skills:

Operating Systems:WINDOWS NT 4.0,UNIX, LINUX v 2.4.36, MVS/ESA, OS/390,HP-UX, SUN SOLARIS2.6/2.7/2.8 (Sun-Ultra, Sun-Spark, Sun Classic), IBMAIX4.2/4.3, Windows 95/98/2000andDOS
Database:ORACLE 10g/9i/ 8i/8.0/7.3, DB2 UDB, DB2 EEE, Teradata 12.0, SQL SERVER 7.0/6.5, WATSON,MS Access 7.0, INFORMIX, Sybase
Languages:SQL, SQL PLUS, PL/SQL, COBOL, JCL, XML, JavaScript, HTML 4.0, DHTML,SHELL Scripting
Data Warehousing Tools (ETL):INFORMATICAPOWERCENTER 1.7/5.x/6.x/7.x/8.6.1/9.0.1,B2B Data Transformation 9.0.1,Data Quality 9.0.1,Test Data Management 9.0.1,POWERMART 4.7/5.1.2/6.2,Power Exchange 8.5, Power Channel, Power Connect for Salesforce.comandPower Connect for SAP R/3
Business Intelligence Tools:BUSINESS OBJECTS XI/5i, WEB INTELLIGENCE 2.6,CRYSTAL REPORTS 6.5
Data Modeling Tools:PlatinumErwin 3.5, CAERwin 4.0andSELECTSE
GUI: FORMS 4.5/5.0, REPORTS 2.5/3.0, VISUAL BASIC 5.0/6.0 Developer 2000
Tools:BTEQ, SQL Assitant,SQL NAVIGATOR, SQL*Loader, SQL-Programmer, WINSQL, TOAD and Microsoft Query
Methodologies:STAR SCHEMA, SNOWFLAKE
Exposed To: Trillium,BO DATAINTEGRATOR 11.7.2, First Logic

Lead ETL Solution Engineer/Informatica Admin November 2010 To Tilldate

Confidential, New Carrolton MD

Solution Engineer/Developer Responsibilities:

  • Participated in the entire requirements engineering process right from requirements elicitation phase to the phase involving documenting of the requirements.
  • Involved in Design and develop the architecture for all data warehousing components e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation, information and analytics delivery and data quality strategy
  • Involved to drive the solution approach to data schema development, business rules, data design and migration processes for theteam. Also provided standards, guidelines, processes and expertise to consistently address recurring data issues including data convergence, data standards and data synchronization.
  • Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design. Participated and lead research and development efforts (proof\'s of concept, prototypes), as subject matter experts, with new technologies.
  • Reviews new and existing systems design projects and procurement plans for compliance with standards and architectural plans. Ensures that solutions across platforms adhere to the enterprise architectural road map and support both short-term tactical plans as well as long-term strategic goals.
  • Ensure technology solutions in Production are monitored and assessed for performance and sustainability through
  • periodic health checks (such as capacity planning, incident and problem reviews)
  • Responsible for the planning, designing and developing an Informatica ETL solution using Informatica objects such as Mappings, Mapplets.
  • Worked with business owners, analysts, solution engineers, development teams and infrastructure services to communicate application and data architectures.
  • Provided expert advice, counsel and technical expertise to the project team to help assure that Informatica solutions are designed and developed in the optimal manner and in accordance with industry and Informatica best practices
  • Produce detail design document, low level design document and involved in code/document review. Participated in the maintenance and enhancement of the application and perform bug fixing
  • Developed ETL mappings, mapplets and transformations usingInformatica Power Center 9.0.1
  • Worked extensively on different types of transformations like source qualifier Transformation, expression, Aggregator, Router, filter, update strategy, lookup, sorter, joiner and sequence generator.
  • Tested all the business application rules with test & live data and automated, monitored the sessions usingWork Flow Managerand Workflow Monitor
  • Created, launched & scheduledWorkflows/sessions. Involved in thePerformance Tuningof Mappings and Sessions
  • Involved in automating the Informatica process by using Unix Shell Script.
  • Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for managementattention and/or escalation. Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Created effective test data, developed and performed thorough Unit test cases to ensure successful execution of the data loading processes.

Administrator Responsibilities:

  • Software installation/configuration, object migration and performance tuning/optimization, perform upgrades and apply hot fixes, Backup/Recovery of Informatica software, repository and configurations, server maintenance including troubleshooting server issues and performance monitoring and tuning.
  • Migration of Informatica Power Center mappings, Workflows, Sessions and Shared Objects.
  • Setup appropriate ETL administration best practices and procedures. Provided technical support for the Informatica environment, Worked with infrastructure teams to ensure an effective operating environment including throughput, repository sizing, capacity planning, monitoring and maintenance
  • Identifies, researches, and resolves ETL root cause of production issues or system problems.
  • Code/folder migration from one environment to another as part of release management
  • Maintain Relational Database connections with the assistance of DBAs.

Environment

Informatica PowerCenter 9.01,B2B Data Transformation 9.0.1,Data Quality 9.0.1,Test Data Management 9.0.1,Toad 9.7,Data Profiling,SQL, Unix Shell Scripts, F-Secure SSH 5.3 and Sun Solaris 9.0

Sr Informatica (ETL) Developer August 2010 To November 2010

Project: Confidential
Responsibilities:

  • Worked with functional and technical project leads, marketing, sales, finance, and other business groups to identify, analyze and document business requirements.
  • Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
  • Involved in customizing out of the box reports to support the business requirements.
  • Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for managementattention and/or escalation.
  • Provided expert advice, counsel and technical expertise to the project team to help assure that Informatica solutions are designed and developed in the optimal manner and in accordance with industry and Informatica best practices.
  • Involved in configuring sources, targets, tasks and execution plans using DAC.
  • ImplementedETL standardsandBest Practiceswhile naming Mappings, Transformations, links, Sessions, Workflow names, file names etc.
  • Involved inInformaticacode migrations and monitoring according to Informatica standards
  • Developed ETL mappings, mapplets and transformations usingInformatica Power Center 8.6.1
  • Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
  • Involved in automating the Informatica process by using Unix Shell Script.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.


Environment

Informatica PowerCenter 8.6.1,Oracle Business Intelligence suite 10.1.3.4, Oracle BI Apps 7.9.6/7.9.5,DAC, Toad 9.7,Data Validation Option, Metadata Manager 8.6.1,Data Profiling, Data Validation Option Tool, Data Analyser,SQL, Unix Shell Scripts, F-Secure SSH 5.3 and Sun Solaris 9.0

Sr Informatica (ETL) Developer/Informatica Administrator April 2009 To August 2010

Confidential, Baltimore

Developer Responsibilities:

  • Participated in the entire requirements engineering process right from requirements elicitation phase to the phase involving documenting of the requirements.
  • Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design.
  • Reviewed data models using Erwin tool to find out data model dependencies.
  • ImplementedETL standardsandBest Practiceswhile naming Mappings, Transformations, links, Sessions, Workflow names, file names etc.
  • Involved inInformaticacode migrations and monitoring according to Informatica standards
  • Developed ETL mappings, mapplets and transformations usingInformatica Power Center 8.6.1
  • Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
  • Converted PL/SQL procedures into Informatica mappings using various transformations.
  • Extensively usedETLto load data fromFlat Files,OracleandTeradata to Teradata
  • Worked extensively on different types of transformations like source qualifier Transformation, expression, Aggregator, Router, filter, update strategy, lookup, sorter, joiner and sequence generator.
  • Extensively wroteuser-defined SQLcoding for overriding for Auto generated SQL query in Source Qualifier Transformation.
  • Tested all the business application rules with test & live data and automated, monitored the sessions usingWork Flow Managerand Workflow Monitor
  • Created, launched & scheduledWorkflows/sessions. Involved in thePerformance Tuningof Mappings and Sessions
  • Migrated mappings and sessions and work flows from dev/test to production environment.
  • Expertise in writing BTEQ scripts in Teradata and running them by using shell scripts in Solaris environment.
  • Involved in automating the Informatica process by using Unix Shell Script.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Created effective test data, developed and performed thorough Unit test cases to ensure successful execution of the data loading processes.

Administrator Responsibilities:

  • Apply Informatica PowerCenter software installation/ upgrades and hot-fixes
  • Informatica Server maintenance including troubleshooting server issues and performance monitoring and tuning.
  • Software installation / configuration, object migration and performance tuning / optimization.
  • Migration of Informatica Power Center mappings, Workflows, Sessions and Shared Objects.
  • Setup appropriate ETL administration best practices and procedures.
  • Identifies, researches, and resolves ETL root cause of production issues or system problems.
  • Code/folder migration from one environment to another as part of release management
  • Work with the System Admin staff on physical optimizations.
  • Maintain Relational Database connections with the assistance of DBAs.

Environment

Informatica PowerCenter 8.6.1,Teradata12.0,Oracle 10g, Data Validation Option, Toad 9.6.1,Metadata Manager 8.6.1,Data Profiling, Data Validation Option Tool, Data Analyser,SQL,PL/SQL, Unix Shell Scripts, SQL Navigator 4.5, BTEQ, SQL Assistant, F-Secure SSH 5.3 and Sun Solaris 9.0

Sr Informatica (ETL) Developer Nov 2008 to April 2009

Confidential, Washington DC

Responsibilities:

  • Involved in design and development of interfaces, transactional logic, design and code reviews.
  • Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design.
  • ImplementedETL standardsandBest Practiceswhile naming Mappings, Transformations, links, Sessions, Workflow names, file names etc.
  • Developed ETL mappings, mapplets and transformations usingInformaticaPower Center 8.1.5
  • Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
  • Converted PL/SQL procedures into Informatica mappings using various transformations.
  • Extensively usedETLto load data fromOracletoORACLE
  • Worked extensively on different types of transformations like source qualifier Transformation, expression, Aggregator, Router, filter, update strategy, lookup, sorter, joiner and sequence generator.
  • Extensively wroteuser-defined SQLcoding for overriding for Auto generated SQL query in Source Qualifier Transformation.
  • Tested all the business application rules with test & live data and automated, monitored the sessions usingWork Flow Managerand Workflow Monitor
  • Created, launched & scheduledWorkflows/sessions. Involved in thePerformance Tuningof Mappings and Sessions
  • Migrated mappings and sessions and work flows from dev/test to production environment.
  • Involved in automating the Informatica process by using Unix Shell Script.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Involved in Unit Testing and System Testing.Created, updated and maintained ETL technical documentation.

Environment

Informatica-Power Center 8.1.5,Oracle 10g,SQL, STAR Schema, Toad 9.5, Unix Shell Scripts, TortoiseSVN and Sun Solaris

Sr Informatica (ETL) Developer Feb 2008 to Nov 2008

Confidential, Reston VA

Responsibilities:

  • Involved in the requirement definition and analysis in support of IODSDesignefforts.
  • Involved in design and development of interfaces, and transactional logic, design and code reviews.
  • ImplementedETL standardsandBest Practiceswhile naming Mappings, Transformations, links, Sessions, Workflow names, file names etc.
  • Developed ETL mappings, transformations usingInformaticaPower Center 8.5.1.
  • Involved in adding registration group for the Source System tables usingPowerExchange CDC 8.5
  • Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
  • Extensively usedETLto load data fromFlat Files and OracletoORACLE,SQL SERVER
  • Worked extensively on different types of transformations like source qualifier Transformation, expression, Aggregator, Router, filter, update strategy, lookup, sorter, joiner and sequence generator.
  • Tested all the business application rules with test & live data and automated, monitored the sessions usingWork Flow Managerand Workflow Monitor
  • Created, launched & scheduledWorkflows/sessions. Involved in thePerformance Tuningof Mappings and Sessions
  • Migrated mappings and sessions and work flows from dev/test to production environment.
  • Troubleshoot connectivity problems. Looked up and read session, event and error logs for troubleshooting
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Involved in Unit Testing and System Testing.Created, updated and maintained ETL technical documentation.

Environment

Informatica-Power Center 8.5.1,Power Exchange 8.5,Oracle 10g, SQL Server 2005, Flat Files ,SQL, STAR Schema, Toad 9.5, Unix Shell Scripts, LINUXv 2.4.36,SecureCRT 4.1.0,Rational Clear Case 7.0.1 and Windows NT

Sr Informatica (ETL) Developer Oct 2007 To Feb 2008

Confidential
Responsibilities:

  • Involved in design and development of interfaces, and transactional logic, design and code reviews.
  • Involved as Technical leadership role providing technical direction to technical team members working withInformatica, Providing mentoring and knowledge transfer.
  • Track record of successful delivery of conversion data at the individual and team levels, schedule management, resources and issue management.
  • Developed ETL mappings, transformations usingInformaticaPower Center 8.1.5
  • Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
  • Extensively usedETLto load data fromFlat Files and OracletoORACLE,Flat Files
  • Worked extensively on different types of transformations like source qualifier Transformation, expression, Aggregator, Router, filter, update strategy, lookup, sorter, joiner and sequence generator.
  • Modified several of the existing mappings and created several new mappings based on the user requirement.
  • Extensively wroteuser-defined SQLcoding for overriding for Auto generated SQL query in Source Qualifier Transformation.Used InformaticaDebuggerto validate and test the business logic implemented in the mappings and fix the bugs.
  • Tested all the business application rules with test & live data and automated, monitored the sessions usingWork Flow Managerand Workflow Monitor
  • Created, launched & scheduledWorkflows/sessions. Involved in thePerformance Tuningof Mappings and Sessions
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Involved in Unit Testing and System Testing.Created, updated and maintained ETL technical documentation.

Environment

Informatica-Power Center 8.1.5,Oracle 10g, NCR TERADATA 12.0,Flat Files ,SQL, STAR Schema, Toad 8.5, Unix Shell Scripts, PL/SQL,Sun Solaries 9.0 and Windows NT

Lead Informatica (ETL) Developer Jan 2007 To Oct 2007

Confidential

Responsibilities:

  • Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets
  • Involved in the requirement definition and analysis in support ofData Warehouse and Datmartefforts.
  • Developed ETL mappings, transformations usingInformaticaPower Center 7.1.4/8.1
  • Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
  • Extensively usedETLto load data fromFlat Files, Oracle andDB2toORACLE
  • Developed dataMappingsbetween source systems andwarehousecomponents using Mapping Designer.
  • Created, launched & scheduledWorkflows/sessions. Involved in thePerformance Tuningof Mappings and Sessions
  • Involved in generating reports usingBusiness Objects.
  • BO Universes and Reports to validate the data movement between the various stages from Source to Staging and Datamarts.
  • Webi Reports were created and deployed through Info View
  • Involved in fixing invalid Mappings, Testing of Informatica Sessions, Batches and the Target Data.
  • Troubleshoot connectivity problems. Looked up and read session, event and error logs for troubleshooting
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment

Informatica-Power Center 7.1.4/8.1,Oracle 10g, Db2 UDB 7.1 ,SQL, STAR Schema, Toad 7.3, CUTE FTP,Unix Shell Scripts, Business Objects XI, AIX 5.2 and Windows NT

Lead Informatica (ETL) Developer March 2006 To Jan 2007

Confidential, Fredericksburg, VA

Responsibilities:

  • Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets
  • Involved in preparing detailed ETL Design Documents.
  • Involved in the requirement definition and analysis in support ofData Warehouse and Datmartefforts.
  • Developed ETL mappings, transformations usingInformaticaPower Center 7.1.2
  • Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
  • Extensively usedETLto load data fromFlat Files, Oracle andSQL SERVERtoORACLE,SQL SERVER
  • Involved in generating reports usingBusiness Objects.
  • BO Universes and Reports to validate the data movement between the various stages from Source to Staging and Datamarts.
  • Troubleshoot connectivity problems. Looked up and read session, event and error logs for troubleshooting
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment

Informatica-Power Center 7.1.2,Oracle 10g, SQL SERVER 2000 ,SQL, STAR Schema, Toad 7.3, Unix Shell Scripts,Business Object 6.1, First Logic 4.2,HP-UX 11i and Windows NT

Sr.Informatica (ETL) Developer Nov 2005 To March 2006

Confidential
Responsibilities:

  • Involved in the requirement definition and analysis in support ofData Warehouse and ODSefforts.
  • Developed ETL mappings, transformations usingInformaticaPower Center 7.1.2
  • Extensively usedInformaticaclient tools – Source Analyzer, Warehouse designer, MappingDesigner, Mapplet Designer,TransformationDeveloper, InformaticaRepository Managerand InformaticaWorkflow Manager.
  • Extensively usedETLto load data fromMainframes, Oracle, ,XML,MQ Series,SAP and Flat FilestoOracle, Flat Files ,Teradata and XML
  • Developed dataMappingsbetween source systems andwarehousecomponents using Mapping Designer
  • Worked with PWS tool and Test Directory to get SIR’s to analyze and fix the code
  • Used Utilities Fast Load and BTEQ

Environment

Informatica-Power Center 7.1.2,TERADATAV2R4, Oracle 9i, XML, Power Connect for MQ Series,Power Connect for SAPR/3 ,SQL, STAR Schema, PWS(Project Workflow System), Toad 7.3, Unix Shell Scripts, HP-UX 11i, Sun Solaris 5.4, WINSQL, Documentum v 7.0 and Smart FTP v 1.5

Confidential Chicago IL July 2005 To Nov 2005

Responsibilities:

  • Involved in the requirement definition and analysis in support ofConversionefforts.
  • Developed ETL mappings, transformations usingInformaticaPower Center 7.1.1
  • Extensively usedInformaticaclient tools – Source Analyzer, Warehouse designer, MappingDesigner, Mapplet Designer,TransformationDeveloper, InformaticaRepository Managerand InformaticaWorkflow Manager.
  • Extensively usedETLto load data frommainframes, OracletoDB2UDBandOracle.
  • Worked with PWS tool and Test Directory to get SIR’s to analyze and fix the code
  • Troubleshooted connectivity problems. Looked up and read session, event and error logs for troubleshooting
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment

Informatica-Power Center 7.1.1,DB2 UDB 8.1, Power Exchange 5.2,Oracle 10G, SQL, STAR Schema, PWS(Project Workflow System) Toad 7.3, Unix Shell Scripts, HP-UX 11i, Sun Solaris 5.4, WINSQL,Humming Bird 9.0 ,CITRIX 7.0 ,Visual SourceSafe 6.0andWindows NT

Education:Bachelor of Engineering

Hire Now