SUMMARY

• Around 8 years years of experience in Data Warehousing Technology requirement gathering, data analysis, low level and high level design, development, customization, unit testing, user interface testing, customization and maintenance of other business applications.
• Extensive hands - on expertise using Informatica 8.x,Datastage 8.x/9.x and Erwin Data Modeler with strong business understanding of Banking, Insurance and Finance domains.
• Worked on relational database management systems like Oracle, TeraData, DB2, and SQL Server and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems and mainframe Cobol files.
• Good understanding of Ralph Kimball and/or Bill Inmon methodologies and Automation of ETL processes with scheduling tools and exception-handling procedures.
• Good knowledge of Installing and Configuring PowerCenter 7/8.
• Experience in writing shell scripting for various ETL needs and worked on integrating data from flat files (mainframe).
• Demonstrated experience with design and implementation of Informatica (IDQ v9.1), Data Quality applications for the business and technology users across the entire full development life-cycle.
• Knowledge of IDQ 9.1 standards, guidelines and best practices.
• Knowledge of Data Profiling guidelines and best practices.
• Development experience on UNIX platforms.
• Experience in Informatica source to target mapping specification documentation, tuning mappings to increase performance, proficient in using Informatica Server Manager to create and schedule workflows and expertise in Autosys and Control M Scheduling tools.
• Having experience as a module lead and possess excellent communication and interpersonal skills, ability to quickly grasp new concepts, both technical and business related and utilize as and when needed.

TECHNICAL SKILLS

Data Warehousing and ETL: Informatica Power Center 9.1/8.6/8.1/7.1/6.2/5.1 , DataStage 8.1/8.5/9.1 Repository Admin console, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Dimensional Modeling, SQL*Plus, Toad, SQL*Loader, SQL advantage, Control-M,ODI

Languages: SQL, T-SQL, PL/SQL,, UNIX Shell Scripting (kern shell)

Scheduling Tools: ControlM, Autosys and Informatica Scheduler.

Databases: Oracle 11g/10g/9i/8.x, MS-SQL Server 2000/7.0, MS-Access, Teradata V2R5/R6/R12/R13

Environment: Windows 98/NT/2000/XP/7/8, UNIX, MS DOS

Web Technologies: HTML, Java Script, XML

PROFESSIONAL EXPERIENCE

Confidential, North Carolina

Sr. ETL Informatica Developer

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify required Sources and Targets
• Analyzed business requirements to build a Data Mart for various business processes conformed to the business rules
• Analyzed the Functional Specs provided by the Data Architect
• Extensively used Informatica for extracting, transforming, loading databases from Oracle, flat files and DB2
• Created PL/SQL Procedures and Functions for scrubbing the data
• Developed Transformation logic and designed various complex Mappings in the Designer
• Designed and developed various mappings in Mapping Designer, sessions & workflows in Workflow Manager to extract data from flat files, Oracle and DB2 sources and load to Oracle.
• Created, launched & scheduled sessions. Configured email notification
• Implemented the best practices for the creation of Mappings, sessions, Workflows and performance optimization.
• Implemented Pipeline partitioning to improve session performance.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data
• Wrote Queries, Procedures and Functions that are used as part of different application modules
• Performed Data Quality Analysis to determine cleansing requirements
• Created scripts to update the parameter files to establish delta extraction
• Wrote various shell scripts for pre-processing of data and scheduling of jobs
• Wrote Unix Shell Scripts for Informatica Pre-Session, Post-Session to schedule the Infa jobs (work flows) .
• Experience in data profiling & data quality rules development using Informatica Data Quality tools(IDQ&IDE).
• Prepared Test Data and loaded it for Testing, Error handling and Analysis
• Involved in preparing ETL design documents and Unit Test Plans for Mappings.
• Prepared the code migration document and worked with release team in Migrating the code (Informatica Objects, Unix Scripts) from Development to Test and Production environments
• Interacted with Users for analyzing various Reports.
• Involved in answering the change request as part of the interaction testing
• Deployed ETL components code into multiple environments as per the approval received
• Provided Production Support by executing the sessions, diagnose problems and fix the mappings for changes in business logic.
• Migrated existing mappings to production environment from testing phase.

Environment: Informatica PowerCenter 9.1/8.6, Windows XP, Oracle 9i, DB2 SQL, PL/SQL, TOAD, Delimited Flat Files, Unix Shell Scripting.

