SUMMARY

• Over 8+ years of IT experience with good knowledge in Analysis, Design, Development, Testing and Implementation of Data Warehouse application using Informatica Power Center and Informatica Data quality, Oracle and Unix.
• Extensively worked on data extraction, transformation and loading data from various sources like Oracle, XML and Flat files.
• Extensively worked onInformatica Power Center Transformations such asSource Qualifier, Lookup, Expression, Router, Aggregator, Union Transformation, Update Strategy, Filter, Normalizer, Joiner, Xml transformation, Rank, Stored Procedure, SorterandSequence Generator.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center 8.6, 9.1 and 9.5.
• Experience in database programming in PL/SQL and UNIX shell scripting.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Good experience on Data Warehouse Concepts like Dimension Tables, Fact tables, slowly changing dimensions, Data marts and dimensional modeling schemas.
• Expertise in data modeling, development and enhancement.
• Experience on creating profile, rules and mappings with IDQ.
• Experience working with IDQ transformations like Labeller, Parser, Standardizer, Matching etc.
• Ensured that all the applications and software modules in the team have proper documentation and business support.
• Demonstrated business knowledge and efficient support for the business users.
• Good communication and interpersonal skills, ability to learn quickly, with good analytical reasoning and adaptive to new and challenging technological environment
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within timeframe.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x

Reporting Tools: SAP Business Objects, Desktop Intelligence, Dashboard, and Info View.

Databases: Oracle 11g, 10g/9i/8i, MS Access, SQL server 2005/2008, My SQL.

Database Tools: TOAD, OracleSQL developer, SQL *PLUS

Languages: SQL, PL/SQL, UNIX Scripting, XML.

Operating System: WIN 2000/XP, UNIX, MS DOS.

Scheduling Tool: Autosys

PROFESSIONAL EXPERIENCE

Informatica DQ Developer

Confidential

Responsibilities:

• Coordinates design activities with other Developers to ensure project adheres to project specifications, and provides Supervisor and/or Project Manager with level of effort estimations, milestone timelines, and periodic status updates.
• Interacting with Business & Data Analysts to understand the business requirements.
• Configuring Mappings by using cleanse functions to get data from landing to staging.
• Responsible for performing data quality checks using profiling and then creating reference tables and scorecards.
• Data profiling and extraction of insights from data, using exact matching, deduplication, fuzzy logic, and other techniques to review data for accuracy.
• Design, develop, test, and deploy IDQ solution for the Supplier data domain.
• Expertise in more than one functional area of technology and provides architecture and design solutions that ensure Data Quality of large scale data along with data lineage.
• Managing the entire life cycle of most assigned projects.
• Writing application code, developing user interfaces, developing unit test cases and harnesses.
• Creating design, interface, system, and user documentation. Tests software and interfaces.
• End to end and performance testing, and performs other tasks needed to complete projects.
• Assists in testing and troubleshooting data quality implementations to ensure integration with product deployments.
• Working with Business Partners when developing technical requirements, design, and status regarding production issues.
• Providing guidance and mentoring to junior level Developers and performs regular code reviews to enforce coding standards and quality.
• Working within project specifications to meet goals and objectives in a timely and accurate manner; raises issues expediently that could impede the project specifications or timelines.
• Manage end to end data quality implementation to ensure quality of data content and all aspects of data quality dimensions using industry standard tools like Informatica IDQ on Hadoop and RDBMS technologies.

Environment: Informatica Data Quality, InformaticaPower center 9.5, Oracle 11g, UNIX.

Informatica Designer

Confidential, Atlanta

Responsibilities:

• Analyze the interface agreements existing between billing systems and notification engines.
• Drafted ETL strategies and Meta Data integration.
• Architected, Designed and documented the end to end solution approach for the CPNI - Data Metrics data mart.
• Define the file format and file details of the data files to be received from the source system.
• Identify the gaps between the data available in the Transaction systems and the requirements.
• Document the identified gaps and communicate it to business user.
• Extensively worked with business users to understand the requirements and architect the most efficient solution.
• Designed the data archival and purge process.
• Architect the file watch, file error handling, and file archive process and strategies.
• Developed technical design specification to load the data into the data mart tables confirming to the business rules.
• Design Systems Solution Approach and Technical design document to integrate the data received from multiple billing system and notification engines.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router and Lookup transformations.
• Involved in the design and development of indexes, views, materialized views, triggers, functions, stored procedures and packages using PL/SQL based on the requirement.
• Co-ordinate the offshore development team and onshore business team.
• Translate the Business requirement into effective and persistent data warehouse architecture.
• Co-ordinate with report analysts to integrate the data mart and Business objects reporting universe.
• Developing UNIX scripts for performing daily and batch jobs.
• Involved in the design and development of logical and physical data model.
• Identify the data cleansing elements and prepare the specifications for data cleansing.
• Identify the data profiling aspects of the project. Interact with users to identify the requirements and architect and implement the data profiling strategies.
• Document functional and technical specifications.

Environment: Informatica Power center 8.6.1, Oracle 10g, PL/SQL, MS-Access, SQL Loader, UNIX, and Business Objects.

Informatica Analyst

Confidential

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like XML and Delimited Flat files.
• XSP is used to notify corporate actions to the clients
• Development of ETL using Informatica 9.1 v
• Used various transformations such as Source Qualifier, Expression, Joiner, Filter and Lookup
• Developed workflows using workflow designer in Workflow manager and monitored the results using workflow monitor
• Prepared pre session and post session commands according to business requirements
• Automated the Informatica jobs using UNIX shell scripting and scheduled jobs using a Scheduler tool
• Worked with business analysts for requirement gathering, business analysis, and testing and project coordination
• Administered trouble shooting of production problems

Environment: Informatica 9.1, Oracle 10g, XML, MS SQL Server 2003, Flat files, Windows 2003, Unix.

Informatica Analyst

Confidential

Responsibilities:

• Analyzed the business requirements and functional specifications
• Extracted data from oracle database and flat files, and applied business logic to load them in the central SQL database
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse
• Extensively used Transformations like Router, Aggregator, Joiner, Expression, Lookup and Stored Procedure
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance
• Used informatica Power Center Workflow manager to create sessions and workflows
• Extensively used Informatica debugger to figure out the problems in mapping
• Created automated emails to get the ETL exception reports and validation reports after the data is loaded into the warehouse database
• Written documentation to describe program development, logic, coding, testing, changes and corrections

Environment: Informatica 8.6, Oracle 10g, MS SQL Server 2008, Flat files, Windows 2003, UNIX.

Informatica Analyst

Confidential

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key measures.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders.
• Worked with the Power Center Designer tools in developing mappings to extract data from sources such as ORACLE DB and Delimited Flat files
• Created various transformations such as Source Qualifier, Expression, Joiner, Filter and Lookup to compare data among three different sources.
• Developed workflows using workflow designer in Workflow manager and monitored the results using workflow monitor
• Used Variables and Parameters in the mappings to pass the values between sessions
• Scheduled Informatica jobs using a scheduling tool
• Created reconciliation report in a shared path in a server for the business users to access
• Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others.

Environment: Informatica 8.6, Oracle 10g, MS SQL Server 2003, Flat files, Windows 2003, UNIX.