Etl/informatica Developer Resume
Elmhurst, IL
SUMMARY
- Over 6+ years of diversified experience in the field of Information Technology with an emphasis on Data warehousing using Informatica PowerCenter 9.5/9.1/8.x Target Databases and developing Strategies for Extraction, Transformation and Loading (ETL) mechanism - using Informatica.
- Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
- Strong work experience in Data Mart life cycle development, performed ETL procedure to load data from different sources like SQL Server (2008/2012), Oracle, Teradata, and flat files into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor
- Involved in developing mappings and mapplets using Informatica Source Analyzer, Warehouse designer, Mapping Designer & Transformation Developer.
- Used various Transformations such as Expressions, Filters, and aggregators, Lookups, Routers, Normalizer, and Sequence Generator etc. to load data into different Oracle, SQL, Teradata databases.
- Experienced in PL/SQL.
- Automation and scheduling of UNIX shell scripts and Informatica sessions and batches using Autosys.
- Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
- Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
- Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
- Extensively involved in project coordination activities by keeping track of various project milestones and organizing weekly project reviews throughout the entire SDLC.
- Worked on data analysis and data validations and preparing Unit Test Cases.
- Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
- Experienced Informatica Data Quality (IDQ).
TECHNICAL SKILLS
ETL Tools: Informatica Power Center, 9.5,9.1, 8.x. IDQ
Databases: Oracle 10g, 11g, MS SQL Server 2008/2012, Teradata, Netezza
Environment: s UNIX, Windows, Linux
Tools: Toad 9.1, SQL developer, ERWIN
Languages: UNIX shell Script, SQL, PL/SQL
PROFESSIONAL EXPERIENCE
Confidential, Elmhurst, IL
ETL/Informatica Developer
Responsibilities:
- Worked closely with business analyst and Data Warehouse architect to understand the source data and need of the Warehouse.
- Translate customer requirements into formal requirements and design documents.
- Involved in creating the design and technical specifications for the ETL process based on Functional specifications.
- Written Informatica mapping for dropping and recreating the indexes of database tables.
- Development of address cleansing Mapplet and mapping using First logic plug-in.
- Worked extensively with Extraction, Transformation and Loading of data from Multiple Sources (oracle, Netezza, Teradata, fixed width and delimited flat files) to Oracle usingInformatica.
- Worked on Scheduling workflows and sessions usingInformaticascheduler and have implemented decision task and email task for tracking the successful completion
- Handled the creation of tables, views, triggers, stored procedures, functions, sequences in the database using SQL and PL/SQL scripts.
- Experience in using Teradata tools like Fast Load, Multi Load, TPump, Fast Export, Teradata Parallel Transporter (TPT) and BTEQ.
- Extensively used T-SQL in creating Procedure.
- Worked extensively on schema (Star schema) creations in data warehouse.
- Implemented complex mapping such as Slowly Changing Dimensions (Type 2).
- Worked on various types of transformations like Expression, Joiner, update strategy, Aggregator, Filter and Lookup.
- Created UNIX scripts for parsing and modifying data and experience in using Autosys job scheduler for automation of UNIX shell scripts and batch scheduling.
- Facilitate end-user procedures development.
Environment: Informatica Power Center 9.0.1/8.6.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 11g, DB2, Teradata, Netezza, XML, SQL Server 2012, UNIX, Toad, Autosys, Cognos.
Confidential, Philadelphia, PA
ETL/Informatica Developer
Responsibilities:
- Responsible for requirements gathering, analysis and end user Meetings.
- Design, development, deployment, and production support.
- Extracted Data from different source systems like Oracle, Flat files, Teradata, Netezza.
- Worked with PL/SQL to create complex queries and procedures.
- Worked with various transformations in Informatica power center like Filter, Aggregator, Joiner, Rank, Router, Sorter, Source qualifier, and Update Strategy transformations.
- Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, TO DATE, Decode, and IIF functions in Expression Transformation.
- Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join In the Joiner transformation.
- Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
- Responsible for best practices like naming conventions, Performance tuning, and Error Handling
- Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
- Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
- Responsible for Unit testing and Integration testing of mappings and workflows.
- Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
- Reviewed and tested Informatica ETL code and wrote test plans.
- Responsible for 24/7 Informatica production support.
- Involved in various meetings, seminars, presentations and group discussions.
- Imported Informatica Data Quality (IDQ) plans as mapplets into Power Center to analyze, standardize and cleanse the source data.
Environment: Informatica Power Center 9.1, Oracle 11g, Pl/SQL, Perl, TOAD, Erwin, SQL Server, Shell Scripts.
Confidential, Berlin, CT
ETL/Informatica Developer
Responsibilities:
- Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification.
- Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development.
- Used PL/SQL procedures for informatica mapping for truncating the data in target tables at runtime.
- Worked on Informatica PowerCenter 9.1 tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
- Extensively used Informatica PowerCenter to load data into different databases: SQL Server, Oracle, Teradata
- Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations.
- Implemented effective date range mapping (slowly changing dimension type2) methodology for accessing the full history of accounts and transaction information.
- Worked with Variables and Parameters in the mappings.
- Worked in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions. Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing
- DevelopedUNIX Shell Scriptsfor scheduling the sessions in Informatica.
- Involved inPerformance tuningfor sources, targets, mappings and sessions.
- Used breakpoints and various test conditions with Debugger tool to test the logic and the validity of the data moving through the mappings.
- Created logical and physical data models and maintained relationships between tables using Erwin.
- Created deployment groups, migrated the code into different environments.
- Experience with Application ILM, Data Quality and Data Governance.
- Worked closely with reporting team to generate various reports.
Environment: Informatica PowerCenter 9.1, PL/Sql, Teradata, TOAD, Oracle 10g, SQL Server, Teredata, UNIX Shell Scripts, Erwin.
Confidential, Hartford, CT
ETL/Informatica Developer
Responsibilities:
- Extracted data from relational databases Oracle, Flat Files, and Teradata.
- Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Enterprise Data warehouse (EDW) and Operational Data store (ODS).
- Developed data Mappings, Transformations between source systems and warehouse
- Performed Type 2 mappings.
- Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
- Performed Data Validations using Microsoft SQL Server Management Studio 2008.
- Worked closely with BA, and DBA team.
- Preparation of test cases/scenarios and execution.
- Recording, tracking and closing of defects/bugs in a systematic manner into a Defect Tracking System and preparation of bug report with bug severity and bug priority.
- Used debugger to test the mapping and fixed the bugs.
- Created sessions, sequential and concurrent sessions for proper execution of mappings in workflow manager.
- Used Power Center Data Masking Options (Random Masking, Blurring, SSN, Credit Card) in mappings.
- Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
- Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data).
- Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
- Included data from different sources like Oracle Stored Procedures and Personal data files in the same report.
- Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
Environment: Informatica Power Center 8.6.1, Oracle 10g, Access, Flat files, UNIX shell scripting, Windows XP, CA Autosys
Confidential, Phoenix, AZ
ETL/Informatica Developer
Responsibilities:
- Actively involved in gathering requirements from the end users.
- Involved in Data Extraction, Transformation and Loading from source systems
- Imported various Application Sources, created Targets and Transformations using Informatica Power Center 7.1.3 Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
- Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
- Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Rank, Update, Router and Sequence generator.
- Created reusable transformations and mapplets and used them in mappings.
- Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
- Did performance tuning at source, transformation, target, and workflow levels.
- Worked extensively with data migration between different versions.
- Experience in data migration in virtual environment
Environment: Informatica 7.1.3, Windows XP, TOAD, Oracle 9.2, Erwin, VSS, Putty, Business Objects 6.5.1, Test Director