SUMMARY:

• Over Eight (8+) years of IT experience with strong background in Database development and Data warehousing and ETL process using Informatica PowerCenter 9.x/8.x/ 7.1.3/7.1.1/6.2. Repository Manager, Repository Server, Workflow Manager & Workflow Monitor.
• Solid experience in Informatica PowerCenter (versions 9.x/8.x/7.x/6.x), Mappings, Mapplets, Transformations, Workflow Manager, Workflow Monitor, Repository Manager, Slowly Changing Dimensions( Type 1, Type 2 and Type 3), OLTP, OLAP
• Expert in developing complex mappings using varied transformations like Unconnected and Connected lookups, Active Lookups, Expression, Filter, Source Qualifier, Union, Router, Aggregator, Sorter, Rank, Joiner, Normalizer and Update Strategy transformations.
• Experience in Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2 and XML Files.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
• Expertise in Relational databases design and development concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, Cursors, Stored Procedures, Functions and Triggers.
• Good experience in all phases of software development life cycle (SDLC) including system design, development, integration, testing, deployment and delivery of applications.
• Experience in Agile Methodologies.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables using ERWIN
• Good working knowledge on Teradata components such as FLOAD, MLOAD, BTEQ and Fast Export.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Experience working on scheduling tools - Control-M, AutoSys, Tidal.
• Exposure to Oracle Business Intelligence Suite (OBIEE).
• Skilled in applying various forms of testing to ensure product quality including: Unit Testing, Integration Testing and Quality Assurance Testing.
• Ability to fix issues and performed troubleshooting and root-cause analysis follow-ups.
• Self-motivated with strong problem solving, analytical, interpersonal skills, and communication skills and have the ability to work both independently and as a team at all levels.

TECHNICAL SKILLS:

Operating Systems: Windows XP/2000/NT/98/95, Windows 7, UNIX, LINUX, MAC OS, Virtual Platforms Parallels

ETL Tools: Informatica 9.x/8.x,7.x,Data Quality(IDQ),SSIS

Data Modelling Tools: MS Visio, ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-InmonMethodology, Star Schema, Snow

Methodologies: Flake Schema, Extended Star SchemaPhysical &Logical Modeling

Programming: PL/SQL, SQL, T-SQL, XML, Perl, C/C++, HTML, CSS

Databases: Oracle 11g/10g/9i, Teradata, DB2, MS SQL Server 2005/2008, MS Access, MS Excel

Tools &Utilities: TOAD, SQL Developer, SQL*Loader,Putty

Scheduler: AutoSys, Control-M, Informatica Scheduler

PROFESSIONAL EXPERIENCE:

Confidential, IL

Informatica Developer

Responsibilities:

• Worked with Business analysts and the DBA’s for gathering requirements and for project coordination.
• Analyzing the client requirement, performing the feasibility study, performing the impact analysis, prepares the high and low level design documents, and prepares detailed technical design document.
• Used Informatica PowerCenter Workflow Manager for session management, database connection management and scheduling of jobs
• In creating complex mappings, extensively used transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure.
• Created reusable transformations and mappings by using mapping designer, transformation developer in Informatica Power Center and used them in mappings.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Involved in building the ETL Source to Target mapping to load data into Data warehouse and created mapping documents to outline data flow from sources to targets.
• Developing Informatica Mappings and Workflows, Preparation of Unit Test Case and Unit Test Data and data validation.
• Follows up with the respective POC’s for the environment issues/defects and for the resolution of the defects.
• Data cleansing in the source and load into staging tables for each data conversion.
• Developed Mapplets Using IDQ Tools in creating Profiles and generated Profiling Reports for concerned Data.
• Documented various Data Quality mapping document.
• Used SQL Assistant to querying Teradata tables.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle
• Scheduled Informatica and Teradata jobs in production using AutoSys scheduling tool.
• Involved in Profiling activities for the column assessment, data inconsistency and natural key study
• Created data trace map and data quality mapping documents
• Performed as Data Analyst by gathering data from different sources, data profiling, data definition, and loaded those data on business warehouse
• Extensively used SQL*Loader to load data from flat files to database tables in Oracle.
• Strong work experience in setting up and leading design, development and production support teams.
• Responsible for writing Unix Shell Scripts to schedule the jobs.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Resolved long standing problem areas on this project

