Dec 2024 – Nov 2025 · 11 mos · Connecticut, United States · Remote

Jun 2023 – Jan 2025 · 1 yr 7 mos · Connecticut, United States

May 2021 – Mar 2022 · 10 mos

• Project: Data Forge
• The main goal is to use AWS Services to create a data lake with salesforce tables that includes history for analytics and machine learning consumption.
• Analysis and listed out various snowflake tables required for loading data into S3 buckets.
• Implemented data integration using IICS CDI to extract data from Salesforce using Salesforce connector, and the resulting data was then uploaded to an S3 bucket as a csv file.
• Created glue jobs based on the requirements.
• The airflow job is triggered by lambda to execute as and when a file is placed in the S3 bucket.
• Using Airflow ran a series of glue tasks to compare it to previously processed files to detect changes.
• If changes are detected, the same file will then be processed to AWS redshift tables as type 2.
• The data from Redshift tables that includes history is being used for analytics and machine learning consumption.
• Technologies Used: AWS, IICS, Unix, SQL, Oracle, Informatica, Power Center, Python
• Project: Fire Flood Heritage Initiative
• Role: Project lead
•  Ingestion of pipeline deals into the data warehouse. Previously, only settled deals were loaded into the DWH; however, the business now wants to load all stages of deals.
•  Developed UTRs and reviewed ETL code and technical design documents produced by the team.
•  Given functional and Technical KT’s to freshers and laterals.
• Technologies Used: Informatica Power Centre 10x, SQL Server, UNIX

Sep 2017 – Apr 2021 · 3 yrs 7 mos · Bengaluru, Karnataka, India

• Role: ETL Developer
• This is about handling utilization, Case management and health information online activities for members. The sun setting of the legacy system and migration to TruCare reduces manual effort, increase efficiency and lower costs.
•  Analyzing the requirements that we get from the System Analysts and creating the design/mapping documents.
•  Actively involved in Development, Design, Testing, Prod support, PI Planning and Sprint planning done with Off/Onshore Team for all project related activities.
•  Worked in Agile methodology and actively participated in standup calls and PI planning and daily work reported in Rally.
•  Created mappings and workflows and had done performance tuning at query level and also workflow level partitioning to increase the performance of the workflow
•  Creating Unit Test Cases and project related design documents etc.,
•  Worked extensively on Informatica Power Center tools - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance...
•  Analyzing the source data and working with business users to develop the Model, Sharing Requirements and make them understand the requirement with Offshore. and setup the environments for brand new Projects and For the Informatica Team.
•  Extracted data from flat files and Sql Server using T-SQL and Oracle Database and applied business logic and loaded into oracle Warehouse.
•  Developed mappings/Reusable Objects/Transformation by using mapping designer, transformation developer in Informatica power center.
•  Implemented Informatica recommendations, methodologies and best practices.
•  Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Technologies Used: Informatica Power Centre 10, SQL Server, UNIX

Dec 2013 – Aug 2017 · 3 yrs 8 mos · Hyderabad, Telangana, India

• ETL DeveloperThe DSM Variable Development application was developed to pull information from various external and internal sources and present the information to Commercial Lines Automated System (CLAS) for use in the underwriting process. This process also includes the scoring of in force policies on a monthly basis to support reporting and the conditional renewal process.
•  Involved in variable development and present the information to CLAS for use in underwriting process.
•  Worked on migration of DATA MART code from SQL SERVER to NETEZZA
•  Design and Development of documents includes Requirement, Design, All Phases of testing.
•  Development of mappings, sessions, workflows using parameters, tasks etc.
•  Worked on different Sources such as Relational and Flat files.
•  Automated testing using Informatica DVO.
•  Worked on TFS (Team Foundation Server) activities such as check-in and check-out for the project.
•  Involved in variable development and present the information to CLAS for use in underwriting process.
•  Effective usage of debugger for debugging the flow of data.
•  Preparing SQL Queries for testing the data. It includes Balancing and comparing the data.
•  Creating Parameters for connectivity with database.
•  Maintaining the quality of the products to achieve customer satisfaction.
•  Unit testing and Integration Testing, Usage of DVO tool for QA testing
•  Health check reports generation to maintain the standards.
•  Effective preparation of promote checklists and proceed with the production promotes.
•  Create deployment groups to promote the development code to QA and Production environments.
•  Fixing the production related issued based on priority.
• Technologies Used: Informatica Power Centre 9.5, SQL Server 2012,2014, DVO, SOAP UI, Zena, Power BI