Informatica Developer Resume Profile
AR
SKILLS INVENTORY
- Experience in data extraction, transformation and loading data using Informatica PowerCenter 9.0.1, 8.6, 8.3, 8.1/7.x Admin Console, Informatica Service, Repository Manager, Designer, Workflow Manager, and Workflow Monitor .
- Hands on experience on Informatica CDC, IDQ, MDM
- Experienced in integration of various data sources like Oracle 10g/9i/8i, IBM DB2, MS SQL Server 2012/2008/2005, XML files, Mainframe COBOL sources into staging area and different target databases.
- Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
- Gathering business and Technical requirements that would best suit the needs of the technical architectural development process.
- Performed data profiling in the source systems that are required for MDM system.
- Participated in all phases of the Software development lifecycle SDLC using both Agile and Waterfall methodologies.
- Experience in all stages of ETL - requirement gathering, designing and developing various mappings, unit testing, integration testing and regression testing.
- Design, develop, test and review optimize Informatica MDM Siperian and IDD Applications.
- Experience in Extraction, Transformation and Loading ETL of Data into Data Warehouse using Informatica PowerCenter 9.x, 8.x, 7.x versions.
- Extensive Experience in designing and developing complex mappings applying various transformations such as Expression, Aggregator, Lookup, Source qualifier, Update strategy, Filter, Router, Sequence generator, Rank, Stored procedure, Joiner and Sorter.
- Good knowledge on Data Analysis/Validation and Profiling based on the business and functional requirements of the Project.
- Proficient in the implementation of Data Cleanup procedures, Stored Procedures, Scripts and execution of Test plans for loading the data successfully into the various Target types Relational and flat file .
- Proficient in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon's SCD's ,Change Data Capture CDC ,Customer Data Integration CDI .
- Involved in performance improvements using partitioning, pushdown optimization and parallel loading.
- Involved in performance tuning and resolving performance bottlenecks of sources, transformation, targets, mappings and sessions.
- Experience in detecting/resolving bottlenecks at various levels like source, target, mapping and sessions.
- Prepare/maintain documentation on all aspects of ETL processes, definitions and mappings to support knowledge transfer to other team members.
- Used various database client tools like TOAD, SQL developer, SQL server to access/create/change database objects and create scripts.
- Extensively worked with Oracle, SQL Server and UNIX shell scripting ,Linux
- Involved in preparing required Tech Specification Documents from the Business requirements following Organization standard.
- Excellent written and verbal communication skills, good analytical reasoning and ability to learn quick and high adaptability to new tools and technologies.
- Involved in designing MDM data model and created base objects ,mappings ,defined trust setting for sources ,customized user exists CMXUE ,developed Match-Merge setup
- Define and design the Data Acquisition, Transformation, and Data Cleansing approach for the MDM implementation.
- Experience on Data Modeling Tools Erwin, Sybase Power designer.
- Experience in working on Enterprise Job scheduling tools like Autosys.
- Adept at communicating with business/clients for understanding business processes/problems, gathering requirements and providing solutions.
- Excellent oral/written/interpersonal communication skills, quick learner, willing to adapt to the team/organizational environment.
TOOLS/METHODS Informatica Power Center 9.0.1 8.x/7.x, Informatica MDM, Informatica Power Exchange, SqlServer Management Studio 2012/2008, Dimensional Data Modeling StarSchema Modeling, Snowflake Schema Modeling, FACT, Dimensions Tables , SQL Navigator, DB Artisan, Cognos, Oracle BI tools, OBIEE 10.1.3.1, Siebel Analytics, Business Objects Web-Intelligence 2.5, Designer 5.0, Crystal, reports and Developer Suite Set Analyzer 2.0 , SQL, PL/SQL, T-SQL, C, VB 5.0, Java, Unix Shell Scripting, Oracle 10g/9i/8i, MS SQL Server 2012/08/05, Teradata, IBM DB2, MS Access, TOAD 8.6, SQL plus, Query Analyzer, SQL Assistant | CLIENTS Wells Fargo GDF Suez North America, Inc. Burger King Corp. Plymouth Rock Assurance Campbell Soup Company Baptist Health South Florida ICICI Bank Volantis Technologies Ltd. EDUCATION Bachelor Degree, Osmania University, India. |
CHRONOLOGICAL SUMMARY OF EXPERIENCE
Senior ETL Analyst/Informatica MDM Developer
Confidential
- Involved in designing MDM data model and created base objects , mappings , defined trust setting for sources , customized user exists CMXUE etc.
- Define and design the Data Acquisition, Transformation, and Data Cleansing approach for the MDM implementation.
- Involved in translating business requirements to integrate into existing data mart design.
- Coordinated cross-functional team efforts in meeting and exceeding goals.
- Played a lead role in the requirement gathering, preparation of Engineering Requirement Specification document.
- Interact with business users for requirements gathering and converting these requirements into technical
- solutions for Informatica Master Data Management product
- Lead E2E technical solution to master client data integration complexity with various upstream and downstream systems
- Lead data mapping of source applications to the MDM data model
- Involved in System analysis, Estimations and design for enhancements.
- Troubleshooting and fine tuning of mappings for maximum.
- Utilized Informatica Data Quality IDQ extensively for loading the data into Informatica MDM Hub
- Proven experience in improving the data quality by Match analysis, analysis of the MDM system performance and tuning the performance by changing the existing cleanse function, match rules etc.
- Strong hands on working knowledge in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
- As part of optimization and reviewable process, performed design changes and changes in Informatica mappings, transformations, sessions and done code migration from one environment to other.
- Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation Connected and Unconnected , Joiner Transformation, and Router Transformation, Web services Transformation, XML transformation, DT and Normalizer Transformation in Informatica.
- Interacted DBA team to make sure application data base and also created all necessary data base objects for our project in Dev and Test Environments.
- Also provided all Database Object scripts for DBA team to deploy stage and prod DB environments.
- Reverse Engineered more than 20 SAP Business Objects reports and identified the source, underlying logic, and the transformation logic that was used to compile the Excel report
- Held meetings with business users to confirm business requirements.
- Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager.
- Created Mapplets and Reusable Transformations to prevent redundancy of transformation usage.
- Done Data cleansing, single and cross table structure profiling, analysis on data, and analyze the patterns with Informatica Data Explorer and generating reports and logs.
- Working on Informatica Developer Informatica Data Quality 9.0.1 and Informatica Analyst9.0.1 to cleanse and profile the data
- Worked on writing Pl/Sql procedures in Oracle and captured those by using Informatica stored Procedures.
- Generated Scorecards based on profile results
- Done single table structure profiling, cross table structure profiling.
- Created Data quality mappings plans and exporting those to power center as mapplets.
- Created Rules on profiled data and used the same to data quality mappings.
- Responsible for Unit Integration test environments and for data accuracy with consistency throughout its lifecycle.
- Developed BI reports comprising line and pie charts, trend analysis reports and sub-reports according to business requirements, using SQL Server Reporting Services SSRS .
- Developed several stored procedures using T-SQL for data manipulation.
- Upgraded Informatica 9.5.1 Standard Edition to Informatica 9.6.0 Advanced Edition successfully without any defects/issues for 4 Environments. Configured Repository Service, Integration Service, Web Service, Model Repository Service, Data Integration Service, Analyst Service, Content Management Service, Metadata Manager Service.
- Developed database monitoring and data validation reports in SQL Server Reporting Service SSRS .
Environment: Informatica Developer9.0.1, Informatica Analyst9.0.1, SQL Server, SAS. Informatica 9.6.0 9.5.1, SSRS, SSIS, Informatica Data Quality 9.6.0 9.5.1, Oracle 11g, UNIX, MS SQL Server, MDM, Teradata, MS Access, PL/SQL, My SQL and flat files, HP ALM, Microsoft Dynamics AX.
Informatica MDM Developer
Confidential
- Responsible for writing requirements for automation of online contract management tool.
- Involved in designing MDM data model and created base objects , mappings , defined trust setting for sources , customized user exists , customized IDD applications.
- Involved in the UAT testing of the Items Data Mart price files tool automation project.
- Responsible for handling Supply Chain Management Data Warehouse and related data base and online solutions.
- Work on writing use cases and requirements for Supply Chain Management data upload automation process.
- Involved in maintenance of reporting tools and processes utilizing Data Warehouse data.
- Worked with user support group to incorporate pharmacy contracts in the SCM Contract Catalog.
- Responsible for generating pricing reports from Finance Procurement Data Warehouse and Data Mart using Business Objects.
- Responsible for managing the online contract management repository and items data mart pricing information.
- Work on formulating the ETL rules using Informatica and Ab Initio.
- Used Informatica Power Center 9.0.1for migrating data from various OLTP databases to the data mart.
- Worked with different sources like Oracle, flat files, XML files, DB2, MS SQL Server
- Extracted data from Sales department to flat files and load the data to the target database
- Developed complex mappings using Informatica to load Dimension Fact tables as per STAR schema techniques.
- Extracted data from sources like fixed width and Delimited Flat files transformed the data according the business requirement and then loaded into Target Data mart.
- Created various Informatica mappings and mapplets to load the data mart. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
- Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation SCD Type-2 .
- Used Debugger to identify the errors in the mappings and fix them
- Performed unit testing to validate mappings and populate the database
- Used TOAD and SQL Plus to write queries and interact with Oracle database
- Implemented several different tasks Session, Assignment, Command, Decision, Timer, Email, Event-Raise, Event-Wait, Control in the workflow
- Involved in writing UNIX scripts and used them to automate the scheduling process
- Error Handling handled in Informatica Mappings sessions and also through validation script.
- Co-ordinated with DBA Team, Functional Team and offshore teams.
- Automation of job processing, establish automatic email notification to the concerned persons.
- Written documentation to describe program development, logic, coding, testing, changes and corrections.
- Used SQL Trace, Analyze, Explain Plan Utilities, and Hints for the performance tuning
- Managed the Metadata associated with the ETL processes used to populate the data warehouse.
- Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
- Worked with business users and gather data cleansing, data reconciliation and data convergence requirements
- Involved in Designing and developing the OBIEE/Siebel Metadata Repository .rpd using OBIEE/Siebel Analytics Admin tool by importing the required objects Dimensions and Facts with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions Drill-Down, Hierarchies Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
Environment: Informatica PowerCenter 9.0.1 Informatica Services, Repository Manager, Designer, Workflow Manager, and Workflow Monitor , Data explorer, Oracle 10g, , SQL Server 2012, PL/SQL, Flat files, PLSQL Developer.
Informatica MDM Developer
Confidential
- Responsible for architecting and developing ETL projects for transferring legacy applications data to enterprise data warehouse from end to end. It includes Retail data, HR data, Procurement data and sales data. Designed MDM solution across the department, so that single source of trusted data can be obtained throughout the organization. Analyzed legacy and data sources to bring ALL DATA to a centralized environment and developed data governance, data quality and architected to analyze large volume of information. Responsible for delivering customer information systems across the organization. Took responsibility for integrating variety of data systems, and geographically fragmented customer information.
- Configured and maintained various components of the MDM Hub including the schema, landing and staging tables, configuring Base Objects, Look-ups, Hierarchies, Queries and Query groups.
- Utilized Informatica Data Quality IDQ extensively for loading the data into Informatica MDM Hub
- Proven experience in improving the data quality by Match analysis, analysis of the MDM system performance and tuning the performance by changing the existing cleanse function, match rules etc.
- Strong hands on working knowledge in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
- Create high and low level ETL design to meet user requirements.
- Create other ETL artifacts such as functional requirement document, data model, source-to-Client mapping, test case matrix, deployment document etc.
- Independently develop efficient Informatica mappings, sessions and workflows as per the design specifications.
- Design ETL data model and conduct Knowledge Transfer sessions to share knowledge with the team.
- Support production ETL batch jobs.
- Evaluate, determine root cause and resolve production issues.
- Propose, implement and adhere to best practices, standards and processes.
- Installing and configuring the Informatica and supporting software's and utilities.
- Perform testing on connections, scripts, workflows, mappings and other scheduled activities.
- Creating repository backup scripts and automated in Active Batch V8 scheduler.
- Creating strategy documents, installation documents and supporting documents.
Environment: Informatica IDQ/IDE, Informatica MDM 9.5.1, Windows 2008 R2, MS Sql Server 2008 R2, Oracle 10g/11g, Perl, TOAD, WINSQL and PLSQL Developer
Informatica Developer
Confidential
- Involved in the design, development and implementation of ETL process using Informatica.
- Generated workflows using reusable tasks, worklets and workflows containing sessions, commands, event raise/wait, decision and timers for flow control
- Involved in optimization of ETL programs and SQL queries overriding SQL query in order to increase performance
- Worked with relational sources and flat files
- Involved in rigorous testing of ETL mappings
- Extensively involved in monitoring the jobs in order to detect and fix unknown bugs and track performance
- Provided excellent Informatica production support
- Used Debugger to test the mappings and fix the bugs
- Implemented Informatica Data Quality 8.5 to do data cleansing, data matching, reporting and monitoring the XML files
Environment: Windows XP, Informatica Power Center 8.1.x, DB2 8.1, WinSql 5.5, UNIX
Informatica Developer
Confidential
- Worked as Informatica Developer to design and develop Informatica mapping. To perform the Extraction, Transform and Load process by studying the business requirement from the users and the mapping documents
- Extensively used COBOL copy book to import the VSAM files from the Mainframe Source. The Mainframe flat file lists were indirectly accessed and implemented mapping with parameters and variables
- Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server, XML files and flat files to perform mappings based on company requirements and load into Oracle tables
- Well versed with creating and Altering Table, Triggers, Sequences, and other DDL, DML and DCL utilities of Oracle 9i and 10g
- Created XSD for XML files, imported into Designer as XML source qualifier
- Performance Tuned Informatica Targets, Sources, mappings and sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval
- Created pre-session and post-session shell scripts and mail-notifications
- Performed error handling for removing database exceptional errors
- 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
- Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings
Environment: Informatica PowerCenter 8.1.1 Informatica Services, Repository Manager, Designer, Workflow Manager, and Workflow Monitor , Mainframe, Solaris 10, Oracle 10g, Informatica PowerExchange, SQL Server 2008, PL/SQL, Flat files, XML Files, ERwin 4.0, TOAD 8.6
Informatica Developer
Confidential
- Involved in the design, development and implementation of the Enterprise Data Warehouse EDW
- Worked on ETL Migration process from legacy scripts to Informatica PowerCenter 7.1.1
- Involved in the creation of logical and physical designs using ERwin data modeler to develop Database schemas in dimensional modeling
- Worked on Informatica PowerCenter Designer - Source analyzer, Warehouse Designer, Mapping Designer and Transformation developer
- Used various Informatica transformations to recreate data in the data warehouse
- Involved in Data cleansing before loading into Oracle data warehouse
- Designed and developed Aggregate, Join, Lookup transformation rules business rules to generate consolidated fact/summary data identified by dimensions
- Used Lookup, Sequence generator, Router and Update Strategy transformations to insert, delete, update the records for Slowly Changing Dimension tables
- Worked on change data capture for slowly changing dimensions SCD-2 to update a target table to keep full history
- Extensively used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability
- Automated scheduling of sessions at regular intervals using Informatica Scheduler
- Worked on identifying Mapping Bottlenecks in Source, Target and Mappings to Improve performance
- Extensively used debugger to troubleshoot logical errors
- Used workflow manager for session management, database connection management and scheduling of jobs
- Monitored workflows and session using PowerCenter workflow monitor
Environment: Informatica PowerCenter 7.1.4 Informatica Server, Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor , Windows XP, UNIX, Solaris 9, Oracle 9i, MS SQL Server 2000, XML, Flat files, ERwin, TOAD
Informatica Developer
Confidential
- Analyzed the systems, architecture, met with end users and business units in order to define the requirements.
- Involved in the requirement definition and analysis in support of Data Warehousing efforts.
- Developed ETL mappings, transformations using Informatica PowerCenter 6.x.
- Extensively used Informatica tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer.
- Implemented various Informatica transformations like Expression, filter, Aggregator, Router, Ranker, update strategy, joiner, Lookup, Sequence generator, stored procedure and Source Qualifier. To load the data from Staging area to DW.
- Developed data Mappings between source systems and warehouse components using Mapping Designer.
- Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data.
- Responsible for creating DLL for report design in HTML format and calling them from ASP pages to provide more security for Crystal Reports.
- Involved in the Performance Tuning.
- Created and ran sessions and workflows using Workflow Manager.
- Monitored the sessions and workflows using Workflow Monitor.
- Trouble shooting of connectivity problems. Looked up and read session, event and error logs for troubleshooting.
Environment: Informatica PowerCenter 7.1 Informatica Server, Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor , Oracle 9i, DB2, Sybase, Cobol files, MS SQL Server 2005, TOAD, UNIX, PL/SQL, SQL Loader, Windows 2000/XP
Database Developer
Confidential
- Written SQL Queries for handling data in the database.
- Maintaining the data coming from the OLTP systems.
- Tuned the database queries to improve the performance of the query and indexing strategies.
- Coded database triggers to record the changes made to the database objects.
- Coded functions and stored procedures to perform the user defined functions and execute the required query whenever needed.
- Document the work performed each day.
- Helped coding shell scripts for database scripting.
- Establishing an application's security measures during development of Application in collaboration with DBAs.
- Involved in Physical schema implementation, objects like table-space, table rollback segments.
- Created database structures, objects and their modification as and when needed.
- Managed users roles for database security.
- Maintained system security, control and monitor user access to database
- Assigned predefined profiles and roles to the users to maintain database security, CPU activity, idle time and quota management on table-spaces.
Environment: Oracle 9i, SQL Plus, PL/SQL, T-SQL, Windows XP