SUMMARY

• 8 Plus years of experience in analysis, design and development of enterprise level data warehouses using Informatica.
• Experience in interacting with business users to clarify requirements and translate the requirements into technical specifications.
• Good proficiency in Informatica Data Quality 9.5.1/9.6.1 and Informatica power center 9.x/8.x/7.xs and Informatica Data Services and Meta Data Management (MDM) and Informatica Cloud, Data Staging.
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
• Experience in complete Software Development Life Cycle (SDLC) (Requirement Analysis, Design, Development & Testings).
• Designed complex Mappings and have expertise in performance tuning and slowly - changing Dimension Tables and Fact tables.
• Strong data modeling experience using Star/Snow flake schema, Re-engineering, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling.
• Strong in implementation of data profiling, creating score cards, creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
• Expertise in developing standard and re-usable mappings using various transformations like Sorter, Rank, Expression, aggregator, joiner, source qualifier, lookup and router.
• Excellent working experience with Insurance Industry with strong Business Knowledge in Auto, Life and Health Care - Lines of Business.
• SQL Server BI (SSIS/SSRS) & T-SQL developer with 5+ years of IT experience in Database design, development, T-SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) & SQL Server Reporting services (SSRS) in various domains like Entertainment, Insurance and Banking.
• Experience in PL/SQL Programming and in writing Stored Procedures, Functions etc., and extensive Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 9.X/8.X/7.X/6.X.
• Experience in source systems analysis and data extraction from various sources like Flat files, Oracle 11g/10g/9i/8i, IBM DB2 UDB, XML files and extensively used ETL to load data using Power Center / Power Exchange from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact-SQL queries, stored procedures, Indexes, CTE and triggers using SQL Servers to facilitate efficient data manipulation and data consistency.
• Excellent skills in designing Logical and Physical Modeling using ERWIN Tool and ER Studio.
• Involved in Data Staging process of creating and testing Informatica mappings and workflows involves in direct Dumping into Database Stage 1 and basic filtering and cleansing of data.
• Expertise in Inforamtica Data Quality (IDQ) tool installation and Standardization, Address Validation and Deduplication.
• Expertise in Informatica Data Services involved in building reusable logical data objects based on the business requirements.
• Involved in production support, resolving the production job failures, interacting with the operations support group for resuming the failed jobs.
• Experience in working with sales operations team for analyzing and optimizing data from Third party vendors.
• Experience in UNIX shell scripting, Perl scripting and automation of ETL Processes.
• Prepared user requirement documentation for mapping and additional functionality.
• With both On-site and Off-shore experience have developed skills in system analysis, troubleshooting, debugging, deployment, Team management, prioritizing tasks and customer handling.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1/9.5/9.1/8.6/7. x/6.x, Sales Force, Informatica Cloud, Informatica Power Exchange 5.1/4.7/1.7, Power Analyzer 3.5, Informatica Power Connect and Metadata Manager, Informatica Data Quality (IDQ), Informatica Data Services (IDS).

Databases: Oracle11g/10g/9i/8i/8.0/7.x, Teradata13, DB2 UDB 8.1, MS SQLServer 2008/2005, Netezaa 4.0, Sybase ASE 12.5.3/15 and SSIS.

Operating Systems: UNIX (Sun-Solaris, HP-UX), Windows NT/XP/Vista, MSDOS

Programming: SQL, SQL-Plus, PL/SQL, UNIX Shell Scripting

Reporting Tools: Business ObjectsXIR 2/6.5/5.0/5.1, Cognos Impromptu 7.0/6.0/5.0, Informatica Analytics Delivery Platform, MicroStrategy.

Modeling Tools: Erwin 4.1 and MS Visio

Other Tools: SQL Navigator, Rapid SQL for DB2, Quest Toad for Oracle, SQL Developer 1.5.1, Autosys, Telnet, MS SharePoint, Mercury Quality center, Tivoli Job Scheduling Console, JIRA, Toad for Data Analyst, Business Objects

Methodologies: Ralph Kimball.

PROFESSIONAL EXPERIENCE

Confidential, Tampa - FL

Sr. Informatica Developer

Responsibilities:

• Good proficiency in Informatica Data Quality 9.5.1/9.6.1 and Informatica power center 9.x/8.x/7.xs.
• Extensively used ETL to load data using Power Center from source systems like Flat Files into staging tables and load the data into the target database Oracle. Analyzed the existing systems and made a Feasibility Study.
• Involved in full software development lifecycle from the throughout the development and support finance industry using Informatica Power Center, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Experience in ETL processes utilizing Informatica Power center tools to design data conversions from a variety of relational, XML and flat file source systems to data warehouse/data marts.
• Strong in implementation of data profiling, creating score cards, Creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
• Worked with Informatica Data Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities using IDQ 9.6.1.
• Wrote and ran different type of SQL queries, including create/insert/update on given databases
• Expertise in developing Interfaces, Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX/Windows environment.
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Implementing and maintaining data quality solutions using SSIS, TSQL, .Net CRL, and a rules engine.
• Experience in Performance tuning & Optimization of SQL statements using SQL trace
• Involved in Unit, System integration, User Acceptance Testing of Mapping.
• Familiar with Agile software methodologies (scrum).
• Supported the process steps under development, test and production environment.

