Summary

• Experience in implementing the complex business rules by creating transformations, re-usable transformations Expression, Aggregator, Filter, Connected and Unconnected Lookup's, Router, Rank, Joiner, Update Strategy , and developing complex Mapplets and Mappings.
• Actively involved in Performance SQLTuning, ETL tuning and Error handling.
• Experience in working with Variable-Length-Records.
• Designed and developed mappings in an Agile environment utilizing a test driven development approach.
• Experience in integration of various Operational Data Source ODS with Multiple Relational Databases like Oracle, SQL Server, and DB2 and worked on integrating data from flat files like fixed width and delimited.
• Extensively worked on Dimensional modeling Star/Snow flake ,Data migration, Slowly Changing Dimensions, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses.
• Good Understanding knowledge of Ralph Kimball Bill Inman Methodologies.
• Extensive experience as ETL Developer in technologies and methods using Informatica Power Center 9.1, 8.x, 7.x, 6.x.
• Nine Plus years of extensive experience in complete Software development life cycle SDLC with a strong background in data ETL, development and implementation of various data warehouses/data marts.
• Experience in Data Modeling Logical and Physical Design for distributed databases, Reverse-engineering and Forward-engineering using Erwin .
• Experience in implementing ETL processes using Oracle Warehouse Builder OWB to load data from sources systems into staging area.
• Converted Oracle Warehouse Builder OWB jobs to Informatica.
• Involved in the designing and building of Universes using Business Objects.
• Excellent knowledge of studying the data dependencies using Metadata stored in the Informatica Repository and preparing batches for the existing sessions to facilitate scheduling of multiple sessions.
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Experience in building Oracle Data Warehouse from different OLTP systems.
• Strong experience with MS SQL, PL/SQL, T-SQL, Stored Procedures, Packages, and Database Triggers.
• Experience with TeraData as the target for the data marts and worked with BTEQ, Fast Load, Multi Load and Fast Export.
• Extensiveexperience with Change Data Capture CDC .
• Experience in shell scripting to run ETL mappings and file handling.
• Experience with various Databases includes Oracle 11g/10g, IBM DB2 and MS SQL Server 2005/2008.
• Experience with various versioning tools includes MKS, Subversion, Rational Clear Case and Visual Source safe.
• Developed Test Scripts, Test Cases, SQL QA scripts to perform Unit testing, System Testing and Load testing.
• Seamlessly migrated the Code from Development to Testing, UAT and Production.
• Experience with various domain areas such as Health Care, Pharmaceuticals, Finance, Supply Chain and Manufacturing.
• Expertise over preparing report specifications, database designs to support the reporting requirements
• Perform review of Session log files to trace causes of bottlenecks.

Technical Skills

Professional Experience

Confidential

Lead Data Warehouse Developer

Responsibilities:

• Working as a Tier 2 Production Support Specialist.
• Worked as an on shore team lead - prioritized/managed daily task assignments to team and provided status updates to Business owner/client on critical issues.
• Conducted daily status/Handoff meetings to track progress, Identify open issues and worked with the Client manager to prioritize tasks based on Business value.
• Worked on Critical Incidents/Abort in the Enterprise Data Warehouse EDWard that maintains the Claims, Memberships and Provider data.
• Coordinated and implemented short term releases for ongoing maintenance activities and enhancements on Edward.
• Worked extensively with BTEQ scripts and Informatica Mappings and Workflows.
• Developed ad-hoc BTEQ scripts to move/copy, unzip/zip source files, Update/Insert/Delete data from the EDWard tables.
• Worked on critical production incidents including Audit and spool space issues.
• Worked with source teams to ensure the on-time delivery of the files to automate the data load process
• Worked as a liaison between on-shore and off-shore teams to balance the work flow.
• Worked on ad-hoc requests from Business to run data analysis, identify patterns and provide data support on daily basis.
• Worked and coordinated major releases to update and delete data from Edward tables on need basis.
• Worked with other teams and downstream systems to maintain the smooth operation of daily/weekly jobs.
• Worked with the team to ensure quality work was delivered on time, managed Client expectations and mitigated/communicated any risks upfront.

Environment: Informatica Power Center 9.1, Teradata 14/13.10, Teradata SQL Assistant, BTEQ Scripting, Clear Case, UNIX Shell Scripting, Windows 7.

Confidential

Sr. Data Warehouse Developer

Responsibilities:

