SUMMARY

• An accomplished and talented IT professional with 10 - years of extensive experience in Architecture, Analysis, Design, Development, Testing, Implementation, Administration and Production support of business applications using ETL Data Warehousing applications.
• Proficient in Informatica Power Center suite (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Administration Console), Informatica Data Quality (IDQ), Informatica Master Data Management (MDM) and Informatica cloud for Salesforce.
• Worked on administrator activities such as adding users, assigning project permissions, server health monitoring and monthly server bouncing activities.
• Good experience in designing and developing Business Intelligence solutions in Data Warehousing systems using Informatica Power Center 9.x/8 x.
• Expertise in Master Data Management (MDM) concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Strong 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 model using Erwin.
• Good experience in AGILE delivery process of software using SCRUM.
• Experience in documenting High Level Design, Low level Design, Unit test plan, Unit test cases and Deployment documents.
• Extensively worked with various database like Oracle, Teradata, Netezza, SQL Server and DB2.
• Strong understanding of RDBMS concepts and experience in writing PL/SQL stored procedures and SQL statements.
• Experienced in 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.
• Good experience in scheduling of ETL jobs using Informatica.
• Well versed with offshore-onsite IT service model.
• Good experience in performing and supporting Unit testing, System Integration Testing (SIT), UAT (and production support for issues raised by application users).
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.
• Strong technical background with excellent problem solving skills, good time management skills and excellent team player with reputation of integrity and an ability to work on multiple technologies.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.x/9.x/8.x, Informatica Power Exchange, Informatica MDM, Informatica Data Quality (IDQ), Informatica Cloud for Salesforce.

OLAP & Reporting Tools: Business Objects

Languages: SQL, PL/SQL, C++

Operating Systems: Windows 10/8/7/XP/2000/NT, UNIX, LINUX

RDBMS: Oracle 11g/10g, MS SQL Server, Netezza, My SQL, Teradata and Sybase

Data Modeling Tools: Erwin

Utilities/Tools: TOAD, SQL Plus, SQL Developer, Autosys and Control-M

Methodologies: Agile Waterfall

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

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Informatica Lead Architect

Responsibilities:

• Lead and guide of an Informatica based ETL architecture.
• Develop solutions in highly demanding environment and provide hands on guidance to other team members.
• Head complex ETL requirements and design of new data models for Billings and Customer intelligence in data warehouse and whenever there are requests from customer then used to enhance the data model by doing thorough analysis and data profiling on the requirements.
• Implement an Informatica based ETL solution fulfilling stringent performance requirements.
• Collaborate with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with product.
• Develop full SDLC project plans to implement ETL solution and identify resource requirements.
• Assess requirements for completeness and accuracy.
• Involved in migration of Informatica from 9.1 to 9.6.
• Determine if requirements are actionable for ETL team.
• Conduct impact assessment and determine size of effort based on requirements.
• Identify, recommend and implement ETL process and architecture improvements.
• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture.
• Resolve difficult design and development issues.
• Identify bugs when developers are not able to do so and provide them resolution.
• Developed ETL programs using Informatica Cloud for Salesforce application to bring salesforce 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 code using Informatica Cloud and extensively used the Cloud environment for Salesforce 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 Set into Informatica MDM from various source systems.
• Configured Address which can cleanse 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 setting up the match/merge rule sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.

Environment: Informatica PowerCenter 9.6/9.1, Informatica IDQ, Informatica Cloud for Salesforce, Informatica MDM, Power Exchange, SAP Business Objects, Oracle 10g, MS SQL Server 2014, TOAD, SQL, Flat files, Agile, Erwin 4.5, Shell script, UNIX, Windows XP.

Confidential, Boston, MA

Sr. Informatica Lead Developer/Admin

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.1.
• 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 9.1 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Informatica Data Quality (IDQ) 8.6.1, Netezza 6.0, Oracle 11g, Teradata 13.0, MS SQL server 2012, Control-M, Shell script, SQL, PL/SQL, TOAD, Agile, Erwin, Flat files, UNIX and Windows.

Confidential, South Portland, ME

Sr. Informatica Developer/Designer

Responsibilities:

• Interacted with business and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the DataMart.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Designed the Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed mappings to extract data from MySQL, Oracle, DB2, Flat files, VSAM and load into Data Mart using the Power Center.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to DataMart.
• Used mapplets for use in mappings thereby saving valuable design time and effort.
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Written procedures, Queries to retrieve data from DWH and implemented in DM.
• Written shell scripts in UNIX to execute the workflow.
• Written shell scripts to run the workflows and automated them through Autosys job scheduler.
• Preparing the technical documents (like design documents, HLDs, LLDs) from business requirement documents.
• Responsible for submitting DBA requests, following up with data base DBA’s and Informatica administrators, creating remedy ticket, handling all the signoff’s for the production, updating all changes with new versions, creating test cases using Quality Center.
• Written SQL Queries, Triggers and PL/SQL Procedures to apply and maintain the Business Rules.
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.
• Written Indexes, primary keys and checked other performance tuning at data base level.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created testing metrics using MS-Excel.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Defects were tracked, reviewed and analysed.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.

Environment: Informatica PowerCenter 8.6, Oracle 10g, DB2, MySQL, Flat files, VSAM, Teradata 6, SQL, PL/SQL, IBM AIX, UNIX Shell Scripts, Erwin, Autosys job scheduler, HP Quality Center.

Confidential, Chicago, IL

Informatica Developer

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.
• Acted as Scrum team member for the agile core process team applying Scrum principles.
• Scheduled various daily and monthly ETL loads using Informatica.
• Provide 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.0, Oracle 10g, TOAD, SQL, Flat files, Agile, Shell Scripts, Erwin 4.5, UNIX, Windows XP.

Confidential

Informatica Developer

Responsibilities:

• Understanding the scope, objectives and requirements of the project.
• Responsible for creating Technical Design document based on the Business requirement.
• Understanding the data model, along with thorough data analysis and data profiling.
• Design and development of ETL application to load data in data warehouse using Informatica.
• Understanding Telecom concepts and different modules like CRM, Clarity and Billing.
• Developing the code using Informatica according to Low level design document and validating the code 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, modifying of stored procedures for code enhancements.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in 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, 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 wherever it is applicable.
• Developed Shell scripts in UNIX for scheduling the Informatica jobs.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for 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 schemas as per requirements.
• Acted as Technical lead for a team of 6 members and used to communicate with customer for any data related issues.

Environment: Informatica PowerCenter 7.0, Power Exchange 7.0, G1, Shell Scripts, Oracle 9i, SQL, PL/SQL, MySQL, UNIX, Windows XP.