SUMMARY

• 8 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.
• Extensive experience as ETL Developer in technologies and methods using Informatica Power Center 10.2/10.1,9.6.1,9.5.1,9.1.1 HF2, 8.x.
• Good Understanding knowledge of Ralph Kimball & Bill Inman Methodologies.
• 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.
• 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.
• Actively involved in Performance SQL Tuning, ETL tuning and Error handling.
• 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.
• Experience in Data Modeling (Logical and Physical Design for distributed databases, Reverse-engineering and Forward-engineering using Erwin).
• 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 for scheduling of multiple sessions.
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Extensive experience in using Business intelligence report tools like Business Objects, Cognos BI Suite for warehouses and data marts, OBIEE etc.
• Experience in building Oracle Data Warehouse from different OLTP systems.
• Strong experience with MS SQL, PL/SQL, T-SQL, Stored Procedures, Packages, and Triggers.
• Experience with Teradata as the target for the data marts and worked with BTEQ, Fast Load, and Multi Load.
• Extensive experience 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 SQL Server 2005/2008.
• Developed Test Scripts, Test Cases, and 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

ETL Tools: Informatica Power center 10.1.1, 9.5/9.1/8.6.1 /8.1 , Power Connect & Power Exchange 9.x/8.x

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration

Data Modeling: ERwin 7.3/4.0, UML Rational Rose, Visio 2007

Databases: Oracle 11g/10g/9i/8i, TeraData, DB2, SQL Server 2005, DB2

Reporting Tools: Cognos 8.3/8.2/8.0, Business Objects xi 1, MS SQL Server Reporting services 2005, OBIEE.

Programming Skills: C, SQL, PL/SQL, BTEQ, SQL*Plus, Java, VB Script, Java Script, DHTML, XML

Office Tools: MS Office, MS Project, MKS, Subversion, Clear Case/Clear Quest, Remedy

Scripting Languages: UNIX Shell Scripting, Pearl, Java Script

SQL Tools: Toad, Rapid SQL, MS Management Studio, Oracle designer, SQL*PLUS

Operating Systems: Windows XP/NT/2000/2003, AIX, Linux and Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

ETL Developer

Responsibilities:

• Transformation of existing data & derived as per the needs of the Users
• Participated in team meeting with Business Analysts of other teams for requirement gathering and transforming it into technical requirements.
• Worked on Power Exchange Navigator for extracting data from Mainframe systems.
• Performed Unit Testing, System Testing and Regression testing and validated the data.
• Involved in testing Informatica mappings using the test data scenarios and upgraded the QA Test Plans.
• Used database objects like views, partitioning for accomplishing complex logical situations and implemented Type II Slowly Changing Dimensions.
• Coordination and Leading the ETL development team and assisting the OBIEE team on RPD and Dashboard customization.
• Created customized OBIEE model in the RPD to retrieve the RPD data into dashboard.
• Extensively involved in Fine tuning the Informatica Code (mappings and Sessions), Stored Procedures and SQL queries to obtain optimal performance and throughput
• Created T-SQL procedures to create temporary tables to populate stage tables
• Defect Fixing & running daily workflows to monitor redone changes in all environments.
• Calculated the KPI’s and worked with the end users for OBIEE report changes.
• Created the RPD for OBIEE.
• Creating build documentation used for migration of codes & mappings from one environment to another.
• Installed and configured SAP power connect for Informatica Power Center 9.5.
• Retrieved data from SAP BW and loaded into SQL Server EDW
• 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, and XML Source Qualifier.
• 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.
• Helped design and development of Conceptual, Logical, and Dimensional Data Models for the Data Warehouse using ERModel.
• 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.
• 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.

Environment: Informatica Power Center 10.2/10.1, Informatica Power Exchange, SQL Server 2014/2012, T-SQL, Oracle 11g, SQL Developer, OBIEE, Management Studio, Microsoft Visual Studio, SAP BW, Xena Scheduling Client, HP Quality Centre.

Confidential

Sr. Data Warehouse Consultant

Responsibilities:

• Interacted with the Business Analysts to analyze 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.
• Created the metadata layer for OBIEE.
• Administrative role and monitoring and support for several projects in Staging and Production environments for Informatica and OBIEE.
• Developed Dimensions and Bridge tables between Fact and Dimensions.
• Developed OBIEE RPD and DAC from end user’s input.
• 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.
• Inserted/updated and deleted jobs in UC4.
• 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.
• Converted Oracle Warehouse Builder (OWB) jobs to Informatica.
• Developed mappings to load Operational Data store (ODS) & 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 up to 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 9.5/9.1/8.6.1 , Oracle 11g, OBIEE, SQL Server 2005, PL/SQL, T-SQL, TOAD 10.6, LINUX Shell Scripting, UC4 scheduling tool, Windows XP.