Sr.informatica Consultant Resume
Dallas, TX
SUMMARY
- Over 7+ years of IT experience in Enterprise Development for Data Warehouse solutions its functionalities using ETL and OLAP tools, in areas of Finance, Insurance, Retail, Banking and Healthcare with various levels of SDLC - Project analysis, design, development, coding and implementation of Data warehouse, Database and Data Marts.
- Strong experience in Informatica Power Center / Power Exchange / Data Validation(Installation & Configuration),Informatica Cloud Integration,OLAP, OLTP concepts.
- Expert-level in designing and developing complex mappings to extract data from multiple sources such as flat flies, XML files, RDBMS tables. Informatica Designer tools - Warehouse Designer, Mapping Designer, Mapplet Designer, Transformations, Workflow Manager and Monitor.
- Experience in Data Design and Analysis, User Requirements its Analysis, Data Transformations, Data Cleansing, Web Service Integration, Database Relationships, Source Systems Analysis and Reporting Analysis
- Complete Knowledge of Data Warehouse methodologies its concepts like Ralph Kimball and Bill Inmon - Star and Snowflake schema, Operation Data Store (ODS), Enterprise Data Warehouse (EDW) and Metadata repository, Data Migration Technique from using Informatica.
- Installation and configuration of Informatica Server and Informatica Repository Server in Windows-UNIX Operating Systems.
- Developed Batch Jobs using UNIX Shell Scripts (csh, bash and ksh) to automate the process of Informatica workflows.
- Good working experience on Database Systems like Oracle 11g,10g, 9i, 8i, SQL Server 2008 and MySQL.
- Good experience in Performance Tuning of Mappings/Sessions, Develop complex database SQL and PL/SQL to validate ETL & Report testing.
- Experience on Performance Tuning of Mappings and Sessions and Batches and fixed bottlenecksand tuned the complex Informatica mappings for better Performance.
- Expertise in Data warehouse Development, Implementation, Documentation, Data Base Testing, Data warehouse Testing, ETL Testing and Production support.
- Experience in Developing Integration system Testing scenarios, Test scripts and Test execution using Quality Center.
- Closely working with Dev lead, Test lead, Project Manager, Business Analysts and Developers.
- Team player, motivated and dynamic with excellent oral and written communication skills.
- Good working experience using Pervasive Data Integration 9.5.
TECHNICAL SKILLS
ETL Tools: Informatica Power Center / Power Exchange / Data Validation 9.5.1/9.1.0/8.6/8.1 , Pervasive Data Integration 9.5
OLAP/BI: Business Objects, Crystal Reports XI, Cognos Impromptu, Cognos Power play, Cognos IWR, Jasper 4.7.1.
Data Modeling: Erwin, Visio, Star-Schema Modeling, FACT and Dimension Tables
DBMS: Oracle 11g/10g/9i/8i, MySQL 5.1, Microsoft Access, SQL Server 2012, MS Excel, Flat Files.
Languages: C, C++, Java, SQL, PL/SQL, T-SQL, HTML, DHTML, XML, UNIX, Shell Scripting, Visual basic, ASP, JSP, XML, Macromedia Software, JCL.
Scripting Languages: Java Script and UNIX Shell Scripting.
Operating Systems: Windows 7/2008/2003/NT/XP, HP-Unix, Linux.
Design Skills: Object Oriented Analysis Design using UML, MS- VISIO, ERwin.
Others: MS Project, MS Office Suite, SQL Developer, TOAD, Control - M, Autosys.
PROFESSIONAL EXPERIENCE
Confidential - Dallas, TX
Sr.Informatica Consultant
RESPONSIBILTIES:
- Extensively used Informatica Client tools-Designer, Workflow Manager, Workflow Monitor, Repository Manager, and Repository Server Administration Console.
- Developed Naming Standards, Best Practices for ETL development.
- Extensively used InformaticaPowerCenter 9.5.1 to extract data from various sources, which included flat files, XML Files, Oracle tables, Flat Files.
- Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter,Router, Aggregator, Lookup, Update Strategy, Stored Procedure, and Sequence generator, Joiner,Unionand Normalizer.
- CreatedMapplet, Parameter Files wherever necessary to facilitate reusability of business logic.
- Involved in developing the Deployment Strategy for Deployment of Source Code between theVarious Repositories (Dev, QAand Prod).
- Created Reusable Transformations, Worklets, and made use of the Shared Folder Concept using shortcuts wherever possible to avoid redundancy.
- Followed Informatica recommended Standards and Best Practices to improve Performance of ETL mappings.
- Used Debugger making use of Breakpoints to monitor data movement and troubleshoot the mappings.
- Created and viewed reports and filtered data using Data Validationtool
- Developed Test cases for Unit Testing of the Mappings, and also was involved in the Integration Testing.
- Full lifecycle oversight of code fixes and monthly deployments, including requirements gathering, design, coding, testing, and deployment.
- Developed UNIX Shell scripts for data cleaning and loading process.
- Checked the accuracy of data loaded into Oracle.
- Analyzed and remediated the existing Informatica mapping logic for load processes and system standards.
- Monitored the Data Quality, Generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.
- Implemented Error Processing for Informatica Mappings and Workflows.
- Effectively documented all Development work done.
- Used TOAD to develop and debug oracle PL/SQL Functions, Procedures and Packages.
- Monitored and improved query performance by creating views, indexes, hints and correlated subqueries.
- Wrote Unix Shell Scripts to perform several operations on text files.
Environment: Informatica Power Center 9.5.1, Data Validation 9.6, Oracle 11g, TOAD 12, Oracle Enterprise Linux, Windows 7, ERWIN, Autosys, Business Objects.
Confidential - Washington, DC
Sr.ETL Consultant
RESPONSIBILITIES:
- Involved different phases of SDLCin agile model for requirement, design, development, testing, training and rollout to the field user and support for production environment.
- Worked with Pervasive Repository Explorer, InformaticaPower center client tools like Source Analyzer, Warehouse Designer, and Mapping.
- Created source and target mappings, transformation logic and processes to reflect the changing business environment over time.
- Designed and developed mapping, transformation logic and processes in Informatica and Pervasive Data Integration for implementing business rules and standardization of source data from multiple systems into the data warehouse.
- Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner and Update Strategy.
- Worked with slowly changing dimension Type1, Type2, and Type3.
- Workflow Manager used for creating and maintaining the Sessions, Monitor, edit, schedule, copy, abort and delete the session.
- Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
- Worked in MySQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, and Sequences etc., closely worked with DBAs to create Physical Databases.
- Involved in designing the Data mart and entire data warehousing life cycle.
- Involved and Worked with DBA to build Dimension Tables and Fact Tables.
- Interacted extensively with user and Involved in gathering requirements, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Integration test plan, Unit test plan Release notes etc.
Environment: Informatica 9.1.1, Pervasive Data Integration 9.5, MySQL 5.1, MS-Excel, MS-VISIO, Expressor, Java TOAD, JASPER 4.7.1
Confidential - Dallas, TX
Sr. ETL Developer
RESPONSIBILITIES:
- Understanding existing legacy system and extensively worked on the requirement definition and analysis in support of Data Warehousing efforts.
- Worked with Architect, Business Analyst and Project Manager in design, migration and scheduling of informatica jobs.
- Using Transformations to clean the data from staging area as per the Data Warehouse requirements.
- Extraction, Transformation and loading of data from DB2, MS-Access, MS-Excel, flat file sources into oracle database.
- Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
- Extensively worked with various Passive transformationsand Active Transformationsin InformaticaPowerCenter likeExpression Transformation, Sequence Generator, Lookup Transformation
- Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
- Successfully Implemented Slowly Changing Dimensions (SCD). Used Type 2 dimension to keep the history changes.
- Used Shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
- Migrated mappings, sessions and workflows from Development to Testing and then to Production environments by using labeling and creation of deployment group.
- Involved in Error handling strategies, Unit, System testing, UNIX test scripts, test scripts and fix bugs in the application.
- Created Control-M jobs by using Control-M tool and run jobs through Control-M enterprise manager tool.
- Extensively worked in the performancetuning of the programs, ETL Procedures and processes.
Environment: Informatica 9.1.1,UNIX, Oracle 11g, Control-M, MS-Excel, MS-Access, TOAD, DB2, Business Objects
Confidential - Jersey City, NJ
Sr ETL Consultant
RESPONSIBILITIES:
- Study and analyze mapping document, the required source tables, data types, required transformations based on Business requirements and Technical specifications.
- Using Informatica Power Center, extracting data from Oracle, XML files and Flat Files.
- Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look ups (connected and unconnected)
- Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
- Expertise in Developing Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings and Workflows and Backup, Recovery.
- Used SQL over rides in Source Qualifier and Lookups to improve mapping performance.
- Developing Reusable Transformations, Aggregations and created Target Mappings that contain business rules.
- Extensively worked with various Passive transformations in InformaticaPowerCenter like Expression Transformation, Sequence Generator, and Lookup Transformation.
- Worked with various Active transformations in InformaticaPowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
- Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
- Created Connected and Unconnected lookup transformation for better performance of the mappings and sessions.
- Developed simple &complex mappings using Informatica to load Dimension & Fact tables as per STAR Schema techniques.
- Optimized the performance of the mappings by various tests on sources, targets and transformations.
- Performed extensive testing on the mappings and wrote queries using TOAD to check if the data was loading to the dimension tables and fact tables properly.
Environment: Informatica 8.6.1, ORACLE, TOAD, Erwin,Autosys, Cognos.
Confidential - Lansing, Michigan
Informatica Developer
RESPONSIBILITIES:
- Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager and Informatica workflow Manager.
- Extensively used ETL to load data from wide range of source such as flat files, oracle and XML to ORACLE.
- The project involved extracting data from various sources, transforming the data from these files before loading the data into target (warehouse) SQL server tables.
- Informatica Metadata repository was created using the Repository Manager as a hub for interaction between the various tools. Security and user management, repository backup was also done using the same tool.
- Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner and Update Strategy.
- Workflow Manager used for creating and maintaining the Sessions, Monitor, edit, schedule, copy, abort and delete the session.
- Messages and status reports using Workflow manager.
- Involved Working on Functional testing, Integration/ System testing, Regression testing, And User Acceptance Testing.
- Performance tuning of the process at the mapping level, session level, source level, and the target level.
- Extensively used un-connected Look-Ups for minimizing the run time and add to the performance of the server, while making sure to avoid duplicates of data from other source systems.
- Extensively worked in the performance tuning of programs, ETL procedures and processes.
- Created different types of reports, such as Master/Detail, Cross Tab and Chart UsingBO.
- Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts, test matrix and test cases for manual and automated testing.
Environment: InformaticaPowercenter 8.6/8.1, Windows XP, UNIX, Oracle 9i, SQL server, PL/SQL, ERwin, Business Objects, Autosys.
Confidential - South Portland, ME
ETL Developer
RESPONSIBILITIES:
- Responsible for Business Analysis and Requirements Collection.
- Translated requirements into business rules & made recommendations for innovative IT solution.
- Worked with the various enterprise groups to document user requirements, translate requirements into system solutions and produce development, testing and implementation plan and schedule.
- Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
- Developed, documented and executed unit test plans for the components.
- Set some understanding according to the business approach and making development while confirming with BA’s, if any BR (Business Rule) being used was not effective. In a way, that using the experience and business understanding to make out BR’s and implements them to design the business logics.
- Documenting the developed code, run the sessions and workflows, while keeping track of source and target row count.
- Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
- Created pre-session and post-session shell scripts and mail-notifications.
- Extensively worked on the Informatica Designer, Repository Manager, Repository Server, Workflow Manager/Server Manager and Workflow Monitor.
- Extensive use of Performance tuning techniques to minimize the run time and create pre-session caches with load being balanced on server.
Environment: Informatica Power Center 8.1.1, Oracle 9i, PL/SQL Developer, SQL Server 2005, UNIX, Control-M, Crystal Reports.
Confidential - Irving, TX
ETL Developer/Tester
RESPONSIBILITIES:
- Interacted with Business analyst and Project Manager to identify the business requirements. Walkthrough the Work Force Management and CVS.COM project architecture and scopes.
- Based on the requirement documents estimated efforts for Informatica design, development, integration testing, UAT testing, bug fixing, Control M Job design, migrating code with sub version tool.
- Worked with Kimball's Data Modeling concepts including data modeling, data marts, dimensional modeling, star and snowflake schema, fact aggregation and dimension tables, slowly changing dimensions and surrogate keys.
- Load operational data from SQL Server, flat files, Excel Worksheets into various data marts.
- Extensively developed various Mappings which perform Extraction, Transformation and Loading of Source data into the OLAP Schema, and used different Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, Joiner etc.
- Created Mappings in mapping designer with Call count by each 15-minute time interval for each store, date and time.
- Created reusable sessions, worklet’s and workflows in Workflow manager. Header and Trailer worklets used to found out the target file name and number of records in a session.
- Created PL/SQL procedures to truncate the tables in Oracle before Informatica job runs.
- Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
- Wrote UNIXshell scripts to work with flat files, to define parameter files and to create pre and post session commands.
- Involved in Unit Testing and Integration Testing of the application.
- Scheduled the Control-M jobs and Manual loads on daily, Weekly and monthly basis.
- Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
Environment: Informatica 8.1.1, UNIX, PUTTY, Oracle, SQL Server, Control-M, MS-Access, SQL Developer
Confidential
Jr. ETL Developer
RESPONSIBILITIES:
- Involved in Requirement Gathering, Analysis, Design & Development and Configuration Management for the above project.
- Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions
- Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
- Development and scheduling the Workflows.
- Troubleshoot the issues by checking sessions and workflow logs.
- Involved in analyzing the bugs, performance of SQL Queries and provided solutions to improve the same.
- Involved in identifying bottlenecks in source, target, mappings and sessions and resolved the bottlenecks byprovided data loading, monitoring, system support and general trouble shooting necessary for all the workflows.
Environment: Informatica 8.1.1, Oracle, Crystal Reports.