SUMMARY:

• Nine years of experience in analysis, design, development, testing, implementation and production support of business applications using ETL Data Warehousing applications.
• Strong experience with Informatica Power Center suite (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Administration Console), Informatica MDM and Informatica cloud.
• Worked on administrator activities such as adding users, assigning project permissions, server health monitoring and monthly server bounce activities.
• Good experience designing and developing Business Intelligence solutions in data warehousing systems using Informatica Power Center 9.x/8 x.
• Expertise in Master Data Management concepts, methodologies and ability to apply this knowledge in building MDM solutions.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
• Expertise in Data Modelling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data mode using Erwin.
• Significant experience in AGILE delivery process of software using SCRUM.
• Experience documenting High Level Design, Low level Design, Unit test plan, Unit test cases and deployment documents.
• Strong understanding of RDBMS concepts and experience writing PL/SQL stored procedures and SQL statements.
• Experience with performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Developed batch jobs using UNIX Shell scripts to automate the process of loading, pushing and pulling data from different servers.
• Experience in Agile (scrum) and Waterfall models.
• Good experience in scheduling of ETL jobs using Informatica.
• Proficient in performing and supporting Unit testing, System Integration Testing (SIT), UAT (and production support for issues raised by application users).
• Experience working through the post development cycle and in production support.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x, Informatica Power Exchange, Informatica MDM, Informatica Cloud

OLAP & Reporting Tools: Business Objects

Programming Languages: SQL, PL/SQL, C++

Operating Systems: Windows 10/7/XP, UNIX, LINUX

RDBMS: Oracle 11g/10g/9i, MY SQL

Data Modeling Tools: Erwin

Utilities/Tools: TOAD, SQL Plus, SQL Developer, PL/SQL developer

MS Office: Outlook, Express, Word, Excel and Power point

PROFESSIONAL EXPERIENCE:

Informatica Architect

Confidential, Atlanta, GA

Responsibilities:

• Lead and guided Informatica based ETL architecture.
• Developed solutions in highly demanding environments and provided hands on guidance to other team members.
• Headed the complex ETL requirements and designs of new data models for billings and customer intelligence in data warehouse.
• Implemented an Informatica based ETL solution fulfilling stringent performance requirements.
• Collaborated with the product development teams and senior designers to develop architectural requirements to ensure client satisfaction with the products.
• Developed a full SDLC project plan to implement ETL solutions and identify resource requirements.
• Assessed the requirements for completeness and accuracy.
• Determined if the requirements were actionable for ETL team.
• Conducted impact assessment and determined the size of effort based on the requirements.
• Identified, recommended and implemented the ETL process and architecture improvements.
• Managed build phase and quality assured codes to ensure fulfilling requirements and adhered to ETL architecture.
• Resolved difficult designs and development issues.
• Identified bugs when the developers were not able to do so and provided them resolutions
• Developed ETL programs using Informatica Cloud for sales force application to bring sales force data into the datawarehouse
• Designed and developed ETL and Data Quality mappings to load and transform data from source to ODS using PowerCenter and Informatica Data Quality (IDQ).
• Designed and developed ETL codes using Informatica Cloud and extensively used the Cloud environment for sales force data loading.
• Involved in gathering business requirements for the data warehouse as well as business - intelligence reports.
• Involved in implementing the land process of loading the customer/product data sets into Informatica MDM from various source systems.
• Configured addresses which could be cleansed whole world address data and enhanced by making some modifications during installation.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined the trust and validation rules and set up the match/merge rule sets to get the right master records.
• Configured match rule set properties by enabling the search by rules in MDM according to the business rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.

Environment: Informatica PowerCenter 9.6, Informatica Cloud, Informatica MDM,Power Exchange Oracle 10g, TOAD, SQL, Flat files, Agile, Erwin 4.5, UNIX and Windows XP.

Sr . Informatica Developer/MDM developer

