We provide IT Staff Augmentation Services!

Sr. Informatica Developer/ Lead Resume

Wall St, NyC

SUMMARY:

  • 10+ years of IT experience in System Analysis, Design, coding and testing of Data Warehousing implementations across Financial, Pharmaceutical and Retail Industries.
  • 10 years of Data Warehousing experience using Informatica PowerCenter 10.1.1, 9.6.1, 9.1.0, 8.6.1/8.1.1/7.1.1/7.0/6.2 , Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Work flow Monitor, Datamart, OLAP, OLTP, Mapplet, Transformations, Autosys, SQL*Plus, SQL*Loader.
  • Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
  • Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
  • One year of Informatica Data Quality experience with strong knowledge of transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
  • 8 years of experience using Oracle 12c/11g/10g/9i/8i/7.0, DB 2 8.0/7.0/6.0 , MS SQL Server 2005/2000/7.0/6.0 , Teradata, MS Access 7.0/2000.
  • 7 years of strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
  • 5 years of Dimensional Data Modeling experience on Data modeling, ERwin 7.1/4.5/4.0/3.5.5/3.5.2 , Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Datamarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling and Oracle Designer.
  • Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.
  • Experience in Performance tuning of the Informatica and Oracle.
  • Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
  • Worked on the design and implementation of Slowly Changing Dimensions (Type 1, Type 2 and Type 6).
  • Well versed in using various DML and DDL statements including manipulation of stored procedures, functions, triggers, and views on different databases including MS-SQL Server, Oracle.
  • Extensively worked with SQL loader for bulk loading into the oracle database.
  • Thorough knowledge of Software Development Life Cycle including Planning, Analysis, Design, Implementation, and Maintenance.
  • Experience in UNIX Operating System and Shell scripting.
  • Over 8 years of experience leading, Mentoring, coordinating with teams in an Onsite-Offshore model.
  • Good skills with computer science concepts and programming.

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter 10.1.1, 9.6.1, 9.1.0, 8.6.1/8.1.1/7.1.1/7.0/6.2 , Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Work flow Monitor, Datamart, OLAP, OLTP, Autosys, SQL*Plus, SQL*Loader.

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration.

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ER Diagrams, ERWIN 7.1/4.5/4.0/3.5/3.2 , Oracle Designer.

Databases: Oracle 12c/11g/10g/9i/8i/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/ 2000/7.0/6.0 , Teradata, MS Access.

Reporting Tools: Oracle Business Intelligence, Business Objects.

Programming GUI: SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, Synopsis, Java, HTML, DHTML, C, C++, Unix Shell Scripting, PERL Programming

Scheduling Tools: Autosys, Control-M, ESP Scheduler

Environment: UNIX, Windows XP/Vista, Linux, MS DOS 6.22.

PROFESSIONAL EXPERIENCE:

Confidential, WALL ST, NYC

Sr. Informatica Developer/ Lead

Responsibilities:
  • Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
  • Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 10.1.1, 9.6.1, 9.1.0.
  • Created reusable transformations and mapplets and used them in mappings.
  • Used Informatica Power Center 10.1.1/9.6.1/9.1.0 for extraction, loading and transformation (ETL) of data in the data warehouse.
  • Implemented Informatica recommendations, methodologies and best practices.
  • Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
  • Worked on different data sources such as Oracle, Flat files etc.
  • Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
  • Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL Transformations.
  • Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
  • Created E-mail notifications tasks using post-session scripts.
  • Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
  • Collaborate with customers and onsite/offshore developers in order to execute projects through full lifecycle software development
  • Created deployment groups, migrated the code into different environments.
  • Actively involved in migrating objects from Informatica PowerCenter 9.1.0 to 9.6.1 and 10.1.1.
  • Validated new migrated objects like Mappings, Mapplets, Sessions, Worklets, Workflows and ODBC connections after migrating from Informatica PowerCenter 9.1.0 to 9.6.1 and 10.1.1.
  • Migrated and tested Informatica Folders, Parameter files, Shell Scripts from Informatica PowerCenter 9.1.0 to 9.6.1 and 10.1.1.
  • Written documentation to describe program development, logic, coding, testing, changes, corrections and Migration from 9.1 to 9.6.1 and 10.1.1.
  • Involved in managing the Unix servers and defining the file systems/directory structures on the Unix box for various parameters and deciding the disk space and memory requirements.
  • Provided support to develop the entire warehouse architecture and plan the ETL process.

Environment: Informatica Power Center 10.1.1/9.6.1/9.1.0 , Oracle 12c/11g, SQL Server, Toad for Oracle, UNIX, Shell Script, ESP Scheduler.

Confidential, Waukegan, IL

Sr. Informatica Developer/ Lead

