Sr. Etl / Informatica Developer Resume
Malvern, PA
SUMMARY:
- Over 8+ years of ETL and data integration experience in developing ETL mappings using Informatica Power Center 9.1/8.x/7.x (Designer Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer),Repository Manager, Workflow Manager& Workflow Monitor..
- Hands on experience with complex mappings with varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Filter, Source Qualifiers, Expression,Sorter, Joiner, Update Strategy and Re - usable transformations.
- Experience in Business Documentation especially in the Pharmaceutical Industry, Financial Industry, Insurance and Telecommunications Industry.
- Expertise in configuration, installation of Informatica&integration of various data sources like Oracle, MS SQL Server, XML, Flat files into the staging area and Design ETL processes that span multiple projects
- Experience in enhancements and maintenance activities of the data warehouse including performance tuning, writing of stored procedures for code enhancements, creating aggregate tables, and modifying target tables.
- Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Good understanding of OLAP concepts and challenges, especially with large data sets.
- Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2/Type3) loads.
- Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center 8.6.1/7.1.3.
- Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse.
- Implemented various Performance Tuning techniques on Sources, Targets, Mappings and Workflows in all versions of Informatica
- Working experience in UNIX shell scripting to manage and schedule workflows.
- Post production support, enhancements and performance tuning.
- Have clear understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and SDLC, Quality analysis, change management, compliance &Disaster recovery.
- Experienced with coordinating cross-functional teams, Project management and presenting technical ideas to diverse groups & Proven ability to implement technology based solutions for business problems
TECHNICAL SKILLS:
ETL Tools: Informatica Power Center 9.1/8.6/8.6.1/7.1.3
Databases: Oracle 10g/9i/8, MS SQL Server 2000/2005,MS Access
Software Tools: Toad, SQL *Loader, PL/SQL Developer, AR SystemLanguages:C, C++, SQL, PL/SQL
Operating Systems: UNIX, Windows NT, Windows 95/98/00/XP
PROFESSIONAL EXPERIENCE:
Confidential, Malvern, PA
Sr. ETL / Informatica Developer
Responsibilities:
- Designed and developed Informatica Mappings to load data from different Source systems to Data Warehouse.
- Populated Slowly Changing Dimensions using Informatica.
- Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for capturing delta loads
- Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
- Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
- Created Mapplet and used them in different Mappings.
- Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
- Worked with session logs, Informatica Debugger, and Performance logs for error handling.
- Tuned poorly performing mappings
Environment: Informatica Power Center 9 (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager), PowerEchange, PowerMart, PowerConnect, PowerAnalyzer, PL/SQL, SQL Server, Unix, Win XP
Confidential, Rochester, NY
Sr. ETL Developer
Responsibilities:
- Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
- Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
- Translated requirements into business rules & made recommendations for innovative IT solution.
- Involved in Designing High level Technical Documentation based on specifications provided by the Manager.
- Worked with the various enterprise groups to document user requirements, translate requirements in to system solutions and produce development, testing and implementation plan and schedule.
- Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
- Extensively used various transformations like Filter, Router, Sequence Generator, Look Ups, Update strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator
- Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for capturing delta loads
- Worked with the Informatica Scheduler for scheduling the delta loads and master loads
- Implemented Slowly Changing Dimensions. Created Type1, Type2, Type3 tables for different data backup requirements
- Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
- Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
- Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
- Worked with the Business Intelligence tools like Business Objects and Crystal Reports
- Extensively worked with various Look up Caches like Static, Dynamic and Persistent Caches
- Worked with session logs, Informatica Debugger, and Performance logs for error handling
- Worked extensively with the business intelligence team to in corporate any changes that they need in the delivered files.
Environment: Informatica Power Center 8.6.1, Workflow Designer, Power center Designer, Repository Manager, PowerMart, Power Exchange, PowerAnalyzer, Terradata, Oracle 10g, Visio, MS office, TOAD 9.0, Windows NT/2000/XP
Confidential, Lansing, MI
ETL Developer
Responsibilities:
- Developed various mappings for extracting the data from different source systems using Informatica, PL/SQL stored procedures
- Developed mappings for extracting data from legacy and Oracle Applications into our data warehouse
- Update Strategy, Rank, Expression and lookups (connected and unconnected) while transforming the Sales Force Data according to the business logic.
- Involved in creating and running Sessions and Workflows using Informatica Workflow Manager and monitoring using Workflow Monitor
- Supporting Informatica Production Environment
- Troubleshooting and Resolving Performance and related issues.
- Created Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
- Worked extensively on SQL, PL/SQL and UNIX Shell Scripts.
- Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
- Used PMCMD command for running Informatica from backend.
- Used relational sources and flat files to populate the data warehouse.
- Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
Environment: Informatica Power Center 8.6.1/7.1, Workflow Manager, Workflow Monitor, Informatica Power Connect, Power Exchange, Power Analyzer, PL/SQL, Oracle 10g/9i, DB2 8.0, SQL Server 2005/2000, Windows Server 2003, Oracle 10g/9i, UNIX, Toad
Confidential, Providence, RI
ETL Developer
Responsibilities:
- Involved in analysis and requirements gathering and translating high-level business requirements into logical business dimensional model.
- Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin tool.
- Data integrated different source and target databases like Oracle, MS SQL Server, Teradata, DB2 and Microsoft EXCEL to the ETL tool.
- Created Different Mappings, Mapplets, Worklets applied required Transformations based on Source to Target mapping document specifications.
- Implemented Performance tuning of targets, sources, mappings and sessionsusing round robin, hash auto key, Key range partitioning.
- Created complex mappings using Unconnected Lookup, Sorter, Aggregator, and dynamic Lookup and Router transformations for populating target table in efficient manner.
- Created and established different Metadata, and Data load connections while designing mapping and loading data to Target.
- Implemented stored procedures, created sessions, Experienced in Workflow manager, Workflow monitor, Task developer, Debugger, fixing Errors.
- Managed Change control implementation and coordinating daily, monthly releases and reruns by Scheduling tasks.
- Implemented SQL Override in mappings Using complex SQL, PLSQL Logic.
- Data Quality Analysis to determine cleansing requirements.
- Designedand Customized data models for Data Mart supporting data from multiple sources on real time. Designed the Data Mart defining Entities, Attributes and relationships between them.
- Designed and developed Oracle PL/SQL scripts for Data Import/Export. Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process and terminating process.
- Generated reports using BI tools and Ad hoc reports using Reporting tool querying database.
- Performed Unit Testing and worked with the end user at various stages of the test cycles.
Environment: Informatica Power Center 7.1 (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager), PL/SQL, Oracle10g/11g, DB2, SQL Server, PL/SQL, Flat files, Windows XP
Confidential
ETL CONSULTANT
Responsibilities:
- Informatica Mapping Designer tools were used to design the source definition, target definition and transformations to build mappings.
- Extracting source definitions from various databases like Oracle, SQL Server and flat files.
- Creating the mappings using a variety of transformations like Source Qualifier, Lookup (static/dynamic cache, connected/unconnected,, Stored Procedures Routers, Filters, Aggregator, Normalizer, Unions, Update Strategies, Sorters.
- Working extensively with Shared Folders, Mapping Parameters & Parameter files in the mappings.
- Developing several Informatica mappings and tuned them for better performance.
- Developing, scheduling, monitoring workflows using Informatica Workflow Manager & Workflow Monitor.
- Creating Pre-session and Post-session UNIX scripts to disable/enable Indices, running procedures.
- Designing and Developing Oracle PL/SQL objects, Shell Scripts for Data Conversions and Data Cleansing.
- Creating Test Cases, Unit Testing and Integration Testing to ensure the successful execution of data load. .
- Participating in the System Integration Test, User Acceptance Test of the code, creating packages and moving code across environments.
Environment: Informatica Power Center 5.1, Oracle 7.3, SQL Server 2000, TOAD, UNIX