Confidential, Boston, MA

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source database systems like Netezza, Oracle, Teradata, SQL server and Flat files and loaded into Oracle.
• Designed and developed ETL and Data Quality mappings to load and transform data from source to ODS using PowerCenter and Informatica Data Quality (IDQ).
• Involved in migration of Informatica from 8.6 to 9.5.
• Extensively tested the mappings by running the queries against Source and Target tables and by using Break points in the Debugger.
• Developing Teradata Utility scripts like FastLoad, MultiLoad to load data from various source systems to Teradata.
• Worked on Agile methodology using Scrum.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of Informatica Data Quality IDQ.
• Created and configured workflows, worklets, and sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
• Created shortcuts, copies of Mappings, Workflows, various objects as per requirements and made use of shared folder objects.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Worked with NZLoad to load flat file data into Netezza tables.
• Involved in writing the UNIX scripts to schedule the Informatica workflows.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Created mappings using pushdown optimization to achieve good performance in loading data into Netezza.
• Creating Jobs and Job streams in Control-M scheduling tool to schedule Informatica maps, PL/SQL scripts and UNIX shell script jobs to run daily/weekly as necessary.
• Used oracle utility, SQL*Loader to load flat files and created log tables containing data with discrepancies.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Scheduled Workflows using the Scheduler in the Workflow Manager.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Used various Transformations like Dynamic Lookup, Connected and Unconnected lookups, Filter, Stored procedure, Update Strategy, Joiner, Aggregator, Expression, Router, Sequence generator, Normalize in the mappings.
• Involved in improving the performance tuning of various mappings and workflows.
• Customized the dashboards and Key Performance Indicators (KPIs) for better manageability of overall performance.
• Scheduled and published reports using Broadcast Agent in various formats like excel PDF and HTML.
• Involved in production support team for data validation requirements such as data loads, data conversions from different source database like SQL Server, Oracle to Enterprise Data Warehouse.
• Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.

Environment: Informatica PowerCenter 8.6, Informatica Cloud, Informatica MDM, Oracle 10g, TOAD, SQL, Flat files, Agile, Erwin 4.5, UNIX and Windows XP.

Informatica Developer/Admin

Confidential

Responsibilities:

• Worked closely with Business Analyst and the end users in writing the functional specifications based on the business requirement needs.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin 4.5 to design the business process, dimensions and measured facts.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.6.1.
• Migrating from Informatica 8.6 mappings into Informatica 9.6 which consists of grid technology.
• Understanding the domain and nodes as well as by using the Informatica integration service to run the workflows in 8.6.1.
• Involved in migration of Informatica from 8.6 to 9.5 and 9.6.
• Acted as Scrum team member for the Agile core process team applying Scrum principles.
• Scheduled various daily and monthly ETL loads using Informatica.
• Provided production support on shared platforms.
• Worked on power exchange to access the data from different sources and to avoid manual coding.
• Experience with high volume datasets from various sources like Oracle, Text Files, and Relational Tables.
• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, Source Qualifier and Stored procedure transformations.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Involved in production support team for data validation requirements such as data loads, data conversions from different source database like Oracle to Enterprise Data Warehouse.
• Implemented Type1 and Type2 methodologies in ODS tables loading, to keep historical data in data warehouse.
• Tuning the complex mappings based on source target and mapping, session level.
• Involved in performance and tuning the ETL processes.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Developed UNIX Shell Scripts for scheduling the sessions in Informatica.
• Used SQL tools like TOAD run SQL queries and validate the data in warehouse.

Environment: Informatica PowerCenter 8.6, Informatica Cloud, Oracle 10g, TOAD, SQL, Flat files, Agile, Erwin 4.5, UNIX, Windows XP.

Informatica Developer

Confidential

Responsibilities:

• Analyzed the scope, objectives and requirements of the project.
• Provided data models, along with thorough data analysis and data profiling.
• Evaluated low level design documents.
• Developed code using Informatica according to low level design documents and validated the codes against the standards.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of the data warehouse including tuning and modified the Stored Procedures for code enhancements.
• Performed unit testing at various levels of the ETL and actively involved in the team code reviews.
• Identified the problems in the existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Developed procedures/functions using PL/SQL.
• Used various new features of Informatica, PowerCenter Designer such as Sorter transformation, and Compare Objects features.
• Parameterized all the Source and Target connection values and defined in the parameter file. Used DB Connection for the Source and Target connections.
• Used Informatica Versioning feature efficiently to keep track of the development changes from time to time.
• Used Informatica efficiently and always tried for the better performance. Used reusability whenever it was applicable.
• Developed shell scripts in UNIX for scheduling the Informatica jobs
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying the Stored Procedures for the code enhancements.
• Scheduled workflows using the scheduler in the workflow manager.
• Created different views, complex views, synonyms and database links on the tables and across the schemas as per the requirements.
• Acted as a technical lead for a team of six members and used it to communicate with customers for any data related issues.

Environment: Informatica PowerCenter 7.0, Power Exchange 7.0, G1, Oracle 9i, My SQL, UNIX and Windows XP.