Informatica Developer Resume
Detroit, MI
SUMMARY
- Over 7 years combined IT experience in analysis, design, development, coding, testing, implementation, support of various projects using Data Warehousing tool like Informatica, Programming in Unix Shell Scripting, PL/SQL and Databases like Oracle, MS SQL Server.
- Very Strong experience in Extraction, Transformation, Loading (ETL) data from various sources (flat files, Oracle, SQL Server, and Teradata) into Data Warehouses and Data Marts using Informatica Power Center.
- Experience in working with Informatica Power Center 9.x/8.x
- Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Task View, Mapplets, Mappings, Workflows, Sessions, Re - usable Transformations, Shortcuts, Import and Export utilities
- Over four years of extensive experience in developing several PL/SQL procedures, queries, and UNIX Shell Scripts.
- Experience in the areas of Financial, Insurance and Retail domains.
- Strong skills including the ability to work through the entire development life (SDLC) cycle from gathering requirements through implementation, development, production, support and documentation of the complete project.
- Have Good understanding of ETL/Informatica standards and best practices, Slowly Changing Dimensions (SCD1,SCD2,SCD3)
- Expertise in Database Programming (Stored procedures, Triggers, Packages, PL/SQL, TSQL) using SQL Server 2008/2005, Oracle 10g/9.x
- Expertise in migration process across different environments Dev/QA/UAT/Prod and developing several shell scripts to run/stop/monitor workflows/trap errors.
- Very Good Programming skills using UNIX/Shell Scripts and PL/SQL for Automation and several ETL process.
- Very good Experience in Troubleshooting, Identifying Bottlenecks and performance tuning.
- Worked with ODS (Operational Data Source), Data validation and cleansing process.
- Experienced in various data systems like Oracle, SQL Server, Fixed Width and Delimited Flat Files, SQL Server, Informix, Sybase into ODS.
- Extensive experience in production support - involving in extensive data analysis, d implementation, troubleshoot and maintenance of different systems.
- Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
TECHNICAL SKILLS
DataWarehousingTool: ETL/ Informatica 9.0/8.6.1/8.5.1/8.1.1/7.1.4/6.2/5.1 (Power Center/Power Mart)
Databases: SQL Server 2005/2008, Oracle 10g/9i/8.x, MS Access 00/03/07, MySQL 5.1, Power Exchange
GUI: Toad, SQL*Loader, SSMS
Programming: UNIX Shell Scripting, PL/SQL, T- SQL, Windows Batch Scripts
Operating System: SUNOS, Solaris 6/7/8/9/10, Red Hat Linux 9, Windows 2000/XP, WinNT4.0, Windows Server 2003/2008.
Utilities: AutoSys, Remedy, Jira
PROFESSIONAL EXPERIENCE
Confidential, Detroit MI
Informatica Developer
Responsibilities:
- Responsible for full life cycle development including gathering requirements.
- Analyzing, coding, testing, and assisting with user acceptance testing, production implementation and system support for the IMS Data Warehouse Application.
- Will be a part of interviewing, gathering, documenting requirements and determining project scope from our Users; analyzing user requirements to create system designs, either coding all or sharing in the coding and development, unit testing, system testing, final implementation and post implementation monitoring.
- Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
- Involved in Debugging and Troubleshooting Informatica mappings.
- Populated error tables as part of the ETL process to capture the records that failed the migration.
- Used Informatica Power Center 9.1/9.01/8.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
- Implemented various Data Transformations for Slowly Changing Dimensions.
- Hands on experience as an Administrator involving Maintaining the Repository Manager for creating Repositories, user groups, folders and migrating code from Dev to Test, Test to Prod environments
- Working on the changes in the Informatica Mappings and testing them for Analyze and Fix gaps in Daily Jobs related to IMS project.
- Respond and resolve ad hoc requests from application and business users. Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
Environment: Informatica Power Center 8.6.1/9/1, SQL Server 2005/2008, TSQL, MS Excel, Windows XP/2003/2008, CA Scheduler change data capture.
Confidential, Chicago, IL
ETL/Informatica Developer
Responsibilities:
- Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses.
- Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
- Identified all the dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
- Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
- Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files, and load into Data warehouse using the PowerCenter, power exchange.
- Developed common routine mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
- Made use of mapping variables, mapping parameters and variable functions.
- Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
- Export/Import data from different data bases, flat files using DTS package and BCP by defining source and target.
- Written SQL Queries, Triggers, PL/SQL Procedures, Packages and UNIX Shell Scripts to apply and maintain the Business Rules.
- Checked performance tunning/debugging at different levels like workflows, mappings, database etc,.
- Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
- Created testing metrics using MS-Excel
- Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
- Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
- Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
- Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing.
- Created reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports
Environment: Informatica PowerCenter 7.1, Informatica Power Exchange, SQL Server 2000, Teradata 6, Oracle 9i,SQL, PL/SQL, UNIX Shell Scripts, Autosys, Remedy.
Confidential, Hoffman Estates,IL
Informatica Developer
Responsibilities:
- Involved in system study, analyze the requirements by meeting the client and designing the complete system.
- Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 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.
- Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
- Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
- Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
- Created E-mail notifications tasks using post-session scripts.
- Designed and developed unit test cases for system integration testing.
- Involved with the users in the creation of test scripts for the user acceptance testing
- Developed some scripts to take weekly backups of certain tables using import/export utilities.
- Worked on tuning some individual mappings and oracle queries that causing performance bottlenecks.
- Written documentation to describe program development, logic, coding, testing and changes made.
- Working on data request tickets and assisting business users (non technical) to understand the quality of the data.
Environment: Informatica Power Center 8.6.1/8.5, Oracle 10g/9i, DB2, SQL Server 2005/2000, PL/SQL, Toad, MS Access, Windows 2003, Shell Scripting, Sun Solaris 9.0, Windows 2003/2008, AutoSys.
Confidential
Informatica Developer
Responsibilities:
- Analyzed user requirements for the system.
- Responsible for verification of functional specifications and review of deliverables.
- Designed and Created data cleansing, validation and loading scripts for Oracle data warehouse using Informatica PowerCenter 7.1.
- Extensively used Informatica Client Tools - Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer, and Informatica Repository.
- Created reusable transformations and mapplets to use in multiple mappings.
- Used debugger to test the data flow and fix the mappings.
- Created and monitored workflows and tasks using Informatica PowerCenter Work flow Manager. Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
- Imported Relational metadata extract and load relational data.
- Setting up batches and sessions to schedule the loads at required frequency using PowerCenter server manager.
- Involved in Version control of the jobs to keep track of the changes in the Development Environment.
- Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
- Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
- Developed Unit test cases for the jobs.
- Provided assistance during user testing (interaction with the users).
Environment: Informatica Power Center 7.1(Designer, Workflow Manager, Workflow Monitor, Repository Manager), Informatica Power Connect, Oracle 8i, UNIX Shell Scripting, TOAD (Tool for Oracle Application Developer), Oracle Designer.
Confidential
Informatica Developer
Responsibilities:
- Reviewing the ETL solutions in Informatica Power Center 6.x
- Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
- Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
- Designed and developed Informatica mappings for data loads and data cleansing.
- Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
- Validation of Data using SQL queries.
- Designed and developed table structures, stored procedures and functions to implement business rules.
- Extensively involved in migration of ETL environment, Informatica, Database objects.
- Involved in jobs scheduling, monitoring and production support in a 24/7 environment.
Environment: Informatica PowerCenter 6.1, SQL Server 2005/2000, OracleTeradata, SQL, PL/SQL,, UNIX Shell Scripts, Windows 2000.