PROFESSIONAL SUMMARY:

• IT professional with extensive experience in implementation of technology based business solutions.
• Expertise in using cutting edge tools like Informatica, DataStage, Oracle, Teradata and SQL server.
• Experienced in a variety of domains Financial, Health Care, Insurance, Telecom, Food Processing, Energy and Public Records.
• Strong in Data warehousing, dimensional star schema, snowflakes methodologies and Data Modeling Concepts.
• Expert in converting business requirements into technical design and Implementations.
• Experience in Installation and configuration of Informatica server on Linux and windows platform.
• Performed ETL procedure to load data from different sources into data marts and data warehouse.
• Proficient in the use of Teradata load utilities - FastLoad, Mload, Bteq, and Tpump.
• Experienced in SQL/PLSQL Stored Procedures, Functions, Triggers, Packages, Explain Plan, Constraints, Indexes, Views, and Materialized Views using Oracle 8i/9i/10 g/11g.
• Well Versed in TOAD, WINSQL, SQL Developer, and SQL Navigator for testing data loads.
• Proficient in all phases of the system development lifecycle, including requirements Definition, Data Cleansing, Data Conversion, Performance Tuning, System Testing and Acceptance.
• Experienced in UNIX/LINUX shell scripting.
• Experience in documentation and presentation skills using tools like Visio and PowerPoint.
• Experience in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.
• Well Versed in technical, problem-solving, organizational, communication, learning and team skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.x/8.x/7.x/6.x (Repository Manager, Designer, Workflow Manager, and Monitor), Informatica Power Connect, Informatica Metadata Manager, IBM WebSphere DataStage 8.7X (Designer, Director, Administrator, Web Console)

Languages: SQL*Plus, PL/SQL, UNIX/LINUX

Reporting Tools: Business Objects XI

Databases: Oracle 11g/10g/9i, Teradata V2R5/V2R6/R12, SQL Server, DB2, MS Access

Scheduling Tool: Control-M, Tivoli Maestro

Hadoop ecosystem: Hadoop, MapReduce, HDFS, Pig, Sqoop, Hive Hue, Flume, Oozie, Zookeeper

Other Tools: Erwin, Mercury Quality Center, Kedit

GUI: Developer 2000 (Forms, Reports).

Environment: Windows 9x/NT/2000, UNIX (Solaris), Linux, DOS

PROFESSIONAL EXPERIENCE:

Confidential

ETL Architect/ Lead Developer

Responsibilities:

• Supported and guided various teams on multiple projects in conjunction with ETL development, Software and Hardware planning.
• Prioritize, Plan and deploy development, Operations and Administration work.
• Provided technical strategy, expertise and directions to the ETL team.
• Successfully maintained and recommended tools for management review.
• Identified, researched and recommended reduction in servers cutting the company cost by 20%.
• Handled and enhanced new and existing projects and planned the resourced accordingly.
• Extensively worked on ETL Architecture Design, naming standards, Source-Target mapping template, ETL design requirement based on functional team requirements and ETL migration templates.
• Interacted with business analysts to frame the data warehouse requirements.
• Provided technical and strategic direction to the ETL team.
• Imported data from multi sources Files, Oracle.
• Created Informatica mappings using update strategy, sorters, routers, overwritten lookups, Dynamic lookups, reusable expressions, aggregators, mapplets, union, joiner, normalizer, reusable sequence generator, sql transformation etc for loading the data.
• Implemented Slowly Changing Dimension (Type1, Type 2) rules in the mappings as per the requirements.
• Worked on Performance tuning of targets, sources, mappings and session and performed partitioning.
• Hands-on experience with Informatica Metadata Manager for Data lineage, Data Analyst Tools, Data Quality, Data profiling and Table Manager.
• Responsible for Installing, setup and configuring Informatica/DataStage servers.
• Responsible for the Administration of multiple projects on multiple servers.
• Created database partitions and database objects. Tuned the SQL queries using hints for maximum efficiency and performance.
• Created Folders, shortcuts for Source, Target & Transformations objects.
• Created and used parameter files to provide values to the variables used across sessions and workflows.
• Created Deployment Group to deploy objects from Dev to QA and Production Repository.
• Performed Folder Migration using Repository Manager from Dev Repository to QA and Production Repository.
• Coordinated with the UAT team.
• Created updated and maintained Technical Design documentation based on business requirements.
• Wrote Korn shell scripts.
• Involved with POC of ETL products like Informatica and IBM InfoSphere DataStage.
• Created DataStage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Funnel, Remove Duplicates, Copy, Filter, Surrogate Key, Column Generator, Row Generator, Etc.
• Used the DataStage Director to schedule and monitor the jobs.
• Created users and group using DataStage Administrator Web Console.
• Created projects and provided access to users using DataStage Administrator.

Environment: Informatica PowerCenter 9.0, IBM InfoSphere DataStage 8.7, Oracle 11g, SQL, PL/SQL, Toad, Linux.

Confidential

ETL Lead

Responsibilities:

• Architecture the overall design, development and unit test of the ETL code as per the requirements.
• Interacted with business analysts and data architects to frame the data warehouse requirements.
• Created, updated and maintained Technical Design Documentation based on extensive discussion with the business.
• Performed extensive data analysis with the Analytical team.
• Provided technical and strategic direction to the ETL team.
• Created mappings using various transformation utilities of informatica for loading the data.
• Performed extensive unit testing and investigated the source and target data to ensure sound data conversion.
• Created error handling process.
• Extensively used the utilities of Teradata - FastLoad, Bteq, and Multi-Load to load data into the Target database.
• Implemented Slowly Changing Dimension rules using Teradata utility.
• Worked on Data Quality issues involving script modifications and data migration of huge tables (30 TB).
• Coordinated with testing team during Integration testing, Regression testing and UAT.
• Created Turnover document for production support.
• Created Maestro scheduler for scheduling the jobs with proper dependencies.

Environment: Informatica PowerCenter 9.0, TeradataV2R6, Teradata SQLAssistant12.0, Oracle11g, ERwin, Maestro, UNIX Solaris

Confidential

Sr. ETL Informatica Application developer

Responsibilities:

• Worked on the ETL Architecture Design, development and unit testing.
• Interacted with business analysts and data architects to frame the data warehouse requirements.
• Imported data from multi sources Files, Oracle and Teradata.
• Created mappings using update strategy, sorters, routers, overwritten lookups, Dynamic lookups, reusable expressions, aggregators, mapplets, union, joiner, normalizer and reusable sequence generator etc for loading the data.
• Worked with Debugger for handling the data errors in the mapping designer, Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance.
• Implemented Slowly Changing Dimension rules in the mappings as per the requirements.
• Worked on Performance tuning of targets, sources, mappings and session and performed partitioning.
• Created database partitions and database objects. Tuned the SQL queries using hints for maximum efficiency and performance.
• Created Folders, shortcuts for Source, Target & Transformations objects.
• Created and used parameter files to provide values to the variables used across sessions and workflows.
• Created Deployment Group to deploy objects from Dev to QA and Production Repository.
• Coordinated with the UAT team.
• Created updated and maintained Technical Design documentation based on business requirement.

Environment: Informatica PowerCenter 9.0, Oracle 11g, SQL, PL/SQL, Toad, UNIX Solaris