Responsibilities:
  • Gather business requirements and design technical solution as per the requirements.
  • Understanding the source Systems and Client logical data model.
  • Work closely with team members to deliver improvements to line up with the Business rules.
  • Handled solely multiple projects including those involved with managing independent consultants and offshore teams
  • Work with IT and functional leads on researching solutions, investigating capabilities, developing requirements, and delivering system implementation.
  • Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
  • Used XML files and Relational tables as sources.
  • Extensively worked with Designer, Workflow Manager and Workflow Monitor.
  • Developed transformation logic and design various Mappings and Mapplets using the Informatica Designer.
  • Created complex mappings in Power Center Designer using Lookup, Aggregator, Expression, Router, Filter, Sorter and Update Strategy transformations.
  • Extensively used Transformations like XML Source Qualifier, Joiner, Normalizer and Expression transformation.
  • Assist with the improvement and practice of a development methodology to consistently enhance and predictably deliver product to customers.
  • Extensively used SQL and PL/SQL Scripts and worked in both UNIX and Windows Environment.
  • Use Workflow Manager to create Sessions and Tasks and used them to build Workflows and Worklets using various Tasks and scheduled the workflows to run at predetermined times
  • Used Indirect Source filetype to read multiple XML source files.
  • Used Pre, Post session commands and On Success, On Failure E-Mail and Variable assignment in Sessions.
  • Create and run debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
  • Created source definitions, from the operational sources, and target definitions.
  • Used Workflow Monitor to monitor tasks, workflows and to monitor performance
  • Responsible for Creating Design Documents like High Level ETL Design, Low level ETL Design and Create UNIT Test Cases
  • Responsible for Scheduling using Autosys.
  • Provide Tier 3 support for production applications on an as-needed basis.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, Toad for Oracle 10g, Microsoft SQL Server 2008, Toad for Data Analysis, SQL, PL/SQL, Altova for XML, UNIX, Shell Script, Autosys.

Confidential, Waukegan, IL

Sr. Informatica Developer

Responsibilities:
  • Gather business requirements and design technical solution as per the requirements.
  • Understanding the source Systems and Client logical data model.
  • Support of Informatica Jobs - Job monitoring, Re-runs and analysis of any issues during runs.
  • Designed Data Quality using IDQ and developed several informatica mappings.
  • Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ
  • Validation of report outputs like D84 and ZS44
  • Understanding the source systems and PPG logical data model
  • Worked on Informatica Designer tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer and Server Manager to create mappings with transformations & Mapplets confirming to the business rules and monitor sessions and batches. 
  • Worked on IDQ transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
  • Perform Impact analysis, ETL Design, coding and unit testing for the change raised.
  • Created summarized tables, control tables, staging tables to improve the system performance
  • Worked on bug fixes on existing Informatica Mappings to produce correct output.
  • Analyzed existing system and developed business documentation on changes required.
  • Adjusted in SQL (DBCR) scripts to create and alter tables.
  • Created design and operational documents of the enhancements provided in the project.

Environment: Informatica Power Center 8.6.1, Informatica Data Quality (IDQ) 8.6, Oracle 10g/9i, Toad for Oracle 10g, Teradata SQL Assistant, UNIX, Shell Script, Autosys.

Confidential, New York

Informatica Developer

Responsibilities:
  • Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
  • Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 7.1.1/8.6.1.
  • Created reusable transformations and mapplets and used them in mappings.
  • Used Informatica Power Center 8.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
  • Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin.
  • Implemented Informatica recommendations, methodologies and best practices.
  • Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
  • Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
  • Involved in creation of Folders using Repository Manager.
  • Worked on different data sources such as Oracle, SQL Server, Flat files etc.
  • Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
  • Extensively used Transformations like Router, Aggregator, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
  • Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
  • Created E-mail notifications tasks using post-session scripts.
  • Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
  • Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
  • Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
  • Created deployment groups, migrated the code into different environments.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Involved in managing the Unix servers and defining the file systems/directory structures on the Unix box for various parameters.
  • Provided support to develop the entire warehouse architecture and plan the ETL process.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, Toad for Oracle 10g, Toad for Data Analysis, SQL, PL/SQL, MS Access, UNIX, Shell Script, Control-M.

Confidential, MA

ETL / Informatica developer

Responsibilities:
  • Extensively used Informatica Power center, Power Exchange for extracting, transforming and loading data from relational sources and non-relational sources.
  • Extensively used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, DB2, XML and Flat files to Oracle.
  • Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
  • Handle slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
  • Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
  • Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
  • Created connected and Un-Connected transformations to lookup the data from Source and Target Tables.
  • Scheduled Sessions and Batches on the Informatica Server using Informatica workflow Manager.
  • Created complex PL/SQL stored procedures and functions.
  • Monitoring the ETL jobs and fixing the Bugs
  • Worked along with the DBA to resolve performance and tuning issues.
  • Provided reliable, timely support of integration, performance and user acceptance testing processes.
  • Involved in doing Unit Testing, Integration Testing and System Testing.
  • Identified and created various classes and objects for report development.

Environment:  Informatica PowerCenter 8.6, Oracle 10g/9i, XML, Teradata, Flatfiles, SQL, PL/SQL, TOAD, Perl, SQL*Plus, Windows, UNIX, Business Intelligence.

Confidential

Oracle Developer

Responsibilities:
  • Created the mapping documents based on the data model and the client requirements.
  • Developed Informatica Mappings as per the documents.
  • Responsible for testing and migration of ETL maps from the development to production environment.
  • Worked on performance tuning.
  • Prepared test cases and test plans.
  • Loading the data received from the wholesalers and the distributors, which are lying in the Unix box into the data warehouse on daily and weekly basis.
  • Involved in analysis of data in various modules of the project.
  • Worked with the data-modeling tool Erwin.
  • Loaded the Dimension tables with the various Sales force data at various levels.

Environment: Informatica Powercenter 6.2, Cognos 5.x/6.1, DB2, Oracle 8i, UNIX (Solaris), Windows NT.

Hire Now