SUMMARY:

• Around 9 years of IT experience in design, coding and testing of Data Warehousing implementations across Financial , Hospitality and al Industries .
• Extensive experience with different phases of Software Development Life Cycle (Requirements gathering, Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications).
• Experience in building Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using Informatica.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using ETL.
• Used transformations like Joiner, Expression, Connected and Unconnected Lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Transaction control, Router and Sequence generator.
• Captured data changes with the help of SCD Type 1 and Type 2 mappings and utilized MD5 to accomplish Dimension, Facts and error record loading.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries using SQL Server and Oracle PL/SQL
• 4+ years of enterprise level software development experience (non-academic) with demonstrable working knowledge of Informatica PowerCenter & Power Exchange 9.x or 10 versions, MS SQL, Oracle & PL/SQL, Firebird and NoSQL databases, exposure to scheduling tools and experience working with parsing and creating XML and JSON files
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, SQL Server Databases and DB2.
• Skilled in analyzing data for error records using Informatica mapping debugger.
• Involved in Analyzing the System requirements, implementation of star schema & Involved in designing and development of data warehouse environment. Also, gathered requirements with Business Users and converted them into project documentation.
• Created mapplets for reusing transformation logic in multiple mappings.
• Involved in Dimensional modeling (Star Schema/Snow flake) of the Data Warehouse and designed the business process, dimensions and measured facts.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Responsible for Performance Tuning Confidential the Source level, Target level, Mapping, Session and database level.
• Experience in scheduling workflows using Informatica scheduler.
• Experience in Database Development using mainly Oracle database. Experience with Data Cleansing, Data Profiling and Data analysis. UNIX Shell Scripting, SQL and PL/SQL coding.

TECHNICAL SKILLS:

Operating systems: UNIX, Windows 2008/2007/2005/ NT, MS-DOS.

ETL Tools: Informatica P In Informatica Power Center 10.2/9.6.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager and Informatica Server)

Dimensional data modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, ERWIN 4.5/4.0/3.5/3.2

Databases: Oracle 11g/10g/9i, DB2/UDB, SQL Server

Operating Systems: Windows 95/98/NT/2000/XP, UNIX, Linux.

Data Modeling: Erwin, ER Studio, Power Designer

Others: C, C++, XML, UNIX shell scripting, PL/SQL, SQL, SQL Developer, TOAD Perl, Python, XML, JSON, WSDL and SQL Server Management studio.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Informatica Developer/Production Support Analyst

Responsibilities:

• Provided development and technical support for HR and Payroll related data and loaded this data from PeopleSoft to Oracle database.
• Created mappings using Designer and extracted online user registration data from various sources like Flat file, relational sources, XML, Normalized data and transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of star schema and snowflake schema.
• Create/administer Oracle 10.2.0.3 databases for PowerCenter repositories
• Configure and support Oracle10G Data Guard databases
• Used Transaction control transformation to generate Flat files dynamically for downstream users.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used Web Services Transformation for authentication of the end users.
• Captured data changes with the help of SCD Type 1 and Type 2 mappings and utilized MD5 to accomplish Dimension, Facts and error record loading.
• Worked on the Support to solve the existing Informatica mappings issues.
• Involved in data analyzing with data analyst to define the structure of dimension and facts.
• Wrote SQL queries, PL/SQL programming and Query Level Performance tuning.
• Moved Mappings, Sessions, Workflows from Development to Test, UAT and Prod environment.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Attended status meetings with project managers, escalated issues when necessary, attended meetings for issues resolution.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Used parameters/variables for PowerCenter mappings, sessions and workflows.
• Created process documents in case of job failures, and documented failures to fix repeat issues.
• Worked with various teams like BSA, DBA, Business users and environment technical leads in case of job failures.
• Worked on enhancements like adding new columns, updating column datatypes and lengths both Confidential Database and PowerCenter level.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.

Environment: Informatica Power Center 10.2/9.1.6, Oracle 11g, DT Studio, SQL Server 2008/2005, DB2, Flat Files, Tableau, Python 2, MS Visio, MS Office, PL/SQL (Stored Procedure, Trigger, Packages), UNIX, LINUX, Toad

Confidential, Houston, TX

