PROFESSIONAL SUMMARY:

• 6+ years of work experience in designing and developing Data warehouse applications with special emphasis on Design and Development of Data Warehousing using Informatica Power Centre 10.1/9.6/9.5/9.1.
• Expert in all phases of Software development life cycle (SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Data Integration from Confidential, SAP, Databases like Oracle, SQL Server, Postgres etc.
• Defined development standards focusing on different types of data load strategies, performance, reusability, parameters, self-healing capability, balancing & controls, reasonability checks, error-handling with proper data lineage and thresholds, and housekeeping.
• Experienced in DB packages, procedures, triggers, views, indexes and partitions.
• Written PL/SQL test cases and performed functional and non-functional testing.
• Extensively worked in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Strong experience with Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer, Workflow Manager/Monitor and Server tools - Informatic Server, Repository Server manager.
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access. Strong knowledge of writing simple and Complex Queries in various databases like Oracle, Teradata, My SQL, DB2 and SQL Server.
• Good experience in creating and using Stored Procedures, Functions, Triggers, Views and packages in Different databases.
• Extensive experience in data profiling, data migration from various legacy sources and relational systems to OLAP and decision support target systems.
• Good knowledge on Informatica IDQ & Informatica Power Exchange. Proficient in Relational Database Management System (RDBMS).
• Having knowledge on Data Integration concepts in large scale implementation environments. Proficiency in developing complex mappings using Informatica and Change data capture (CDC), Data Cleansing, slowly changing dimensions (SCD) types 1&2.
• Database experience using Oracle 11g/10g/9i, MS SQL Server 2000 and MS Access. Having good Knowledge of Informatica administration in windows and Linux environment.
• Practical knowledge of Data warehouse concepts, Data modelling principles - Star Schema, Snowflake, Normalization/De-normalization.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, DB2, flat files into the staging area and Design ETL processes that span multiple projects.
• Experience in working in a Multi-Dimensional Warehouse projects. Experience in reading and loading high-volume Type 2 dimensions by implementing SCD (Slowly Changing Dimensions).
• Expertise in OLTP/OLAP System Study, Understanding E-R modelling and Dimensional Models using Star schema and Snowflake schema techniques.
• Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
• Proficient in creating UNIX Shell Scripts. Excellent communication skills and co-ordination with project managers, business analysts, architects, DBA’s and Developers.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1/9.6/9.5/9.1/8.6/8.1, Informatica Power Exchange 9.1/8.6.

Databases: Oracle 11g/10g/9i, DB2, MS SQL Server (2012, 2008, 2005)

Other Tools: TOAD, MLOAD, TPUMP, Erwin 4.x/3.5/3.x, SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer

Languages: SQL, PL/SQL, UNIX Shell Scripting, Unix Commands, C, C++

Scheduling tools: Autosys, Control-M

Operating Systems: Windows Server 2008/2003, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Windsor, CT

Pl/SQL, Informatica Developer

Responsibilities:

• Worked collaboratively with my Team developers to design, develop and deliver an entire application (i.e interface, ETL, extract, BI app).
• Participated in estimation of project delivery timeline.
• Defined and executed manual test cases which test all aspects of the component under development.
• Increased use of automating testing, developing automated tests for components of an application
• Analyzed specifications and designs, develops, and tests high quality solutions in support of defined business objectives.
• Ensures accuracy and integrity of data and applications through analysis, coding, profiling and problem resolution.
• Troubleshoots application programs and provides timely response; performance-tunes these applications as necessary.
• Identified problems and seeks assistance with solution implementation.
• Provided technical knowledge and subject matter expertise as required. Adheres to detailed deployment plans, schedules, timelines and milestones.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle, SQL Server, Teradata etc.
• Developed data mappings between source systems and target system using Mapping Designer.
• Developed shared folder architecture with reusable Mapplets and Transformations.
• Created batch jobs for Fast Export.
• Prepared Conceptual Solutions and Approach documents and gave Ballpark estimates.
• Design and developed Amazon Redshift databases
• Worked with XML, Flat file connectors.
• Prepared Business Requirement Documents, Software Requirement Analysis and Design Documents (SRD) and Requirement Traceability Matrix for each project workflow based on the information gathered from Solution Business Proposal document.
• Data modelling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Created SSIS ETL packages to get data from different sources like Flat files, MS Excel, MS Access.
• Involved in Migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Responsible for optimization of SQL queries, T-SQL and SSIS Packages.

Environment: PL/SQL, Informatica Power Center 10.1, Oracle 10g, MS SQL SERVER 2000, Teradata, SQL, UNIX Shell Script, Informatica Workflow Manager, Power Center Designer, Oracle 12c.

Confidential, SFO, CA

Informatica Developer

Responsibilities:

• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and to successfully implement business logic.
• Understood the Business point of view to implement coding using Informatica power center designer. Used Informatica Power Center 10.1 for retrieving data from Mainframe system.
• Involved in development of ETL loads and Business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems.
• Debugging invalid mappings using breakpoints, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Identified sources, targets, mappings and sessions and tuned them to improve performance. Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Developed SQL and PL/SQL scripts to validate and load data int interface tables using SQL Loader. Performed strategies for incremental data extraction as well data migration to load data into Teradata.
• Developed ETL programs using Informatica to implement the business requirements. Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensions and Fact tables.
• Utilized Informatica Data Quality (IDQ) for data profiling and matching/removing duplicate data, fixing the bad data, fixing the null values.
• Implemented different Mappings with the collection of all Sources, Targets, and Transformations using Designer.
• Implemented Conceptual, Normalized/Denormalized Logical and Physical data models to design OTLP and Data warehouse environments.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 11g RDBMS in accordance with requirements and specifications.
• Designed and developed mapplets and re-usable transformations and used them in different mappings.
• Experience developing and supporting complex DW transformations. Creating Reusable Transformations and Mapplets in a mapping.
• Expertise in using both connected and unconnected Lookup Transformations. Exported the IDQ Mappings and Mapplet's to power center and automated the scheduling process. Knowledge of data profiling using Informatica Data Quality (IDQ)
• Developed Conceptual, normalized Logical and Physical data models to design OTLP and Data warehouse environments.
• Used ETL process to load data from multiple sources to staging area (Oracle 10g) using Informatica Power Center 10.1 Created Mapplets and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning using Informatica partitioning. Involved in Data Base Tuning. Written UNIX Shell Scripts for various purposes in the project.

Environment: Informatica Power Center 10.1, Oracle 10g, MS SQL SERVER 2000, Teradata, SQL, PL/SQL, SQL*Loader, UNIX Shell Script, Informatica Workflow Manager, Power Center Designer, Oracle 11g.

Confidential, Merrimack, NH

Informatica Developer

Responsibilities:

• Responsible for Internal Delivery of ETL code from Architecture/Design/Development/Testing and Implementation phases.
• Extensively developed various mappings incorporated business logic, which performed Extraction, Transformation and Loading of source data into OLAP schema.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables. Worked on Data Hub configurations - Data modeling & Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director (IDD).
• Involved in the development of Informatica mappings and Mapplets and tuned them for optimum performance, Dependencies and Batch Design.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked on PPM related requirements & providing solutions for issues related with same which covers activities like: requirement analysis, ETL designing, scheduling workflows and providing Maintenance, Enhancement & Support to the Client.
• Involved in implementing the Land Process of loading the customer data set into informatica from various source system.
• Knowledge of Identifying Facts and Dimensions tables. Involved in understanding of Business Processes, identification of dimensions and measures for OLAP applications.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions and packages.
• Extensively worked on developing and debugging Informatica mappings, Mapplets, sessions and workflows. Experienced with creating Unit Test Cases for mapping and code reviews.
• Loading data from different sources like relational Tables and Flat Files to Target Data warehouse. Used Slowly Changing Dimensions (SCD 1 and SCD 2) techniques to load the conformed dimensions.
• Worked with various Informatica client tools like Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.

Environment: Informatica Power Centre 9.5/9.5, Work Flows, ETL, Oracle 11g, Teradata, XML, SSRS, MS SQL Server, Flat Files, ETL, PL/SQL, SSOracle, Excel source files, XML files, Unix Shell Scripts.

Confidential

Informatica Developer

Responsibilities:

• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Responsible for Impact Analysis, upstream/downstream impacts. 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 the Teradata using Teradata Utilities.
• Worked on Informatica- Source Analyzer, 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.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets. Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Successfully upgraded Informatica 9.1 and to 9.5 and responsible for validating objects in new version of Informatica.
• Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Integrated the data into centralized location. Used migration, redesign and Evaluation approaches. Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Tuned the performance of mappings by following Informatica best practices and applied several methods to get best performance by decreasing the run time of workflows.
• Scheduling Informatica jobs and implementing dependencies if necessary using Autosys. Managed post production issues and delivered all assignments/projects within specified time lines.

Environment: Informatica Power Center 9.1/9.5, Oracle 11g, SQL, DB2, Teradata, Flat Files, Erwin, SQL Assistant, Toad, ETL, Autosys, UNIX.

Confidential

SQL Developer

Responsibilities:

• Created/ modified SQL Queries better performance tuning on analyzed existing code for better outcome.
• Performed End-to-End Testing, troubleshooting, debugging, integration testing and performance testing and analyzed the results to justify the validation.
• Works with business analysts to gather and interpret business requirements for multiple financial and healthcare systems including large data warehouses.
• Designs and develops database applications using SQL Server Integration Services, TSQL and Stored Procedures. Developed User Defined Functions and created Views.
• Created Triggers to maintain the Referential Integrity. Implemented Exceptional Handling. Worked on client requirement and wrote Complex SQL and PL/SQL Queries to generate Reports.
• Collaborates with business analysts, source system experts, and other team members to determine data extraction and transformation requirements.
• Involved in performing database Backup and Recovery. Collaborate with IT operations for support in problem resolution and root cause analysis.
• Supports IT staff and business users in the development, usage and troubleshooting of database-driven applications. Participates in special projects as needed and performs other duties as assigned.

Environment: Oracle 9i, Reports 6i, Forms 6i, SQL* loader, Oracle SQL Developer PL/SQL, SQL*Plus.