Confidential, San Francisco, CA

Sr. ETL/Informatica Developer

Responsibilities:

• Involved in all phases of software development life cycle.
• Involved in requirements gathering and analysis to define functional specifications.
• Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing the Informatica Mappings.
• Involved in loading of data into Teradata from legacy systems and flat files using complex scripts.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
• Extensively used Informatica Client tools - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed Informatica mappings based on business requirements using various transformations like Dynamic Lookup, Connected and Unconnected lookups, Filter, Stored procedure, Update Strategy, Joiner, Aggregator, XML, Expression, Router, Sequence generator and Normalizer.
• Created Connected, Unconnected and Dynamic lookup transformation for better performance and increased the cache file size based on the size of the lookup data.
• Extensively tested the mappings by running the queries against Source and Target tables and by using Break points in the Debugger.
• Developed Reusable Transformations and Mapplets using Transformation Developer and Mapplet Designer for use in multiple mappings.
• Performed Unit and Integration Testing of Informatica sessions, batches and the target data.
• Redesign the mapping to improve the data quality.
• Worked with Session Logs, and Workflow Logs for Error handling and Troubleshooting in DEV environment.
• Managed Scheduling of Tasks to run any time without any operator intervention.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Automated daily load reports to send messages to the concerned personal in case of process failures and discrepancies.
• Provided knowledge transfer to the end users and created extensive documentation on the design, implementation, daily loads and process flows of the mappings.
• Extensively worked in the performance tuning sources, targets, mappings and SQL queries in the transformations.

Environment: Informatica Power Center 8.6 (Repository Manager, Designer, Workflow Manager, Workflow Monitor) SQL Query Analyzer 8.0, Teradata, Toad, SQL Developer 1.1.2,Windows, Unix/Linux, putty.

Confidential, Cranbury, NJ

Sr. Informatica Developer

Responsibilities:

• Analyze the system, meeting with end users and business units to define the requirements.
• Involved in designing STAR Schema for the business processes.
• Extracted the data from Oracle, Flat files and loaded them into Data Warehouse.
• Wrote SQL Queries, Stored Procedures, Functions and Shell Scripts to apply and maintain the Business Rules.
• Translated business requirements into Informatica mappings/workflows.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse/Data Marts.
• Developed Mappings that extract data form ODS (Operational Data Store) to Data mart and Monitored the Daily and Weekly Loads.
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle, MS SQL Server databases.
• Extensive work on Performance Tuning, determining bottlenecks from session, target, source, mapping and transformations.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Migrated existing mappings to production environment from testing phase.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server, Toad, Control-M.

Confidential, New York City, NY

Informatica Developer

Responsibilities:

• Prepared ETL Mapping documents based on the Business Requirements.
• Developing mappings and workflows to populate dimensions and fact tables available in the secondary sales data warehouse system.
• Created SQL scripts to populate/modify the YTD (Year to Date) values in the Fact Tables.
• Involved in the tuning of the workflow to improve the performance of the loading process.
• Involved to implement the incremental loading of the fact tables.
• Designed and developed validation ETL process using Informatica, Oracle SQL Loader on unix shell programming for validating the distributor daily sales transaction CSV files.
• After developing the project, also involved in the production support of secondary sales system project.
• Involved in Unit test cases to ensure successful execution of the data.

Environment: Informatica Power Center 7.1, DB2, Oracle, UNIX, SQL*Loader, Control-M, Sql, Pl/Sql

Confidential

Datastage Developer

Responsibilities:

• Worked in Data Warehousing project and obtained experience in design and implementation of Data Warehousing solutions especially design & development of Data Warehousing, Data Modeling, and Relational Database Systems.
• Expertise in development and designing of ETL methodology for supporting data transformations using Data Stage 8.5.
• Strong work experience in performing ETL procedure to load data from different sources into data marts and data warehouse using Data Stage 8.5 Designer client.
• Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
• Learnt Data modeling using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables in Erwin.
• Worked with Type II slowly changing dimension.
• Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups & Proven ability to implement technology based solutions for business problems
• Strong analytical, problem-solving, organizational, communication, learning and team skills
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes
• Database Design (Relational and Dimensional models) using Erwin
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data.
• Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.

Environment: Datastage 8.1, Oracle 9i/10g, Toad, SQL Developer, DB2, Windows, Unix/Linux, putty.