• Interacted with the Business Analysts to analyze and to transform the business requirements into the technical requirements.
• Automated a process using concurrent workflows and dynamic parameter file generation using Normalizer, reducing the development time from 3 days to 10 minutes.
• Developed scripts for automation to generate parameter files, split files and also to run the workflows using PMCMD.
• Worked with Star Schema Data Warehouse Model.
• Developed Dimensions and Bridge tables between Fact and Dimensions.
• Created complex workflows with more than 50 sessions including decision and event tasks.
• Worked with relational Oracle and SQL Server and Flat Files sources and targets.
• Moved data from one platform to another using Informatica Power Center.
• Created T-SQL procedures to create temporary tables to populate stage tables.
• Worked extensively on PL/SQL coding and creating stored procedures to be used from Informatica mappings.
• Worked as part of the team upgrading Informatica repository from 8.6.1 to 9.1.
• Developed and worked with a complex error-processing system.
• Worked with Ralf Kimball's Change Data Capture CDC system, diff compare , comparing with Hexadecimal using MD5 .
• Worked with multiple pipeline mappings.
• Worked on Java transformation to develop a code to create date list between 2 dates to load them into Fact table.
• Converted Oracle Warehouse Builder OWB jobs to Informatica.
• Developed mappings to load Operational Data store ODS table and ODS to Confirm/Extract tables.
• Developed mappings to replicate data from SQL Server tables to Oracle tables.
• Worked with complex audit process that will store all the information about the records processed, passed and failed in a mapping.
• Worked with Oracle partitions, doing joins, loading data into individual partitions and deleting partitions.
• Worked with Flat Files with size upto 7GB.
• Developed Shell Scripts that will look for source files on server and if found, create a parameter file for individual files and run a workflow using PMCMD command, multiple times, to load all the files into an ODS table.
• Created Mapping documents, Production Implementation Documents and Production turnover Documents.

Environment: Informatica Power Center 8.6.1/9.1, Oracle 10g, SQL Server 2005, PL/SQL, T-SQL, TOAD 10.6, LINUX Shell Scripting, Windows XP.

Confidential

Sr. Informatica Developer

Responsibilities:

• Interacted with the Business Users to analyze the business requirements and transform the business requirements into the technical requirements.
• Follow the quality standards and guidelines for configuration management, testing, project planning and execution.
• Demonstrated the ETL process Design with BusinessAnalyst and Data Warehousing Architect.
• Developed scripts to come up with a generic way to load the data into the table on a particular database.
• Developed Source to Target mapping document.
• Created logical and physical data models using Erwin.
• Tested Informatica 9.1 with all functionalities for migration of Informatica 8.6.1 to 9.1.
• Loading data from Flat Files into the staging area using Informatica Power Center.
• Lead and coordinate the design and development of new business applications that support the ETL processes.
• Worked with the team to upgrade the Informatica repository from 8.6 to 9.1
• Extensively used almost all the transformations, which includes Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOKUP Static and Dynamic , Update Strategy, Source Qualifier, Stored Procedure, Joiner, Normalizer, XML Source Qualifier .
• Extensively used all Power Center/Power mart capabilities such Target override, Connected, Unconnected and Persistent lookup's.
• Extracted data from Transaction System into Staging Area.
• Establishing and monitoring issue management, change management and quality management processes.
• Developed SQL scripts and PL/SQL scripts to implement complex ETL process.
• Used database objects like views, partitioning for accomplishing complex logical situations and implemented Type II Slowly ChangingDimensions.
• Tuned the Mappings for Optimum Performance, Dependencies and Batch Design.
• Schedule and Run Extraction and Load process using Informatica Workflow Manager.
• Debugged and sorted out the errors and problems encountered in the production environment.
• Developed the test scripts using SQL for the unit testing.
• Developed shell scripts and used InformaticaPMCMD command to run workflows.
• Involved in testingInformatica mappings using the test data and upgraded the QA Test Plans.
• Seamlessly migrated the code from Development >Testing > UAT >Production.
• Extensively involved in Fine tuning the Informatica Code mappings and Sessions , Stored Procedures and SQL queries to obtain optimal performance and throughput

Environment: Informatica Power Center 8.6/9.1 TeraData, Oracle 10g, PL/SQL, BTEQ, SQL Plus, TOAD, ERwin 7, Business Objects XI R2, Windows NT, Shell Scripting, HP UNIX 10.2.

Confidential

Informatica Developer

Responsibilities:

