Skills

Please use this table to list the skills noted in the Required/Desired section of the Peoplefluent requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Employment History

Confidential

Sr. ETL/Informatica Developer

Responsibilities:

• Created Source definitions from Flat Files, Oracle DB, Imported/Created Target definitions and created Reusable Transformations, Mapplets in Shared folder
• Designed Source to Target mappings from primarily Flat files and Oracle using Informatica Power Center.
• Involved in design, development and implementation of ETL process in power center
• Responsible for managing, scheduling and monitoring the workflow sessions
• Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area which is the source for stage loading.
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements
• Used Informatica Data Transformation and Data Exchange to integrate data safely with the internal systems
• Responsible for performance tuning for several ETL mappings, Mapplets, workflow session executions
• Used Data Analyzer to track and tune data flow performance, enrich and speed integration
• Extensively worked on Connected Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator, Union, XML, etc.
• Involved in conceptual, logical and physical data modeling and used star schema in designing the data warehouse
• Involved in developing an Informatica web service mapping
• Responsible for Error handling, bug fixing, Session monitoring, log analysis
• Worked on Power Mart client tools viz. Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developers
• Extensive ETL design, planning, implementation, testing, and documentation utilizing standard ETL tools like SSIS, SSRS SSAS.
• Wrote a number of stored procedures to validate the complex mappings and automated the validation process.
• Involve in Designing of logical Data model using Erwin Tool
• Enterprise Application Integration using Hub Spoke architecture and Integration Bus architecture
• Analyzed business problems and design proper solutions utilizing Oracle BI Enterprise Edition OBIEE
• Imported Data from MS-Access Database and XML to SQL Server Database using DTS
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables by using cursors, triggers and procedures to bring data into database based on the design
• Used UNIX Shell Scripts for automating Batches and Sessions
• Generate scripts for Data Migration and Data Validations as specified in the technical design
• Used Workflow Manager to schedule and run batches, sessions, as well as to check session logs and other session related activities
• Involved in unit testing entire process flow.
• Installation and Configuration of ETL tool Informatica for creating Data ware housing
• Written SQL Scripts and PL/SQL Scripts to extract data from Databases
• Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange
• Power Exchange Change Data Capture has been done for data updates

Environment: Informatica Power Center 9.5, PowerMart, Informatica Power Exchange, PowerConnect, Oracle 11g, MS SQL Server 2008, SQL, PL/SQL, ERWIN, UNIX Shell Scripting, Teradata, Mainframes, JCL, VSAM, XML, 8.0, Perl, Informatica 9.x Web services.

Confidential

ETL/Informatica Developer

Responsibilities:

• Developed various mappings for extracting the data from different source systems using Informatica, pl/SQL stored procedures.
• Developed mappings for extracting data from legacy and Oracle Applications into our data warehouse.
• Extensively used Informatica to load data from MS SQL Server into the data warehouse
• Developed mappings between multiple sources such as flat files, oracle and multiple targets.
• Strong experience in using Expressions, Joiners, Routers, Lookups, Update strategy, Source qualifiers and Aggregators.
• Created Informatica mappings with PL/SQL stored procedures/functions to incorporate critical business functionality to load data.
• Developed Informatica mappings for Slowly Changing Dimensions.
• Created Mapplets for implementing the incremental logic, in identifying the fiscal quarter of the transaction and in calculating various requirements of business processes
• Work with other SSIS Architects, business analysts BAs , project managers PMs , relationship managers PMs , sales, and other staff to ensure smooth implementation and integration of all components on large-scale projects
• White paper on Integrating hub and spoke with point-to-point architecture.
• Extensively used almost all the transformations, which includes Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP Static and Dynamic , Update Strategy, Source Qualifier, Stored Procedure, Joiner, Normalizer, XML Source Qualifier .
• Used Mapplets, Reusable transformations, Parameters and Variables to implement OO object orientation techniques and to facilitate the reusability of Code.
• Involved in creating and running Sessions Workflows using Informatica Workflow Manager and monitoring using Workflow Monitor.
• Extensively worked on creating and executing formal test cases, test plans for functional, system and regression testing

