SUMMARY

• 6+ Years of Experience in IT/Data warehousing, with Proficiency in ETL/ELT, Teradata and Strong Expertise in SQL queries.
• Worked in Informatica Power Centre in 8.6.1, 9.0.1, 9.5.1.9.6.1 for ETL/ELT In Implementing large Enterprise Data warehouse using Change Data Capture (CDC) and SCD - 2 for 5 years 7 Month.
• Excellent experience in performance tuning of ETL Job using Informatica Pushdown Optimization, Partitioning & Teradata Utilities Likes FastLoad,Multiload and TPT
• Have excellent Working experience in Teradata version 12.0 & 14.0 and Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including Flat Files.
• Good Understanding of Database concept.
• Expertise in writing /analysing/Migrating/converting large/complex queries in to cross RDMS platform (Oracle, Terdata, postures SQL).
• Excellent experience in Data Modelling, creating High-level Design to Low-level Design and creating Database and table structure in backend RDBMS Database System.
• Worked on Informatica Informatica Information life cycle management (ILM) tool for Data Archival and restore.
• Good in UNIX operating system- Shells Scripting.
• Good knowledge on scheduling tool - AppWorx.
• Worked on AWS cloud postgres Database
• Worked on Informatica power Exchange connectors
• Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation, Testing (UAT/SIT), production Deployment and knowledge Management.
• Worked in the Project Management Document like UPP, BCP, MOM, and Traceability Matrices.
• Have more then 2 year of experience in project management procedure.
• Possess good analytical and logical thinking abilities, combined with Quick learning ability, good interpersonal and managerial skills.
• Have Team leading experience of more then 2 years
• Six Sigma Certified professional, with constant involvement in process improvement of Existing application running in production Environment.

TECHNICAL SKILLS

Informatica: Informatica Power centre 8.6.1 and 9.0.1, 9.0.5, 9.6.1, Informatica TDM for Masking.

Languages: Teradata 12.0&14.0, Oracle PL/ SQL 9i, 11g Basic UNIX Command and UNIX scripting Teradata 12.0&14.0, PostgreSQL AWS cloud database.

Tools: Informatica ILM Data Archival and Enterprise Data Manager for the Entity Management, AppWorx for workflow scheduling

IDE: PL/Sql Developer, putty software, Wincp, Filezilla as a interface to Unix Server, Teradata Assistant

PROFESSIONAL EXPERIENCE

Confidential

Environment: Informatica power Centre 9.6.1.Oracle 11i, AWS Cloud PostgreSQL Database

Technology: Data warehousing Informatica, Unix Scripting.

Tool: Oracle SQL Developer, putty and Wincp, appworx . for Scheduling workflows

Developer & Project Leader

Responsibilities:

• Worked for understanding the manual process of Project Management and deals related to Distributed power and submitted the Requirement Specification document to client
• Worked to design ETL model and provided parallel ETL Architecture Model to Source data from various source to single integrated database.
• Worked to Create ETL design by creating Mapping, mapplet, Workflow, Parameter file and prepared dataflow chain in appworx .
• Worked to create ETL mapping and integrated data from Multiple Enterprise Database and loaded Historical data to cloud based post gre SQL database.
• Worked to create Unix Script for full Automation of ETL workflow to load data from 2 sources and have it loaded in single table for each subjective data
• Worked to create PostgreSQL Query for tableau reporting, have worked on to prepare tabular report in tableau
• Worked on POC to connect Tableau with cloud database and to generate .TBD file.
• Provided Database Queries help to Tableau Development team and involved in preparing Tableau reports.

Confidential

Environment: Informatica power Centre 9.0.5, Teradata 14.0.

Technology: Data warehousing Informatica,, Teradata 14.0,Unix Scripting.

Tool: Teradata Assistant, putty and Wincp, Approx. for scheduling workflows

Developer & Project Leader

Responsibilities:

• Worked for understanding the manual process of collecting Prediction data for various deals related to Equipment finance team, prepared requirement analysis and current model presentation and demonstrated to SALEs and Marketing team
• Worked to design ETL model and method to provide final prediction analytical Data to Sales team.
• Worked to Create ETL design by creating Mapping, mapplet, Workflow, Parameter file and prepared dataflow chain in appworx.
• Worked in Teradata for developing the Validation Script As per Spec.
• Worked with SAS team to prepare Script to call SAS R program to generate prediction data along with Loan Data on the basis of Each Loan id.
• Worked with DA to validate data end to end and logged all the UAT test case in ALM tool.
• Prepared Prod move document along with Run Guide to move all the ETL component to Production Environment
• Provided first run support for the jobs running in production, involved in validating and explaining first version of automated report to Sales and Marketing team.

Confidential

Environment: Informatica power Centre 9.0.1,PL/Sql Developer, Teradata assistant

Technology: Data warehousing Informatica, Oracle 9i, Teradata 12.0 & 14.0

Tool : Teradata Assistant, PL/SQL Developer, Appworx for Scheduling workflows

Developer & Module Lead/Technical Lead

Responsibilities:

• Involved as Enterprise Data warehouse Developer for different Database and Schema, Interacting Client for Demonstration of Different Module, gathering design requirements, implementing the same.
• Involved in Mapping design and development, Validation Scripts, UAT and Testing.
• Worked for design the Mapping and pipeline Architecture & Design of overall flow of data from sure to access layer (Dim & Fact Table Layer)
• Worked in Teradata for developing Bteqs, Fast load Load, Fast export scripts& integration of Bteq queries with UNIX shell script for complete end to end automation .
• Involved in resolving the tickets and issues related to previously developed Mapping & Application present & running in production.
• Understanding Client Business Process and Requirement, and implementing in System.
• Creating documentation required for resolving the issues and demonstration of Tools.
• Created document for moving ETL components to production from testing environment
• Work on preparing & Maintaining run guide when ever new changes deployed to production
• Worked in preparing UAT test case and Executing that in ALM, for every code release on Monthly/Quarterly basis.
• Worked with Data analyst team to understand and explain function view of the all ongoing changes.

Confidential

Environment: Informatica power Centre 8.6.1, PL/Sql Developer, Informatica TDM, Putty

Technology: Data warehousing Informatica, oracle 9i

Tool : Informatica Data Archival With Enterprise Data Management Tool (ILM),AsLM( for test case execution.

Developer

Responsibilities:

• Involved as Data Warehousing Developer for different Database and Schema.
• Interacting Client for Demonstration of Different Module, gathering requirements, implementing the same and resolving Clients issue in respective module.
• Worked extensively with Informatica 8.6.1 for Data cleansing and Data Loading.
• Involved in Mapping design and development and Validation.
• Worked to Archive Data from Production Database Server to Other server for Data warehousing.
• Worked in Oracle pl/sql for developing the insert and delete queries for Archival Process.
• Involved in resolving the tickets and issues related to custom Data Loading, Data Masking and Data Archiving.
• Understanding Client Business Process and Requirement, and implementing in System.
• Creating documentation required for resolving the issues and demonstration of Tools
• Provides Month End Support and Preparing monthly status reports.