Satyanarayana rao G.

Satyanarayana rao G.

I have overall 8+ years of experience in Denodo, Snowflake,Azure Databricks and Informatica

New Delhi , India

Experience: 8 Years

Satyanarayana rao

New Delhi , India

I have overall 8+ years of experience in Denodo, Snowflake,Azure Databricks and Informatica

8 Years

Now you can Instantly Chat with Satyanarayana rao!

About Me

I have overall 8+ years of experience in Denodo, Snowflake,Azure Databricks and Informatica Power center

...

Show More

Portfolio Projects

PPL Corporation(Enhancement and Production Support)

Company

PPL Corporation(Enhancement and Production Support)

Description

·         Requirement gathering for small development from business users.

·         Daily monitoring of ETL Jobs .

·         Making enhancements and resolving the batch failures.

·         Investigating the issues and fixing the failures.

·         Creating service now tickets.

·         IBM Infosphere jobs monitoring and fixing the replication issues.

·         Running and monitoring the jobs through Tivoli and Cherwell.

·         Creation of IDRCDC replication subscriptions.

Show More Show Less

Invetment Banking (Ameriprise)

Company

Invetment Banking (Ameriprise)

Role

DevOps Engineer

Description

·         Good understanding of Technical Design Document.

·         Worked on Informatica Power Center tools like Source Analyzer, Warehouse Designer to import the source and target database schemas. Mapping Designer, Workflow Manger and Workflow Monitor.

·         Used transformations like Aggregators, Sorter, lookups, Filters, Expression, Router, Joiner, Source Qualifier, Update Strategy, Sequence Generator

·         Used mapping parameters and variables.

·         Created sessions & workflows to ensure the data to be loaded into the specific tables of DWH.

·         Configured various tasks in the workflows for the dependency by using Command, Event wait, timer and Email task.

·         Involved in unit testing and Performance tuning.

·         Optimizing the mappings by changing the logic to reduce run time.

Show More Show Less

Wellpoint

Company

Wellpoint

Description

§  Responsible for requirement gathering from different Business users as well as application users

§  Involved in detail analysis of the structure of input/output tables, and the required source to target mapping file.

§  Using Informatica Designer, developed mappings, which populated the data into the target.

§  Designed and developed database packages, procedures, functions and triggers on Oracle 9i/10g databases.

§  Understanding business requirement for data acquisition and loading to target .

Show More Show Less

Market Basket

Company

Market Basket

Description

·         Teamed with business analysts to deduce the business requirements to produce effective technology solutions.

·         Worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.

·         Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.

·         Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.

·         Participated in the development and implementation of the MDM decommissioning project using InformaticaPowerCenter that reduced the cost and time of implementation and development.

·         Worked on data cleansing using the cleanse functions in Informatica MDM.

·         Used Informatica ETL Power Center 9.6 for migrating data from various OLTP databases to the data mart.

·         Worked with different sources like Oracle, flat files, XML files, DB2, MS SQL Server

·         Extracted data from Sales department to flat files and load the data to the target database

·         Developed complex mappings using Informatica to load Dimension & Fact tables as per STAR schema techniques.

·         Extracted data from sources like fixed width and Delimited Flat files transformed the data according the business requirement and then loaded into Target Data mart.

Show More Show Less

Petsmart-Pet Retail

Company

Petsmart-Pet Retail

Role

Backend Developer

Description

I am working as a Denodo developer and Snowflake Developer 

Show More Show Less
Share:

Verifications

  • Phone Verified

Preferred Language

  • English - Fluent

Available Timezones

  • Eastern Daylight [UTC -4]

  • Central Daylight [UTC -5]

  • Pacific Daylight [UTC -7]

  • Eastern European [UTC +2]

  • Mountain Daylight [UTC -6]

  • Australian EDT [UTC +11]

  • Australian CDT [UTC +10:30]

  • Eastern EST [UTC +3]

  • Greenwich Mean [UTC ±0]

  • Further EET [UTC +3]

  • Dubai [UTC +4]

  • New Delhi [UTC +5]

  • China (West) [UTC +6]

  • Singapore [UTC +7]

  • Hong Kong (East China) [UTC +8]