SUMMARY:

• 7+ Years of experience with all phases of SDLC including Analysis, Design, Development and Implementation of operational database systems (OLTP) and data warehouse systems (OLAP)
• Primarily worked on Data warehouse projects using Informatica Power center, Oracle, SQL Server and Business Objects on UNIX and Windows platforms.
• Experience in database modelling like Erwin, MS Visio using ETL/Informatica and implementation of several database and data warehousing applications.
• Hands on experience with Informatica Data Explorer (IDE)/Informatica Data Quality (IDQ) tools for Data Analysis Data Profiling and Data Governance.
• Extensive ETL experience using Informatica 9.6.1/9.1/8.6.1 Power Center, Designer, Workflow Manager, Workflow Monitor, Server Manager and Power Exchange.
• Experience in Administration activities like Creating and Managing Repositories, Users, Groups, Folders and other administrator functions of Repository Manager.
• Designed and developed Complex mappings from various transformations like Unconnected/Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more mappings using Stored Procedure’s, Normalizer, XML External Procedure
• Expertise in implementing complex business rules by creating re - usable transformations, and Mappings/Mapplets and Creating Source and Target Databases.
• Good knowledge on SDLC, OOAD Techniques and experience with unit testing and integration testing.
• Experience in with major Relational Databases like Oracle, SQL Server, Teradata and MySQL.
• Worked on Data Integration using Informatica for the Extraction and loading of data from various data sources like databases, flat files, and XML files.
• Expertise on tools like Toad, SQL*Plus and SQL Server Management Studio.
• Performed ETL procedure of source system analysis, data transformation and load data from different sources into data marts and Data Warehouse.
• Experience in developing mappings and tuning existing mappings and sessions for better performance
• Used Informatica Version Control for checking versions of the objects used in creating the mappings, workflows and to keep track of the changes in the development, test and production environment.
• Written post SQL and pre-SQL at the session level. Worked on session log files and workflow log files.
• Design develop and unit test Informatica Power Center transformations.
• Execute ETL test plans, Document ETL processing and generate required metadata.
• Expertise in Production migration of new releases and Enhancements.
• Have a clear understanding of Business Intelligence and Data Warehousing Concepts.
• Worked with various clients in the Banking, Financial, HealthCare and Insurance industries.
• Participated in team meetings and proposed ETL Strategy, coordinating the work with the offshore team.
• Ability to interact with individuals at all levels possess excellent presentation and interpersonal skills.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.5/8.6/8.1/7.1/6.2/5.1 , Informatica Power Mart 7.x/6.x, Informatica Power Exchange 8.x/7.x, Repository Admin console, Repository Manager, Designer, Workflow Manager and Workflow Monitor Informatica MDM, IDQ

RalphKimball Methodology, Bill: Inmon Methodology, Star Schema, Snowflake schema, Dimensional data modelling, Snowflake modelling, Fact Tables, Dimension Tables

Databases/Files: Oracle 11g/10g/9i/8i, SQL Server, Teradata, MySQL, DB2, XML& Flat files

Oracle Utilities: Oracle SQL Developer, SQL*Plus

Operating Systems: Windows 7/vista/NT/2000/XP, MS-DOS, UNIX/Linux, Ubuntu

Reporting Tools: Informatica Power Analyzer, Business Objects XI R3

Modeling Tools: Erwin 4.1/4.0, TOAD 9.x/8.x/7.x, SQL Loader 11g/10g, ER-Studio

Office Tools: MS PowerPoint, MS Word, MS Excel, MS Visio, MS Project

Programming: SQL, PL/SQL, C, C++, Java, Python, HTML

UNIX Shell Scripting, Java: Scripting

Methodologies: Waterfall, Scrum, Agile

PROFESSIONAL EXPERIENCE:

Sr Informatica Power center Developer

Confidential, St. Louis, MO

Responsibilities:

• Analyzing the requirements and making functional specification by discussing with business user groups and translate the Business Requirements and documented source-to-target mappings and ETL specifications.
• Solid experience in performance tuning on Teradata SQL Queries and Informatica mappings
• Worked on Teradata SQL Assistant, Teradata administrator, Teradata viewpoint and BTEQ scripts.
• Experience in migrations of project’s application interfaces.
• Implemented PL/SQL queries, triggers and Stored Procedures as per the design and development related requirements of the project.
• Handling the File transfer through SFTP Scripts, which are running through Informatica and having some Unix Shell Scripts used to send emails to Clients whenever there is success or failure depending upon the Business requirements to the Customers.
• Extensively used the Teradata utilities like BTEQ scripts, MLOAD and FLOAD scripts to load the huge volume of data.
• Designed ETL processes for optimal performance.
• Worked on moving the code from DEV to QA to PROD and performed complete Unit Testing, Integration Testing, User Acceptance Testing for the three environments while moving the code.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement a data warehouse.
• Used Teradata Data Mover to copy data and objects such as tables and statistics from one system to another.
• Used Teradata Data Mover for overall data management capabilities for copying indexes, global temporary tables
• Other Teradata duties include managing workloads and performance using Teradata TASM, Teradata Dynamic Workload Manager, and Viewpoint.
• Managing Viewpoint (defining Viewpoint portlets, managing access, provide Viewpoint training to users, creating alerts).
• Scheduled Informatica jobs to trigger BTEQ Scripts with the help of UC4 job scheduler
• Automated jobs using Korn shell scripting SAS and Teradata jobs, stage flat-files data onto UNIX environments to support ETL processes.
• Created Parameter files to pass database connections, parameter entries for source and target.
• Implemented Target Load Plan and Pre-Session and Post Session Scripts.
• Created test cases and test scripts to validate data.
• Created complex Informatica mappings, reusable transformations and prepared various mappings to load the data into different stages like landing, staging and target tables.
• Worked with cross-functional teams to resolve the issues.
• Designing the SCD type1 and type2 mappings and key fact tables. Also, designed and developed code set tables that will assist the dimension tables.
• Used the debugger in Informatica to test the mapping and fix the mappings.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Hands-on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant and Query man.
• Built the Operational data store by using BTEQ, Teradata, Oracle, SQL, PL/SQL, and UNIX
• Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy for designing and Optimizing.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and applied several methods to get the best performance by decreasing the run time of workflows.
• Involved in the defect analysis for UAT environment along with users to understand the data and to make any modifications to the code.
• Prepared the recovery process in case of workflow failure due to database issues or network issues.
• Conduct a thorough code review and ensure that the outcome is in line with the objective and all the processes and standards are followed.

Environment: Oracle 11g, Informatica Power Center10/9.6/9.1, SQL Server, My SQL Server, My SQL, T-SQL, SSIS, Erwin, Mload, Fastload, TPump, FastExport, Tableau Desktop 8.0, XML, Windows 10

Informatica Developer

Confidential

Responsibilities:

• Extracted data transformed and loaded into Oracle database according to the specifications.
• Experience in creating Tables, Procedures, Functions, Views and other database objects on Oracle DB.
• Experience in writing Complex Queries, Subqueries, Co-related subqueries, Dynamic SQL queries.
• Developed mappings and mapplets extensively using Informatica Designer tools - Source Analyzer, Target Designer, Transformation Developer and Mapplet Designer and Mapping designer.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Union, Normalizer, Sequence Generator, Update Strategy, SQL Transformation, Stored Procedure, and Joiner.
• Created and ran workflows using Workflow Manager to load the data into the Target Database. Optimized/Tuned mappings for better performance and efficiency.
• Developed mapping parameters and variables to support SQL override.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets.
• Created reusable components in the shared folder as it reduces time and effort.
• Integrated and installed IDQ on Informatica power center server machine to cleanse data.
• Designed IDQ mappings which are used as Mapplets in Power center.
• Validate data in the reports using Business Objects and provide an update on business queries.
• Involved in each phase of Software Development Life Cycle such as design, build, test and deployment phase.
• Deployed the code to the Production that follows the migration checklist.
• Used debugger to test the data flow between the source and target and to fix the invalid mappings.
• Migrated mappings and workflows from the development server to the Test Server to perform the unit, integration and system testing.
• Involved in all the existing releases and helped the team in resolving critical issues.