Environment: Informatica Power Center 9.6.1/9.5.1, IDQ 9.6.1, SQL, Teradata, Oracle 11g/10g, Control-M, clear case, Tivoli Job Scheduler, Informatica Data Services(IDS).

Confidential, Columbus - OH

Sr. Informatica Developer

Responsibilities:

• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Extracted data from relational databases DB2, Oracle and Flat Files.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into DataMart, Enterprise Data warehouse (EDW) and Operational data store (ODS).
• Developed data Mappings, Transformations between source systems and warehouse
• Performed Type1 and Type2 mappings.
• Excellent in working on SSIS, SSAS, SSRS, OLAP, OLTP, Reporting and Analytics, Data Cleansing, Data Scrubbing, Data Migration and writing PL/SQL.
• Expertise in developing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Experience in profiling the data and performed Proof of Concept for Informatica Data Quality (IDQ)
• Used Power Center Data Masking Options (Random Masking, Blurring, SSN, and Credit Card) in mappings.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Cleanse and Scrub the Data in uniform data type and format applying MDM Informatica and IDQ tools and Load to STAGE and HUB tables and then to the EDW and Finally to Dimension and rollup/aggregate the data by the business grains into the FACT tables.
• Performing Unit testing and tuned the mappings for the better performance.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data).
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.

Environment: Informatica Center 9.6.1/9.5.1, Power Exchange, Microsoft SQL Server Integration Services (SSIS), SQL, Teradata, UNIX shell scripting, Oracle 11i, SQL, PL/SQL, TOAD, SQL SERVER 2005/2008, XML, T-SQL, Shell Scripts, SQL Navigator, Rational Suite, Business Objects XI R2

Confidential, Schaumburg, IL

Informatica Developer

Responsibilities:

• Developed mappings in Power center for Job Monitoring and Data Validation.
• Strong expertise in installing and configuring the core Informatica MDM components (Informatica MDM Hub Server, Hub Cleanse, Resource Kit and Cleanse Adaptors like Address Doctor)
• Defined, configured and optimized various MDM processes including landing, staging, base objects, foreign-key relationships, lookups, query groups, queries/custom queries, cleanse functions, batch groups and packages using Informatica MDM Hub console.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL specifications.
• Coordinated and worked closely with legal, clients, third-party vendors, architects, DBA’s, operations and business units to build and deploy.
• Used various transforms in SSIS to load data from flat files and Excel files to the SQL databases.
• Collaborating with Business Analysts by providing analysis, consultation, coding, testing and documentation in accordance with the specification and target completion dates.
• Developed different mapping logic using various transformations to extract data from different sources like flat files, IBM MQ series, Oracle, IBM DB2 UDB 8 databases that were hosted on HP UX 11i v2 RISC server.
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, SQL, Update strategy, Salesforce Lookup and Sequence generator.
• Actively implemented Informatica performance tuning by identifying and removing the bottlenecks and optimized session performance by tuning complex mappings
• Documented Informatica mappings, design and validation rules.
• Extensively involved in unit testing, integration testing and system testing of the mappings and writing Unit and System Test Plan.
• Migrated objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Supported the process steps under development, test and production environment.

Environment: Informatica Power Center 9.1.0/8.6.1, Sales force, JIRA, SQL Server 2008, Toad, AQL, SQL Developer, MS Access, Clear Quest, Autosys Job Scheduler, UNIX, IDS Informatica Data Services IDS, Trivoli.

Confidential, Windsor, CT

Sr. Informatica Developer / ETL Analyst

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs document for all the mappings.
• Worked on Informatica Power Center tool - Source Analyzer, Target designer, Mapping & Mapplet Designer and Transformation Designer.
• Resolved issues that cause the production jobs to fail by analyzing the ETL code and log files created by the failed jobs on the Informatica server.
• Used Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Worked on slowly changing dimension tables data.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Stored Procedure, dynamic Lookup and Router transformations for populating target oracle tables in efficient manner
• Tuning Informatica Mappings and Sessions for optimum performance

Environment: Informatica Power Center 8.6, Oracle 10g/9i, SQL, TOAD For Data Analyst, Business Objects 6.5/XIR2, UNIX, TOAD, PVCS, Unix, Tera Data, Meta Data Management MDM.

Confidential

ETL Developer

Responsibilities:

• Documented Informatica mappings, design and validation rules.
• Developed different mapping logic using various transformations to extract data from different sources like flat files, IBM MQ series, Oracle
• Created Sessions and Workflows to load data from the IBM DB2 UDB 8 databases that were hosted on HP UX 11i RISC server
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Actively implemented Informatica performance tuning by identifying and removing the bottlenecks and optimized session performance by tuning complex mappings
• Extensively involved in unit testing, integration testing and system testing of the mappings and writing Unit and System Test Plan.
• Migrated objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Involved in production support, resolving the production job failures, interacting with the operations support group for resuming the failed jobs.

Environment: Informatica Power Center 8.1, Autosys 4.5, HP-UNIX 11i, Oracle 10g/ 9i, IBM DB2 8.5, MQ Series, VSAM files UDB 8, Toad for Oracle, Business Objects.