Venkateshwara
SYNOPSIS
Venkat has 7+ years of experience in the Design, Development, and implementation of Data Warehousing, Data Migration and Business intelligence Solutions using Informatica, Amazon Web Services, Azure and Python.
EXPERIENCE SUMMARY
- 7+ years of work experience in Cloud archData Warehousing, ETL, Development and Documentation.
- AWS certified cloud practitioner and Azure DP 900 certified,Azure fundamentals .
- Building Data pipelines for lift and shift of data from on prem PL SQL server to Azure Synapse using Azure synapse analytics.
- Have built scd1 and scd2 pipelines on Azure synapse. Have built metadata driven frame to load the data from on prem sql servers to Azure Synapse Datawarehouse.
- Have built data flow for reading data from on prem sql server to Azure SQL DB.
- Hands on experience on Informatica Power Center 10x, Informatica Big Data Edition,Informatica Intelligent cloud Services(IICS),Informatica MDM,AWS, Python, Talend ,SQL, Oracle, UNIX, Teradata SQL Assist 13, Mainframes.
- Being an AWS Certified resource, have deep knowledge of AWS compute services like Ec2, Lambda, storage services like S3, EFS and database services like relational DBs, redshift and DynamoDB.Also have good knowledge on Glue, Snowball, SNS, SQS, CloudWatch.
- Proficient in Designing and Architecting data warehousing Solutions and ETL process consisting of data transformation, conversion, loading and data analysis, design and development of mappings and having good knowledge of Oracle SQL, SQL Server, DB2, and UNIX scripting.
- Extensive experience of Product Lifecycle Management Data Migration, Data Profiling and Solution Designing using Informatica Power Center, AWS, Python.
- Proficiently organized and facilitated daily scrum, sprint reviews, retrospectives, sprint and release planning.
- Extensive experience on interaction with system users/Client Engineers in gathering business requirements and involved in developing projects.
- Good Functional understanding of Health Care, Asset Management, Health Insurance and BFSI domain.
- Have built ABC framework(Audit ,balance and control) frame work on python using pandas and other python libraries
- Extensively used ETL methodology for supporting data extraction, transformation and loading process, in a corporate-wide ETL Solution using Informatica.
- Have integration client data on AWS cloud and performed analytics on it.
- Experience in Performance Tuning – Comprehensively implemented all the Tuning Methodologies involving Tuning Sources, Targets, Mappings, Sessions and the System Parameters etc.
- Creating and running jobs through TWS and ESP
- Good interpersonal skills, committed, result oriented, Innovative, Hardworking with quest and zeal to learn new technologies.
- Expertise in Unit testing, Requirement Analysis, development and Release management.
- Knowledge on Software Development Life Cycle (SDLC)
- Good relationship building & interpersonal skills accompanied by exceptional communication skills.
- Have good experience in Teradata 13, Oracle 11g databases and worked with different sources like flat files and Databases.
- Have good knowledge with Mainframe Cobol language, JCL’s, IMS DB and other mainframe tools.
WORK EXPERIENCE
- Worked as Manager at Deltacubes from Apr 2021 – Till Date.
- Worked as Senior consultant for Deloitte from Nov 2016 – Apr 2021.
CERTIFICATIONS
- AWS certified Cloud Practitioner
- Azure DP 900
- Azure Fundamentals
TECHNICAL SKILLS
ETL TOOL
Cloud Technologies
Informatica(Power Center 8x,9X,10x),Talend,IICS ,Talend
AWS,Azure
Scheduling Tool
Mainframe ESP tool, Informatica Scheduling
Operating Systems
Windows XP/2000, Unix
RDBMS
Teradata,Oracle
Other Tools
IBM RAA tool, TeraData OLE TOOL
Programming Language
Reporting Tools
Big data Technologies
Python,Mainframe Cobol,PL SQL, SQL
Tableau
Hive,Spark SQL
RELEVANT PROJECT EXPERIENCE:
Project:#1
Duration: Apr 2021 – Ti
ETL Developer
Location : Hyderbad, India
Experience : 7 Year
Rate: $14 / Hourly
Availability : Immediate
Work From : Any
Category : Information Technology & Services
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
