We provide IT Staff Augmentation Services!

Informatica Etl Developer Resume

NapA

SUMMARY:

  • Over 10 Years of IT Experience in designing, developing, implementing and delivering Full life cycle of Data warehousing project. Result oriented professional in analyzing the Business requirements Analysis, Data Modeling, Development using Informatica, Oracle, MS SQL server, Implementations and Testing of Data Warehousing and Database Business systems for Health Care, Financial, Insurance and involved in DATA MIGRATION from AS400 to Oracle for Confidential client.
  • Eight years of Development and Design Experience with Informatica Power Center 9.5/9.1/8.6/8.1/7.1/6. x. Informatica Power Mart 6.2/5.1/4.7, OLAP, OLTP and Data Mining.
  • Experience in all phases of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor).
  • Expertise in Health care domain like Medicare, Medicaid, and Insurances compliance within HIPPA regulation and requirement.
  • SAP Business Objects Data Services to populate the tables in Data ware house and Data marts.
  • Worked on DATA MIGRATION from Legacy systems to SAP Systems.
  • Proficient in using SAP Business Objects Data Services/Integrator to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle (SQL, PL/SQL), SQL Server.
  • More than Four years of experience in Data Analysis, Data profiling, and data Cleansing using Informatica tools like Informatica Data Quality and Data Analysis.
  • Extensive experience in Relational Database Systems design likes Oracle, SQL Server, MS Access; Multi - dimensional application and database development experience with SQL, SQL PLUS, Stored procedures.
  • Experience with Oracle SQL programming, Stored procedures, creating triggers, sequence generator on the target table
  • Experience in implementing complex Business rules by creating robust mappings using various transformations, mapplets, and reusable transformations, starting concurrent batch processes on the server and doing backup recovery and tuning of sessions and developing strategies.
  • Experience in Performance Tuning at various levels such as Source, Target, Mapping, Session, System and Partitioning.
  • Experience in handling data extraction from multiple source platforms like Flat files, Oracle, XML files, XLS files, Oracle to target areas like Data Marts and Data Warehouse.
  • Experience in creating Entity Relational & Dimensional Relational Data Models with Kimball and Inman Data warehousing methodologies (Star and Snow flake schema architectures, Fact/dimension tables), Star Schema/Snowflake modeling, FACT & Dimensions tables.
  • Experience with Data Modeling using Erwin 4.0 Data Modeler.
  • Experience with Initial & Incremental loading to Target databases using SCD Type1/Type2 loads
  • Experience in writing SQL queries and PL/SQL (Stored Procedures, Functions, and Triggers).
  • Proficient in using DB tools like Toad, SQL*Plus, SQL*Loader Query Analyzer and SQL Assist.
  • Demonstrated experience with Design and Implementation of Informatica (IDQ v8.6.1), Data Quality applications for the Business and Technology users across the entire full development life-cycle.
  • Experience in Oracle8i/9i/10g database, UNIX & NT operating system.
  • Actively involved in Performance Tuning and support on various platforms. SQL Tuning and creation of indexes for faster database access and better query performance
  • Self-motivated and able to work independently and as a member of a team.
  • Excellent communication, interpersonal and analytical skills.

TECHNICAL SKILLS:

Databases/Databases Tools: Oracle 8i/9i/10g, SQL Server 2007, MS Access, DB2, Teradata 13.0, TOAD 8.6, SQL plus, ERwin 4.0, Query Analyzer, SQL Assistant, SQL, SAP Data Services, Netezza 7.0.2

ETL/Reporting Tools: Informatica Power Center 9.6.1, Power Mart 6.2/5.1. Power Exchange9.0, IDQ, DVO.

Methodologies: Star Schema, Snowflake Schema, Fact and Dimension Tables.

Operating Systems: Windows XP/NT/95/98/2000, UNIX, LINUX, MS- DOS.

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, HTML, XML.

Query/Reporting: SQL, TOAD 6.5, SQL*Plus, Business Objects 5.1/5.0.

PROFESSIONAL EXPERIENCE:

Confidential, NAPA

Informatica ETL Developer

Responsibilities:

  • Worked closely with HQ-IT Architect to identify the key areas to automate the catalog validation process.
  • Involved with L3 support team to resolve tickets related to Informatica issues during data conversion.
  • Proposed an alternative catalog load process from RPM central to cloud in turn to Napa stores.
  • Worked with Product team to identify the key data issues and reported to Sales Force.
  • Worked with BI Architect team in Performance Tuning the catalog load process in production from 120 to 6 hours
  • Involved with Environment Planning Team to build CIQ environment for support team and also responsible to keep catalog data in synch with production.
  • Involved in building SSIS mapping using transformations like Lookup, Conditional Split, Aggregate, sort, join, merge, Union All to extract data from Production system for reporting purpose.
  • Worked with BI group and sales force to deploy Ad-hoc SQL queries to production.
  • Responsible to run the CIQ Informatica catalog load process to keep the data in synch with PRODUCTION. Also involved in end to end validation to keep physical store server for CIQ in synch with all 48 catalog tables.

Confidential