• Worked with users to understand their reporting requirements and translate those requirements to extract data, and load data in the form of a report.
• Tested Informatica 8.6 with all functionalities for migration of Informatica 7.1.2 to 8.6.
• Analyzed business and systems specifications and developed logic flowcharts.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Implemented Informatica Power Center for building Oracle Data Warehouse from different OLTP systems.
• Developed mapping using Oracle Warehouse Builder OWB for data loading. Created Process flow, scheduled monitored session.
• Implemented bulk load method with SQL Loader for loading history data to staging area.
• Defined UNIX Batch scripts for automation of execution of Informatica workflows.
• Executed Multi load scripts for daily batch jobs.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Implemented business rules by using database triggers.
• Generated Drill Up, Drill Down and Drill Through reports using Business objects based on user requirements.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
• Handled Incremental loading using persistent mapping variables and used versioning of folders in the Informatica Designer.
• Experience in SQL tuning using Hints, Materialized Views.
• Extensively worked in the performance tuning for the mappings and ETL Procedures both at designer and session level.
• Expertise in working with Oracle Stored Programs, Packages, Cursors, Triggers, Database Links, Constraints, Views, Indexes, Sequences.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Designed and developed full client reports in all different formats and modified, tuned the legacy reports. Used Business Objects for Adhoc reporting.

Environment: Informatica Power Center 8.6/7.1, Oracle 9i, OWB, Business Objects 6.5, UNIX, Shell Scripts, TOAD 8.0, Autosys, Sun Solaris.

Confidential

Informatica Developer

Responsibilities:

• Involved in gathering the Business requirements from the client and writing and maintaining technical/design documentation.
• Designed and developed end-to-end ETL process for the FIIS production systems.
• Worked extensively on data that was used for doing risk assessment for collateral management.
• Analyzed the business requirements for ETL process and created schema flow diagrams in VISIO.
• Performed extensive analysis of metadata to test the integrity, consistency and appropriateness of the data brought into the warehouse from various sources.
• Analyzed and tuned queries on the database that will be executed from reporting system.
• Leveraged Informatica to extract data from heterogeneous source systems and aggregate the data and load into the target warehouse.
• Extracted data from sources like Oracle database and Flat Files.
• Created various reusable transformations such as Slowly Changing Dimensions.
• Design and Development of ETL routines within theInformatica Mappings.
• Usage of Aggregator, SQL overrides usage in source filter and lookups and data flow management into multiple targets using Routers.
• Worked on Unix AIX4.3 machine on which Informatica Server was installed.
• Worked on the UNIX AIX4.3 to connect to the Oracle database and run PL/SQL scripts.
• Wrote stored procedures for dropping and recreating indexes for efficient Data Load.
• Extensively worked on the tuning of mappings and sessions.
• Used Oracle hints for performance tuning.
• Worked on Clear Case Source Control System, this provides a virtual workspace to check in and checkout various files and directories.
• Used pmcmd command to run workflows.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Created number of standard reports and queries based on the existing classes/objects.
• Worked along with the team lead for decision support environments.

Environment: Power Centre 7.1, Oracle 10g/9i, SQL Plus, TOAD 8.5, SQL Developer, ERwin 7.1, UNIX Shell Script, Windows NT

Confidential

ETL Consultant

Responsibilities:

• Involved in full life cycle implementation of the project.
• Helped design and development of Conceptual, Logical, and Dimensional DataModels for the Data Warehouse usingERwin 4.1.
• Extensively involved in ETL coding using Informatica in order to meet requirements for extraction, transformation, cleansing and loading of data from source to target data structures.
• Wrote functional and technical plans for transformation and loading the Data Mart.
• Developed transformation logic and designed various complex Mappings and Mapplets.
• Performed tuning of the Mappings and optimized the mappings to provide maximum efficiency and performance.
• Created mappings using various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy transformations and Sequence generator.
• Designed complex mappings involving target load order and constraint based loading.
• Configured and used the Debugger to troubleshoot the mappings.
• Set up batches of worklets and sessions to schedule the loads at the required frequency.
• Developed UNIX shell scripts and used Autosys for automation of ETL processes.
• Actively involved in training and support.

Environment:Informatica Power Center 7.1, Oracle 9i, AIX 5.3, Toad 8.5, ERwin 4.1, Windows XP.

Confidential

Data Warehouse/ETL Developer

Responsibilities:

• Developed and supported the Extraction, Transformation, and load process ETL for data migration using Informatica power center.
• Developed Transformation logic and created various Complex Mappings and Mapplets using the designer.
• Worked with Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target.
• Conceptualized and developed incremental data loads in Informatica using Update strategy transformation.
• Developed mappings, sessions for relation and flat file source and targets.
• Imported data from various source Oracle, Flat file, XML and transformed and loaded into targets using Informatica.
• Monitored Workflows and Sessions.
• Involved in Unit Testing for the validity of the data from different data sources.
• Involved in developing reports using Business Objects.
• Identified the facts and dimensions and designed the relevant dimension and fact tables.

Environment:Informatica Power center 7.1/6.2, Oracle9i, PL-SQL, Erwin 4, UNIX, Windows XP