Environment: Informatica Power Center 9.1/8.6.1, Workflow Designer, Powercenter Designer, Power Exchange, Repository Manager, Power Mart, Oracle10g, SQL Server, PL/SQL, Flat files, TOAD and Windows.

Confidential

ETL Developer

Responsibilities:

• Worked with different Informatica client Tools like Source Designer warehouse designer, Mapping designer, Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Server.
• Worked with Business requirements analyst to identify and understand source data systems and Developed Mappings between source systems and warehouse components.
• Extensively Created different complex mappings using expressions, aggregators, filters, lookup, router, joiner, sorter and procedures to develop and feed in Data Warehouse and used Update strategy transformation to transfer data from source to data effectively.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Used debugger to validate mappings and gain troubleshooting information about data and error conditions.
• Involved in creating shell scripts for various database objects related to the data model, which involve in creation of schema, tables, sequences, views, Materialized views, constraints, and indexes.
• Created SQL server configurations for SSIS packages and XML Windows event logs
• Developed shell scripts to automate pre-session and post- session tasks.
• Sound knowledge in migrating mappings from development to testing and then to production.
• Used SQL, PL/SQL, and TOAD to validate the Data going in to the Data Ware House.
• Extraction Involved in the development of Informatica mappings and also tuned them for better Performance.
• Enterprise Application Integration using Hub Spoke architecture and Integration Bus architecture
• Migrated Informatica folders, mappings, workflow, reusable objects from one environment to another and in the process of change control.
• Monitoring the existing ETL jobs and takes necessary actions as per the errors handling methodology.

Environment: Informatica Power Center 8.6, Workflow Designer, Powercenter Designer, Power Exchange, Autosys, Repository Manager, Power Mart, Oracle10g, SQL, PL/SQL, SQL Loader, TOAD, and UNIX, Windows XP, Erwin 4x, UNIX Shell Scripts.

Confidential

ETL/Sr.Informatica Developer

Responsibilities:

• Analyzing business processes, functions, existing transactional database schemas and designing star schema models to support the users reporting needs and requirements
• Converting the Business rules into Technical Specifications for ETL process
• Created Conceptual data model by gathering the business requirements from various sources like discussion with functional teams, business analysts and from business documents
• Designed logical and physical database designing using Erwin Tool.
• Used SQL Loader to load the data from Flat files to Oracle for Comm Dashboard system.
• Developed complex aggregate, join, look up, filter, router transformation logic to generate consolidated data needed.
• Worked extensively on Flat Files, as the data from various Legacy Systems is flat files.
• Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations
• Designed and optimized moderate to complex Initial load to populate SCD Type-2 using date format.
• Created mapplets using Mapplet Designer and used those Mapplets for reusable business process in development.
• Created re-usable transformations and Worklets.
• Enterprise Application Integration using Hub Spoke architecture and Integration Bus architecture
• Improved the session performance by pipeline partitioning.
• Generated Unit and integration Test Plans and related documents
• Created Workflows in the Workflow designer and executed tasks such as Sessions, Commands, etc. And Monitored transformation processes using Workflow monitor
• Created SQL server configurations for SSIS packages and XML Windows event logs.
• Involved in performance tuning of the Informatica mapping and identifying the bottlenecks.
• Wrote shell scripts to perform pre-session and post-session operations Used Shell script and Perl script to audit check on the flat files before loading the data into National data mart
• Primarily responsible for Production support National, Comm Dashboard, RSA Dashboard systems.
• Performed general controls oversight and reviewed to verified compliance with SOX provision and professional standards
• Coordinating with middleware team for migrating Informatica objects into test and production environment
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor
• Troubleshooting the loading failure cases, including database problems.
• Used Autosys scheduling tool to schedule and monitoring the jobs

Environment: Informatica Power Center 8.6, WorkFlow Designer, Powercenter Designer, Power Exchange, Autosys, Repository Manager, PowerMart, Oracle10g, SQL Server, PL/SQL, SQL Loader, Perl, UNIX Shell Scripting, Windows NT/2000/XP,Business Objects 6.5

Confidential