Environment: Informatica Power Center 8.6.1/8.1, Oracle 10g, Windows XP.

ETL/Data Warehousing Developer

Confidential

Responsibilities:

• Used Informatica to create and organize various Metadata types, including legacy Source and Data warehouse Target data definitions and ETL jobs.
• Loaded operational data from Oracle, SQL Server, flat files, Excel Worksheets into various data marts.
• Developed numerous Stored Procedures, Triggers and common functions using PL/SQL.
• Designed and created a complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Created an update strategy and stored procedure transformations to populate targets based on requirements.
• Major involvement in creating and tuning the mappings, to perform maximum efficiency and have complete knowledge of session properties in Workflow monitor.
• Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.
• Built-in mapping variable/parameters and created parameter files for imparting flexible runs of sessions/mappings based on changing variable values.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Worked extensively on IDQ Analyst for Profiling, Creating rules on Profiling and Scorecards.
• Created Tasks and Workflows using Task Manager and Workflow Designer.
• Generated reports using Business Objects Report Designer.
• Debugged the mappings when there are issues with the data and involved in creating test case documents and test case scenarios.

Environment: Informatica Power Center 8.1, Work Flow Manager, Oracle 8i/9i, PL/SQL, Erwin, TOAD, Business Objects.

Data Warehouse ETL / SQL Developer

Confidential

Responsibilities:

• Interacted with business analysts, data architects, application developers to develop a data model.
• Good Business and System analysis skills to understand the requirements customize client applications and designed Domain model for it.
• Worked on creating mapping documents and used ETL for data conversion from legacy to the new model.
• Created a data dictionary to map data points from source to destination that were used for conversion.
• Coordinated with front-end developers for implementing logic in stored procedures and functions for faster retrieval of data.
• Used Teradata utilities (FASTLOAD, MULTILOAD) to load the bulk data into the Tables and for comma delimited and fixed-width data files onto Teradata.
• Created new database objects like tables, procedures, functions, indexes and views using SQL in development and production environments.
• Expertise in Data cleansing, setup & management of centralized business data dictionary using MDS (Master Data Services)
• Used Source Qualifier, Aggregator, Filter, Expression, Lookup, Update Strategy, Router, and Joiner transformation.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Implemented slowly changing dimensions according to the requirements and maintain historical data.
• Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Create new & optimize existing reports using gauges, charts, click-through reports, maps etc. as well as Power BI Reports
• Developed views are necessary for structured and ad-hoc reporting.
• Designed testing procedure and test plans assisted in Production support.

Environment: Informatica Power Center 6.1, Data modelling, Oracle 8i, SQL, PL/SQL, Teradata, Flat Files, Windows 2000

Informatica Developer

Confidential

Responsibilities:

• Analyzed relationships of Flat Files and to extract the analyzed systems, met with end users and business analyst to define the requirements.
• Documented user requirements translated requirements into system solutions and develop implementation plan and schedule.
• Developed data Mappings between source systems and warehouse components.
• Worked with Informatica Administrator to setup project folders in development, test and production environments.
• Extensively worked in Oracle SQL, PL/SQL, Query tuning, Created DDL scripts, created database objects like Tables, Indexes etc.
• Created mappings using Informatica Power Center Designer and extracted data from various sources and transformed data according to the requirement.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy.
• Created and Monitored Batches and Sessions using Informatica PowerCenter Server.
• Responsible to tune ETL procedures and STAR Schemas to optimize load and query performance.
• Tested all the backend programs, Informatica mappings and update processes.
• Involved in generating reports from the DM layer using Business Objects.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Perform analysis and resolution of Help Desk Tickets and maintenance for assigned applications.
• Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error-handling methods.
• Stayed on call for support for any workflow failures or any Technical Issues.

Environment: Informatica Power Mart 8.1, Oracle, PL/SQL, Windows.