SUMMARY:

• Over 5 years of IT experience in all phases of Software Development Life Cycle (SDLC) which includes User Interaction, Business Analysis/Modeling, Design, Development, Integration, Planning and testing and documentation in data warehouse applications, ETL processing and distributed applications
• Strong expertise in using ETL Tools Informatica Power Center 9.6 (Repository Manager,Designer,Workflow Manager, Workflow Monitor), IDQ, PowerExchange and ETL concepts .
• Experienced in writing SQL, PL/SQL programming, Stored Procedures, Functions, Cursors,Triggers, Views, Materialized Views, indexes, partitions, table partitions and query performance tuning.
• Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookup, joiner, sequence generator, sorter, SQL, stored procedure, Update strategy, Source Qualifier.
• Data Modeling: Data modeling knowledge in Dimensional Data modeling, Star Schema, Snow - Flake Schema, FACT and Dimensions tables.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources like Multiple Relational Databases (Teradata, Oracle, SQL SERVER, DB2), VSAM, XML,Webservices and Flat Files.
• Experience in working with POWER EXCHANGE to process the MainFrame files (IMS).
• Experience in working with POWER EXCHANGE in implementing Change Data Capture CDC.
• Designing and developing Informatica mappings including Type-I, Type-II, Type-III slowly changing dimensions (SCD).
• Coordinating with Business Users, BI teams, functional Design team and testing team during the different phases of project development and resolving the issues.
• Experienced in Teradata SQL Programming and Worked with Teradata utilities like Fast Load and Multi Load and Tpump and Teradata Parallel transporter.
• Experienced in using advanced concepts of Informatica like PUSH DOWN OPTIMIZATION (PDO), PIPELINE PARTITIONING.
• Good hands on experience in writing UNIX shell scripts to process Data Warehouse jobs.
• Good skills in defining standards, methodologies and performing technical design reviews.
• Executed software projects for Banking and financial services.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6, Data Stage 8.7,InformaticaPowerExchange

Languages: SQL, TSQL,PLSQL,UNIX Shell Scripting

Methodology: Agile RUP, SCRUM, Waterfall

Databases: Teradata14/13/v2r12/v2r6/v2r5,Oracle11i/10g/9i,DB2,SQLSERVER2005/2008,Netezza

Operating Systems: Windows, UNIX, Linux

IDEs: TOAD, Teradata SQL Assistant, SQL * Loader.

Scheduling Tools: Control-m, Autosys, Tidal,Automic,Cron

Tracking Tool: Rally,SharePoint, JIRA, VersionOne

PROFESSIONAL EXPERIENCE:

Confidential

Developer

Environment: Informatica Power Center 9.6, Teradata.

Responsibilities:

• Involved in preparing STTM Documents with BSA.
• Preparation of Design documents, Understanding document and Technical Specifications.
• Developed Several Mappings using transformations like Aggregator, Sorter, Expression, Router, Update strategy, Joiner and Look up transformations etc.to load the data from different Sources in to Relational tables.
• Attending Client calls to update project status.
• Responsible in supporting the SIT & UAT runs and supporting them for business clarifications.
• Improving performance of Informatica mappings which requires additional tuning created by fellow team members.

Developer

Environment: Informatica Power Center 9.6, Oracle 10g, FACETS, ESP Scheduler.

Responsibilities:

• Liaising with user in business requirements gathering.
• Preparation of BRD.
• Preparation of Design documents, Understanding document and Technical Specifications.
• Implementation of change requests.
• Developed Several Mappings using transformations like Aggregator, Sorter, Expression, Router, Update strategy, Joiner and Look up transformations etc.to load the data from different Sources in to Relational tables.
• Attending Client calls to update project status.
• Coordinate with team members to guide and review the work done by them.
• Monitor Informatica and Facets batch jobs in ESP scheduler.
• Improving performance of Informatica mappings which requires additional tuning created by fellow team members.

Developer

Environment: Informatica Power Center 9.6, Sybase, Teradata.

Responsibilities:

• Responsible for gathering the requirements as per the design documents & mapping documents given.
• Identifying the issues in the Detail Physical Document & Source to Target Document.
• Verifying the table DDL’s as per the Source to Target Document given.
• Implementing the Logic of Change Data Capture (CDC) and loading the Staging tables & the Atomic tables using the Teradata Parallel Transporter connection.
• Responsible for preparing the KSH scripts for running the Informatica jobs.
• Responsible for preparing the Configuration files that are required for KSH scripts.

ETL Developer

Environment: Informatica Power Center 8.6, 9.0, Sql Server 2005, UNIX.

Responsibilities:

• Requirement Gathering and analysis of the specifications provided by the Users.
• Preparing Project Documentations.
• Extracted, Transformed and Loaded (ETL) data from different sources (Sql Server, Mainframe, and Flat file) to Relational tables.
• Unit testing the code.
• Fixing the bugs raised by ETL Testing team.
• Coordinating with ETL Testing and Production team for timely releases.