We provide IT Staff Augmentation Services!

Etl/informatica Developer Resume

3.00/5 (Submit Your Rating)

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

We'd love your feedback!