Etl Informatica Developer Resume
Chicago, IL
SUMMARY
- 7 ½ years of IT experience in System design, development and maintenance.
- 7 years of Technical and Functional experience in Decision Support Systems - Data Warehousing, ETL development.
- Experience in various stages of System Development Life Cycle(SDLC) and its approaches likeWaterfall,Spiral,Agile,and Prototyping Model.
- Worked in a variety of Business domains which include Ecommerce, Healthcare, Finance, Networking,, Telecom, including off-shoring models.
- Extensively used Informatica Power Center/Power Mart (10.1/9.5/9.1/8.6.1/8.5/7.1/5.1 ) for ETL (Extraction, Transformation and Loading) of data from multiple source database systems to Data Warehouses in UNIX/Windows environment.
- Solid understanding of Data Warehousing life cycle and strong working experience on Data Warehousing applications.
- Understanding & Working knowledge of InformaticaCDC (Change Data Capture)
- Experience in Database Design, Entity-Relationship modeling, Dimensional modeling like Star schema and Snowflake schema.
- Experience working with various Heterogeneous Source Systems like Oracle 8i/9i/10g/11g, MS SQL Server 2008, XML, Flat files.
- Directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
- Extensively worked on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
- Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc.
- Strong experience in Slowly Changing Dimension Mappings of type I, II and III.
- Extensive experience in Creating and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Primary keys, Sequence, Synonyms and Database Link.
- Expert in developing SQL, PL/SQL, Database Triggers, Exceptions, Packages, Stored Procedures and Functions.
- Experience in Performance Tuning techniques Confidential various levels such as Source, Target, Mapping, and Session levels.
- Experience in SQL Performance Tuning using Explain Plan, Tkprof, Hints and Indexes.
- Exposure to Data Modeling, Reengineering and Logical & Physical database designs using Erwin.
- Used Autosys Scheduler in creating and scheduling the job’s run timings.
- Effective communications skills (verbal and written) for both highly technical and non-technical audiences.
- Team Player, Able to Work with a new and fresh perspective on work assignments, good in debugging, creative and able to learn new things.
- Highly motivated, energetic individual and a very good team player willing to work hard to meet intensive schedules and having excellent communication, presentation and interpersonal skills.
- Experienced in production support activities
TECHNICAL SKILLS
ETL Tools: Informatica 5.1/7.1/8.5//8.6.1/9.1/9.5/10.1 (Power Mart & Power Center)
RDBMS: Oracle 11g,10g,9i,8i, MS SQL Server 2008, MY SQL
Data Modeling: Dimensional Data Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Physical and Logical Data Modeling, Entities, Attributes, Cardinality, ER Diagrams, ERWIN, MS Visio
Tools: Toad, Oracle SQL Developer, Autosys, JCL, Dimensions, MS Visio, Erwin, SQL * Plus, PL/SQL Editor, SQL * Loader
Business Intelligence: Business Objects XIR3
Language: SQL/ PL SQL, Unix Shell Scripting, C, and C++, HTML, XML
Operating Systems: UNIX, Windows 2003/2000/XP/98, Win NT, Fedora Linux, MS-Dos.
System Design & Dev: Requirements Gathering and Analysis, Data Analysis, ETL Design, Reporting Environment Design, Development and Testing UAT Implementation.
PROFESSIONAL EXPERIENCE
Confidential, Chicago, IL
ETL Informatica Developer
Responsibilities:
- Working with business analysts to gather business requirements and implementing the same into a functional data warehouse design.
- Involved in creating Logical and Physical design of data models using Visio.
- Actively involved in requirements gathering and complete life cycle of the project.
- Involved in Migration of Informatica 9.5 to Informatica 10.1
- Extensively worked on Informatica client tools - Source Analyzer, Warehouse Designer, Transformation developer, Mapplets Designer, Mapping Designer, Workflow Designer, Worklet Designer and Task Developer.
- Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, XML files...etc. into the Staging table and then to the target database.
- Created different parameter files and changed Session parameters, mapping parameters, and variables Confidential run time.
- Developed new and maintaining existing Informatica mappings and workflows based on specifications.
- Created Mapplets, reusable transformations, Worklets and used them in different mappings, workflows.
- Used Source qualifier, Expression, Aggregator, Lookup, Router, Normalizer, Sorter, Stored Procedure transformations to do necessary data calculations and manipulations according to the business rules and loaded data into Target systems.
- Performed trunk & Load process by using stored procedure transformation and load control table to stage the data.
- Worked on Slowly Changing Dimensions i.e. Type1 & Type2.
- Performed incremental aggregation to load incremental data into aggregate tables.
- Developed PL/SQL scripts, stored procedures, Indexes, Constraints, partitions and triggers in Oracle.
- Worked on production issues like bug fixing, bottlenecks, data validation and report errors.
- Performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
- Created pass through session partitions to improve performance of reading source data.
- Extensively used Shell scripts to automate the Pre-Session and Post-Sessions processes.
- Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
- Scheduled the entire process in Autosys.
- Worked with reporting team to help understand them the user requirements on the reports and the measures on them.
- Involved in designing and developing the reporting requirements by using Business Object Xi3.1, Business Objects Report Designer.
Environment: Informatica Power Center 10.1/9.5, Erwin, MS Visio, Oracle 11g/10g, SQL,PL/SQL, TOAD, MY SQL, SQL Server 2008, Mainframe, XML, Business Objects Xi 3.1,Autosys, UNIX Shell Scripting, MKS Integrity.
Confidential
ETL Informatica Developer
Responsibilities:
- Developed various Mappings with the collection of all Sources, Targets, and Transformations using Designer.
- Used SAS for pre-processing data, SQL queries, data analysis, generating reports, and statistical analysis.
- Identified problems with the data and produced derived data sets, tables, listings and figures, which used to analyze the data.
- Resolved business and technical queries from business partners related to decision making and reporting on data available in the Data warehouse.
- DevelopedSASprograms for Data cleaning, Data mining and Reporting and to support routing processing
- Responsibility included requirement study, developing use cases for business layer and Dimensional Data Modeling and coordinating the team for development.
- Performed extraction, transformation and loading of data from RDBM Stables and Flat File sources into Oracle 11g RDBMS in accordance with requirements and specifications.
- Developed and designedSASprograms/macros to analyze marketing data and creating files, tables, listings, and graphs.
- Designed and developed Mapplets and re-usable transformations, and used them in different mappings.
- Applied slowly changing dimensions like type 1 and type 2 effectively to handle the delta loads.
- Used Debugger to test the data flow and fix the mappings.
- Created Workflows in the Workflow designer and executed tasks such as Sessions, Commands, etc. and Monitored transformation processes using Workflow monitor.
- Developed Test Plans, test scripts and executed the test scripts.
- Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
- Involved in performance tuning of the Informatica mapping and identifying the bottlenecks.
- Prepared the Test Plan and Testing Strategies for Data Warehousing Application. Setting up, monitoring and using Job Control System in Development/QA/Prod.
- Migrated the workflows and scripts from development environment to test and production environment.
- Actively involved in production support and transferred the knowledge to the other team members.
Environment: Informatica Power Center 9.1, PL/SQL developer, SAS, Oracle 11g, Flat files, UNIX, Teradata.
Confidential, Cedar Rapids, IA
ETL Informatica Developer
Responsibilities:
- As a consultant studied the existing DataMarts to understand and integrate the new source of data.
- Managing the off shore support group in India for support issue as well as small enhancements for data warehouse.
- Preparing the weekly status report and coordinating weekly status calls with technology lead/business
- Designed and created new Informatica jobs to implement new business logic into the existing process
- Using Informatica modules (Repository Manager, Designer, Workflow Manager and Workflow
- Monitor) to accomplish end to end ETL process.
- Performed data profiling with Sources to analyse the content, quality and structure of source data during mapping development.
- Created required scripts/transformations to extract the source data from various sources such as Oracle, Flat Files etc.
- Used all the complex functionality of informatica (Mapplets, Stored Procedures, Normalizer,
- Update Strategy, Router, Joiner, Java, SQL Transformation Etc...) to interpret the business logic into the ETL mappings.
- Designed and developed complex aggregate, joiner, lookup transformations to implement the business rules in the ETL mappings to load the target Facts and Dimensions.
- Defined Target Load Order Plan for loading data into Target Tables
- Used Mapplets and Reusable Transformations prevent redundancy of transformation usage and maintainability.
- Created Complex Informatica mappings and in other hand Simple mappings with Complex SQLs in it based on the need or requirement of business user.
- Used Informatica’s features to implement Type 1, 2, 3 changes in slowly changing dimension, Change Data Capture (CDC)
- Different database triggers Created and configured workflows, worklets & Sessions to transport the data to target systems using Informatica Workflow Manager.
- Fine-tuned the session performance using Session partitioning for long running sessions.
- Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
- Used Versioning, Labels and Deployment group in the production move process.
- Automation of Workflow using UNIX scripts using PMCMD, PMserver commands.
- Setup Permissions for Groups and Users in all Environments (Dev, UAT and Prod).
- Created tables, views, primary keys, indexes, constraints, sequences, grants and synonym.
- Involved in developing optimized code using PL/SQL for Server related Packages to centralize the application through procedures containing PL/SQL were created and stored in the database and fired off when contents of database were changed.
- Used debugger to test the mapping and fixed the bugs.
- Conducted Design and Code reviews and extensive documentation of standards, best practices and
- ETL Procedures.
- Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run Confidential specified time.
- Developed Oracle Stored Procedures, Packages and Functions and utilized in ETL Process.
- Handled the performance tuning of Informatica Mappings Confidential various level to accomplish the established standard throughput.
- Analysed the Target Data mart for accuracy of data for the pre-defined reporting needs.
- Wrote complex SQLs to achieve and interpret the reporting needs into the ETL Process. Also worked n SQL tuning to achieve the maximum throughput.
- Assisted in all aspects of the project to meet the scheduled delivery time..
- Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
- Conducted unit testing of all ETL mappings as well as helped QA team in conducting their testing.
- Wrote UNIX shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
- Used Autosys Tool to schedule shell scripts and Informatica jobs.
- Performed Unit, Grid Integration, Testing and validate results with end users.
- Worked as a part of a team and provided 7 x 24 support
Environment: Informatica Power Center 9.5, Erwin, MS Visio, Oracle 11g, SQL, PL/SQL, Oracle Sql Developer Tool, SQL Server 2008, Flat Files, XML, Mainframe, Cobol Files, Autosys, UNIX Shell Scripting, Subversion.
Confidential
ETL Informatica Developer
Responsibilities:
- The goal of the project was to analyze the data and identify the consumer and provide them with the promotional offers to customer satisfaction. The promotional offers included providing them with discounts and special plan depending on the usage and billing.
- Provided with data cleansing techniques that can be used for multiple systems including billing, customer service centers and e-channels.
- Developed mappings in Informatica to load thedatafrom various sources includes SQL server, DB2, Oracle, Flat files into theDataWarehouse, using different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations.
- Applied source to target mapping and generated mapping matrix for transformation.
- Performed the customer profiling using number of different classifications which helped the organization to target relevant customers with product and service offers, which helped them to retain the existing customers and add the new customers.
- Debugged the mapping in Informatica using debug wizard to observe the flow of data using different test case for different types of data.
- Configured and installed MySQL Enterprise monitor tools and connect all MySQL instances.
- Configured MySQL and reconfigure InnoDB pool size for better performance.
- Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance.
- Analyzed the source data and made decisions on appropriate extraction, transformation and loading strategies.
- Involved with Business Analysts team in requirements gathering and in preparing functional specifications and changing them into technical specifications.
Environment: Oracle 10g, SQL Server 2003, Toad, MySQL, Informatica 7.1.
Confidential
ETL Informatica Developer
Responsibilities:
- This application is mainly used for managing and utilizing the resources effectively and project allocations in the sector. It provides interfaces for Resource Management that offers cross-project hierarchical pool of people to assign to projects by skill sets for a specific month, Program Management that streamline program initiation and identifying of sub-projects and Skill capacity.
- Worked on ETL optimization, troubleshooting and analyzing Informatica mappings.
- Source systems data from the distributed environment was extracted, transformed and loaded into the Data warehouse using Informatica.
- Development, Testing, Implementation & Training of users.
- Performed requirements gathering and Gap analysis for the ETL load.
- Worked as a key player in Database Modeling, Design and Normalization.
- Created mappings for Historical and Incremental Loads.
- Used Version Control to check in and checkout versions of objects.
- Designed the Source Definition, Target Definition and Transformation for building mappings using the designer tools.
- Involved in the Design, development and implementation of mappings using Informatica Power Center designer and creating Design Documents.
- Worked on different Transformations like Source Qualifier, Joiner, Router, Aggregator, Lookup, Expression and Update Strategy to load data into target tables.
Environment: Informatica PowerCenter 8.1/ 8.6, Oracle, MS PowerPoint, MS Access, Microsoft Excel, Ewrin Tool.