SUMMARY

• Over 8 years of experience in the field of Information Technology with expertise in ETL development, Data Modeling and Data/system Analysis
• 8 years of strong experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing ETL Solutions using Informatica Power Center (8.x/7.x).
• Extensively worked on Informatica Designer Components - Source Analyzer, target Designer, Transformations Developer, Mapplet and Mapping Designer.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Vast experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.
• Experience on Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Dimensions, Facts and Star, Snowflake Schemas.
• Expertise in Query Analyzing, performance tuning of informatica mappings
• Experience in integration of various data sources like Oracle, SQL Server, Teradata and flat files into staging area.
• Experience in writing database scripts such as SQL queries, PL/SQL Stored Procedures, Indexes, Functions, Views, Materialized views and Triggers.
• Experience in writing UNIX shell scripts to support and automate the ETL process.
• Performed data validation by Unit Testing, integration testing and System Testing.
• Knowledge on creating list reports and cross tab reports using Business Objects and Cognos.
• Created UNIX scripts for parsing and modifying data and experience in using AUTOSYS/CONTROL M job scheduler for automation of UNIX shell scripts and batch scheduling.
• Extensive experience in managing teams/On Shore-Off Shore Coordination/Requirement Analysis/Code reviews/Implementing Standards.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Good Project Coordination skills, onsite coordination and offshore team management.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.6.1/8.1.1/7. x/6.x, Power Mart 6.2/5.1, Informatica Power Connect, Informatica Power Exchange.

Databases: Oracle 10g/9i/8i, SQL Server 2000/2005/2008, sybase, DB2.

Languages: SQL, T-SQL, PL/SQL, C, UNIX Shell Scripting.

Operating Systems: UNIX, Windows 2000/2003/NT, Linux, Sun Solaris, HP-UNIX, IBM AIX.

BI Tools: Business Objects, Crystal Reports, SSRS, SSIS, Oracle Business Intelligence Applications.

DB Tools: TOAD, SQL *Plus, PL/SQL Developer, SQL * Loader

Web Technologies: HTML, XML, DHTML, CSS

Data Modeling Tools: ERwin 4.5/4.1, MS Visio

Other Tools: Dream Weaver, Fireworks, Photoshop, Ms-Office, Autosys, Control-M.

PROFESSIONAL EXPERIENCE

Confidential, Alabama

Senior Informatica Developer

Responsibilities:

• Interacted with various business people and gathered the business requirements and translated them into technical specifications.
• Designed and developed Informatica Mappings based on the business requirements.
• Excellent interpersonal and communication skills and customer facing skills.
• Constantly interacted with the Business Intelligence team and the Data warehouse Architecture team to understand the requirements and implement them seamlessly.
• Extensive experience in managing/On shore-Off shore coordination/Requirement analysis/Code reviews/Implementing standards.
• Experience in complete Software Development Life Cycle (SDLC) including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
• Extensive experience on Technical low level mapping from source systems to target data mart.
• Experience in informatica Installation and Repository Administration.
• Extracted Data from different Source Systems like Oracle, Sql and Flat files.
• Experienced in optimizing the SQL queries to improve the performance.
• Used PL/SQL to write stored procedures to increase the performance.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked extensively on different complex mappings using transformations like Source qualifier, expression, Router, filter, update strategy, Connected and Un-connected lookup, Normalizer, joiner, Aggregator, Update strategy.
• Implemented Slowly Changing Dimension (SCD) Type 1 and Type 2 for maintaining the history.
• Responsible for using Data Masking Transformation to modify sensitive information like stock market indexes and credit ratings
• Successfully used the Masked Data in Development, Testing and Data mining.
• Worked with mappings to dynamically generate parameter files used by other mappings.
• Experience on Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Dimensions, Facts and Star, Snowflake Schemas, RalphKimball Methodologies and ER modeling.
• Creating sessions, worklets and workflows for carrying out test loads.
• Created the Deployment groups to move the workflows from one environment to the other.
• Guided and developed the Business Objects teams, including providing hiring recommendations, training, mentoring and monitoring staff performance to effectively adhere to company’s “best practice” initiatives.
• Designed/created the plan for the Master workflows that are to be scheduled to run on daily and monthly basis and created Reusable Transformations in Shared folder
• Extensive on the Data Integrator using the Business Objects and generating Reports.
• Involved in Migration of Informatica Mapping from Development to Production environment.
• Developed the UNIX shell scripts to send out an E-mail on success of the process indicating the destination folder where the files are available
• Good Knowledge and Experience on Unix Operating System and Shell scripting
• Use of Agile methods within my team, implementing code versioning and improving documentation
• Responsible for Unit testing, system and integration testing.
• Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better performance.
• Used Autosys to schedule session runs.

Environment: Informatica Power Center 8.6.1, Oracle9i/10g, Sql, UNIX Shell Scripting, Unix, Business objects11, PL/SQL, XML, Flat Files, Toad 9.0, SQL * Loader, Windows XP, Autosys.

