SUMMARY

• Having 9 years of experience in IT industry with vast exposure in Informatica ETL Tool, SQL, and PL/SQL, Informatica DT studio,Informatica Cloud .
• Expertise in Requirement Analysis, Application Maintenance, Functional Studies and Testing.
• Extensive experience in designing, data profiling, data migration from various legacy sources to OLAP/OLTP target applications.
• Worked for Information & Media Domain for over 4 years, Health Science for 1 year and Banking Domain over 4 years.
• Extensive Knowledge in Informatica 8.X, 9.1.1, informatica cloud, Oracle, Teradata,AWS Redshift and have good knowledge in tuning Informatica Mappings.
• Expert in designing the mappings, Oracle Database Activities like DB Scripting, PLSQL Coding, Query Tuning and have worked database like Teradata,Aws Redshift and Netezza.
• Worked on loading the data by using Teradata with PDO option in Informatica.
• Worked on projects for clients such as Standard & Poor’s, McGraw - Hill Companies, Confidential, Time Warner Cable, Caremark, JP Morgan & Chase and Cydcor.
• As part of BASEL III banking regulatory, designed and developed Informatica Mappings with complex transformations and PDO.
• Extensively worked on Performance tuning using Informatica (Partitioning, PDO etc)
• Closely worked with BAs and Modelers to understand the requirement and create functional spec Docs.
• Provided ETL solution design for multiple initiatives including building Credit Data mart and BASEL III regulatory platform.
• Managed offshore ETL Team.
• Experience in dealing with 50-80 TB of data in data warehousing.
• Strong Technical expertise in the complete SDLC and the Production Support functions and environment by handling key responsibilities as the Module Lead, Team Lead, Tech Lead over the years .

TECHNICAL SKILLS

Hardware / Platforms: Windows 98/XP, UNIX

Technology: Data warehousing

BI/ETL Tools: Informatica Power Center 9.5/9.1/8.6/8.1/7. x Informatica DT Studio,Informatica Cloud,Informatica Data Quality 8.6.1

Programming Languages: SQL, PL/SQL

Databases: Oracle 9i, Oracle 10g,sqlserver2008,Netezza,Teradata,Aws Redshift

Version Control Systems: Confidential, SVN

Other Tools & Utilities: Toad, Control M, Mercury Quality Center

PROFESSIONAL EXPERIENCE

Confidential, Agoura Hills, CA

Cydcor Date Warehouse Senior ETL/Aws Redshift developer

Responsibilities:

• Analyzed Business requirement and involved in designing the schema for the reports.
• Played a major Role in designing the ETL processes and Framework as per the business and reporting requirement.
• Extensively worked on Informatica cloud to build ETL mappings in order to extract, transform and load data into Amazon RedShift from oracle database and Salesforce.
• Extensively worked in blending the data from oracle and salesforce into Aws Redshift.
• Connected informatica cloud to wave analytics and pushed the datasets as per the reporting requirements.
• Experience in scheduling the ETL load jobs in cloud.
• Performed 24/7 on call Production support duties for nightly ETL batch loads.
• Involved in basic report development using wave analytics
• Coordinated with reporting team, business users in the effort of QA testing.
• Managed the Code Deployment across Environments.

Confidential, Woodland Hills, CA

Senior ETL Developer

Responsibilities:

• Analyzed Business requirement and involved in designing Enterprise Reporting System.
• Played a major Role in architecture and design of ETL processes and Framework as per the business and reporting requirement.
• Extensively worked on Informatica tool to build ETL mappings in order to extract, transform and load data into data warehouse of 50-70 TB size.
• Performed Informatica Administrative activities like creating Integration Services,
• User Accounts, Repositories, Folders and manage them.
• Extensively worked on performance tuning at Informatica and database level.
• Created the Batch Scripts (Windows, UNIX shell) to run ETL Jobs automatically.
• Experienced in scheduling ETL Batch jobs in ControlM Scheduler
• Performed 24/7 on call Production support duties for nightly ETL batch loads.
• Involved in design and development of Master Data Management project to integrate product metadata from different sources.
• Involved in basic report development using Business Objects
• Coordinated with reporting team, business users in the effort of QA testing.
• Managed the Code Deployment across Environments.
• Involved in fixing the bugs identified in the Legacy system.
• Download the Partner files from API and ingest into Redshift using Python.
• Migrated all on premise data from FTP servers and backups to Amazon S3 using Python.
• Set up the incremental process to move the data from SQL server into Redshift automatically.
• Done the ETL by applying the transformations using Hive SQL and Amazon data pipeline.
• Moved 20 TB of Historical data from SQL server to Redshift using Attunity cloud beam and custom python scripts

Environment: Informatica 9, SQL Server 2008 R2, MDS 2012, Master Data Maestro, Oracle 10g, WinScp, Amazon Redshift, Attunity Cloud Beam, Python, Perl, Hive, Simple Storage Services (S3), Elastic Map Reduce (EMR), ControlM Scheduler. SQL Developer, SQL Workbench/J, Aginity

Confidential, Dublin, OH

Senior ETL /Teradata Developer

Responsibilities:

• Understand the existing EDW Process (code in ab initio) and capture the Business rules and Process Flow.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8 for Classification subject area in ICDW.
• Design the Low level document with the help of HLd and Data model
• Develop the ETL’s using Informatica, Teradata (PDO and Bteq) and UNIX.
• Testing- Unit Testing & Quality Acceptance Test
• Done Technical Code review for Project
• Done Performance tuning.
• Develop the ETL’s using Informatica, Teradata (Mload,FASTLoad,TPUMP and Bteq)
• Integrated various data sources of VSAM, XML and sequential files into staging area.

Environment: Informatica Power Center 9.5,informatica IDQ,Ab initio, Power Exchange, DB2, Teradata SQL Assistant, UNIX Shell Scripting, Flat Files, Mercury Quality Center, MS OFFICE, MS Project, Project Plan, VISIO, Outlook, Unix, Control-M, COGNOS, Erwin, Data Studio, Putty

Confidential

Senior ETL Developer/Lead

Responsibilities:

• Analyze the design
• Develop the ETL’s using Informatica, Teradata (Mload and Bteq) and UNIX.
• Testing- Unit Testing & Quality Acceptance Test
• Done Technical Code review for Project
• Done Performance tuning.
• Staged the Landing Xml files by using Informatica DT studio.

Environment: Informatica Power Center 8X, Informatica DT Studio, Teradata SQL Assistant, Oracle, Netezza, UNIX Shell Scripting, Flat Files, Mercury Quality Center, MS OFFICE, MS Project, Project Plan, VISIO, Outlook, Unix, Control-M, Erwin, Putty