SUMMARY

• More TEMPthan 8 years of Strong experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using IBM DataStage 11.5/9.1/8.5/8.1/7.5x2/7.x and Informatica 10.1/9.x/8.x and BODS 4.2 (Business Object Data Services)
• Extensively used Datastage client components like Data stage Designer, Director, and Administrator in Data Warehouse development. Worked with Data Migration, Data Conversion in diverged environment like DB2, Oracle, SQL Server and complex files.
• Extensive experience with Informatica Power Center 10.1,9.x, 8.x and 7.x hosted on UNIX, Linux and Windows platforms and Informatica cloud hosted on UNIX.
• Expertise in OLTP/OLAP database design and development of database schemas like star schema and snowflake schema that are used in relational, dimensional and multidimensional modeling. Implemented SCD’s (Slowly Changing Dimensions) and CDC (CDCChange Data Capture).
• Good understanding of Ralph Kimball and Bill Inman methodologies/approach.
• Involved in Full Life Cycle Development (Waterfall & Agile) of building a Data warehouse on Unix Platforms for Retail, Financial, insurance Industries.
• Proficient in designing and developing complex standard containers using various transformation logics by utilizing teh transformer, filter, joiner, lookup, merge, sort, remove duplicates, aggregator.
• Experienced in developing UNIX shell scripts to automate jobs, Pre - processing of files and checking teh integrity of files.
• Worked on loading of data from several flat files sources to staging using Teradata loading utilities like TPUMP, MLOAD, FLOAD and BTEQ.
• Expertise in creating reusable components such as Shared containers, Local containers and in creating custom transformations, functions and routines.
• Worked on scheduling tools like Crontab and Control-M for automating jobs run.
• Maintained outstanding relationship with Bussiness Analysts and Bussiness Users to identify information as per teh Bussiness Requirement.
• Worked on various transformations like Expression, join, Lookup, Sort, Filter, Aggregator and Mapplets and Reusabe transformations using Informatica Powercenter Designer.
• Having hands on experience in Informatica Power Exchange and Informatica IDQ.
• Expertise in creating databases, users, tables, triggers, views, functions, packages, joins and hash indexes in oracle and Teradata database.
• Worked extensively on Informatica Cloud tool to pull teh data from cloud applications.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills

TECHNICAL SKILLS:

ETL Tools: Data Stage 7.x/8.x/9.x/11.x, Informatica 10.1,9.x/8.x/7.x, BODS 4.2, Talend

Operating Systems: Windows 98/2003/2000/XP/7/NT, Unix, MSDOS

RDBMS: Teradata, DB2, Oracle 11g/10g/9i/8i/8.0, sybase

Data Modeling: Erwin 4.1.4/3.5.2

Data Base Tools: SQL Developer, Toad 4.0.3, MS Visio, MS Access

Reporting Tools: Tableau, OBIEE 10.x/9.x

Scripting: UNIX Shell Scripting

Web Technology: Web Technology HTML, Java script

Languages: SQL, PL/SQL, C, C++, XML

PROFESSIONAL EXPERIENCE

Confidential, Palo alto, CA

ETL Developer(Informatica)

Responsibilities:

• Designing Technical and functional specs based on requirements provided by business and finalizing teh data model.
• Involved in writing mapping specification document (STTM).
• Created ETL documents (ETL Standards, Migration Manual, and Unit Testing) for teh development.
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner.
• Used Parameter files to specify DB Connection parameters for sources.
• Designing and developing complex Informatica mappings including Type-me, Type-II
• Involved in writing Range Partitioning with dates on fact table.
• Involved in writing Stored Procedure to break a string and for truncating teh partitioned tables.
• Extensively worked in teh performance tuning for mappings and ETL procedures both at mapping and session level. Developing, Testing and debugging teh mappings in Informatica.
• Developed workflowtasks like reusable Email, Event wait, Timer, Command, Decision.
• Support and batch monitoring for weekly refresh.

Environment: Informatica PowerCenter 10, Unix, sql Developer, Sybase, salesforce, OBIEE, Oracle 11g

Confidential, Bentonville, Arkansas

Sr. Data Stage Developer

Responsibilities:

• Worked closely with business analysts inrequirements gathering, reviewing business rules and identifying data sources.Worked on analyzing teh systems and gathering of requirements.
• Work with teh project and business teams to understand teh business processes involved in teh solution.
• Created technical design documents by analyzing functional specification documents that are required forETL development.
• Extracted teh data from DB2 database into flat files, performed required transformations and loaded them into DB2 Staging Tables.
• Developed parallel jobs using various stages like sequential file, data set, lookup, filter, funnel, copy, surrogate key generator, column generator, sort, transformer, change data capture.
• Extensively used stage variables for source validations, to capture rejects and used job parametersfor automation of jobs.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used teh datastage director and its run-time engine to monitor teh running jobs.
• Involved in all steps of development and deployment processes.
• As Part of TRIRIGA provided SAP ECC, JDE Extracts to all teh teams using BODS designer and scheduling teh jobs weekly/bi-weekly using data service management console.

