SUMMARY

• More than 7 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.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 wif Data Migration, Data Conversion in diverged environment like DB2, Oracle, SQL Server and complex files.
• Extensive experience wif Informatica Power Center 10.1,9.x, 8.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 the transformer, filter, joiner, lookup, merge, sort, remove duplicates, aggregator.
• Experienced in developing UNIX shell scripts to automate jobs, Pre - processing of files and checking the integrity of files.
• Good knowledge about Topology, Designer, Operator in Oracle Data Integrator.
• Good Understanding about ODI Architecture.
• 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.
• Maintained outstanding relationship wif Bussiness Analysts and Bussiness Users to identify information as per the Bussiness Requirement.
• Worked on various transformations like Expression, join, Lookup, Sort, Filter, Aggregator and Mapplets and Reusabe transformations using Informatica Powercenter Designer.
• 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 the data from cloud applications.
• Ability to meet deadlines and handle multiple tasks, decisive wif strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly wif analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills

TECHNICAL SKILLS

ETL Tools: Data Stage 8.x/9.x/11.x, Informatica 10.1,9.x/8.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

Sr.ETL Developer

Responsibilities:

• Designing Technical and functional specs based on requirements provided by business and finalizing the data model.
• Involved in writing mapping specification document (STTM).
• Created ETL documents (ETL Standards, Migration Manual, and Unit Testing) for the 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-I, Type-II
• Involved in writing Range Partitioning wif dates on fact table.
• Involved in writing Stored Procedure to break a string and for truncating the partitioned tables.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level. Developing, Testing and debugging the mappings in Informatica.
• Developed workflow tasks 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 wif business analysts inrequirements gathering, reviewing business rules and identifying data sources.Worked on analyzing the systems and gathering of requirements.
• Work wif the project and business teams to understand the business processes involved in the solution.
• Created technical design documents by analyzing functional specification documents that are required for ETL development.
• Extracted the 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 wif proper job dependencies, job control stages, triggers.
• Used the data stage director and its run-time engine to monitor the running jobs.
• Involved in all steps of development and deployment processes.
• As Part of TRIRIGA provided SAP ECC, JDE Extracts to all the teams using BODS designer and scheduling the jobs weekly/bi-weekly using data service management console.

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

Confidential, Hoobken NJ

Informatica Developer

Responsibilities:

• Designing Technical and functional specs based on requirements provided by business and finalizing the data model.
• Involved in writing mapping specification document (STTM).
• Created ETL documents (ETL Standards, Migration Manual, and Unit Testing) for the 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 the installation and setup ETL (Informatica Cloud) applications on Linux servers.
• Designing and developing complex Informatica mappings including Type-I, Type-II
• Involved in writing Range Partitioning wif dates on fact table.
• Involved in writing Stored Procedure to break a string and for truncating the partitioned tables.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level. Developing, Testing and debugging the mappings in Informatica.
• Developed workflow tasks 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 wif Business analysts and Business users to understand the requirements and to build the technical specifications.
• Involved in all business meetings to understand the existing logic, different member information and agency data to come up wif the 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 the concerned business teams from various entities.
• Developed and supported the Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources using DataStageDesigner and to load the 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 jobswif dependency and email notifications.
• Involved in Unit Testing, SIT and UAT Worked wif the users in data validations.
• Extensively worked in improving performance of the 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 wifin the team to make appropriate, effective decisions related to project responsibilities and to initiate and follow-up on assigned tasks wifout supervision.
• Provided support and guidance by creating Release, Deployment & Operation guide documents.
• Involved in Performance tuning of complex queries.
• Developing SQL scripts to facilitate the 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 the establishment of standards, guidelines and best practices.
• Responded to customer needs; self-starter and customer service oriented.
• Experience wif 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 wif the users in data validations.
• Extensively worked in improving performance of the jobs by avoiding as many transforms as possible.
• Prepared documentation for unit, integration and final end - to - end testing.
• Helped in preparing the 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 the ETL Coding.
• Developed job sequencer wif 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.