SUMMARY

• 8 Years of IT experience in designing, implementation, development, testing and maintaining the ETLcomponents for building Data Warehouse & Data marts across different domains.
• Experienced in all stages of the software lifecycle Architecture (Waterfall model, Agile Model) for building a Data warehouse.
• Well acquired on Informatica Power Center 9.x/8.x/7.x Designer Tools (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer), Workflow Manager Tools (Task Developer, Worklet and Workflow Designer) and Repository Manager & Admin console.
• Involved in Troubleshooting data warehouse bottlenecks, Performance tuning - session and mapping tuning, session partitioning & implementing Pushdown optimization.
• Extensively worked on various transformations like Lookup, Joiner, Router, Rank, Sorter, Aggregator, Expression, etc.
• Exposure to Data Warehousing, Data Architecture, Data Modeling, Data Analysis, SDLC Methods.
• Good Understanding with experience in Ralph Kimball Methodology, Bill Inmon Methodology, entity-relational and dimensional-relational table modeling using Data Modeling (Dimensional & Relational) concepts like Star Schema Modeling and Snow-flake schema modeling.
• Extensive experience with Data Extraction, Transformation, and Loading(ETL) from heterogeneous Data sources of Multiple Relational Databases like Oracle, Teradata, DB2, SQL Server, My Sql, Sybase and Worked on integrating data from flat files like fixed width and delimited, CSV, XML into a common reporting and analytical Data Model (DWH) using Informatica PC.
• Experience with Teradata utilities like Fast load, Fast Export, Multi Load, TPUMP & TPT. Have experience in creating BTEQ scripts.
• Experience in Talendopen studio and Talendintegration suite.
• Created standard and best practices for TalendETL components and jobs.
• Strong knowledge of Sreporting tools and working with reposting & Business users.
• Experience on Oracle utilities like SQL Loader.
• Extensively used SQL and PL/SQL for development of Procedures, Functions, Packages and Triggers.
• Experience in using the Informatica command line utilities like PMCMD to execute workflows in Unix environment.
• Good programming skills in SQL and PLSQL.
• Developing ETL processes using Informatica to read and write complex XML, HL7 and EDI X12(810,832,835,850,855,856 ).
• Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment, Normalization & De-normalization, Cleansing, Performance Optimization along with the CDC (Change Data Capture).
• Good Experience in UNIX Shell scripting & Windows Batch Scripting for Parsing Files & automation of batchETLjobs.
• Strong knowledge in RDBMS concepts.
• Versatile team player with excellent analytical, communication and presentation skills.
• Quick adaptability to new technologies and zeal to improve technical skills.
• Good analytical, programming, problem solving and troubleshooting skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1/9.5.1 /9.1/8.6/8.5/8.1/7.1 (Workflow Manager, Workflow Monitor, Repository manager and Informatica Server).

Databases: Oracle 8.x/9i/10g/11g, Teradata 14/13/12, DB2, MS SQL Server 2000, Sybase, My Sql.

Database Utilities: Modelling

SQL Plus, SQL Loader, ODBC, Toad, Teradata Utilities.: Erwin and MS Visio.

Languages and Packages: SQL, PL/SQL, Unix Shell Scripting, XML

Operating Systems: Unix (Sun-Solaris, HP-UX, AIX), Windows 95/98/NT/2000/XP

Testing Tools: Quality Center, Mercury Test Director

Scheduling Tools: Control-M, Autosys, Maestro

PROFESSIONAL EXPERIENCE

Confidential, AUSTIN, TX

