Ramesh Polamarasetty

Albertsons:

• Design and implementation of numerous complex data pipelines to connect operational systems, data for analytics and business intelligence (BI) systems
• Communicating between the technical and non-technical
• Data analysis and synthesis
• Establish enterprise-scale data integration procedures across the data development life cycle, and ensure that teams adhere to them
• Ensure that the most appropriate actions are taken to resolve problems as they occur and co-ordinate teams to resolve problems and to implement solutions and preventative measures.
• Deployment of artifact through CI-CD
• Provinding handover to business stakeholders

SKY-SNS :

• Shared capability migration to GCP, This project aims the development of data pipeline in GCP ,implement the transformations in GCP by referring to legacy system and migrate the data from legacy systems to BQ.Required to write the Big queries in GCP and implement SCD1 ,SCD2 in BQ
• Responsibilities:
• Leading the team to build ETL pipeline in BQ as per requirement and design documents
• Interacting with Client to understand the requirements and providing the status of development
• Creating LLD to explain data trasformations and flow
• Defining the partition on the tables
• Reviewing the code and approving it for Deployment

Kaiser Permanente - Shared Analytics Healthcare (SAH360) :

• Roles and Responsibilities
• Building ETL mapping & workflows as per business requirement and design documents, data contract sheets, source to target mapping documents, test cases and test logs creation
• Creating the Sessions, Workflows with respective mappings in Power Center Manager, Designer
• Informatica workflows monitoring, failure debugging and fixing
• Scheduling Informatica jobs using Tivoli scheduler
• Creations of mappings using different load types - SCD type 1, type 2, type 3
• Configuration of SFTP job triggering from Informatica server to transfer files
• Taking care of production loads and incidents.

Toyota :

• This project aims the development of Informatica integrations for performing the Extraction, Transformation & Loading of incentive data provided by toyota to dealers and customers.Incentive details like payments,accruals,reversals etc.
• Building ETL mapping & workflows as per requirement and design documents,data contract sheets,source to target mapping documents,test cases and test logs creation
• Creating the Sessions, Workflows with respective mappings in Powercenter Manager, Designer
• Informatica workflows monitoring, failure debugging and fixing
• Scheduling Informatica jobs using Redwood scheduler
• Creations of mappings using different load types - SCD type 1, type 2,type 3
• Configuration of SFTP job triggering from Informatica server to transfer files.

Sunpower Corporation :

• This project aims the development of Informatica integrations for performing the Extraction, Transformation & Loading of data stored in SFDC i.e.Sunpower customer account details.Buildings of data replication tasks,mappings to load data from SFDC and oracle to amazon rds(staging) and then into data mart- Amazon redshift database.
• Building Data replications,mappings,Task flows & scheduling tasks as per requirement and design documents in informatica cloud
• Worked with different source/target relational systems like SFDC, Oracle10g,Amazon rds,Amazon s3 and Amazon redshift

GE Aviation :

• Collaborated with business analysts to understand and define requirements.
• Implemented business logic parameters for model execution.
• Prepared technical design documents and specifications.
• Developed mappings, workflows and tasks using Informatica Power center.
• Tested troubleshooting methods and documented resolutions for inclusion in knowledge base for support team use.
• Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.