SUMMARY

• Around 8 years of IT work experience at various levels and functions in data warehousing design, development, testing, production and maintenance.
• Demonstrated expertise building complex business rules by creating complex mappings/mapplets, shortcuts, reusable transformation.
• Experience in data analysis, working with data models, ETL designs for relational and dimensional models.
• Managed all phases of ETL development on assigned projects including reviewing technical documentation, allocating ETL development work, conducting design reviews, coordinating packaging and release deployments and testing of solutions in highly complex environments.
• Strong knowledge of ETL development to support data warehouse design using dimensional models on an Oracle platform
• Proficient with Informatica Power Center
• Demonstrated proficiency in improving re - usability, automation of data loads, performance tuning in Informatica and de-bugging/rectification of data load errors
• Created Informatica mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Connected and Unconnected Lookup, Normalizer, Stored Procedure, filter, Sequence generator, Router and Update strategy
• Extensively worked with performance tuning at mapping levels like implementing Active Transformation filter and Update Strategy transformation for implementing inserts and updates.
• Vigorous experience in understanding data models and creating Dimensions and Facts
• Working experience with slowly changing dimensions
• Involved in creating folders and session migration and Repository Administration.
• Extensive experience on deploying Workflow, Session on Grid
• Worked with Business model dimensions, Hierarchies, measures, Aggregation rules, Time Series, Caching and mapping
• Vast experience in error handling and troubleshooting in Informatica
• Experience with data analysis and Dimensional Data Modeling (specific to a data warehouse), Star schema/Snowflake schema, fact and dimension tables
• Experience in database programming with PL/SQL (Stored Procedures, Functions and Triggers)
• Worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Repository Manager
• Create Repository, Users and Groups. Analyze and import the Source definitions. Create target definitions, logical and physical designing of target tables.
• Working experience with complex XML templates in Informatica Data Transformation
• Developed and executed UNIX shell scripts as pre/post-session commands to schedule loads, through SQL-loader utility.
• Proven ability to effectively manage time and resources and prioritize tasks in order to consistently complete projects on time

TECHNICAL SKILLS

Data Warehousing Tools: Informatica Power Center 7.x/8.x/9.X, Change Data Capture (CDC), Repository Server Administrator Console

Databases: Oracle 11g/10g/9i, T-SQL, MS-SQL SERVER 7.0/2005/2008 , Teradata

Data Modeling: Star Schema Modeling, Snowflakes Modeling, FACT and Dimensionstables

Languages: C, C++, Java, XML

GUI Development: Data Transformation Services (DTS), Oracle designer

Database Utilities: TOAD 8.0/7.1, Winsql, SQL*Plus, SQL Developer, PL /SQL

Environment: s: UNIX (Solaris, AIX, HP-UX), LINUX, Windows Server 2003, 2008

Other Tools: MS Visio, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, New York

Sr. ETL Developer

Responsibilities:

• Source to target data mapping, job scheduling, development and testing of Informatica ETL programs.
• Over saw interactions with business users to resolve data questions and anomalies; mentoring of junior staff members; participation in data modeling design sessions, and metadata development.
• Worked extensively across fixed width flat files, handled the null records, exceptional records, space records and gained hands on with data level accuracy.
• Created mappings using various transformations like source qualifier, expression, filter, router, update strategy, lookup, aggregator and sequence generator.
• Generated and routed the data into various target definitions which consists of delimited flat files and table records.
• Used various functions like round, replace and diff kinds of date functions to compare the data elements across the feeds for consistency.
• Worked to improve performance by creating the materialized views and going against those materialized views instead of multiple relational tables.
• Alsodeveloped the ETL job to refresh the materialized views and the source tables on a daily basis.
• Developed UAT testing as requested by the business support team after new patches wereimplemented to enhance the business usage.
• Involved conducting team meetings, providing work plans and status reports

Confidential, NY

Sr.Informatica Developer

Responsibilities:

• Designing and understanding mappings for extracting & loading data to/from heterogeneous sources including Oracle/Sybase/SQL Server/NoSQL databases to optimize data workflows and ensure data quality.
• Responsible for technical design, development, testing, code migration and take ownership of the body of work.
• Designed and created required mappings for consistency check to compare like data elements across the files to assure the consistency of data.
• Created tasks and workflows in the workflow manager and monitored the session properties in the work flow monitor
• Coordinated and managed delivery of interfaces on time with high quality and on budget.
• Transitioned in and retained the technical integration knowledge from external system integrators. Maintained project documentation for integration center of excellence and provide training to developers.
• Worked with business process experts to map integration requirements to ETL code.
• Managed defects, enhancements and new functionality requests to meet changes in systems and business needs.
• Identified and resolved problems with data processing infrastructure, processes, systems & tools and recommend solutions for improvement and standardization
• Performed Data conversion, Quality and Verification activities.

Confidential, TarrytownNY

ETL Developer

Responsibilities:

• Involved in gathering requirements from business users.
• Created users/groups and folders using repository manager.
• Extensively worked with source analyzer, warehouse designer, transformation designer mapping designer and mapplet designer.
• Extracted source data using Informatica tools and stored procedures from source systems.
• Developed transformation logic and designed various complex mappings and mapplets using the designer.
• Designed various mappings using transformations like Look Up, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, and Expression Transformation.
• Used Mapplets, parameters and variables to implement object orientation techniques and facilitate the reusability of code.
• Modify existing programs to confirm to system changes
• Used Workflow Manager to create and run batches for different applications
• Tune the SQL Queries for Performance Issues.

Confidential

Sr. Executive

Responsibilities:

• Analyzed the systems, met with end users and business units in order to define the requirements.
• For Customer system, developed logical & physical data model by defining strategy for Star Schema with Fact & Dimension tables with Detail, Summary, Look-up tables, Indexes and views.
• Used Informatica as the ETL for extracting data from the flat files on UNIX platform and transforming the data according to the target database and performed loading.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookups and stored procedures.
• Creating source, target, lookups, transformation, session, batches and define schedules for those batches and sessions
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Confidential

System Analyst

Responsibilities:

• Responsible for SQL coding using SQL/PLUS.
• Responsible for PL/SQL programming.
• Developed Stored Procedures, functions, triggers, and packages.
• Created primary Database storage structures (Table Spaces) and objects (Tables, Views, and Indexes).
• Managed the Table Spaces, rollback segments and indexes for applications.
• Coded the scripts for loading the data into Oracle Database from flat files using SQL Loader.
• Extensively used all the features of Informatica Versions 6.x and 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.