Sr.ETL Informatica Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
• Preparation of technical specification document for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETLstandards
• Estimates and planning of development work using Agile Software Development.
• Good experience on Agile Methodology and the scrum process.
• Worked on TalendRTX ETL tool, develop jobs and scheduled jobs in Talendintegration suite.
• Ensured performance metrics are met and tracked
• Processes to generate Daily, Weekly and Monthly data extracts were developed and the data files were sent across to the downstream applications.
• Involved in Data modeling review sessions - E/R diagrams, normalization and de-normalization as per business requirements.
• Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management and Data transportation.
• Experience in Performance tuning of Source SQL queries and Teradata Queries.
• Designed and Developed ETL(Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems such as Oracle, Oracle GG, Flat files, XML, My Sql.
• Sourced transaction data being staged by Golden Gate tool CDC (Change Data Capture) through Informatica Power center and loaded into the target
• Worked on slowly changing dimension Type1 and Type2.
• Used the Teradata external loading utilities like MultiLoad, TPUMP, Fast Load and Fast Export to extract from and load effectively into Teradata database
• Worked on Web Service Call through Informatica by generating and testing the incoming XML using external Freeware called SOAP UI.
• Configured tasks and workflows using workflow manager.
• Involved in the creation of Oracle Sql and PL/SQL stored procedures and functions.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Tuned the Sessions for better performance by eliminating various performance bottlenecks.
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
• Writing UNIX & Perl script to load data from sources to staging tables, to create indirect file list, generate parameter files for respective paths.
• Used SVN for version control and Autosys for Job scheduling.
• Applied Agile methodology throughout the development life cycle of application.

Environment: Informatica Power Center 9.6.1/9.5.1 , Oracle 11g, Oracle Golden Gate, CDC, PLSQL, Teradata 14/13, Teradata Tools and Utilities, Autosys, My Sql, UNIX, Putty, Perl, MS Visio.

Confidential, PLEASANTON, CA.

Sr.ETL Developer

Responsibilities:

• Involved in creating Detail Design Documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writingETLspecifications for development and conversion projects.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Designed complexETLmappings andOracle Sqlscripts.
• Developed Informatica mappings, transformations, reusable objects by using mapping designer, and transformationdeveloperand mapplet designer in Informatica Power Center.
• Created Reusable Transformations and Mapplets and used them in mappings.
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created complex mappings in Power Center Designer using different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Sequence Generator, Router, Update Strategy, Sorter, Normalizer, Lookup, Joiner and Stored procedure transformations.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business logic) to generate consolidated (fact/summary) data using InformaticaETLtool.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex problems.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Designed and Deployed UNIX Shell Scripts.
• Experienced in performance tuning in Informatica.
• Coordinated with testing team to make testing team understand business and transformation rules being used throughoutETLprocess.
• Production & On Call Support.
• Involved in collection layer development

Environment: Informatica 9.5.1/9.1.1 , Flat files, Oracle, DB2, Sybase, Sql, PL/SQL, UNIX, Windows.

Confidential, NY

ETL Developer

Responsibilities:

• Involved in system study, analysis of the requirements and designing of the complete system.
• Created mapping documents with the required Transformation logic, Sources and Targets for Facts and Dimensions.
• Responsible for verification of functional specifications and review of deliverables.
• Designed and Created data cleansing, validation and loading scripts for warehouse using Informatica Power Center 9.1.1/8.6.1.
• Extensively used Informatica Client Tools Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer, and Informatica Repository.
• Created reusable transformations and Mapplet to use in multiple mappings.
• Used debugger to test the data flow and fix the mappings.
• Created and monitored workflows and tasks using Informatica Power Center Work flow Manager.
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Logical and physical Sybase database design in Erwin for data warehouse used by a securities lending application.
• Created repository, Groups, Users assigned privileges using repository manager.
• Developed mappings/Transformation/Mapplet by using mapping designer, transformationdeveloper and Mapplet designer in Informatica Power Center.
• Worked with XML sources to get the data to Oracle to suite our environment.
• Setting up batches and sessions to schedule the loads at required frequency using Power Center server manager.
• Involved in Version control of the jobs to keep track of the changes in the Development Environment.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.
• Developed Unit test cases for all the jobs.
• Provided assistance during user testing.

Environment: Informatica Power Center 9.1.1/8.6, Oracle 9i/8i, SQL Server 2005, Sybase, PL/SQL, SQL Loader, Unix Shell Script, Windows.

Confidential

ETL Developer

Responsibilities:

• Translated business requirements into data warehouse design.
• Involved in understanding logical and physical enterprise data warehouse schemas.
• Used Star Schema approach for designing of Data Warehouse.
• Integrated different systems using Informatica server configuration. Extracted data from Flat files, Oracle, SQL Server, MS-Access and Loaded data into Oracle using Informatica.
• Created Source definitions, Target definitions, Mappings, Transformations, Reusable Transformations, Mapplet using Informatica Designer tool which includes Source Analyzer, Warehouse Designer, TransformationDeveloper, Mapping Designer and Mapplet Designer.
• Created sessions, database connections and batches, Scheduled and monitored transformation processes using Informatica Server Manager.
• Used Informatica repository manager to backup and migrate metadata in development, test and production systems.

Environment: Informatica Power Center 6.2/7.1, Cognos Impromptu 6.0, Impromptu web reports (IWR 6.0), UNIX, PL/SQL, Oracle 8.0/8i and Win NT.