SUMMARY

• Overall 9 plus years of IT experience in Data - warehousing projects as a technical consultant across Insurance, Banking, Credit Card and Retail & Supply domains.
• 8.2 years of strong experience in Informatica (Powercenter) versions and UNIX shell scripting
• 2 years of strong experience in Informatica Master Data Management, Denodo virtualization Tool and Tableau using various excel files.
• Certified Denodo Developer.
• Expertise in Teradata utilities- BTEQ, Fast export, Fast Load and MLOAD.
• Proficient in various databases like Oracle 11g, Teradata and SQL Server.
• Well versed with Data warehousing concepts of slowly changing dimensions (type1, type2, and type3), surrogate keys, star schema and snowflake schema.
• Solid understanding of Extraction, Transformation and Loading (ETL) process and usage of Informatica Powercenter.
• Experience in MDM implementation including Data Profiling, Data extraction, Data validation, Data Cleansing, Data Match and Merge Loads using Fuzzy & Exact Match concepts and Trust Score validation.
• Performed MDM Hub job set-up and executions off Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer/Group and Automation Processes.
• Experience in defining and configuring landing tables, staging tables, base objects, lookups, queries, packages and hierarchies.
• Knowledge of various techniques for Performance Tuning involved with sources, targets, mappings and sessions.
• Install, Design and implement Data virtualization layer using Denodo platform for master data consumption by building Denodo base, derived, and interface views per the requirements.
• Validation of data in virtual data port (VDP) of each environment with VQL shell, Denodo views with actual source data, defined views, and targets data.
• Create JDBC, ODBC, Delimited file, Web Service connections to fetch the schemas and tables using the data sources.
• Create Base views using data sources and VQL along with filters and aggregations, Create Derived views using selection, join, union, minus and intersections.
• Using Restful WS and create HTTP, XML and JSON files using the GET, POST, PUT and Delete options.
• Actively involved in production support and admin activities.
• Insurance Domain certification (LOMA-290).
• LinkedIn - www.linkedin.com/in/gautham-nagaraj-714bb6118

TECHNICAL SKILLS

Tools: - Informatica Powercenter, MDM, Denodo, Tableau.

Operating System: Windows, Linux

Development Platform and Framework: ORACLE, .NET/SQL Server, Teradata

Languages: Python, SQL

PROFESSIONAL EXPERIENCE

Informatica Lead Developer

Confidential

Responsibilities:

• Understanding the business requirements and preparing technical specifications of the client module.
• Developed different mappings like creating dynamic parameter file, master & child loading and reusable Transformations as per the Business requirements to facilitate initial and incremental loads.
• Technical assistance from design and development standpoint.
• Documenting the test case scenario steps followed for various tasks for specific module.
• Planning the test activities and preparation of test scenarios as per customer requirements.
• Customization of various applications/reports and implementation of selected business model.
• Make additional setups to implement new business processes, develop integration test scripts to repair business flow.
• Functional analysis of specifications, tracking tickets arise from customers and resolving problems
• Identify customer’s business flow and gap analysis; provide recommendations in key strategic areas involving competitor performance.
• Design, tracking and coordinating project activities to meet project deliverables
• Develop enhancements, system documentation, and production support and implement procedures for quality improvement and development.
• Developed challenging data quality ETLs to meet the business requirements and data standards.
• Release Coordinator for Production/UAT implementation and migrations.
• Single handedly built an overall CCAR Production job Dashboard report as a value adds.
• Single handedly implemented Gather statistics maintenance on whole of CCAR table and frameworks as a value adds.
• Recently Bank of the West passed the CCAR Fed submission and was one of the few developers worked from initial days of the project.
• Handled the IFRS project for commercial and mortgage loans single handedly.
• Developed the entire ETL model for Credit Risk Modelling and contributed to user and business questions and helped them understand how the project can be implemented in ETL and meet the requirements.
• Create a central data “hub” for party, product, and account
• Acquire party data from existing systems; define rules to create “Master” parties and relationships.
• Create Landing, Stage, Base tables along with Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.
• Validation rules, Trust Score, Queries and Packages setup.
• Creating mapping from Landing to Stage tables using appropriate cleanse functions.
• Preparing match and merge rules using exact and fuzzy logic needed for Match and Merge process.
• Create Base and Derived views in Denodo using JDBC connections.
• Implementing various logic in Derived views using join, union by passing input parameters.
• Creating views and validating data using VQL option in Denodo.

Senior Software Engineer

Confidential

Responsibilities:

• Requirements Analysis by direct interaction with Business Analysts.
• Collect information on various lines of business such as Inventory, Gross Margin, Yarn and Supply chains to understand the requirements and plan the loads.
• Creation of conversion mapping or technical design mapping documents.
• Developing Extract Transform Load (ETLs) programs as per design documents with good Informatica Coding standards.
• Create unit test case and capture the test results for various logics.
• Validate the test results against the requirements across Dev, Test and Prod environments.
• Reviewing and approve other team member’s ETL programs and other technical aspects.
• Maintenance of ETL programs.
• Asset migrations across various environments.
• Post-implementation support
• Production job runs support by identifying the issues and fixing them without impact to SLAs.
• Mentoring New team members.

Informatica Lead Developer

Confidential

Responsibilities:

• Requirements Analysis and Preparing Technical Specification Documents.
• Developing scd-1 and scd-2 mappings using Informatica Powercenter tool.
• Preparing the Teradata BTEQ, Fast export, and Fast Load and MLOAD scripts for loading huge amount of data quickly.
• Writing UNIX scripts for etl parameterizations and processing of flat-files.
• Managing and Monitoring production data loads to ensure data have been loaded into the warehouse properly and the data is ready for reporting.
• Reviewing components that are to be delivered to the client.
• Improving the SQL query and ETL performance and updating the technical documents.
• Involved in unit testing, process testing and preparing migration documents.