SUMMARY

• IT experience in Data Warehouse Design, Analysis, Development, Testing and Maintenance.
• Expertise in entire life cycle of DWH - Analysis, requirements gathering, ETL Design, development, Unit testing and production support.
• Strong ETL experience of using Informatica 10.2.0/10.1.1 /9.6.1/8.6 Power Center Client tools - Source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplet Designer, Repository manager, Workflow Manager/Monitor.
• Worked in Data Ingestion project to inject data into Data Lake using multiple sources systems using Talend Bigdata.
• Experienced in scheduling Talend jobs using Talend Administration Console (TAC).
• Developed complex mappings using Informatica Power Center Transformations - Lookup Unconnected, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Java, and Sequence Generator.
• Having strong hands on experience in extraction of the data from various source systems like DB2, Oracle, Teradata, Flat Files, and XML.
• Experience in both ETL Informatica & Database Sql Performance Tuning.
• Experience in working with Teradata Utilities like TPT to improve the loading performance.
• Experience in writing BTEQ scripts also tuning them for performance issues.
• Experience in writing the SQL, PL/SQL stored procedures to meet the business requirements and the transformations.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in developing Stored Procedures, Packages, Functions, Views and Triggers, Complex SQL queries.
• Proficiency in data warehousing techniques for Change Data Capture, Data Cleansing, Slowly changing dimensions types (1 and 2).
• Good experience in doing Unit testing & working with QA team for QA Testing also experience in working with ETL Admin team for informatica higher environment Testing, Migrations & Deployments.
• Good experience with both Waterfall & Agile (Scrum Process) implementations.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.

TECHNICAL SKILLS

Tools: and Utilities: Informatica Power Center 10.2.0/10.1.1 /9.6.1/8.6 , Talend Studio 7.1.1

Databases: Oracle 11g/10g, Teradata 14, SQL Server, DB2

File System: Flat Files, XML

Scheduling Tools: Tidal

Languages: SQL, PL/SQL, Teradata SQL, UNIX Shell

Operating Systems: Windows, Unix, Linux

Others: WinScp, Putty, Sql Assistant

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Informatica/Talend Developer

Responsibilities:

• Involved in Requirement analysis in support of Data Warehousing efforts along with Business Analyst.
• Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
• Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations.
• Extensively worked with various Passive transformations like Expression, Lookup and Sequence Generator.
• Involved in creating Mapplets using Java Transformations for Decrypting the Encrypted data.
• Worked with source databases like Oracle, SQL Server, XML and Flat Files.
• Extensively worked with Teradata utilities like BTEQ & TPT to load data in to ware house.
• Extensively Involved in Tuning Teradata scripts along with Oracle and Other source Queries for extraction.
• Created Stored Procedures to map, transform and migrate data based on business requirements .
• Involved in extracting data from client operational databases, transform, cleanse data, load it into staging area and then from stage to data warehouse.
• Created complex mappings using Unconnected and Connected lookup Transformations.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Implemented Slowly changing dimension Type 1 and Type 2 for change data capture.
• Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache.
• Worked extensively with update strategy transformation for implementing inserts and updates.
• Experience in writing DMR’s for Production issues.
• Extensively used the tasks like email task to deliver the generated reports to the mailboxes and command tasks to write post session and pre session commands.
• Extensively used debugger to test the logic implemented in the mappings.
• Performed error handing using session logs.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval.
• Involved in production support when required.
• Monitored workflows and session using Power Center workflows monitor.
• Used Informatica Scheduler along with Tidal for scheduling the workflows.
• Involved in creating the jobs in Tidal Scheduler tool.
• Extensively used Talend Administrator Console (TAC) for running the jobs on different servers by passing various context parameters.
• Have the knowledge on scheduling jobs on TAC.

Environment: Informatica Power Center 10.2.0/10.1.1 , Talend 7.1 Oracle, Sql server, My Sql, PL/SQL, Flat Files, Teradata 15/14, Tidal, SQL Assistant, Unix, Windows.

Confidential

ETL Developer

Responsibilities:

• Involved in Project Analysis and documenting the development requirements.
• Worked with ETL Architects, Data Modelers & Business Analysts.
• Designed and developed database views and stored procedures, Packages and Functions.
• Used SQL to extract the data from the database and also using views on the tables.
• Worked with Development Life Cycle in performing the Data Movement.
• Wrote stored procedures, functions &Packages.
• Involved in the creation of Mapping for various requirements using Informatica 9.6.1 and used Informatica Workflow Manager for configuring mappings also validated schedule run and monitor jobs using Workflow Monitor.
• Involved in the preparation of documentation for ETL using Informatica standards, procedures and naming conventions.
• Developed SQL Applications for extracting the data from the Oracle tables.
• Created detailed system design specifications to serve as a guide for system and the program development.

Environment: Informatica Power Center 9.6.1, Oracle, SQL, UNIX, Windows.

Confidential

Jr.ETL Developer

Responsibilities:

• Involved in Project Analysis and documenting the dev requirements.
• Worked with Data Modelers & Business Analysts.
• Designed and developed database views and stored procedures, Packages and Functions.
• Used SQL to extract the data from the database and also using views on the tables.
• Worked with Development Life Cycle in performing the Data Movement.
• Wrote stored procedures, functions &Packages.
• Involved in the creation of Mapping for various requirements using Informatica 8.6 and used Informatica Workflow Manager for configuring mappings also validated schedule run and monitor jobs using Workflow Monitor.
• Involved in the preparation of documentation for ETL using Informatica standards, procedures and naming conventions.
• Developed SQL Applications for extracting the data from the Oracle tables.
• Created detailed system design specifications to serve as a guide for system and the program development.

Environment: Informatica Power Center 8.6, Oracle, SQL, PL/SQL, UNIX.