Informatica Developer Resume
Madison, WI
SUMMARY
- Over 7 years of IT experience as specialist in performing Analysis, Design, Development, Testing, Deployment, and Maintenance for various software applications.
- Extensive noledge on the SDLC development life cycle. Involved in different phases starting from Requirement Gathering to Production Deployments.
- Extensive experience in ETL design, development and maintenance using SQL, PL/SQL, Informatica Power Center 9.x/8.x/7.x on UNIX and Windows platforms.
- Proficient in the development of solutions usingInformatica (Siperian) MDM Hub.
- Expertise in Data Warehousing, Data Migration, Data Integration using Business Intelligence (BI) tools such as Informatica Power Center, Power Exchange CDC, B2B Data Transformation, Informatica Data Quality, Informatica Data Explorer, MDM, SSIS, OBIEE, Congo s, etc.,
- Worked with various source systems such as Relational Sources, Flat files, XML, Mainframe COBOL and VSAM files, SAP Sources/Targets and Web Services etc.
- Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups
- Extensive noledge of various Performance Tuning Techniques on Sources, Targets, Informatica Mappings, Sessions, and Data Base Tuning.
- Experience in writing BTEQ scripts and loading data into Teradata using FASTLOAD, MLOAD and TPUMP utilities.
- Expertise on integration mappings including dynamic cache lookup, shared, and persistent cache for mappings of Type me, Type II, and Type III Slowly Changing Dimensions and implementing update strategies, incremental loads, and change data capture.
- Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes
- Expertise in defining and documenting ETL Process Flow, Job Execution Sequence, Job Scheduling and Alerting Mechanisms using command line utilities.
- Extensive experience in implementing Error Handling, Auditing and Reconciliation and Balancing Mechanisms in ETL process.
- Knowledge of various Data Modeling techniques such as E - R modeling, and Dimensional modeling (Star/Snowflake Schema).
- Strong Expertise in Database Design, development of SQL Scripts, Stored Procedures, Functions, Packages, Triggers using Oracle PL/SQL, T-SQL, Teradata SQL, DB2 SQL PL, etc.
- Knowledge of Informatica Administration, complete installation and upgrade of Informatica 8x.
- Working noledge of other integration tools such as SSIS, Data stage, Abinitio, etc.
- Worked on creating reports using OBIEE, Oracle Analytic functions, Business Objects and Congo s.
- Experience in UNIX Shell Scripting for applying data fixes and automation of ETL jobs.
- Committed individual with excellent interpersonal, analytical and communication skills.
- Ability to work simultaneously on multiple projects, work independently as well as a team member.
TECHNICAL SKILLS
Operating Systems: Windows 2003/XP//Vista/7, Windows Server 2003, UNIX
ETL Tools: Informatica Power Center 9.5/9.1/8.x/7.x., Power Exchange, and Metadata Manager, Informatica MDM Multi-domain 9.1, Siberian MRM XU, Informatica Data Director (IDD)
Data Modeling: ERwin, E-R Studio, UML
Databases: Oracle 11g/10g//9i, SQL Server 2005/2008, Teradata, DB2, Sybase, Netezza, etc.
Languages: C, C++, Java, SQL, PL/SQL, T-SQL, HTML, XML, UNIX Shell Scripting, VB
Reporting Tools: OBIEE 10g, Business Objects, Congo’s, SSRS etc.
Other Tools: HP Quality Center, Tivoli, Tidal, Autosys, Control-M
PROFESSIONAL EXPERIENCE
Confidential, Madison, WI
Informatica Developer
Responsibilities:
- Documented User Requirements, translated requirements into system solutions and developed implementation plan and schedule.
- Involved in data modeling and designed the Data Warehouse using Star Schema methodology. Also responsible for all ongoing data model design decisions and database implementation strategies.
- Extracted data from different source systems such as Oracle, SQLServer, DB2, Mainframes, XML and Flat Files.
- Developed Complex transformations, Mapplets using Informatica to Extract, Transform and Load Data into Datamarts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
- Used Metadata Manager to manage the Metadata associated with the ETL processes.
- Used Power Center Data Masking Options (Random Masking, Blurring, SSN, and Credit Card) in mappings.
- Used error handling mapplets to capture error data into PMERR tables for handling nulls, analysis and error remediation process.
- Identified slow running ETL jobs and reduced the run time drastically by applying performance tuning techniques.
- Advocated best practices for ETL Processes and conducted Data Integration COP meetings.
- Created slice and dice and drill down Reports, Dashboards, and Scorecards using OBIEE 11g for various subject areas.
Environment: Informatica Power Center 9.5/9.1.1/8.6 , Power Exchange CDC, Oracle 11g, PL/SQL, TOAD, ERwin, Quality Center, SQL SERVER 2005/2008, XML, T-SQL, Shell Scripts, Control-M. Teradata
Confidential, McLean, VA
Informatica ETL Developer
Responsibilities:
- Understanding of the business requirements and current technology challenges & issues.
- Design and Develop Client centric Master Data Management solution.
- Designed, Installed and Configured the Informatica MDM Multi domain. (Hub Server, Cleanse, Cleanse Adaptor, Resource Kit)
- Configured Match and Merge Rules in improving the data quality by match analysis, analysis of the MDM system performance and tuning the performance by changing the existing cleanse function, match rules etc.
- Involved in developing and configuring the Hierarchies using Hierarchy Manager to identify hierarchical relationships.
- Designed, Configured and tested Informatica Data Director (IDD) interfaces. Provided weekly status updates on progress, status and fatal errors in IDD.
- Steered ETL team towards designing and development of extraction mappings for inbound source to MDM and then outbound MDM to consuming systems.
- Developed Synchronization process using Tibco Designer to invoke web service and perform Database calls for Siperian Tokens.
Environment: Informatica Multi Domain MDM 9.1, Informatica Data Director, Informatica Data Quality 9.x, Informatica Power Center 9.1, SIF, Weblogic, Oracle 10g, SQL Developer, Address Doctor, Toad, SQL*Loader, Windows server 2003, Erwin.
Confidential, Des Moines, IA
Informatica Developer
Responsibilities:
- Analyzed the functional specs provided by the data architect and createdTechnical System DesignDocuments and Source to Target mappingdocuments.
- Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
- Designed, Installed and Configured the Informatica MDM Multi domain. (Hub Server, Cleanse, Cleanse Adaptor, Resource Kit)
- Defined Business rules in Informatica Data Quality (IDQ) to evaluate data quality by creating cleanse processes to monitor compliance with standards and also identified areas for gaps and assisted in resolving data quality issues.
- Hands on executing MDM hub Batch Jobs (Stage, Load, Tokenize and Match Processes) and Batch Groups
- Involved in designing Staging and Data mart environments and built DDL scripts to reverse engineer the logical/physical data model usingERwin.
- Informatica Power Exchange for Mainframe was used to read/write VSAM files from/to the Mainframe.
- DesignedAudit tablefor ETL anddeveloped Error Handling Processes for Bureau Submission.
- Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
- Managed Change Control Implementation and coordinating daily, monthly releases and reruns.
- Responsible for Code Migration, Code Review, Test Plans, Test Scenarios, Test Cases as part ofUnit/Integrations testing, UAT testing.
Environment: Informatica MDM 9.1,Informatica Power Center 8.6, Power Exchange, SAP, Oracle 11g, PL/SQL, TOAD, SQL SERVER 2005/2008, XML, UNIX, Windows XP, OBIEE
Confidential, Tulsa, OK
Informatica Developer
Responsibilities:
- Involved in Dimensional Modeling (Star Schema) of the Data Warehouse and used ERwin 3.5 to design the business process, grain, dimensions and measured facts.
- Extensively migrated data from different source systems such as Flat Files, Relational, SAP, and XML sources to ODS, Data Marts, and Data Warehouse running on Teradata using utilities like MultiLoad and Fast Load.
- Used Type 1 and Type 2 SCD mappings to update Slowly Changing Dimension tables using Power Exchange Change Data Capture (CDC).
- Involved in extraction of data from Teradata and writing to flat files using BTEQ and FastExport and loading data into Teradata from flat files using Multiload.
- Using Informatica Power Exchange for Siebel to extract and integrate customer relationship management (CRM) data stored in Siebel.
- Informatica Data Quality (IDQ) was used to identify Data Duplication and understand the quality of data. Used Informatica Data Explorer (IDE) tool for profiling the data prior to migration.
- Used Shell Scripts to schedule PMCMD to interact with Informatica Server from command mode.
- Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
- Worked with testers and participated in Unit, Integration, Regression and Performance testing of ETL applications.
Environment: Informatica Power Center 8.6.1, Informatica Power Exchange (CDC), Informatica Data Quality (IDQ), Oracle 11g, Teradata, AIX, PL/SQL, TOAD, HP-UX, Autosys, DB2.
Confidential, NJ
Informatica ETL Developer
Responsibilities:
- Designed multi dimensional Star schema, Generated the database scripts, E - R diagrams using ERWIN.
- Participated with the Data Architect in the dimensional modeling of the Market Quality Data warehouse
- Involved in the creation of universes for the data warehouse project.
- Wrote Shell scripts for the daily maintenance operations of the Database like backup procedures, checking the space allocations and table space analysis.
- Generated reports of Multidimensional analysis, slice and dice and drill down reports.
- Involved in the configuration of Business Objects for 2 tier and 3-tier architecture using Web Server.
- As Business Objects Administrator, worked extensively with Supervisor module in the process of controlling universe, restricting objects and data to universes and profile management.
- Worked extensively on BO Administration, optimization of universes and SQL Query, performance and tuning.
Environment: Informatica Power Center 8.1 Oracle 10g, Mainframes, DB2, MS SQL Server 2005, Toad, PL/SQL, SQL, XML, AIX
Confidential
Informatica ETL Developer
Responsibilities:
- Involved and Designed the System Development Life Cycle, me.e. such as conducting the preliminary investigation and technical specs.
- Involved in creation of tables, writing stored procedures, Triggers, PL/SQL Libraries.
- Created facts and dimensions according to the business requirements.
- Performed Normalization and Logical Database Design Unit Testing of the modules.
- Developed user - friendly forms for easy data entry.
- Created UNIX shell scripts to invoke the SQL scripts which are run daily.
Environment: Oracle Database 8i, SQL, PL/SQL, Sun Solaris V5.8, Windows 2000, Toad, Test Director