Informatica Developer Resume
Norwalk, CT
SUMMARY
- Over 6 years of total IT experience in software analysis, design and development for various softwareapplications in client - server environment with expertise in providing Business Intelligence solutions in Data Warehousing for Decision Support Systems.
- Excellent hands on experience in OLAP and ETL processing usingInformatica Power Center 6.x, 7.x, 8.x, Oracle8i/9i/10g.
- Experience in ETL process using ETL Tools, creating and maintaining Repository, Source systems, Target Databases and developing strategies for ETL mechanisms using ETL tools like Informatica PowerCenter.
- Gathering and analysis, design, development, testing, performance tuning, and production support.
- Extensive experience in Data warehouses with strong understanding of Dimensional Modeling, Star and Snowflake Schemas.
- Designed and developed complex mapping logic from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union and more.
- Proficient in using Workflow Manager Tools like Task Developer, Workflow Designer and Worklet Designer
- Experience in integration of various data sources with Multiple Relational Databases like OracleDB2 UDB, SQL Server, MS Access, and XML System.
- Hands on experience in tuning mappings, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings, and sessions.
- Involved in Data Warehouse QA Process. Good experience in Analyzing and Validating Large Volumes of Data from different systems.
- Experienced in developing applications in Oracle and writing Stored Procedures, Triggers and Functions in PL/SQL. Used SQL*loader to load data from Flat files into Oracle database.
- Good in writing shell scripts in UNIX to automate teh process of loading and pulling data from different servers.
- Hands-on in migrating Informatica maps versioned with releases maintained properly.
- Expertise In data analysis
TECHNICAL SKILLS
ETL Tools: Informatica Power Center 9.0.1/8.6.1/8.1.1/7.1.2/6.3
BI Tools: Micro strategy, Business Objects
Databases: Oracle 10g/9i/8i, SQL Server 2000/2005, DB2 7.x/8.x, My SQL.
Database Tools: Oracle SQL*Plus, SQL Navigator, Toad 7.4
Languages: C, C++, SQL, PL/ SQL, UNIX Shell Script (Bash, ksh),HTML
Office Suite: MS Word, MS Power Point, MS Excel, MS Access
Operating Systems: Windows XP/2000/NT/95/98, UNIX (Solaris 7/8/9, HP-UX, AIX)
PROFESSIONAL EXPERIENCE
Confidential, Norwalk, CT
Informatica Developer
Responsibilities:
- Responsible for preparing teh technical specifications from teh business requirements
- Analyze teh requirement, work out with teh solution. Develop and maintain teh detailed project documentation.
- Improved performance by identifying teh bottlenecks in Source, Target, Mapping and Session levels.
- Configured teh workflows for recovery and restartability.
- Worked on parameter files and variables to allow for reusability of teh ETLs
- Provide overall direction and guidance to ETL development and support for teh Prescription Solutions’ Data Mart.
- Used teh Shell Scripts for running teh session.
- Used Update strategy and Target load plans to load data into Type-2 Dimensions.
- Created and used reusable Mapplets and transformations using Informatica Power Center.
- Created Snapshots, Summary tables and materialized views in Database to reduce teh system overhead.
- Executed several sessions and created batches to automate teh loading process.
- Worked and developed extensively on Autosys job scheduling tool to schedule teh Informatica Workflows.
- Ensure integrity and availability of DBMS and reporting applications per service level agreements.
Environment: Windows,Informatica 9.0.1,Oracle 10g, DB2 UDB,Autosys, Unix ShellScripts, Windows 2008 advance server.
Confidential, NYC, NY
Informatica Developer
Responsibilities:
- Created Informatica mappings to build business rules to load data.
- Analyzed and Created Fact and Dimension Tables.
- Developed mappings using InformaticaPowerCenter Designer to load data from various source systems to target database.
- Created complex mappings using transformations like Source qualifier, Aggregators, Connected & Unconnected Lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, Sorter etc.
- Responsible to design, develop and unit test teh mappings.
- Created Mapplets with teh halp of Mapplet Designer and used those Mapplets in teh Mappings.
- Used Task developer in teh Workflow manager to define sessions
- Written design documentation for teh ETL maps.
- Unit tested teh maps by running SQL queries on source and target.
- Used heterogeneous files, flat files, Spreadsheets, Oracle stored procedures as sources
- Imported an XML file to Designer, did some modifications, used in teh Mappings and exported into an XML file.
- Worked with source teams to resolve data quality issues raised by end users
- Used different Data Warehouse techniques like Star-Schema,Snowflake Schema.
- Loaded data into target database from source database using Workflow Manager.
- Created and Scheduled Sessions based on demand, run on time, run only once using Informatica workflow Manager
- Was responsible for preparation and review of Solution Design Documents.
- Provided technical assistance during development and testing.
- Coordinated between teh client and teh other developers.
- Was involved in Raising and Resolving Issues.
- Prepared project documentation.
Environment: Oracle 9i, ERWIN4.0, Power-Center 7.1, 8.1.3 (Designer, Repository Manager, Workflow Manager andWorkflow Monitor), PL/SQL, DB2, Solaris 9, AIX/HPUX 10.20 and 11.0.
Confidential, Cherry Hill, NJ
ETL Developer
Responsibilities:
- Used Informatica Power Center for extraction, loading and transformation (ETL) of data in teh data warehouse.
- Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console.
- Extracted teh data from teh flat files and other RDBMS databases into staging area and populated onto data warehouse
- Developed and documented data Mappings/Transformations and Informatica sessions.
- Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data marts.
- Used teh Informatica Designer, Source Analyzer, Warehouse Designer and Mapping Designer.
- Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
- Used Informatica Power Center Workflow manager to create sessions, batches to run with teh logic embedded in teh mappings.
- Implemented Type 1 and Type 2 slowly changing dimensions.
- Used teh update strategy to effectively migrate data from source to target.
- Designed several mappings to extract teh data from teh Flat file sources and Relational Sources. Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
- Maintained stored definitions, transformation rules and targets definitions usingInformatica repository manager.
- Used Informatica as an ETL tool to extract data from Oracle manufacturing applications to Target system.
- Created and scheduled sessions and Batch process based on demand, run on time, run only once using Informatica server manager.
- Scheduled and monitored transformation processes using Informatica Server Manager.
- Used Informatica repository manager to backup and migrate metadata in development, test and production systems.
Environment: Informatica Power Center 6.2, Oracle 9i, DB2, PL/SQL, TOAD, SQL* Plus, SQL*Loader, SQL Server 2000, Erwin 4.5, Windows Server 2000.
Confidential
Datawarehouse Developer
Responsibilities:
- Interfaced with users and business analysts to gather information and requirements.
- Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using SAS, Ms Excel, Ms Access, SQL, PL/SQL AND UNIX.
- Extracted data from existing data source and performed ad-hoc queries by using SQL, PL/SQL, Ms Access and UNIX.
- Understood basic business analysis concepts for logical data modeling, data flow processing and data base design.
- Utilized skills for problem solving. Developed databases and data warehouse.
- Assisting with teh Design and coding and implementation of new production and data storage systems.
- Performing in-depth quantitative analysis or data analysis.
- Extensive system study, design, development and testing were carried out in teh Oracle environment tomeet teh customer requirements.
- Performed various SQL queries for business analysts.
- Analyzed teh data & build data warehouses by using SQL, PL/SQL, and SAS.
- Assisted in teh analysis, design, coding and development of building a new schema (staging tables, views, SQL files).
Environment: Oracle 9i, MS SQL Server 2005, UNIX, PL/SQL,UNIX shell scripting, SQL*PLUS, SQL, TOAD, Reports.