PROFESSIONAL SUMMARY:

• 6+ years of IT industry with substantial experience in providing information management consulting services on Informatica Power Center, Power Exchange, Informatica Data Quality, Data Integration and Business Intelligence Applications.
• Developed applications to individual client standards. Submitted weekly status reports to Application Development Managers.
• Over 6+ years of experience in Informatica PowerCenter and 4 years using Informatica Data Quality.
• Extensive exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Strong experience with Informatica tools using real - time CDC (change data capture) and MD5.
• Experience in integration of various data sources like Oracle, Teradata, Netezza, Mainframes, SQL server, XML and Flat files.
• Very strong in Data Warehousing Concepts like Dimensions Type I, II and III, Facts, Surrogate keys, ODS, Staging area, cube also well versed in Ralph Kimball and Bill Inmon Methodologies.
• Realistic understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling.
• Superior SQL Skills and ability to write and interpret complex SQL statements and also mentor developers on SQL Optimization.
• Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server and Teradata. Good understanding of Views, Synonyms, Indexes, Partitioning, Database Joins, Stats and Optimization.
• Experience in developing very complex mappings, reusable transformations, sessions and workflows using Informatica ETL tool to extract data from various sources and load into targets.
• Experience in tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulk load.
• Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Reduced the execution time for huge volumes of data for a company merger projects. Heavily created mapples, user defined functions, reusable transformations, look-ups.
• Technical expertise in designing technical processes by using Internal Modeling & working with Analytical Teams to create design specifications; successfully defined & designed critical ETL processes, Extraction Logic, Job Control Audit Tables, Dynamic Generation of Session Parameter File, File Mover Process, etc.
• Strong expertise in using ETL Tool Informatica Power Center 8.x /9.x/10.x (Designer, Workflow Manager, Repository Manager, Data Quality (IDQ) and ETL concepts.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookup, joiner, sequence generator, sorter, sql, stored procedure, Update strategy and Source Qualifier.
• Experienced in using advanced concepts of Informatica like Push down Optimization (PDO).
• Designing and developing Informatica mappings including Type-I, Type-II and Type-III slowly changing dimensions (SCD).
• Experienced in scheduling Informatica jobs using scheduling tools like DAC, AutoSys and Control-M.
• Data Modeling: Data modeling knowledge in Dimensional Data modeling, Star Schema, Snow-Flake Schema, FACT and Dimensions tables.
• Experienced in writing SQL, PL/SQL programming, Stored Procedures, Functions, Triggers, Views and Materialized Views.
• Involved in the development of Informatica mappings and also tuned for better Performance.
• Good hands on experience in writing UNIX shell scripts to process Data Warehouse jobs.
• Deftly executed multi-resource projects following Onsite Offshore model while serving as a Mentor for the Junior Team Members
• Excellent communication and presentation skills, works well as an integral part of a team, as well as independently, intellectually flexible and adaptive to change.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 10.1/9.6/9.1/8.6/8.1, Informatica Data Quality 10.1/9.6.1/9.1, Power Exchange, Metadata Manager 9.6.1, Data Mart, OLAP, OLTP and ERWIN 4.x/3.x.

Programming Languages: Unix Shell Scripting, SQL, PL/SQL.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin and Oracle Designer.

Methodology: Agile, SCRUM and Waterfall.

Databases & Tools: Oracle 11g/10g/9i, SQL Server 2012/2008/2005, Netezza, SQL*Plus, SQL*Loader and TOAD.

Operating Systems: Windows, UNIX and Linux.

Reporting Tools: OBIEE, Tableau.

Scheduling Tools: UC4, Control-m, Autosys, DAC.

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

Sr. ETL Informatica Developer/IDQ Developer

Responsibilities:

• Responsible for design and development of multiple projects leveraging Informatica Power Center ETL tool, Data Quality and Tableau reporting tools.
• Understand the data quality rules defined by the business/functional teams and propose the optimization of these rules if applicable, then design and develop these rules with IDQ, including development and unit testing.
• Working with Business Analyst, get the Functional Specification Document and prepared Technical Design Document.
• Performed Data Profiling using Informatica Data Quality Analyst (IDQ) Tool.
• Analysed heterogeneous sources, applied transformations and moved to target according to the business requirements
• Provided Golden Set of Records using Grouping, Matching, and Consolidation to Data Steward Team.
• Designed various mappings and Mapplets using different Transformations Techniques such as Key Generator, Match, Labeller, Case Converter, Standardizer, and Address Validator.
• Responsible for Impact Analysis, upstream/downstream impacts.
• Analyse business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.
• Worked on Informatica- Source Analyser, Warehouse Designer, Mapping Designer &Mapplet, and Transformation Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Queried the Target database using Teradata SQL and BTEQ for validation.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Work let Designer.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Implemented pipeline partitioning concepts like Hash-key, Round-Robin, Key-Range, Pass Through techniques in mapping transformations.
• Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions. Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.
• Scheduling Informatica jobs and implementing dependencies if necessary using Autosys.
• Responsible for performing SQL query optimization using Hints, Indexes and Explain plan.
• Managed post production issues and delivered all assignments/projects within specified time lines.

Environment: Informatica Power Center 10.1/9.6.1, Informatica Data Quality 10.1/9.6.1, Metadata Manager 10.1, Power Exchange 9.5, Oracle 11g, IBM DB2, SQL server 2012, Teradata 15, Flat Files, Tableau, Erwin 4.1.2, Toad, SVN, WinScp, HP ALM, UC4, UNIX, Putty, Shell Scripting.

Confidential

Informatica Developer

Responsibilities:

• Responsible for design, development and maintenance of Data Marts including Sales, Policy, Customer Reporting and Claims.
• Worked with Business Analyst and application users to finalize Data Model, with Netezza functional and detailed technical requirements.
• Data Cleansed and Address Validated through Address Doctor for the Facets System.
• Used Case Converter for Contact Data such as First Name and Last Name.
• Extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems
• Defined Business rules in Informatica Data Quality (IDQ) to evaluate quality of data by creating cleanse processes to monitor compliance with standards and also identified areas for data quality gaps and assist in resolving data quality issues.
• Design and developed Exception Handling, data standardization procedures and quality assurance controls
• Exported Mappings from IDQ to Informatica Power Center. Responsible for Data Warehouse Architecture, ETL and coding standards.
• Developed Capacity Planning/Architecture/ Strategic Roadmaps/Implementing standards.
• Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Conducted a series of discussions with team members to convert Business rules into Informatica mappings.
• Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Mapplets and used them in different Mappings.
• Developed stored procedure to check source data with warehouse data and if not present, write the records to spool table and used spool table as lookup in transformation.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Managed Scheduling of Tasks to run any time without nay operator intervention.
• Leveraged workflow manager for session management, database connection management and scheduling of jobs.
• Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.
• Experienced in Debugging and Performance tuning of targets, sources, mappings and sessions. Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.
• Delivered all the projects/assignments within specified timelines.

Environment: Informatica Power Center 9.5, Informatica Data Quality 9.5, Netezza, Oracle 10g, Power Exchange, Flat files, MS SQL server 2008, HP Quality Control, Winscp, Autosys, MS. Visio, Shell Scripting, UNIX.

Confidential

Informatica developer

Responsibilities:

• Worked on complete project life cycle from analysis to production implementation with emphasis on identifying the source.
• Involved in the analysis, design and development of the interface using Informatica PowerCenter in the development team and interfaced with onsite business analysts for business related issues.
• Designed and developed mappings, reusable transformations using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Used Debugger to test the mappings and fix the bugs. Extensively worked in the performance tuning of the mappings, sessions.
• Involved in fixing invalid mappings, Unit and Integrating testing of Informatica Sessions.
• Delivered the releases after each stage of the testing and defect removal within estimated time.
• Prepared UNIX shell scripts for making the process to execute without any hard-coded parameters.
• Involved in the migration of the mappings and workflows from the Development Server to UAT and then to Production Server.
• Assisted the team for the Production Run and resolved issues if arises. Created, updated and maintained ETL technical documentation.

Environment: Informatica PowerCenter (Designer, Workflow Monitor, Workflow Manager), Sybase, Flat files, Oracle, UNIX.