SUMMARY

• Over 9+ years of experience wif ETL tools Informatica Power Center 9x/8x/7x and DataStage 8x/7x
• Extensive Database experience using Teradata 13.xx/14.xx, Oracle 11g/10g/9i, SQL Server, DB2, Sybase Strong Experience on database interfaces like TSQL, PL/SQL Developer, SQL Plus and TOAD.
• Experience in interacting wif Business Users to gather Business Requirement Specifications (BRS) and Prepare Technical Specifications
• Extensive experience of Data Modeling, Data Conversions, Data integration and Data Migration wif specialization in Informatica Power Center.
• Experience in complete Software Development Life cycle (SDLC) including Requirement, Analysis, estimations, Design, Development, Unit and System Testing and implementation
• Extensive experience in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, scheduling workflows and sessions.
• Expert in Extraction of data from multiple sources, such as, flat files, RDBMS tables from legacy systems into Data Warehouse.
• Experience in developing varied data transformation logic like Unconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc
• Expert on Slowly Changing Dimensions for inserting and updating Target tables for maintaining teh history.
• Extensive experience in Performance Tuning of targets, mappings and sessions, coordinating wif DBAs and UNIX Administrator for ETL tuning
• Developed Complex database objects like View, Macros, Stored Procedures, Functions, and Triggers using TSQL and PL/SQL.
• Worked wif various Teradata Utilities like Bteq, FLoad, FExport, MLoad, TPump and Teradata Parallel Transporter
• Involved in Performance tuning in Teradata using explain plan
• Good Knowledge of UNIX Shell scripting for better handling of incoming source files such as moving files from one directory to another directory and extracting information from teh log files on Linux server.
• Experience on post - session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing teh file name to reflect teh file generated date etc.
• Experience on Data Migration, Data Conversion, Data Processing, Data Cleansing, Data Validation and Data Archiving Process.
• Extensive experience in migration mapping, sessions and workflows from Development to UAT and from UAT to Production using informatica Repository manager
• Worked wif Business Intelligence team in generating variety of printed reports using OBIEE, Business Objects, & Cognos,
• Willing to learn and adapt to new concepts and challenges, both technical and business related and utilize as needed. Excellent analytical, troubleshooting, communication and interpersonal skills, wif ability to interact wif individuals at all levels Good team player wif dedicated work ethics

TECHNICAL SKILLS

DW/ETL Tools: Informatica Power Center 9x/8x/7x, IBM DataStage 8x/7x

Databases: Teradata 13.xx/14.xx, ORACLE 11g/10g/9i, SQL Server 2008/2005/2000 , IBM DB2, Teradata, MySQL, MS Access, Sybase

Data Modeling: Physical/Logical/Relational/Dimensional Modeling, Star/Snow-Flake schema, FACT, Dimensions, Entities, Attributes, Cardinality, ER Diagrams, salesforce.com, ER win

Functional/Business/Data Analysis: Requirements Gathering, User Interviews, Process/Data Flow Diagrams, MS Project, Business Requirements Analysis

Reporting & BI/OLAP: OBIEE, Business Objects, Cognos, Crystal Reports, Actuate

Languages: SQL, PL/SQL, Perl, UNIX Shell Scripting, C, C++, JAVA

Operating Systems: MS-DOS, Windows 8/7/Vista/XP/2003/2000/NT, Linux, UNIX, AIX, Sun Solaris

Web Technologies: HTML, XML, DHTML, PHP

Others: TOAD, Teradata SQL Assistant, I series navigator, CMS Supervisor, MS Office, Autosys, DAC 7/8 x, SQL*Loader, Fast-Load, Multi-Load

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Sr. ETL/ Informatica Developer

Responsibilities:

• Interacted wif various business people, gathered teh business requirements, translated them into technical design specifications/documents, and created HLD/LLD documents of all teh business processes dat helped technical team in understanding.
• Source to Target Mapping and DLD documentation
• Extensively designed, developed, tested complex Informatica mappings, Mapplets and to extract data from external flat files, XML files, Oracle tables.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for teh delta process to extract only teh additional data added during dat period.
• Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Worked wif mappings to dynamically generate parameter files used by other mappings.
• Involved in performance tuning of teh ETL process by addressing various performance issues at teh extraction and transformation stages
• Extensively wrote Unix shell scripts to call Informatica jobs from Tidal and involved in design, develop and monitor Tidal jobs.

