Ramesh Gantala

Sr. Informatica Developer

+1-571-***-**** LinkedIn: https://www.linkedin.com/in/ramesh-gantala-169907120/

adwb1m@r.postjobfree.com

Having 15 years of IT experience with a strong background in SDLC, Data Integration tools including Informatica PowerCenter, Informatica Power Exchange and IICS.

Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.

Experience working with Informatica IICS tool effectively using it for Data Integration and Data Migration from multiple source systems.

Experience working with IICS concepts relating to data integration, Monitor, Administrator, deployments, permissions, schedules.

Implemented processes, services and data integrations using APIs.

Expertise in Informatica Power Center 10.5/10.2/9.5/9.0.1/8.6/7 extracting data from Oracle, SQL Server, Teradata databases, Flat files, Web Services, API's, XML & JSON files.

Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookups, joiner, sequence generator, sorter, SQL, XML, stored procedure, Update strategy, Source Qualifier, Transaction Control, Union etc.,

Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.

Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.

Experience in Installation, Configuration of Informatica Power center 10.x/9.x Client, Server in UNIX.

Experience in Performance Tuning and Debugging of existing ETL processes.

Experience in Integration of various data sources like Oracle, Teradata, SQL Server, PostgreSQL and Flat Files in various formats like fixed width, CSV and excel.

Extensively Worked on Slowly Changing Dimensions (SCD) – Type 1, Type 2 & Type 3.

Good knowledge of Data Warehouse concepts – Star Schema, Snowflake, SCD, Normalization/ De-normalization Expertise in SQL/PLSQL programming, developing & executing Packages, Stored Procedures, Functions, Triggers, Table Partitioning, Materialized Views.

Knowledge on Python scripting.

EDUCATION

Post Graduation - Master of Computer Applications – 2005

Batchelor’s Degree – Batchelor of Computer Science - 2002

SKILLS

Informatica Intelligent Cloud Services

Informatica PowerCenter 10x/9x/8x/7

Informatica Power Exchange 10x/9x/8x/7

Oracle 12c/11g/10g/9i/8.x

SQL Server 2008/2005/2000

SQL*PLUS

SQL, PLSQL

GIT Hub

Autosys, Crontab, CRTL-M

Green Plum

Certifications & Trainings

Informatica Power Center 8x/9x/10x

AWS – Certified Developer Associate

Trained on – Snowflake Data Warehouse

Trained on – MSTR, Tableau, Click-view

Shell Scripting

WinSCP, Putty

MS-DOS

Windows 95/98/2000/XP/10

UNIX/LINUX

PL/SQL

Agile Methodology, SAFE

Dimensional Data Modeling

Star Schema Modeling

Snowflake Modeling

PROFESSIONAL EXPERIENCE

Employer: S&P GLOBAL Feb 2015 – Till Date

Client: S&P Global Ratings U.S.A New York, NY

Lead Software Engineer, Data Services

Sr. Informatica Developer/IICS Developer

RADAR - Regulatory Administration Detection and Remediation – combination of 18 applications and provides a customizable dashboard that consolidates and provides easy access to information about corrective actions for Analytical Managers and Quality Officers. This helps to rating Analysts for giving the rating in different roles. Radar has its own application that gives the data to the source tables. We will pull the data from that source system to staging area, dims and fact tables in the data warehouse. Reporting people will generate the different kinds of reports.

Responsibilities

Designed and built IICS mappings to extract data from PostgreSQL, Oracle, SQL Server and loaded into Oracle/Designed the ETL flows for generating flat file extracts as per the business need.

Worked on converting Informatica PowerCenter ETL code to IICS using PC to Cloud Conversion service.

Involved in enhancements and maintenance activities of the data warehouse.

Understanding the data model, mapping specs, raising queries, and resolving with Client.

Developing the mapping, sessions, workflow as per the mapping specs.

Using different transformation like Source-Qualifier, expression, look-up, joiner, Router etc.

Develop the shell scripting for run the workflow.

Creating AUTOSYS and CRON jobs to run the UNIX scripts for automatic process.

Working on daily loads failures in production support.

Will work on the client requests if they will raise requests on miss-match data.

