SUMMARY

• Over 6+ years of total IT experience and technical proficiency in building Data Warehouses,Data Integration, Operational Data Stores and ETL processes for clients inEcommerce(Sales orders,Inventory tracking,daily reports) ,Financial (Equities, Futures) and HealthCare (Providers, Customers, Organizations, Plans, Claims, and Extracts) domains.
• Hands on experience in Design, Development, Migration, Implementation of Data Warehouse and ETL Application development.
• Hands on experience in working with large scale Data Warehouse implementations and ETL tools using Informatica PowerCenter 8.x/7.x, DataStage 9.x,8.x, Oracle 10g&11g, DB2,Netezza, SQL Server on UNIX and Windows platforms.
• Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using DataStage Designer & Talend Open Studio environment.
• Expertise in implementing complex business rules by creating several parallel jobs and sequencers for process execution flow with robust mappings in DataStage.
• Experience in working on performance tuning jobs and thereby decreasing the execution time and efficient server utilization with limited resources .
• Stop / start services, monitor logs, create/delete projects, create/modify environmental parameters etc
• Evaluate system specifications, working parameters for hardware / software compatibility
• Comply with standards and guidelines related to the design, construction, testing and deployment activities within the Delivery Management environments
• Install IBM Information Server product suite, post configurations including configuring database native connectivity and ODBC connections and parallel database reads and writes
• Works with minimal guidance; seeks guidance on only the most complex tasks
• Create documentation for the installs, upgrades and regular maintenance
• Resolving ETL DataStage performance issues
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files,XML files into Data Warehouse and also experienced in Data Cleansing and Data Analysis.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages, Cursors, Triggers, Views, and Indexes in distributed environment.
• Hands on experience on different types of data load strategies and scenarios like Historical Dimensions, Surrogate keys, Summary facts etc.
• Strong experience in writing UNIX Shell scripts, SQL Scripts for development, automation of ETL process, error handling, and auditing purposes. Experience in using Autosys and Control - M scheduling tools to organize and schedule jobs.
• Experience in preparing documentation such as High level design, System requirement document, and Technical Specification document etc.
• Extensive ETL experience of more than 4 years in data extraction, transformation and loading data using Informatica PowerCenter 9.x/8.x,Informatica PowerExchange9.x,8.x and Data Warehousing and Teradata.
• Worked extensively in all stages of SDLC, from gathering requirements to testing, implementation and support.
• Fluid understanding of multiple programming languages, including C#, C, C++,Java, JavaScript, HTML, and XML.
• Expertise in developing and debugging indexes, stored procedures, functions, triggers, cursors using DB2.
• Experience in project management, estimations, and resource management activities.
• Excellent analytical, problem solving skills with strong technical background and interpersonal skills.

TECHNICAL SKILLS

Databases: Oracle,Netezza,DB2,NoSQL,SQL Server,Teradata

Operating Systems: Windows/Unix/Linux

Database Tools: TOAD, SQL Navigator

Programming Languages: C, C++, HTML, XML, PL/ SQL, Java, J2EE,Python

ETL Tools: IBM DataStage Enterprise Edition 9.1/8.5 / 7.5 Informatica PowerCenter 10.x 9.6.1/8.5.1

Scripting Languages: Shell Scripting, Perl Scripting

SchedulingTools: Autosys,Tivoli, Control-M

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer,
• Warehouse Designer, Mapplet Designer and Mapping Designer.
• Experienced in developing mappings using transformations such as Source Qualifier, Aggregator,
• Lookup, Filter, Sequence Generator, Expression, Router, Update Strategy, Rank, XML, Normalizer etc., to load data from different sources like Oracle, Flat Files, Excel Spread Sheets, XML files to the target Data Warehouse.
• Created Hive tables and loaded data from HDFS to Hive tables as per the requirement.
• Worked in MDM Hub configurations - Data Mappings, Data validation, Hierarchy Manager, customizing/configuring Informatica/Business Data Director
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Designed & Developed Informatica MDM User Exits, Match rules etc
• Worked as an Informatica Administrator to migrate the mappings, sessions, workflows, repositories into the new environment.
• Designed and developed scripts for administrative tasks like backup’s, tuning and periodically refreshing the test databases from the production databases.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression,
• Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implementedslowly changing dimensionmethodology for accessing the full history of accounts.
• Write Shell script running workflows in unix environment.
• Optimizing performance tuning Confidential source, target,mapping and session level
• Participated inweeklystatus meetings, and conducting internal andexternal reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica PowerCenter 9.6, SQL Developer, AQT,Oracle 11g, UNIX Shell Scripting,Hive.

Confidential

ETL Developer(Datastage)

Responsibilities:

• Designed and developed mappings between sources and operational staging targets, using Star and Snow Flake Schemas.
• Provided data models and data maps (extract, transform and load analysis) of the data marts for systems in the aggregation effort.
• Involved in Extracting, cleansing, transforming, integrating and loading data into data warehouse using Datastage Designer.
• Developed various transformations based on customer last name, zip code for internal business analytical purposes, loaded warehouse based on customer credit card number with dynamic data re - partitioning.
• Developed user defined Routines and Transformations by using Universe Basic.
• Used Datastage Manager for importing metadata from repository, new job categories and creating new data elements.
• Used the Datastage Director and the runtime engine to schedule running the solution, testing and debugging its components and monitoring the resulting executable versions (on adhoc or scheduled basis).
• Developed, maintained programs for scheduling data loading and transformations using Datastage and Oracle 12c.
• Developed Shell scripts to automate file manipulation and data loading procedures.

Environment: Datastage 9.1/8.7, Oracle 12c, SQL, TOAD, UNIX, Windows NT 4.0 .