Informatica ETL-Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting, reporting, and Identifying facts and dimensions.
• Interacted with Lead Developers, System Analysts, Business Users, Architects, Test Analysts, Project Managers and peer developers to analyze system requirements, design and develop software applications.
• Prepared the required application design documents based on functionality required.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Teradata Warehouse database.
• Wrote Queries, Procedures and functions that are used as part of different application modules.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Involved in writing procedures, functions in PL/SQL.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Involved in Dimensional modeling (Star/Snow flake Schema) of the Data Warehouse and used Erwin to design the business process, dimensions and measured facts.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Used the Data Transformation Studio (DT Studio) 4.0 to create scripts that convert complex data formats, into standard ones and then integrate to Informatica Power Center platform, using the UDO transformation.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Involved in migration of mappings and sessions from development repository to production repository.
• Created Flat files for external vendors using Informatica ETLs and moved them to MFT (Go Anywhere), for the vendors to pick up files.
• Unit test code before handing over code to QA Team along with documents.
• Provided Tier l support duties for Informatica Production Support, including off hours and weekends. Keep the Production Support team management informed of any issues or concerns.

Environment: Informatica Power Center 10.2/9.6.1, Teradata, Repository Manager, Designer, Workflow Manager, Business Objects 4.x, Oracle 11g/10g, UNIX, LINUX, SQL Server 2008/2005, DB2, Flat Files, CSV files, Toad.

Confidential, Herndon, VA

Informatica Developer

Responsibilities:

• Involved in understanding the Requirements of the End Users/Business Analysts and developed strategies for ETL processes.
• Responsible for requirements gathering for an enhancement requested by client. Involved in analysis and implementation for an Intranet Based Information Management Information System.
• Provided maintenance and support of Online and Batch Programs using COBOL, DB2.
• Wrote several DB2 Stored Procedure scripts to implement the business logic.
• Created data models for information systems by applying formal data modeling techniques.
• Strong expertise in physical modeling with knowledge to use Primary, Secondary, and Join Indexes.
• Designed Fact tables and Dimension tables for star schemas and snowflake schemas using ERWIN tool and used them for building reports.
• Performed reverse engineering of physical data models from databases and SQL scripts.
• Provided database implementation and database administrative support for custom application development efforts.
• Developed OLAP reports and Dashboards using the Business intelligence tool - OBIEE .
• Synchronizing all regions PCR, Unit and System while migration changes from lower region to acceptance.
• Reviewing programs for QA and Testing.
• Responsible for Coding, Unit Test Plans, Unit Test Results, Functional Testing and Regression Testing.
• Involved in comprehensive end-to-end testing- Unit Testing, System Integration Testing , User Acceptance Testing and Regression.
• Provided 24/7 On-call Production Support for various applications and provided resolution for night-time production job failures, attend conference calls with business operations, system managers for resolution of issues.

Environment: Oracle 11g, SQL * Plus, Informatica Power Center9.1.6, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, SQL*Plus, PL/SQL, Oracle Designer 2000 , Windows 2000, Toad.

Confidential

ETL/Informatica Developer

Responsibilities:

• Extensively involved in requirements gathering, writing ETL Specs and preparing design document
• Designed and developed ETL mappings for data sharing between interfaces utilizing SCD type 2 and CDC methodologies
• Worked on parameters, variables, procedures, scheduling and pre/post session shell scripts
• Developed code to extract, transform, and load (ETL) data from inbound flat files and various databases into outbound flat files and XML files using complex business logic
• Expertise in performance tuning of the mappings, ETL Environments, procedures, queries and processes
• Expertise in handling and loading high volumes of data into data warehouse in a given load window
• Expertise in preparing test strategy, test plan, test summary reports, test cases and test scripts for automated and manual testing based on user requirement documents and system requirement documents.
• Extensive experience in Data warehouses with strong understanding of Logical, Physical, and Dimensional Data Modeling to design Star and Snow flake Schemas.
• Utilized of Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
• Used SCD (type1, type2 and type3) to Load present and Historical Data to ODS, EDW.
• Planned, created and executed SSIS packages to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
• Experience in ETL process using ETL Tools, creating and maintaining Repository, Source systems, Target Databases and developing strategies for ETL mechanisms using ETL tools
• Gathering and analysis, design, development, testing, performance tuning, and production support.
• Experience in Unix Shell scripting, scheduling cron jobs and Job Scheduling on multiple platforms like Windows NT/2000/2003, Unix
• Worked with architects and DBA in designing the rules engine and implementing the logical, physical and Dimensional model based on the rules and metadata.
• Bug fix and release including changes in coding, technical support of system testing, writing implementation plans, assisting and debugging deployment issues, creating/updating technical documentation.
• Developed reporting capabilities to increase skill levels and efficiency.
• Documented business specifications and followed during the process of development and testing.
• Continuously monitored performance and quality control plans to identify improvements

Environment: Informatica PowerCenter, Workflow Manager, Workflow Monitor, Oracle, RHEL, Visual SourceSafe, SQL, PL/SQL, BO, AutoSys and Tableau