Environment: Informatica PowerCenter 9.1 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), IDQ 9.6.1, SQL Assistant, SSIS,Oracle 11g/10g, SQL Server 2008, TOAD 6.0, SQL, UNIX, Windows 7, AutoSys

Sr. Informatica/Teradata Developer

Responsibilities:

• Involved in design of database and created Data marts extensively using Star Schema.
• Worked extensively on SQL, PL/SQL, and UNIX shell scripting.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Involved in developing packages for implementing business logic through procedures and functions.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Generating Email Notifications through scripts that run in the Post session implementations.
• Extensively involved in application tuning, SQL tuning, memory tuning and I/O tuning using Explain Plan and SQL trace facilities.
• Creating high level and low level functional specification and Technical specification document for application development.
• Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
• Writing UNIX Shell Scripting for FTP Utility program for transferring files.
• Dimensional data modeling using Data Modeling, Star Join Schema/Snowflake modeling, fact and dimensions tables, physical and logical data modeling using ERWIN data modelling tools.
• Used Teradata Utilities BTEQ, Fast Load, T-pump, Multi Load utilities for loading bulk data
• Extensively used FastExport to export data out of Teradata tables.
• Created BTEQ scripts to invoke various load utilities and queries against Teradata database.
• Created proper PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Enhanced performance of the queries by executing optimization techniques such as index creation, table partition and coding stored procedures.
• Used SQL tools TOAD to run SQL queries and validate the data in warehouse.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Importing & exporting database using SQL Server Integrations Services (SSIS) and Data Transformation Services (DTS Packages).
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Involved in modification of Developed UNIX Shell scripts in Automation of ETL Teradata processes.
• Involved in all the phases of Migration from DTS to SSIS packages.
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Provided troubleshooting support and conduct tests for consistent outputs as per defined needs.

Environment: Informatica Power Center 9.1, Windows-XP (Client), Informatica Data Quality (IDQ), Power Designer, Power Exchange, Work Flows, ETL, Flat Oracle 11g, Teradata, XML, SSIS, Web services, MS SQL Server, TOAD 9.6.1, Unix Shell Scripts, AutoSys

Sr. Informatica ETL Developer

Responsibilities:

• Gathered requirements from the end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Involved in the Data Warehouse Data modeling based on the client requirement.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, Oracle, XML files, SQL Server and load them into Oracle.
• Responsible for creating system design and detail design documents based on the requirement document provided by the business users.
• Provides strategic thinking, leadership pertaining to new ways of leveraging information to improve business processes.
• Involved in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions.
• Based on the logic, developed various Mappings and Mapplets to load data from various sources using different transformations like Source Qualifier, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner in the mapping. Also, developed Error Processing to capture the error records and loads them into Message Log table.
• Worked with Stored Procedure Transformation for time zone conversions.
• Created UNIX scripts to automate the activities like start, stop, and abort the Informatica workflows by using PMCMD command in it.
• Used SSIS tools like import and export wizard, package installation and SSIS package designer.
• Created SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Provided production support including error handling and validation of mappings.
• Addressed and track requests for system enhancements, improvements from end users/customer and resolved production issues.
• Extensively used Debugger Process to modify data and applying Break Points while Session is running.
• Used various Informatica Error handling techniques to debug failed session.
• Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to another Environment.

Environment: Informatica 9.1, UNIX, Windows, Oracle 10g, PL/SQL, MSSQL 2008R2, SQL, Flat Files and CSV, Shell Scripting, SSIS, Putty, PL/SQL, ERWIN

Informatica ETL Developer

Responsibilities:

• Extensively involved in the requirement analysis, development, writing test cases and unit testing.
• Resolving design/development issues and interacting with infrastructure support partners (DBA, Sys Admins).
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Normalizer, Union, Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Extensively used ETL and Informatica to load data from Oracle, MS SQL Server, flat files into the target Oracle 11g database.
• Used Informatica features to implement Type I & II changes in slowly changing dimension (SCD) tables.
• Created and ran workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Testing of Informatica Sessions, Batches and the Target Data.
• Planning and designing the system, writing queries in SQL and PL/SQL.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simple ETL coding and mapping standards.
• Responsible for Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Developed UNIX shell scripts to automate different tasks involved as part of loading process and scheduling and performed Unit Testing on the mappings.
• Involved in Data loading to Oracle based tables and Extracting functions using SQL*Loader.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Resolved long standing problem areas on this project.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, DB2, SQL, PL/SQL, XML, TOAD, MS Access, Windows XP, UNIX