Professional Summary
12+ years of experience in Information Technology predominantly in the area of Insurance, Pharmaceutical, Entertainment & Banking domain. Expertise in ETL technologies and Informatica suite, Informatica Power Center (PC), Power exchange (PX), Database programming. SQL loader, Database tuning, building complex queries. Strong Technical experience in Data Model, Design, Development, implementation, customization, Maintenance and production support of ETL Migration, Integration and Data warehousing projects using InformaticaPowerCenter tool. 2+ years of experience in Cloud platform (AWS). Certified AWS Solution Architect in Associate Level 3+ Years of development experience with Big Data Hadoop cluster(HDFS, MapReduce frameworks), Hive, Pig, Python 2+ Years of Experience on working using Spark Technology. -Familiar with data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling and and advanced data processing. Experience optimizing ETL workflows. Hands-on experience with Amazon EC2, Amazon S3, Amazon RDS, VPC, IAM, Amazon Elastic Load Balancing, Auto Scaling, Cloud Front, CloudWatch, SNS, SES, SQS and other services of the AWS family. 6+ Years of Experience in Data Warehouse Architecture and Design implementing data warehouses of various domains and sizes. Responsible for designing the Logical and Physical Data Model, implementing the ETL flows that performs initial and incremental batch loads, performing pre-production test, production monitoring etc. Have exposure to Erwin and Database Modeling. 3 years of experience in Teradata development, Load Utilities and tool such as SQL assistant. Experienced in both SDLC and Agile methodologies Scrum. Selecting appropriate AWS services to design and deploy an application based on given requirements. Implementing cost control strategies. Setup/Managing CDN on Amazon Cloud Front to improve site performance. Solid programming knowledge on Spark,Python. Good working experience on Hadoop tools related to Data warehousing like Hive, Pig and also involved in extracting the data from these tools on to the cluster using Sqoop. Experience on handling cluster when it is in Safe mode. Good knowledge of High-Availability, Fault Tolerance, Scalability, Database Concepts, System and Software Architecture, Security and IT Infrastructure. 9+ years of ETL experience with InformaticaPowerCenter (9.1, 8.6, 8.1.1,10.1) in developing and administering ETL mappings with Designer (Source Analyzer, Target Designer, Transformation Developer, Mapping designer, Mapplet Designer), Repository Manager, Workflow Manager, Workflow Monitor& Admin console. Lead onshore & offshore service delivery functions to ensure end-to-end ownership of incidents and service requests. Experience in using Oracle development tools such as Tool for Oracle Application Development (TOAD), SQL developer, SQL* Plus and PL/SQL Developer. All the projects which I have worked for are Open Source Projects and has been tracked using JIRA. Excellent written and verbal communication skills including experience in Business meetings, SOW proposals, project presentations, design solution walkthroughs, publishing regular status reports, conducting status meetings, handling/resolving situations like customer facing issues etc. Excellent in documentation skills. Have released Technical Design Documents, Design SPECS, Mapping document, E-R model, DDL scripts documents etc. of precise quality. Have performed various testing activities like Unit Testing, Integration-System Testing, Regression Testing, User Acceptance Testing and ensured that the code is ideal.