Sr.ETL Developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Audited small business loan applicants to determine cash flow, debt levels and risk factors to assess credit worthiness.
• White paper on Integrating hub and spoke with point-to-point architecture.
• Experience in Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Extensively used ETL to load data using Power Center from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Design and Development of ETL routines, using Informatica Power Center Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Stored procedures / functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Analyzed and determined the most complex transformations
• Used Update strategy and Target load plans to load data into Type-2 Dimensions
• Designed the complete workflow for all the extracts mappings to serve the business requirements with dependency hierarchy.
• Created SQL server configurations for SSIS packages and XML Windows event logs.
• Developed, monitored the workflows and responsible for performance tuning of the staging and 3NF workflows.
• Responsible for monitoring all the sessions that are scheduled, running completed and failed. Involved in debugging the Mappings that failed.
• Created PL/SQL packages, Stored Procedures and Triggers for data transformation on the data warehouse.
• Created the parameter file to run the workflow.
• Created Users, user groups, database connections and managed user privileges using supervisor.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels
• Created Snapshots, Summary tables and materialized views in Database to reduce the system overhead.
• Worked on full SDLC including onshore and offshore teams.
• Developed and maintained Reports using Business Objects.
• Involved in Designing BO reports Universe guiding designers and developers for each component.
• Generated, published and scheduled reports in Web Intelligence.

Environment: Informatica Power Center 7.x, Informatica Power Connect, Repository Manager, Designer, Server Manager, Workflow Monitor, Workflow Manager , Power Exchange, Power Analyzer, ETL, Business Objects , Oracle 9i, Teradata, PL/SQL,ODI, Erwin, Unix, Excel and shell scripting, MS Windows XP professional 2002,UNIX.

Confidential

Sr.ETL Consultant

Responsibilities:

• Participated in the requirements gathering meetings with End users, business analysts.
• Helped in designing the working structure for Informatica with different folders to be created at different tiers.
• Actively involved in the Development/ Design phases of the project.
• Worked with team developers in implementing the best strategies/practices for code development.
• Assisted the Development team in developing some of the critical code in Informatica by using all the Informatica tools.
• Debugged and resolved some of the job failures in Informatica by making changes to the code and helped finding the issues in the code which cause the workflow failures.
• Extensively involved in tuning of the Informatica mappings and SQL queries.
• Enterprise Application Integration using Hub Spoke architecture and Integration Bus architecture
• Designed dynamic SSIS packages to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS
• Created users/groups/folders and associated UNIX directories for the smooth development of the code.
• Created Informatica connections pointing all types of databases like Teradata, Oracle and also external loader connections and made the corresponding changes to ODBC file and Tnsnames.ora files.
• As an admin worked on the failures of the Informatica services and production job failures.
• Worked on migration of the Informatica code from Dev to UAT to Prod repositories by using different migration procedures.
• Worked on the migration of UNIX components across Dev/UAT/Prod servers.
• Documented all the Functional and technical specifications.
• Provided 24x7 production support for business users and documented problems and solutions for running the workflows.
• Developed some mappings to get the repository OPB table information into local database tables which are further used for reporting purposes.
• Wrote some queries which run every month to get the statistics on each repository like number of jobs ran repository size etc
• Worked as a part of Informatica admin team in maintaining all the repositories across all the data warehouses

Environment: Informatica Power Center 7.x, Oracle 9i/10g, Teradata, SQL, PL/SQL, TOAD, UNIX Shell Scripting, UNIX, SQL Server 2005, WLM.

Confidential

ETL Developer

Responsibilities:

• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center Designer.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Sales and Marketing Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Designed dynamic SSIS packages to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Developed Mappings for the Category, Specification, Code, Type areas.
• White paper on Integrating hub and spoke with point-to-point architecture.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Worked with various transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner transformations.
• Involved in the development and testing of programs, Informatica mappings and update processes.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules business rules .
• Developed schedules to automate the update processes and Informatica Sessions/Batches.

Environment: Informatica power center 7.x, Oracle 9i, Erwin, Windows 2003, SQL Server 2005, SSIS, and TOAD.