Senior ETL Developer (Agile)

Environment: Informatica Power Center 9.6.1, Netezza, SQL Server

Responsibilities:

  • Worked closely with Scrum master to understand the requirement and deliver every 21 days of iteration.
  • Coordinated with business users and business analysts on a regular basis to discuss the business requirement documents and transformed them into technical specification documents finally into Informatica code.
  • Notify the job failure to user groups and work with them to rerun the job and ensure the completion of the load.
  • Worked on modifying the existing Informatica code and connected Stored Procedure to split Store numbers based on Sku Id’s.Style Id’s.
  • Involved in meetings with the process team in order to help the process team work effectively and accurately.
  • Extensively worked on the migration of data from SQL-Server to Netezza.

Confidential

Application Developer (Agile)

Environment: Informatica Power Center 9.5, Oracle 11g, SQL Server

Responsibilities:

  • Working with an Agile, Scrum methodology to ensure delivery of high quality work with every monthly iteration.
  • Worked closely with project managers and other functional team members to meet tight Agile Deadline.
  • Actively participated in Team meeting to understand the requirement from the Business and delivered effective ETL Solutions.
  • The coordinated configuration of back-end components in support of application development to support Business.
  • Created variables and parameters files for the mapping and session so that it can migrate easily in a different environment and database.
  • Worked extensively on MKS and Informatica designer to design a robust end-to-end ETL process to board Confidential Merchants Into Chase Paymentech system involving transformation like Source Qualifier, Lookup, Update Strategy, Router, Aggregator, Sequence Generator, Filter, Expression, Stored Procedure, External Procedure, Transactional Control for the efficient extraction, transformation and loading of the data to the staging and then to the Data Mart (Data Warehouse) checking the complex logics for computing the facts.
  • Working closely with the testers in order to help with overall-testing completion of the commited Iteration Capacity.
  • Perform Unit testing by writing simple test scripts in the database and involved in integration testing and SQL script comparing from source to target.
  • Worked with Informatica workflow monitor in running and debugging its components and monitoring the resulting executable version.

Confidential, FL

Informatica Developer

Environment: Informatica Power Center 9.5, Oracle 11g, Data Services

Responsibilities:

  • Worked closely with Business and Architect to understand the requirements.
  • Responsible for converting the Business Requirements into Data Mapping Sheet.
  • Involved in creating the test cases.
  • Working on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
  • Responsible for maintaining EMR Cerner EDW using Power Insight.
  • Extract EMR data from Source using CCL scripts and loading it to PI EDW.

Confidential, Deerfield, FL

Informatica Developer

Environment: Informatica Power Center 9.5, Oracle 11g, Informatica DVO, Teradata 13, Oracle 10g and SqlServer.

Responsibilities:

  • Involved in Creating Test cases for both 8.6 and 9.5 Informatica.
  • Worked closely with Business and Architect to understand the requirements and environments.
  • Worked with Informatica Architect to set up Grid system with 4 nodes and two integration services.
  • Involved in creating new connections in workflow manager and updating the ODBC.ini and Parameter files accordingly TNS entries for Teradata 13, SQL-Server and Oracle 10g.
  • Worked with Informatica DVO tool to configure Regression Testing for 5000+ Tables using PowerCenter create appropriate mappings, sessions, and workflows, to compare Table pairs.
  • Involved in running several Workflows for each business to load data separately for 8.6 and 9.5 for regression testing.
  • Used UNIX scripts to run Workflows to run test maps in 8.6 and 9.5 environments.
  • Developer detailed DVO reports and TDD of the end results.
  • Generated several table compare reports for both 8.6 and 9.5.
  • Worked closely with Business and Architect to understand the requirements.
  • Responsible for converting the Business Requirements into Data Mapping Sheet.
  • Involved in creating the test cases.
  • Review of Source Systems and Designed and developed ETL and Data Quality mappings to load and transform data from source to ODS PC 9.5 and IDQ 8.6.1. Also provided knowledge transfer to the end users and created extensive documentation on the design.
  • Utilized Informatica IDQ 8.6.1 to complete initial Dataprofiling and matching/removing duplicate data.
  • Working on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.

Confidential

Informatica Developer

Environment: Informatics Power Center 9.1, SQL, PL/SQL, Linux, Oracle 11g, SQL Developer, DB2 (AS400), Teradata 12.0

Responsibilities:

  • Requirements gathering from Business users and prepared a TDD.
  • Involved in Rollback Strategy from Oracle back to DB2 for insu rance purposes.
  • Data Migration involves Extracting data from AS400 DB2 to load oracle every 2 hours using PWX CDC and Powercenter Informatica tool.
  • Worked closely with Business team to understand the requirements to convert BRD into Informatica code.
  • Worked closely with Architect and Data warehouse team to Integrate for smooth flow of data.
  • Involved in creating Shared and Re-usable Objects in the shared folder and update the objects with the new requirements and changes.
  • Developed a total of 1600 mapping in a combination of COPY and CDC mapping.
  • Deployed the maps, workflows, and all dependent objects from development to testing, testing to QA and from QA to production.
  • Used Debugger to check the errors in the mapping and made appropriate changes in the mappings to generate the required results
  • Developed Mappings, Mapplets, and Reusable Transformations to extract, transform and load the data.
  • Used PMCMD Unix Scripts to Run and check the Status of the job.
  • Migrated code to Functional and performance environment using Deployment groups by creating labels.
  • Heavily involved in Performance Tuning of Informatica mappings to reduce the time taken for bactch jobs.
  • Prepared a detail Technical Design Document.

