Sai Krishna P. Email & Phone Number

Data Engineer + API Development with hands-on experience in Information Technology with good knowledge in Data Warehousing, Data Modelling, Business Intelligence, Analytics and ETL processing.• Having database experience in Oracle, Greenplum, IBM DB2, MySQL, AWS Aurora, Vertica and Microsoft SQL Server.• Having good understanding in Data Modelling, Data Architecture and Design development process.• Having experience in developing ETL pipelines using Python with Pandas.• Worked on AWS Services S3, EC2, EMR, Cloud Formation, Cloud Watch, Athena, Glue, Step Functions, Dynamo DB, SNS, Secret Manager.• Having good knowledge in SQL, Stored Procedures, Performance Tuning and Shell Scripting.• Worked on Implementing Data Lake to migrate data from multiple various sources to S3 in multiple phases.• Replicating data from various systems like RDBMS, Third-Party applications, XML, JSON, CSV, Parquet, Orc and Sqp to transform the data for analytical purpose (decision making and predictive analysis)• ETL experience using Informatica Power Center 9.6.1 and proficient in optimizing query performance, performance tuning of mappings, sessions, workflows and worked on transformations like Transactional Control, UDF’s and SCD’s.• Experience using Attunity data replication tool, tasks to ingest the data in real time to targets as CDC and FL.

• 

  Srm Ist Chennai

  Bachelor'S Degree