ETL Informatica/IDMC Developer (10 Years)

ETL-Informatica/IDMC Developer

Bindupriya Tamma

**********.*****@*****.***

Contact: +1-980-***-****

Professional Summary:

Overall 10years of specialized experience in the IT industry as an ETL Developer in different domains like Healthcare/ Financial, Domains of IT projects following the SDLC process such as analysis, design, coding, testing, and deployment and support.

• 10 years of Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Informatica Cloud as ETL tool on Oracle, Teradata, AWS Redshift, Snowflake and SQL Server Databases.

• Experience with ETL tool Informatica 10.x/9.x in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring and Installing Informatica power center tool, IICS and and scheduling the workflows and sessions.

• Experience with Data integrations from cloud based and on-premises databases with the help of Informatica Intelligent cloud Services (IICS).

• Designed, Implemented and developed ETL processes using IICS Data Integration and developed cloud integration mapping templates for SCD1, SCD2 applications.

• Designed enterprise-scale ETL/ELT pipelines using Informatica PowerCenter and Informatica IDMC for large datasets.

• Led cloud data migration projects migrating on-prem databases to Snowflake with zero-downtime strategies.

• Built real-time CDC pipelines into Google BigQuery on GCP using Informatica Cloud connectors.

• Developed complex SQL and PL/SQL procedures to support data transformation and validation.

• Implemented Informatica PowerExchange for high-throughput change data capture (CDC).

• Architected scalable ELT solutions on Snowflake with micro-partitioning and clustering.

• Managed Informatica IICS objects: Mappings, Mapping Tasks, Taskflows, and Processes.

• Executed data Migration plans from Oracle and DB2 to Snowflake and Google BigQuery.

• Tuned SQL queries and indexing strategies across Oracle, SQL Server, and PostgreSQL.

• Automated ETL runbooks using UNIX Shell and Control-M for scheduled workflows.

• Integrated Salesforce and Veeva CRM data into enterprise warehouses via Informatica.

• Implemented SCD Type 1/2 logic using Informatica PowerCenter to maintain history.

• Designed mapping logic in IDMC for complex data transformations and data quality checks.

• Performed data validation and SIT for end-to-end Migration and integration projects.

• Developed Snowflake data models and stages for efficient ELT processing.

• Built GCP-based ingestion frameworks to load data into Google BigQuery from GCS.

• Created robust error-handling and audit trails in Informatica mappings and workflows.

• Optimized ETL performance through pushdown optimization and partitioning strategies.

• Developed snowflake queries to accommodate ETL IICS requirements.

• Experience in preparing, deploying scripts and migrating the code to higher environments QA, UAT.

• Experience in using GitLab, Jenkins, U-deploy software to migrate the code with the help of creating branches and modules.

• Experience in preparing unit test cases and ensured that the results are right before moving to QA and Production.

• Excellent interpersonal and communication skills, and developers across multiple disciplines.

• Designed and coded application components in an Agile environment.

• Resolving production issues for any scheduled jobs failures and reporting issues to the concerned teams.

• Worked in Agile sprint iterations and experienced with TFS, JIRA, RALLY boards.

• Demonstrated ability to quickly grasp new concepts, both technical and business related and utilize as needed.

• Flexible and versatile adapt to new environments and hardworking and self-motivated. Technical Skills:

ETL Tools Pyspark,Informatica Intelligent Cloud Services (IICS) CAI & CDI, Informatica Power Center 10.x/9.x, IDMC,

Dimensional Data Modeling Star Schema Modeling, Snowflake Modeling, SCD Type 1, SCD Type 2, FACT and Dimensions Tables, Physical and Logical Data Modeling, DataWarehouseConcepts,OLTP,OLAP, ODS, DataLakes and Datamart

RDBMS Oracle, SQL Server

Database Snowflake,SQL Server, Oracle, PL-SQL, T-SQL, Teradata, AWS Redshift, Amazon S3, Dbeaver, Azure, Snowflake

Languages SQL, PL/SQL, Shell Scripting, SSIS, REST-API Scheduling Active Batch, ESP, Control M, Autosys,Unix Shell scripting DataMigration/Reporting

Tools

Jenkins, GitLab, U-deploy, Tableau

Environments UNIX, Windows.

Professional Experience:

Fiserv, NY Feb 2025 to Present

Role: ETL / IDMC Lead

Responsibilities:

• Lead Business Analysis and Requirements Collection and preparation of Mapping specification Documents..

• Lead defining logical and physical database models for building new enterprise data warehouse in cloud to replace existing on-premises warehouse.

• Effectively using IICS Data integration console to create mapping templates to bring data into staging layers from different source systems like Teradata, Flat Files, AWS S3.

