PROFESSIONAL SUMMARY:

• Have been in IT since 2004 and having 9 plus years of IT experience in Analysis, Design, Development and Implementation of various EAI (Enterprise Application Integration), EDW (Enterprise Data warehouse) projects using ETL processing tool Informatica7.x,8.x,9.x in various domains like Banking, Insurance and Retail. Experience in OLAP reporting tool Business objectsXIR3. Team Player with excellent communication, analytical, verbal and writing skills.
• Currently working as ETL Informatica Lead and Developer.
• Extensive experience in Data Warehousing projects in Collecting Client requirements, Data modeling and Development experience in ETL tool informatica7.x,8x Designer, Work flow manager, Work flow monitor, Repository manager, Power Exchange navigator and experience with BI OLAP tool BOXIR3,webi reports .
• Ability to work in teams as well as individually, quick learner and able to meet deadlines
• Hands on experience in developing SCD type 1/2/3 mappings
• Proficient in understanding business processes, requirements and translating them into technical requirements and test strategies. Extensive experience working with business users, SMEs, App DBAs, ETL admins, Prod support team as well as senior management.
• Have experience in relational and dimensional data modeling for creating Logical and Physical Design of Database and ER Diagrams. Worked in security implementation based on roles.
• Strong in Data warehousing concepts Fact table, dimension table, star and snowflakes schema methodologies.
• Have experience with scheduling tool Control - M for creating, scheduling and ordering jobs.
• Experienced in writing oracle Sql queries and Pl/Sql procedures, functions packages, Materialized Views and performance tuning.
• Worked for a while on BOXI webi, crystal reports and universe(Dimensional modeling) to present data to end users.
• Good Knowledge on UNIX Shell Scripting and scheduling using crontab & Control-M
• Experience in IBM info sphere Change data capture(CDC) tool, mapping tables from different sources like DB2,SQL server to oracle ODS of large volumes greater than 100 TB.
• Experience in SQL analysis services cubes. Prepared DB naming standard documents for tables, columns, indexes, views, access information, data mapping sheets with cardinalities and coordination with DBAs to get DB changes done and had created physical model.
• Knowledge in Installation & Configuration like Informatica,BoxiR2 and Oracle.
• Had performed informatica admin activities like installation, configuration of repository, integration services, back up of repositories, creating folders, migration of code and granting role access to users/groups to appropriate data maps by using admin console and repository manager.
• Good overview of production support procedures and change management.
• Diverse background with fast Learning and creative Analytical abilities with good Technical, Problem Solving, Communication and Interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1, 8.x, 7.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Administration Console), Power Exchange.

RDBMS: Oracle11g / 10g / 9i, SQL Server 2000/2005, DB2, Teradata

Operating System: UNIX, Windows NT/2000/XP/7

Job Scheduling Tools: Control-M

Languages: SQL, PL/SQL

Tools: IBM CDC, MS Office, TOAD, Winscp, Putty, Squirrel, File zilla

Products: IBM CDC(Change Data capture), SVN Subversion

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

ETL Lead& Developer

Responsibilities:

• Team Lead & Developer and interacting with Business Analyst to understand the business requirements. Involved in analyzing requirements to refine transformations .
• Enterprise Application Integration (EAI) is an integration framework composed of a collection of technologies and services which form amiddlewareto enable integration of systems and applications across the enterprise. EAI group is responsible for exchange of data among internal departments .
• Informatica acts as EAI Hub that performs the business logic to transform the data into a common business language. Transformation applies in layers from incoming specific, to shared, to outgoing specific
• Analysis of the specifications provided by the clients.
• Preparation of HLD, project plan based on the business functional spec.
• Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
• Extracting data from sources like Oracle and Flat Files using Power center designer transforming them using the business logic and loading the data to the target Data mart.
• Designing mappings as per the business requirements using Transformations such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc.
• Fine tuning mappings, partitioning sessions, Push down optimization to improve performance
• Coordinating with business and development teams for closure of UAT defects and enhancing BO universe for end user reporting.
• Refreshing Materialized views.
• Helping the team in fixing the technical issues if any and Tuning of Database queries for better performance.