Environment: IICS, Informatica Power Center 10.4/10.2, MSTR, Oracle, SQL Server, Flat Files, AWS S3, Autosys, Crontab, Unix.

Client: Blue Shield of Massachusetts, USA Feb 2011 - Jan 2015

Sr. Informatica Developer

BSCMA is the Insurance sector and tie-up with the US government. DI is the data-warehouse which is having the four data marts and three levels of stages. Like PRESTG, SA, load ready files after load into the data with deferent environment. We are supporting the customers’ data that are joined in this Health insurance sector. DI applications is having development team and support team at the off-shore and we are developing this application as a quickly with support of SL team.

Responsibilities:

Extraction, Transformation, loading of the data into warehouse using Informatica.

Understanding the data model and mapping specs and raising queries and resolving with Client.

Developing the mapping, sessions, workflow as per the mapping specs.

Transformations like Source Qualifier, expression, look-up, joiner, SQL, XML, JAVA, filter etc.

Preparing the XSD file for XML transformation as per the mapping spec.

Getting the XSL file from client and calling from parameter file.

Solved the production issues at Informatica, Unix and Oracle levels.

Working on different shifts and different shift responsibilities when required.

Extensively worked in the performance tuning of the ETL processes using Oracle.

Sending reports to business on time.

Following Agile methodology

Environment Informatica Power Center 8x, MSTR, Oracle, SQL/PLSQL, UNIX, WinSCP, Putty

Client: Blue Shield of California, USA Jan 2009 - Jan 2011

Sr. Software Engineer

Sr. Informatica Developer/Informatica Admin

BSC-DI is the Insurance sector and tie-up with the US government. DI is the data-warehouse which is having the eight data marts and three levels of stages. Like PRESTG, SA, load ready files after load into the data with deferent environment. We are supporting the customers’ data that are joined in this Health insurance sector. DI applications is having development team and support team at the off-shore and we are developing this application as a quickly with support of SL team.

Responsibilities:

Extensively involved in gathering business requirements and translating them into technical requirements.

Used Informatica PowerCenter to extract the data from source system and generate the reports.

Responsible in strictly maintaining naming standards and warehouse standards for future development.

Extracted data from various sources such as Flat Files, XML and Oracle using Informatica Power Exchange.

Created mappings using pushdown optimization to achieve good performance in loading data into Oracle

Created and monitored workflows/sessions using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.

Performed Unit testing, Integration Testing, and User Acceptance testing to pro-actively identify data discrepancies and inaccuracies.

Involved in performance tuning at source, target, mapping and session level.

Prepared design documents, ETL Specifications and migration documents

Maintained daily Tech Tracker for the updates from the team regarding their objects, issues and progress

Involved in Informatica Power Center 8.1.1 Repository upgrade to Informatica Power center 8.6.1

Involved in providing Informatica Technical support to the team members, as well as, the business

Environment Informatica Power Center 8x, MSTR, Oracle, UNIX, WinSCP, Putty.

Client: Hewlett and Packard Dec 2006 - Oct 2008

Software Engineer

Informatica Developer/Admin

CKM - Customer Knowledge Management C360 is an enterprise Business Customer Data Hub which will provide a 360-degree view of customer data for reporting, analytics and data mining that enables targeted marketing, sales and support. It is a one reporting environment that supports the internal needs from Management and Sales and offers a high level of visibility to the corporate and enterprise Customer on their business with the HP.

Responsibilities

Extensively involved in gathering business requirements and translating them into technical requirements.

Implemented Informatica Framework for (dynamic parameter file generation, start, failed and succeeded emails for an integration, Error handling and Operational Metadata Logging).

Implemented sending of Post-Session Email once data is loaded.

Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.

Scheduled various daily and monthly ETL loads using Autosys.

Involved in Production Support in resolving issues and bugs

Responsible in strictly maintaining naming standards and warehouse standards for future development.

Created and monitored workflows/sessions using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.

Performed Unit testing, Integration Testing, and User Acceptance testing to pro-actively identify data discrepancies and inaccuracies.

Involved in performance tuning at source, target, mapping and session level.

Prepared design documents, ETL Specifications and migration documents

Environment Informatica Power Center 7/8x, BO, UNIX, Oracle, WinSCP, Putty.

Contact this candidate