• Wrote advanced SQL scripts for data reconciliation and anomaly detection.

• Lead Deployments in Informatica Cloud CDI and CDQ solutions for master data quality and integration.

• Migrated legacy ETL jobs from PowerCenter to IDMC/IICS with automated conversion scripts.

• Implemented role-based security and access controls in Snowflake and Google BigQuery.

• Lead and Developed stored procedures and PL/SQL packages to encapsulate business logic.

• Extracted and staged data from AWS S3 into Snowflake using Snowpipe and Informatica.

• Implemented near-real-time replication using CDC to minimize lag during Migration.

• Built orchestration Taskflows in IICS for conditional execution and dependency management.

• Tuned Teradata and DB2 database objects for large-scale analytical queries and ETL loads.

• Implemented data lineage and impact analysis for Informatica mappings and IDMC pipelines.

• Automated deployment pipelines and CI/CD for ETL artifacts across environments.

• Performed performance tuning of SQL queries and execution plans for Snowflake loads.

• Lead and Designed data lake ingestion patterns on GCP and integrated with Google BigQuery.

• Created comprehensive monitoring and alerting for ETL jobs using Autosys and Control-M.

• Conducted root-cause analysis and production support for Informatica and database incidents.

• Implemented CDC with minimal latency to Google BigQuery for streaming analytics.

• Led cross-functional teams during large-scale Migration to Snowflake and GCP.

• Developed IICS mapping parameters and variables to support SQL override, created mapplets to use them in different mappings.

• Developed IICS mapping tasks to load into staging tables and then to Dimensions and Facts.

• Lead and Created IICS is attributed to extracting data from various sources, transforming data, and loading into data warehouses. Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables in IICS.

• Worked on Snow SQL and snow pipe and designed warehouse size of snowflake for different types of loads.

• Extensively worked on SSIS packages and SSIS queries to optimize it and improve performance.

• Created ETL(SSIS) process to transfer data from OLTP Files to data warehouse, scheduled and monitored jobs.

• Used Debugger to test the mappings and fix the bugs. Involved in Performance tuning at source, target, mappings, sessions, and system levels.

• Worked on various sources like SQL server, Redshift, Teradata to process it with the help of REST-API and load it into JSON, flat files.

• Prepared migration document to move the mappings from development to testing and then to production repositories. Involved in peer reviews and mentoring team members.

• Shares learning and coaching experience through knowledge transfers between peers.

• Involved in automating the process by creating jobs through Active Batch. Independent Blue cross,PA Mar2023 to Jan 2025

Role: Informatica/IICS Teradata Developer

Responsibilities:

• Requirement Gathering and Data Analysis of all supporting systems.

• Designed Informatica mappings and data flows. Used Debugger wizard to troubleshoot data and error conditions.

• Understand Business Requirements and translate into IICS Technical Specifications.

• Maintained staging area between source and target, performed all cleansing operations, aggregations etc for IICS ETL applications.

• Developed reusable Informatica mappings, mapplets, and transformations to accelerate delivery.

• Implemented data masking and PII protection across ETL processes and target systems.

• Wrote complex SQL for data aggregation, window functions, and analytical reporting.

• Migrated batch workloads to ELT patterns leveraging Snowflake compute elasticity.

• Designed backup, restore, and recovery procedures for cloud data warehouses.

• Implemented incremental load strategies and change detection in IDMC to reduce costs.

• Integrated Azure Blob Storage as source with Informatica for hybrid cloud ETL.

• Performed capacity planning and cost optimization for Snowflake and GCP BigQuery.

• Created metadata-driven ETL frameworks enabling rapid Migration and onboarding.

• Built data quality rules and profiling using Informatica CDQ to ensure trustworthy data.

• Executed cross-database data syncs between Oracle, SQL Server, and PostgreSQL.

• Designed partitioning and distribution schemes to optimize BigQuery and Snowflake queries.

• Automated end-to-end testing, deployment, and rollback procedures for ETL releases.

• Implemented logging, SLA tracking, and operational dashboards for Informatica jobs.

• Collaborated with data architects to define canonical models for Snowflake and GCP.

• Leveraged PowerExchange to extract mainframe and legacy data into modern warehouses.

• Enhanced query performance using advanced SQL tuning, indexing, and statistics management.

• Implemented enterprise-wide Migration governance, change control, and cutover plans.

• Trained teams on Informatica IDMC, PowerCenter best practices, and cloud Migration patterns

• Communicated with business customers to discuss the issues and IICS requirements.

• Using Informatica Cloud mappings, mapping tasks to load data from multiple Source databases. Designing IICS ETL strategy for both Initial and Incremental & CDC Loads.