Confidential, Chicago, IL

ETL Lead & Developer

Responsibilities:

• Team Lead and interacting with Business Analyst to understand the business requirements. Involved in analyzing requirements to refine transformations.

  Analysis of the specifications provided by the clients.

• Preparation of HLD, project plan based on the business functional spec.
• Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
• Analysis of Data model to check table constraints and columns in Data mart
• Extracting data from sources like Oracle, Mainframe Db2 and Flat Files using Power center designer and power exchange and transforming them using the business logic and loading the data to the target warehouse.
• Designing mappings as per the business requirements Using Transformations such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc.
• Coordination of system/Integration/UAT testing with other teams involved in project and review of test strategy
• Used complex data transformations with more than 50 transformations for each mapping.
• Fine tuning mappings, partitioning sessions, Push down optimization to improve performance
• Coordinating with business and development teams for closure of UAT defects and creating adhoc reports for end users.
• Involved in Universes design& development discussing joins, cardinality between tables, creation of conditions with prompts, derived tables, applying contexts and alias tables to resolve cyclic dependencies like Loops, Fan Traps and Chasm Traps
• Analyze and validate reported data on ad-hoc basis.
• Monitoring and adding tables in CDC for RCT and TAP ODS systems using Data mirroring and refresh methods.
• Helping the team in fixing the technical issues if any and Tuning of Database queries for better performance.
• Keep tracking of all CI list, maintaining versions and Change requests.

Confidential

ETL Lead& Analyst

Responsibilities:

• Tech Lead and interacting with Business Analyst to understand the business requirements. Involved in analyzing requirements to refine transformations.
• Designing and developing exception handling and Preparation of technical specification documentation
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Using designer to create source definitions, design targets, create mappings and develop transformations.
• Involved in Data profiling and data quality team work.
• Created different transformations for loading the data into oracle database e.g. Source Qualifier, Joiner transformations, Update Strategy, Lookup transformations, Filter, Rank transformations, Expression, Aggregator, and Sequence Generator.
• Responsible for monitoring all the sessions that are scheduled for run, investigation of failed session and debugging the corresponding mappings
• Created sessions using Informatica power centre workflow manager.
• Involved in Unit Testing and prepared Test Cases
• Worked on SQL performance tuning to fix slow running BO reports

Confidential

Analyst & Developer

Responsibilities:

• Developed various mappings for extracting data from various sources involving flat files and relational tables.
• Using designer to create source definitions, design targets, create mappings, sessions and developing transformations.
• Created different transformations for loading the data into stage and main schemas of oracle database using Source Qualifier, Joiner transformations, Update Strategy, Lookup transformations, Filter, Rank transformations, Expression, Aggregator, and Sequence Generator.
• Responsible for monitoring all the sessions that are scheduled and re running the failed sessions after debug the Mapping.
• Used Mapplets, Parameters and Variables to implement Object Orientation techniques and facilitate the reusability of code.
• Preparation of Unit Test Case and unit testing
• Keep track of status of ETL jobs responsible for hyperion report data.
• Preparation of low level design document

Confidential

 Analyst &Developer

Responsibilities:

• Analysis of the specifications provided by the clients
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Using designer to create source definitions, design targets, create mappings, sessions and developing transformations and created data maps in power exchange navigator
• Created different transformations for loading the data into oracle database e.g. Source Qualifier, Joiner transformations, Update Strategy, Lookup transformations, Filter, Rank transformations, Expression, Aggregator, and Sequence Generator.
• Implemented SCD type 2.
• Responsible for monitoring all the sessions that are scheduled and re running the failed sessions after debug the Mapping
• Developed and executed UNIX scripts as pre/post-session commands to schedule loads, through SQL-loader utility
• Involved in Unit Testing and prepared Test Case
• Involved in Performance tuning and testing at mapping level.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.