AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF24357
profile image
Masku S AXF24357 Active
IICS Developer in hyderabad
With over 4.2 years of experience in ETL methodologies, extensive work in Informatica PowerCenter and IICS, and proficiency in SQL and UNIX Shell Scripting. Successfully developed and optimized ETL processes, enhancing data integration and transformation for various projects. Demonstrated ability to tune performance and debug workflows, ensuring high-quality data delivery. Involved in all phases of SDLC, from requirement gathering to deployment, with a focus on data accuracy and consistency. Experience in managing complex SQL queries and collaborating with cross-functional teams.
Industries : Data Integration
Share
Hire Masku S
Download PDF
Availability
Full-time
Total experience
4 years
Technical skills
Informatica v10.4.1
4 Years & 2 Months
SQL
4 Years & 2 Months
Oracle
4 Years & 2 Months
iics
3 Years & 2 Months
SQL Server
3 Years & 2 Months
Informatica PowerCenter, IICS (CDI),Azure SQL DW, IBM Netezza, Unix shell scripting., Oracle 11g, Informatica Powercenter, Informatica Intelligent Cloud Services (IICS), AWS Redshift DB, Unix Shell Scripting
Projects
MolinaHealthcare (MOH),USA
December-2022 to December-2024
Description
This project is part of Insurance. This provides end-to-end analysis from Policies, Claims, Premium, Loss Ratio and Growth Rate at higher level and in details the project main objective is to create a central database for data and provide a set of standard reports basic Operational Reporting-Strategic Development. The Operational Reporting Strategic Development, from which it is extracting the data through Flat files and Oracle, Transforming and Loading into Oracle target database in a Data warehouse using Informatica, Building Data marts from Data warehouse tables for Generating Reports.
Roles and Responsibilities
Gather and analyze business requirements, supporting all SDLC phases. Design, develop, and optimize IICS and PowerCenter ETL workflows for seamless data integration. Develop mappings using transformations like Expression, Joiner, Lookup, Aggregator, and Router. Migrate PowerCenter code to IICS and deploy across environments. Implement SCD Type 1 & Type 2 for historical data tracking. Perform performance tuning, troubleshooting, and error handling for ETL processes. Manage workflows, scheduling, and system monitoring to ensure data accuracy and efficiency
Technologies: Informatica PowerCenter, IICS (CDI),Azure SQL DW, Oracle, IBM Netezza, Unix shell scripting.
Industry: Data Integration
CBI Insurance, Louisville, US
January-2022 to November-2022
Description
CBI Insurance is a leading independent insurance agency based in Louisville, Kentucky, providing a range of commercial and personal insurance products. The project aimed to integrate and streamline policyholder, claims, and underwriting data across multiple platforms. The goal was to develop an enterprise-wide data warehouse to enhance analytics, improve fraud detection, and ensure regulatory compliance. The ETL process involved extracting data from various source systems, transforming it as per business rules, and loading it into Snowflake for analytical processing.
Roles and Responsibilities
Developed and optimized IICS ETL mappings for policy and claims data. Designed data integration workflows from Oracle to AWS Redshift. Used transformations like Aggregator, Lookup, Router, and Filter for data processing. Implemented CDC for real-time claims data synchronization. Automated workflows, optimized performance, and ensured data accuracy. Developed error-handling mechanisms and resolved ETL failures. Translated business rules into ETL logic and collaborated with analysts.
Technologies: Oracle 11g, Informatica Powercenter, Informatica Intelligent Cloud Services (IICS), AWS Redshift DB, Unix Shell Scripting
Industry: Data Integration
Work history
ETL Developer • January-2021 to February-2025
Description: I design, develop, and optimize ETL workflows using Informatica IICS and PowerCenter for seamless data integration. I ensure data accuracy, perform troubleshooting, and enhance performance through tuning and error handling.
Education
Bachelors degree in Mechanical Engineering
MVSR Engineering College , Osmania University
2013 to 2018
Language
English - Advanced