SUMMARY

• 8+ years of extensive experience in Informatica Power Center (9.x/8.x/7.x/6.x) tools such as Designer, Workflow Manager, Workflow Monitor, Repository Manager and Repository Server Administration Console.
• Hands on experience with Data Profiling/Data Quality using Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Expertise in Dimensional Data Modeling techniques such as Star and Snowflake schemas using ERWIN 7.x/4.x/3. x.
• Expertise in design and implementation of SCD - Slowly changing dimensions’ types (1, 2 and 3) and CDC - Change data capture.
• ETL best practices/methodologies (transformation usage, naming conversions, mapping standards, slowly changing dimensions, deployment groups, versioning, etc).
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from multiple data sources such as Oracle, DB2, SQL Server, Flat files, CSV files, VSAM files, COBOL files and XML files into a Reporting and Analytical Data Model.
• Have very good exposure on Change Data Capture using Power Exchange for Oracle.
• Involved in Performance tuning of Informatica mappings, sessions, source and target.
• Expertise in Database Design, Development of SQL, PL/SQL and Query tuning for better performance.
• Good exposure in writing BTEQ scripts and loading data into Teradata using FASTLOAD, MLOAD and TPUMP utilities.
• Experienced in writing Unix Shell Scripts for the automation of ETL processes and using schedulers like AutoSys, Ctrl-M.
• Good knowledge in Informatica Master Data Management (MDM) and Informatica Data Quality (IDQ).
• Knowledge on Green plum, Big Data Analytics, Could systems.
• Excellent working knowledge on multiple platforms like HP-UX, Windows, Unix-AIX, Sun Solaris, Linux.
• Dedicated, self-motivated achiever who is committed to success and adept at handling multiple tasks in a high-pressured environment.
• Excellent communication skills and Ability to work in-groups as well as independently.
• Integrating sap data into warehousing using Informatica.
• Had experience with data warehouse appliance and enterprise data warehousing solutions.
• Good hands on experience with SOW.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter (PWC) 9.x/8.x(Workflow Manager, Workflow Monitor, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, and Informatica server), IDQ,IDE

Database & Related Tools: Oracle 10g/9i/8i, MS SQL Server 2005/2008, Oracle SQL Developer, MS Access, Putty, WinSCP

Data Modeling Tools: Oracle SQL Developer tool, MS Visio, Star schema, Snowflake schema), Physical and Logical Data Modeling

Languages: SQL, PL/SQL, SQL*Plus, C

Operating Systems: Window / 98/2000/2003/2008/ XP, Unix.

BI Tools: Business Objects 8.x/5.x, Cognos 8.x

Other: Agile & waterfall methodology, MS Word, MS Excel, MS Office 2003/2007/2010 , Outlook, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, KY

Informatica Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• 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.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively worked on Onsite and Offshore work model.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• 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.

Environment: Informatica Power Center 9.5.1/9.6.1 , Power Exchange, Oracle 11g/12g, SQL Server,TOAD, JIRA, UNIX shell scripting, MS OFFICE, Erwin Data Modeler, Putty, Winscp, Control - M.

Confidential, Birmingham, Alabama

ETL Developer

Responsibilities:

• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy, Transaction control, Sorter etc.
• Extracted data form flat files and Oracle 12g database, applied business logic to load them in the central Oracle database.
• Analysed the current DW environment to understand the data loading, source data normalization processes, database environment, batch jobs, reporting and dashboard publishing systems.
• Worked with oracle data integrator (ODI) to cover all data integration requirements for data warehouse. understand the current application issues, challenges, technology bottleneck if any
• Supported the current requirements from IT team for their support processes, SLA and ticket escalation processes, response, and resolution time.
• Find any gaps that may be present in the processes in managing the support requirements that are need to be met by the proposed system.
• Exclusively used SQL to write complex queries.
• Extensively used Power Center Designer, workflow manager and source analyser.
• Created source and target tables in oracle database and worked on flat files.
• Identified any probable risks that may harm the proposed application support and highlight for further analysis by stakeholders.
• Suggest and share risk mitigation strategies discuss them with the stakeholders including the business and get the same approved.
• Worked on Data Warehouse Production on call Support 24/7 and monitoring services for the Control - M batch jobs.

Environment: Informatica ETL 9.5 Skills: Designer, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Work Flow Monitor, Transformation techniques, Data loading, Reporting tools dashboard, Cognos & crystal reports, batch jobs, Admin Console.

Confidential, Washington County, OR

Sr. Informatica Developer

Responsibilities:

• Prepared the mapping design document using the specifications gathered from the Business Analysis teams
• Took part in the data modeling for DataMart (shoe - mart) and created logical and physical tables in Teradata environment.
• Used Erwin forward engineering and backward engineering to modify existing data model.
• Created the ETL logic document and dependency mapping sheet.
• Worked on Teradata utilities like fastload, MultiLoad and FastExport.
• Developed Teradata and Informatica based ETL scripts/jobs to meet client requirements.
• Load data from various source flatfile, excel source, xml, ORACLE, etc. to stage table.
• Created range in excel source to import data from excel file source.
• Generated dynamic flat file using Informatica power center using transaction control transformation.
• Using delimited flat file load target file and generate excel reporting.
• Using excel formulas generate sales revenue pie charts. (per location wise)
• Created DSN for excel source in PowerCenter designer and session level.
• Created workflows with concurrent and sequential sessions as per requirement using control and email tasks.
• Load data from staging area into Teradata data warehousing using Bteq, Mload, fastload, TPT utilities.
• Worked on query tuning.
• Validated the data for accurate load into target databases.
• Involved in development of SQL Queries.
• Involved in writing scripts to schedule the different workflows.
• Tested the scripts and queries according to the requirements.
• Meeting and discussions within the team and also with onsite counterpart

Environment: Informatica PowerCenter 9.1/9.5, Teradata 13.0, Teradata Parallel Transporter, FastLoad, MLOAD, Fast Export, Tpump, RHEL 6.4, Solaris 10

Confidential, Billerica, MA

Informatica Developer

Responsibilities:

• Transformed business requirements into technical documents BRD, explained business requirements in terms of technology to the developers.
• Developed Data Flow diagrams to create Mappings and Test plans. The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Developed Test plan to verify the logic of every Mapping in a Session.
• The test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Created Mapplet and used them in different Mappings.
• Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Created registration and data map for loading CDC data.
• Designed various mappings for extracting data from various sources involving Flat files, Oracle, Sybase and SQL Server, IBM DB2.
• Involved in writing and modifying UNIX shell scripts.
• Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
• Worked with data quality team to fix the production data issues and also provide solutions to the business users.
• Coordinated with offshore team to support the existing ODS system jobs.
• Coordinated with business users and across the development teams in implementing new business requests.
• Used Toad for data quality verification and unit testing the data.

Environment: Informatica Power Center 9.0/9.5.1, Power Exchange 9.5.1/8.6, AS-400 (DB2), Oracle 11/10g, Teradata 12, OBIEE 10g

Confidential

Informatica Developer

Responsibilities:

• Interacted with business analysts to gather the business requirements by attending regular meetings with the business community.
• Performed Informatica Administrator functions like created repository, Groups Users, Folders, giving permissions on the folders to the users, etc.
• Used Power exchange data movement and CDC to move bulk amount of data in various platforms
• Extensively used command line tool like pmcmd, pmrep & pmrepagent.
• Involved in managing Informatica backup and restores.
• Used Informatica user defined functions to reduce the code dependency.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performing ETL & database code migrations across environments.
• Prepared ETL detail design and unit testing document to outline the flow of data, for testing source/targets counts and field-to-field mappings.
• Provided production support by running the jobs and fixing the bugs.
• Experience with upgrading repositories from 8.1 to 8.6 version of Informatica.
• Taking the backup of the repository at regular interval depending on the amount of work done.
• Aided in migrating the code across various environments.
• Worked on test cases and test plans.
• Documented the process for further maintenance and production support.

Environment: Informatica Power Center 8.6, Informatica PowerExchange8.6, Autosys, ORACLE 9i, SQL, PLSQL

Confidential

Informatica/SQL Developer

Responsibilities:

• Extensively involved in Gathering requirements by holding meetings with users.
• Constructed context diagrams and data-flow diagrams based on a description of a business process.
• Analyzing the data model and identification of heterogeneous data sources.
• Constructed an extended entity relationship diagram based on a narrative description of a business scenario.
• Created the Source and Target Definitions using Informatica Power Center Designer.
• Used Informatica Power center to load the data into data warehouse.
• Development of Informatica mappings and Mapplets and also tuned them for Optimum performance and dependencies.
• Created reusable Transformations for modifying data before loading into target tables.
• Created mapplets in the Informatica Designer which are generalized and useful to any number of mappings for ETL jobs.
• Created Transformations using the SQL script to modify the data before loading into tables.
• Created and used mapping parameters, mapping variables using Informatica mapping designer to simplify the mappings.
• Used the Business objects features Slice and Dice and Drill Down for multi-dimensional analysis.
• Scheduled various daily and monthly ETL loads using Control-M.
• Inserted Objects, Conditions, classes, subclasses and user objects according to client’s requirement.
• Prepared SQL Queries to validate the data in both source and target databases.
• Managed the database objects Indexes, Triggers, procedures, functions, packages, cursors.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.

Environment: Informatica Power Center 8.1/8.6, Oracle 9i, SQL Server, TOAD, Control M, Windows 2003 and UNIX.