SUMMARY:

• Over 9+ years of experience in IT industry having extensively involved in analysis and design, testing, implementation, maintenance, production support and knowledge transfer.
• Over 7+ years of extensive experience with ETL tool Informatica Power Center 9.x/8.x, Power Exchange 8.6.1/8.1/8.0 in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions.
• Over 7+ years of Database experience using Oracle 10g/9i/8i, DB2 UDB 8.0/7.0, Vertica 6.0, Teradata 14/13/12, MS Access 7.0/2000, PL/SQL, SQL Plus, SQL Server. Strong Experience on database interfaces like PL/SQL Developer, SQL Plus and TOAD.
• Experience in complete Software Development Life cycle (SDLC) including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
• Extensively followed the advanced concepts of Ralph Kimball and Bill Inmon Methodologies.
• Extensive knowledge of Data Modeling, Data Conversions, Data integration Data Mining and Data Migration with specialization in Informatica Power Center.
• Expert on Slowly Changing Dimensions Type 1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
• Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console.
• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files. Written number of shell scripts to run various batch jobs.
• Solid experience in writing SQL queries, Stored Procedures, Cursors, Indexes, Views, Sequences and Triggers.
• Knowledge on BigData, Hadoop, Hive, Hbase, AWS S3 data lake, AWS EMR.
• Experience on post-session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Willing to learn and adapt to new challenges.

TECHNICAL SKILLS:

Data Warehousing / ETL Tools: Informatica 9.5/9.1/8.6/8.1 (Repository Admin Console, Repository Manager, Designer, Workflow Manger, Workflow Monitor, Power Exchange), Microsoft SSIS 2012/ 2008.

Data Modeling: MS Visio 2010,Star Schema Modelling, Snow Flake Modelling

Databases: Teradata 14/13/12/, Vertica 6.0/5.0, Oracle 11g/10g/9i/8i, MS SQL Server 2012/ 2008 R2/2008.

Languages: C, C++, JAVA, SQL, PL/SQL, T-SQL, BTEQ Scripts, Unix Shell Script, Power Shell

Tools: Toad, SQL* plus, SQL Assistant 13, Squirrel SQL Client version 3.3.0, Fast Load, Multi Load, Fast Export, TPT, Putty

Operating Systems: Windows 95/98/NT/XP/2000/2003, Sun Solaris, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Spring, Nashville, TN

Lead Informatica Teradata Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business analyst to develop ETL procedures that are consistent across all applications and system.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Migrate Teradata, Informatica code (parameter files, mappings, sessions and workflows) and Active Batch (scheduler) from Dev/QA/UAT and PROD servers using deployment scripts ( Teradata) and deployments group ( Informatica ).
• Worked on Cobol Copybook (VSAM files) to load data into Teradata.
• Designed and maintained end to end mappings, sessions, workflows and tables in Informatica and Teradata.
• Understand SQL Server stored procedures and SSIS packages and convert them into Informatica Teradata.
• Worked on Teradata parallel transporter TPT and pushdown optimizer PDO.
• Created tables, Volatile tables, views, stored procedures and function in Teradata to achieve business functionality.
• Used most of the transformations such as the Transaction Control, JAVA, SQL transformation, Routers, Sequence Generator, Expression and lookups (connected and unconnected) while transforming the Data according to the business logic.
• Achieved performance improvement by analyzing explain plan, identifying and defining indexes, Collect statistics on columns that are used in Joins and compression on appropriate attributes to save the disk space
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Schedule jobs in Active Batch V9 scheduler.
• Proven Accountability including professional documentation and weekly status report.

Environment: Informatica Power Center 9.6/9.5, Teradata 14/13, MultiLoad, TPT, BTEQ, Win XP, Active Batch V10/v9, SQL Assistant 14, SQL Server 2012/2008, PDO.

Sr. Informatica Teradata Developer

Responsibilities:

• Migrate Informatica code(mappings, sessions and workflows) and unix scripts from 8.6 to 9.1 server and also to DR system using scp commands and deployments group.
• Used HTTP transformation to get data web service.
• Loaded data into Hadoop (HDFS) using Informatica.
• Create folder, users using repository manager and admin console.
• Worked on very huge volumes of data (40 million records per day) mostly flat files and loaded them into Teradata tables.
• Wrote shell script using infacmd.sh command to check Informatica server, node and integration service status and send emails when something is wrong.
• Created Microsoft SSIS packages to extract data from MS Access database to flat files.
• Worked on odbc.ini file to created ODBC connection in informatica.
• Wrote FTP and SFTP scripts to get and put files from third party sites.
• Worked with JAVA transformation to parse JSON records and URL( name value pair) records.
• Used ruby script to decode records from base64 and some perl script to parse the records.
• Design activity tables for all informatica jobs to monitor and record job activities.
• Used FastLoad, MultiLoad and FastExport connection to load and export data from Teradata tables.
• Worked extensively on SQL, BTEQ Scripts and UNIX shell scripts. Schedule jobs in crontab, informatica scheduler and Tadial.

Environment: Informatica Power Center 9.5/9.1/8.6.1, Teradata 14/13, Vertica 6.0/5.0, FastLoad, MultiLoad, TPT,UNIX, Linux, perl, Win XP, Tidal, SQL Assistant 14/13, JIRA, Putty, BTEQ, Cognos 10.

Teradata Informatica Developer/Production Support

Responsibilities:

• Extensively worked on Power Center Client Tools like Power center Designer, Workflow Manager, and Workflow Monitor.
• Extensively worked on Power Center 8.6 Designer client tools like Source Analyzer, Target Designer and Mapping Designer.
• Worked extensively on SQL, BTEQ Scripts and UNIX shell scripts.
• Performed Unit testing and Data validation testing using Validation scripts (BTEQ Scripts).

Environment: Informatica Power Center 9.1/8.6, Power Exchange 8.5,Oracle 10g, Teradata 13, Fast Export, UNIX, Win XP, TOAD, SQL Assistant, $U, Remedy, Putty, BTEQ.

ETL Informatica Teradata Developer

Responsibilities:

• Analyzed the source data coming from different sources (Oracle and SAP Flat files) and worked on developing ETL mappings, sessions, worklets and workflows.
• Created Parameter files, User Defined Functions for converting SAP values and validation scripts.
• Used FakeMload connection and created used custom Mload Scripts from command task.
• Worked extensively on SQL, BTEQ Scripts and UNIX shell scripts.

Environment: Informatica Power Center 8.6, Oracle 10g, SAP BW Flat Files, Teradata 13, UNIX, Win XP, SQL * Plus, SQL Assistant, Control-M, Putty, BTEQ, OBIEE 10.1.3.

ETL/Informatica Developer

Responsibilities:

• Generated XML files to deliver to Thompson Reuters.
• Used Fastload, Mload connection to load data into teradata tables.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval.
• Developed the UNIX shell scripts to send out an E-mail on success of the process indicating the destination folder where the files are available.

Environment: Informatica Power center 8.1, Teradata 12, SQL Server 2005, Oracle 10g, TOAD, PL/SQL, and Windows XP.