Environment: Informatica Power Center 9.5.0, Sql Developer, MS Sql, Unix, Autosys .

Confidential, Richmond, VA

Role: Sr. ETL/Teradata Developer

Responsibilities:

• Interacted wif various business people, gathered teh business requirements, translated them into technical design specifications/documents, and created HLD/LLD documents of all teh business processes dat helped technical team in understanding.
• Source to Target Mapping and DLD documentation
• As Part of teh New Reporting Changes, Modified teh existing DDL changes and INFA WF’S by standardizing them to new Confidential standards.
• Worked wif data analysts / business analysts to implement Teradata views, stored procedures, Informatica mappings / workflows and shell scripts to meet business requirements
• Extensively designed, developed, tested complex Informatica mappings, Mapplets and to extract data from external flat files, XML files, Teradata tables.
• Extensively designed, developed, tested complex Fastload, Fexport and Tpt scripts to extract data from Teradata tables (using shell scripts and Informatica components)
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for teh delta process to extract only teh additional data added during dat period.
• Extensively used BTEQ scripts to move data from Staging layer to Base and Summary Layers wif in Teradata system.
• Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Worked wif mappings to dynamically generate parameter files used by other mappings.
• Involved in performance tuning of teh ETL process by addressing various performance issues at teh extraction and transformation stages
• Extensively worked on Teradata performance tuning of developed load jobs
• Extensively wrote Unix shell scripts to call Informatica jobs from Tidal and involved in design, develop and monitor Tidal jobs.
• Strong knowledge on fine tuning SQL statements using Teradata Explain plan, Teradata Visual explain plan utilities.
• Extensively used UNIX Shell to call BTEQ scripts to process exceptions handling, Post processing clean and database maintenance (Define/Refresh Index and join stats)

Environment: Informatica Power Center 9.1.0, Teradata 14.10 SQL Assistance, Fast LOAD, Multi LOAD, UNIX, Rational Clear Case, CAT (Code Assessment Tracker) .

Confidential, Bellevue, WA

Sr. ETL Developer

Responsibilities:

• Interacted wif various business people, gathered teh business requirements, translated them into technical design specifications/documents, and created HLD/LLD documents of all teh business processes dat helped technical team in understanding.
• Responsible for creating ICDs, Source to Target Mapping and DLD documentation
• Worked wif data analysts / business analysts to implement Teradata views, stored procedures, Informatica mappings / workflows and shell scripts to meet business requirements
• Extensively designed, developed, tested complex Informatica mappings, Mapplets and to extract data from external flat files, XML files, Teradata, Oracle tables.
• Extensively designed, developed, tested complex Fload, Fexport and Tpt scripts to extract data from Teradata tables (using shell scripts and Informatica components)
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for teh delta process to extract only teh additional data added during dat period.
• Extensively used BTEQ scripts to move data from Staging layer to Base and Summary Layers wif in Teradata system.
• Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Worked wif mappings to dynamically generate parameter files used by other mappings.
• Involved in performance tuning of teh ETL process by addressing various performance issues at teh extraction and transformation stages
• Extensively worked on Teradata performance tuning of developed load jobs
• Extensively wrote Unix shell scripts to call Informatica jobs from Tidal and involved in design, develop and monitor Tidal jobs.
• Strong knowledge on fine tuning SQL statements using Teradata Explain plan, Teradata Visual explain plan utilities.
• Extensively used UNIX Shell to call BTEQ scripts to process exceptions handling, Post processing clean and database maintenance (Define/Refresh Index and join stats)

Environment: Informatica Power Center 9.1.0, Teradata 14.10, TOAD 10.6, TSQL, ORACLE 11g, UNIX, MS SQL Server & HP Quality Center

Confidential, Houston, TX

Sr. ETL/Informatica Developer

Responsibilities:

• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources
• Developed and Maintained appropriate documentation for all Designs solutions
• Interacted wif Data Modelers and Business Analysts to understand teh requirements and teh impact of teh ETL on teh business
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of teh workflow.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in teh Target
• Implemented slowly changing dimensions (SCD) for some of teh Tables as per user requirement
• Attending Meetings wif Business Users to develop/modify system specifications when needed
• Worked along wif UNIX team for writing UNIX shell scripts to customize teh server scheduling jobs
• Created Test Cases, Test plans and Documented Steps for Data validation of EDW against Source DB Validated EDW Data by pulling reports using SQL queries
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance
• Provided Assistance wif quick and Innovative recommendations wif some guidance to various development and support initiatives
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables
• Supervised development, test and production implementation phases of teh project
• Lead / coordinate offshore Development and Test teams

Environment: Informatica Power Center 8.6.1, Taradata, PL/SQL, Oracle 10g, TOAD, Shell Scripts, SQL * Loader, UNIX scripting.

Confidential

Sr. Informatica Developer

Responsibilities:

• Coordinating wif Business Owners for gathering user requirements, designing technical and functional specifications
• Creating ER diagrams & maintaining corresponding documentation for corporate data dictionary wif all teh attributes, table names and constraints
• Developing Logical and Physical data models dat capture complete flow of data using Erwin 4.1
• Maintain Development, Test and Production mapping migration Using Repository Manager
• Involved in enhancements and maintenance activities of teh data warehouse including performance tuning
• Worked in 5 complete software development life cycles (SDLC) of Iterative Model
• Used autosys for scheduling teh jobs
• Involving in preparation of design, support and release documents Documenting teh mapping processes and methodologies used to facilitate future developments
• Extensively working wif Mapping Parameters, Variables & Parameter files in teh Mapping Designer; workflows wif sessions, worklets, event waits, assignments, conditional flows, email and command tasks in Work Flow Manager and Monitored teh performance of teh session through Task View in Work Flow Monitor
• Creating reports through SPs (PL\SQL Stored Procedures) to monitor teh status of teh entire load process using Informatica Tables & views
• Coding teh critical source systems in ODS using Slowly Changing Dimension (SCD type II)
• Proficient in Performance Tuning, Troubleshoot of sources, targets, Power Center transformations and sessions using techniques like Explain plans, Oracle hints, changing session parameters, re-designing teh mappings, using test loads & performance stats
• Designing and developing complex Reports in BO using objects like multiple groupings, drilldowns, parameter fields, formulae, conditional formatting, prompts, advanced features like report objects, dash boards and inter-report communication
• Testing (Unit, System, Integration & User Acceptance Test) teh code according to Client Specifications wif teh intent of rectifying Bugs and logging them in Test Director 8.0
• Written UNIX shell scripts for pre and post session tasks, start/stop Informatica services and job scheduling

Environment: Informatica Power Center 8.1, SQL server 2005, Oracle-10g, DB2 UDB 8.0, PL/SQL, Flat Files (fixed width, delimited, XML), UNIX Shell Scripting, Business Objects 6.5 (BO), TOAD 4.0, Autosys 3.1.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Developed various Mappings wif teh collection of all Sources, Targets, and Transformations using Designer
• Worked extensively wif mappings using expressions, aggregators, filters, lookup and stored procedures transformations
• Extensively used Server Manager for creating and scheduling various sessions
• Developed Shell Scripts (Korn & Bourne) to run batch jobs
• Created Shortcuts to reuse objects across folders wifout creating multiple objects in teh repository
• Applied performance-tuning logic to optimize session performance
• Developed PL/SQL Stored Procedures to check teh status of teh target database before moving records into it
• Taking teh Backup of Repository on regular intervals depending on teh amount of work done
• Worked as a team member for design and development of Sales Data Mart and integrating it wif Global Data Warehouse.

Environment: Informatica Power Center 7.1, Business Objects, Oracle 9i, Flat Files, SQL, Oracle Tools, PERL, and SunOS Release 5.8

Confidential

SQL Developer

Responsibilities:

• Created and maintained Windows NT user profiles
• Installed and configured MS SQL Server 7.0 on NT machines
• Created and managed tables, functions, indexes using T-SQL in development and Production environment
• Created stored procedures and triggers using T-SQL in Query Analyzer
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins
• Responsible for setting up teh monitoring performance counters and alerts on Windows NT for SQL Server database

Environment: MS SQL Server 7.0, T-SQL, and Windows NT 4.0