Environment:IBM Data Stage 11.5/9.1, BODS (Data Services Designer) 4.2, Netezza, My SQL Server, File Zilla, UNIX Shell Scripts, Flat Files, BODS 4.2.

Confidential, Hoobken NJ

Informatica Developer

Responsibilities:

• Designing Technical and functional specs based on requirements provided by business and finalizing teh data model.
• Involved in writing mapping specification document (STTM).
• Created ETL documents (ETL Standards, Migration Manual, and Unit Testing) for teh development.
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner.
• Used Parameter files to specify DB Connection parameters for sources.
• Worked on teh installation and setup ETL (Informatica Cloud) applications on Linux servers.
• Designing and developing complex Informatica mappings including Type-me, Type-II
• Involved in writing Range Partitioning with dates on fact table.
• Involved in writing Stored Procedure to break a string and for truncating teh partitioned tables.
• Extensively worked in teh performance tuning for mappings and ETL procedures both at mapping and session level. Developing, Testing and debugging teh mappings in Informatica.
• Developed workflowtasks like reusable Email, Event wait, Timer, Command, Decision.
• Extensively worked in Informatica cloud using DRT(data Replication Tasks) and DST(Data Synchronization Task)
• Support and batch monitoring for weekly refresh.

Environment: Informatica Powercenter 9.1, Informatica cloud, Unix, TOAD, sql Developer, Peoplesoft, Taleo, Citrix, OBIEE, Oracle 11g

Confidential

Sr. Data stage Developer

Responsibilities:

• Worked closely with Business analysts and Business users to understand teh requirements and to build teh technical specifications.
• Involved in all business meetings to understand teh existing logic, different member information and agency data to come up with teh best IT solution.
• Responsible to create Source to Target (STT) mappings.
• Involved in day to day production support activities.
• Worked on various defects raised by teh concerned business teams from various entities.
• Developed and supported teh Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources using DataStageDesigner and to load teh target tables using theDataStageDesigner.
• Worked on various stages like Transformer, Join, Lookup, Sort, Filter, Change Capture and Apply stages,Quality Stage.
• Developed parallel jobs using various Development/debug stages (Peek stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)
• Designed job sequencerto run multiple jobswith dependency and email notifications.
• Involved in Unit Testing, SIT and UAT Worked with teh users in data validations.
• Extensively worked in improving performance of teh jobs by avoiding as many transforms as we can.
• Prepared documentation for unit, integration and final end - to - end testing.
• Optimized/Tuned DS jobs for better performance and efficiency
• Responded to customer needs; self-starter and customer service oriented.
• Worked within teh team to make appropriate, TEMPeffective decisions related to project responsibilities and to initiate and follow-up on assigned tasks without supervision.
• Provided support and guidance by creating Release, Deployment & Operation guide documents.
• Involved in Performance tuning of complex queries.
• Developing SQL scripts to facilitate teh functionality for various modules.
• Created control M jobs for scheduling.

Environment:IBM Infosphere DataStage 8.x (Designer, Director) Oracle 10g, Teradata 13, Sequential files, UNIX Shell Scripting

Confidential

Datastage Developer

Responsibilities:

• Implemented full lifecycle management to capture and migrate various Datastage ETL metadata including data mapping and other data integration artifacts (such as schedulers, scripts, etc.,) across environments including teh establishment of standards, guidelines and best practices.
• Responded to customer needs; self-starter and customer service oriented.
• Experience with ETL Unit and Integration Test creation and verification.
• Worked on various stages like Transformer, Join, Lookup, Sort, Filter, Change Capture and Apply stages, Quality Stage.
• Involved in Unit Testing, SIT and UAT Worked with teh users in data validations.
• Extensively worked in improving performance of teh jobs by avoiding as many transforms as possible.
• Prepared documentation for unit, integration and final end - to - end testing.
• Helped in preparing teh mapping document from source to target.
• Used DataStage stages namely Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Funnel, Row Generator, Remove Duplicates, Copy stages in accomplishing teh ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers, and used notification activity to send email alerts.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Environment:IBM InfoSphereDataStage8.5/7.5, Oracle 10g, Teradata 13, Sequential files, ControlM, UNIX Shell Scripting.