Confidential, FL

Sr. Informatica Developer

Responsibilities:

• Gathered user requirements and reporting requirements for a better understanding of the business process and the current reporting system.
• Worked on Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Involved in Various Phases Of SDLC from requirement gathering, analysis, design, development and testing to production.
• Experience in informatica Installation and Repository Administration
• Meeting with business users and defining Functional and Technical business requirements.
• Worked extensively on Power center designer components like Source Analyzer, Target designer and Mapping Designer.
• Extensively created Reusable Transformations and Mapplets to implement the business logic for loading to the target database.
• Extracted data from various source systems like Oracle, SQL Server and flat files as per the requirements.
• Implemented Slowly Changing Dimension (SCD) Type 1 and Type 2 for maintaining the history.
• Developed different complex mappings using transformations like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy.
• Good understanding of Data Warehousing concepts, Dimensions, Facts and Star, Snowflake Schemas
• Improved the mapping performance using SQL overrides and used PL/SQL to write stored procedures to increase the performance.
• Developed post-session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Extensive experience on the Data Integrator using the Business Objects and generating Reports.
• Developed various sessions, batches containing parameters files, indicator files and multiple sources file.
• Optimized query performance, session performance.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers.
• Involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data.
• Used Autosys to schedule informatica workflows/sessions..

Environment: Informatica Power Center 8.1.1, Designer, Workflow Manager, Workflow Monitor, SQL Server 2005, Erwin 4.0/3.5.2, Cognos8.3/8.4, Business objects,TOAD 8.6.1.0, PL/SQL, Flat files, Oracle 9i, and Autosys.

Confidential, Chicago

ETL Developer

Responsibilities:

• Design and develop the ETL processes for Workforce Management Implementation-Base Reporting that are leveraged across multiple clients(Rockwell, Cintas, Omnicom and Pepsi)
• Co-ordinated the work between offshore and on-site and across all the clients
• Heavily involved in the logical and physical data modeling.
• Experience in informatica Installation and Repository Administration
• Customized and configured the ETLs for various clients using reusable transformations and mapplets.
• Extensively used Erwin to design Logical/Physical Data Models, forward/reverse engineering.
• Used Informatica Power Exchange to import source definitions from Mainframe system to Informatica Power Center.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Modeled the Data Warehousing Data marts using Star Schema.
• Involved in data conversion using Teradata Utilities and loaded into Teradata tables.
• Worked extensively on the performance tuning of ETLs by tweaking the lookup transformation cache
• Worked on Informatica Utilities - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Implemented Slowly Changing Dimension (SCD) Type 1 and Type 2 for maintaining the history.
• Extensive experience on Data Warehousing concepts, Dimensions, Facts and Star, Snowflake Schemas
• Worked with various transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, joiner transformations.
• Involved in creating Shell Scripts to automate Pre-Session and Post-Session Processes.
• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Developed stored procedure to determine the effective dates of various person records
• Coordinated with the QA and the Reporting team and provided guidance and knowledge on the ETL process
• Good Knowledge and Experience on Unix Operating System and Shell
• Involved in the UAT testing and Integration testing process
• Migrated the ETLs and the Database structure changes between the environments
• Used Control-M scheduler to schedule the ETL processes

Environment: Informatica Power center6.1, Oracle, DB2, SQL Server 2005AQT, UNIX, OBIEE 10.1.3.x,Control-M Scheduler

Confidential

Informatica developer

Responsibilities:

• Involved in Data transfer from OLTP systems forming the extracted sources.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the sources, transformed the data, mapped the data and loading the data into targets using Power Center Designer.
• Experience in informatica Installation and Repository Administration
• Designed and developed Oracle PL/SQL Procedures.
• Experience on Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Dimensions, Facts and Star, Snowflake Schemas, RalphKimball Methodologies and ER modeling.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Developed Sessions and Batches to schedule the loads at required frequency using Power Center Server Manager 5.1.
• Involved in data quality testing.
• Good Knowledge and Experience on Unix Operating System and Shell

Environment: Informatica Power Center 5.1 / Power Mart 5.1, Oracle 8i, SQL, PL/SQL, Quest TOAD 7.3 and Windows NT.

Confidential 

SQL Developer

Responsibilities:

• Design of the overall database using Entity Relationship diagrams.
• Wrote triggers and stored procedures in PL/SQL.
• Building, debugging and running forms.
• Data loading and Extracting functions using SQL.
• Designed and developed all the tables, views for the system in Sql server.
• Designing and developing forms validation procedures for query and update of Data.
• Created forms, and queries.
• Created reports for different criteria.
• Develop technical specifications from business requirement analysis and design sessions.
• Fix errors in data for various clients by using GUI interface of application or PL/SQL scripting.
• Managing theresolutionof support service issues, queries and enhancements.

Environment: Sql server, PLSQL, Windows NT.