ETL Developer with 5+ years in Informatica, Snowflake & Data Warehousing
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Total 5.2+ years of IT experience in developing Data warehouse applications, with extensive work on technologies like Informatica, IICS, IDMC, Snowflake, Oracle, and Unix. Expert in all phases of the Software Development Life Cycle (SDLC), including requirements, design, development, testing, and support. Highly skilled in data migration, cleansing, extraction, transformation, and loading (ETL) from multiple sources to Data Warehouses. Proven ability to implement ETL naming standards, best practices, and performance tuning for Informatica and Snowflake environments, ensuring efficient data processing and quality.
Yogi Vemana University
BSC
N/A – June 30, 2021
Accenture
IICS & IDMC Developer
March 1, 2021 – Present
India
Project Profile-3: Cisco
May 28, 2026 – Present
Designed and implemented end-to-end ETL solutions using Informatica IICS/IDMC for Stage, Dimension, and Fact table loads including SCD Type 1 & Type 2. Developed complex mappings and task flows using transformations such as Joiner, Aggregator, Lookup (Connected/Unconnected), Expression, Router, Update Strategy, Sequence Generator, and Normalizer. Worked with Mapping Tasks, Replication, Synchronization, Dynamic Mapping Tasks, and parameterized workflows with input/in-out parameters. Integrated heterogeneous data sources including Amazon S3, Oracle, Teradata, Flat Files, ODBC, and APIs for real-time data ingestion. Loaded and transformed data from S3 to Snowflake using COPY commands; optimized Snowflake SQL queries and utilized Time Travel, Streams, and Stored Procedures. Performed DDL/DML operations in Oracle including Views, M-Views, Indexes, Joins, and Analytical Functions. Improved performance using partitioning, pushdown optimization, bulk loading, and bottleneck analysis (source, target, mapping, session). Conducted unit testing, production deployment, and post-production support with defect-free releases.
Project Profile-2: PNC Bank, USA
May 28, 2026 – Present
Analyzed business requirements and translated them into scalable ETL and MDM solutions. Designed and developed data integration pipelines using Informatica PowerCenter and IICS. Implemented data ingestion, cleansing, standardization, and transformation processes. Developed Customer, Product, and Supplier master data solutions using Informatica MDM SaaS. Configured match-merge, survivorship, and hierarchy management rules. Built reusable mappings, mapplets, and parameterized workflows for reusability. Integrated data from heterogeneous sources including databases, files, APIs, and cloud systems. Implemented data quality rules, validation logic, and data profiling processes. Performed performance tuning of ETL mappings, SQL queries, and sessions. Managed data warehouse loads including staging, dimension, and fact tables (SCD1/SCD2). Developed and optimized SQL/PLSQL for data processing and validation. Scheduled and monitored batch workflows using enterprise schedulers. Supported data migration, deployments, and release management activities. Collaborated with business, QA, and architecture teams across SDLC phases. Performed unit testing, SIT/UAT support, and production issue resolution. Ensured data governance, consistency, and integrity across enterprise systems. Prepared technical design documents and operational runbooks. Mentored junior developers and enforced ETL/MDM best practices.
Project Profile-1: Subway
May 28, 2026 – Present
Analyzed business requirements and delivered scalable Master Data Management (MDM) and data integration solutions. Designed and developed end-to-end data ingestion, cleansing, and standardization pipelines using Informatica IICS (CDQ & IDQ). Configured Informatica MDM SaaS (Customer 360, Supplier 360, Product 360, Reference 360) data models and entities. Implemented match-merge, survivorship, and hierarchy management to create and maintain golden master records. Built data quality rules, scorecards, and reference data to improve accuracy, consistency, and completeness of master data. Developed governance workflows and stewardship processes within IDMC. Integrated MDM SaaS with downstream applications (Snowflake, Salesforce, and enterprise systems) using REST APIs and CAI. Configured and managed Informatica API Gateway for secure publishing and lifecycle management of data services. Ensured data governance, lineage, and role-based access controls across master data domains. Developed SQL queries and validation logic for data quality checks and reconciliation. Collaborated with business, QA, and deployment teams across SDLC phases. Prepared technical design documents, unit test cases, and deployment artifacts. Performed unit testing, SIT/UAT support, and production deployments. Monitored data pipelines and resolved data quality and integration issues.
Cultural Fit Analysis
The candidate exhibits strong cultural fit through their diverse project experience across different industries, including technology (Cisco), banking (PNC Bank), and retail (Subway). This breadth of exposure indicates adaptability and the ability to work in varied business contexts. Their consistent focus on both on-premise (Informatica PowerCenter) and cloud-native (Informatica IICS/IDMC, Snowflake) data integration and MDM solutions demonstrates a proactive approach to modern data technologies. The emphasis on data governance, consistency, and integrity across all projects aligns well with organizations prioritizing robust data management practices.
Soft Skills & Operational Fit
The candidate demonstrates strong collaboration skills, having worked effectively with business, QA, and architecture teams across various SDLC phases. They have experience in mentoring junior developers and enforcing ETL/MDM best practices. Operationally, the candidate is proficient in preparing technical design documents, unit test cases, and operational runbooks, and is capable of managing unit testing, SIT/UAT support, and production issue resolution. The resume also highlights the candidate as a 'highly motivated, energetic, individual and a team player with good communication and interpersonal skills'.