Confidential

Informatica Developer

Environment: Informatics Power Center 9.1, SQL, PL/SQL, UNIX, Oracle 9i, Win 2000, TOAD 5.0.

Responsibilities:

  • A collection of requirements from business users and analyzed based on the requirements.
  • Extensively used XML files to Design and develop complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications
  • Worked with TOAD to create and Alter Tables, Triggers, Sequences, and other DDL, DML and DCL utilities of Oracle 9i and 10g
  • Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
  • Worked on identifying Mapping Bottlenecks in Source, Target and Mappings to Improve performance
  • Monitored workflows and session using Power Center workflow monitor.

Confidential

Informatica Developer

Environment: Informatica Power Center 9.1, Oracle 10g, PL/SQL, TOAD, Flat Files, Windows XP, UNIX, Tidal TES v6.0

Responsibilities:

  • Involved in meeting with business to gather, Designed the target load process based on the requirement documents.
  • Optimized the performance using Informatica Performance Concepts.
  • Developed Mappings and Workflows to generate Staging Files.
  • Developed Mappings and Workflows to load the data into Oracle tables.
  • Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator, Stored Procedure for loading the data into the target table.
  • Created Workflows, Tasks, Database Connections using Workflow Manager
  • Developed Complex Informatica mappings and tuned them for better performance
  • Created sessions and batches to move data at specific intervals.
  • Responsibilities include creating the Sessions and Scheduling the sessions
  • Recovering the failed Sessions and Batches.
  • Involving in Extracting the data from Oracle and Flat files
  • Implemented performance tuning techniques by identifying and resolving the Bottlenecks in the source, Target, Transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
  • Developing, Testing and Debugging the mappings in Informatica.
  • Data Validation Testing.
  • Preparing the documents for test Data Loading

Confidential, DC

Informatica Developer

Environment: Informatica Power Center 8.6, Win 2000, Flat Files, PL/SQL, Erwin 3.0, Toad 5.0.

Responsibilities:

  • Analyzed the business requirements and framing the business logic for the ETL process.
  • Extensively used ETL to load data from both fixed width as well as Delimited Flat files.
  • Worked extensively on different types of transformations like the expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator joiner, and normalizer.
  • Designed and Developed complex mappings, reusable Transformations for ETL using Informatica Power Center 8.6.
  • Developing and testing all the Informatica mappings involving complex Router, lookups and update strategies.
  • Created workflows and worklets for designed mappings.
  • Implemented variables and parameters in the mappings.
  • Setting up batches and sessions to schedule the loads at required frequency using Power center workflow manager.
  • Generated completion messages and status reports using workflow manager.
  • Working on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
  • Involved in writing ETL specifications and unit test plans for the mappings.
  • Performed Developer testing, Functional testing, Unit testing for the Informatica mappings.
  • Designed the ETL processes using Informatica to load data from SQL Server, Flat Files, XML Files and Excel files to target Oracle database.
  • Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator etc.
  • Written SQL overrides in source Qualifier according to business requirements.
  • Created reusable transformations and mapplets.
  • Redesigned some of the mappings in the system to meet new functionality.
  • Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent batches and Sessions and scheduling them to run at a specified time with required frequency.
  • Used workflow Monitor to monitor the performance of the Jobs.
  • Extensively worked in the performance tuning of the ETL process.

Confidential, Miami, FL

Project Engineer

Environment: Windows NT, Oracle 9i, Informatica 8.6, Power center RT, Erwin 3.5.2, and SQL Server 2000.

Responsibilities:

  • Understanding the requirements and the elements required for the reporting.
  • Analyzed the data coming from different sources and their relationships and created configuration tables.
  • Interacted with the business community and gathered requirements based on changing needs and incorporated identified factors into Informatica mappings to build Data Marts.
  • Responsible for the physical and logical design of the Datamart (Oracle9i) on Windows NT.
  • Updating existing ER diagram, database schema, and table definition as per client requirements.
  • Involved in creating dimension and fact tables in the database.
  • Identified, imported the sources and targets into shared folder and created shortcuts.
  • Extensively used mapplets, lookups, Expressions, aggregators, filters, sequence generators and other transformations in the mappings.
  • Written pre and post SQL in the source qualifier and target instance as required.
  • Created sessions and workflows and populated the data mart with the development data.
  • Used debuggers to detect bugs in the mappings with the development data.
  • Performed partitions on the sources to improve the performance.
  • Enabled incremental loading in fact table mappings and made required changes to the mappings to populate the production data.
  • Improved the performance of the mappings by indexing and tuning.

Hire Now