• Used Parameters, Variables and Parameter Files for various Database Relational Connections to eliminate migration issues. Developed Informatica Cloud processes to facilitate Daily, Weekly, monthly loading of data.

• Extensively worked on all the IICS transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank, Union, Joiner, Source Qualifier, etc.,

• Performed partitioning of Teradata tables using stored procedures and Informatica Passthrough partitions and loaded huge volumes of data to flat files using Informatica.

• Created sessions and workflows for processing and populating the dimensions and facts in the star schema.

• Involved in the scrum discussions and agile methodology of development of the process of the project.

DFW Securities, India Jan2022 to Sep2022

Role: ETL Developer/Support

Responsibilities:

• Collaborate with Project Manager, Business analysts for requirements gathering, business analysis and designing of End-to-End solution.

• Day to day interactions with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.

• Extracted data from Oracle database transformed and loaded into Oracle DB according to the business specifications. Developed mapping parameters and variables to support SQL override.

• Involved in Dimensional modelling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions, and measured facts.

• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

• Worked with transformations Source Qualifier, Update Strategy, Expression transformation, SQL Transformation, Router transformation, Lookup Connected and Unconnected.

• Working with informatica Partitions and Pushdown Optimization.

• Responsible for Designing Logical and Physical data modelling for various data sources SQL, Oracle.

• Wrote complex T-SQL Queries involving multiple tables with joins.

• Created Unix Shell Scripts to automate sessions and cleans the source data.

• Documentation of ETL process for each project and KT to Offshore and team.

• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer, scheduling of the workflow. Used Debugger to test the mappings and fix the bugs.

• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

• Involve in creating Oracle Objects like Table Structures, Stored Procedures, Functions, Cursors, Triggers, Packages as a part of the release. Involve in Documenting ETL Design Document for test plans, test cases, test scripts, test procedures.

• Supporting User Acceptance Testing and Deployment Process.

• Experienced on Capital assets such as homes, cars, and investment properties.

• Supporting Change Request management and Production Support Task after Deployment. ADT Securities, India Jan2017 to Dec2021

Role: Informatica Developer

Responsibilities:

• Understand the business requirements from Business Analysts.

• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.

• Designed and developed Informatica mappings to extract master and transactional data from heterogeneous data feeds and load.

• Worked on loading data from several flat files to XML targets.

• Designed and procedures for getting the data from all systems to the Data Warehousing system.

• Created the environment for the staging area, loading the staging area with data from multiple sources.

• Developed production-grade Python applications using object-oriented and functional programming principles.

• Automated data pipelines and ETL tasks with Python scripts and scheduled jobs using cron and Airflow.

• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to Target systems.

• Used session parameters, mapping variables/parameters and created parameter files for imparting flexible runs of workflow based on changing variable values.

• Worked with static, dynamic, and persistent cache in lookup transformation for better throughput of sessions.

• Designed and Developed ETL jobs to extract data from multiple sources and load it in data mart.

• Used Workflow manager for session management, database connection management and scheduling of jobs.

• Worked on OLAP and OLTP data warehouse architectures for data integration from source to target.

• Created UNIX shell scripts for Informatica tool to automate sessions.

• Monitored sessions using the workflow monitor which were scheduled and running and completed or failed.

Magna Infotech, Hyderabad, Telangana May2016 to Dec2016 Role: Jr. Informatica Developer

Responsibilities:

• Worked with various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.

• Involved in the development of Informatica mappings and tuned for better performance.

• Extensively used ETL to load data from flat files to Oracle. Analyzed the source system of ETL Maps.

• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table. Adjusted in Data Model and SQL scripts to create and alter tables.

• Worked extensively on SQL, PL/SQL, and UNIX shell scripting. Designed and developed the fact/dimension entities.

• Compared actual results to expected results and suggested changes to mappings owned by others.

• Worked on a new data model to form a single security master for all the Data Marts and retrofit the existing and new securities in the FACT tables. Performed the tuning of ETL SQLs, Designed ETL mapping based on Existing ETL logic.

• Designed and developed mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.

• Developed reusable transformations and mapplets transformations.

• Extracted the data from the flat files and other RDBMS databases into the staging area and populated onto the Data warehouse. Used Type 1 and Type 2 SCD mappings to update slowly Changing Dimension Tables.

• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values. Co-ordination with the Client Business & Systems team for QA.

• Performing the Implementation, Unit testing of the build, pre-production activities and post-implementation activities, Plan Production deployment and verifying the mapping functionality.

• Worked as a fully contributing team member with independent planning & execution responsibilities.

Education Details: B.Tech,ECE Passed out from JNTU KAKINADA, in 2016.

Contact this candidate