Senior Informatica ETL & Data Governance Engineer
Resume:
DILIP KUMAR TADAKAMADLA
Senior Informatica / ETL & Data Governance Engineer
*********@*****.***
Columbus, GA, 31909
PROFESSIONAL SUMMARY
Over 12 years of extensive IT experience specializing in Big Data architectures, enterprise Data Warehousing, and multi- platform ETL development pipelines.
More than 8 years of hands-on technical experience designing, implementing, and optimizing high-velocity data pipelines within the Informatica software ecosystem.
Over 9 years of deep lifecycle expertise using Informatica PowerCenter to design complex structural mappings, workflows, and session task dependencies.
Over 6 years of professional experience deploying Informatica DEI / BDM (Big Data Management) frameworks to scale heavy data lake ingestions.
Over 4 years of hands-on experience architecting modern data integration workflows using Informatica Intelligent Data Management Cloud (IDMC).
Proven track record of configuring end-to-end automated data lineage tracking models utilizing Informatica Enterprise Data Catalog (EDC) and AXON.
Highly proficient in modern cloud data warehouse design, including extensive pipeline optimization configurations natively within Snowflake.
Formally validated with an active Snowflake Pro Certification, specializing in optimized staging, variant data handling, and query tuning.
Expert in implementing Type 2 Slowly Changing Dimensions (SCD Type 2) in cloud environments using unified MERGE conditions to secure chronological data accuracy.
Specialized in engineering idempotent warehouse ingestion layers that handle duplicate or out-of-order event retries without corrupting base fact tables.
Expert at configuring dual-execution parameters inside Informatica DEI to seamlessly toggle pipelines between Spark and Native engines, minimizing compute costs.
Skilled in executing automated threshold-based data profiling, structural metadata cataloging, and automated quality rule remediation loops to eliminate silent pipeline failures. Experienced in managing multi-tenant Hadoop environment directories, HDFS space quotas, and secure perimeter access configurations using Kerberos, Apache Knox, and Apache Ranger. Verifiable success collaborating with cross-functional technical teams, business analysts, and product support divisions across the United States, United Kingdom, and APAC regions. TECHNICAL EXPERTISE MATRIX
Informatica Suite: IDMC, Cloud Data Governance &
Catalog (CDGC), PowerCenter, BDM/DEI, EDC, IDQ,
AXON.
Data Governance & Quality: Data Lineage Mapping,
Data Profiling, Metadata Management, Source-to-Target Rule Remediations.
Cloud Platforms & DWH: Snowflake (Pro Certified), AWS S3, Google Cloud Storage, BigQuery, OCI.
Databases & Analytics: Oracle SQL/PL-SQL, Hive
(HQL), MongoDB, Teradata, MSSQL, XML, JSON.
Big Data Ecosystem: Spark, HDFS, Impala, Oozie,
Scala, YARN, HBase, Knox, Apache Ranger.
Scripting & Orchestration: Python, Unix/Shell Scripting, Control-M, Autosys, TWS (IBM Scheduler), Jenkins,
Bitbucket.
•
•
•
•
•
•
•
•
•
•
•
•
•
•
PROFESSIONAL EXPERIENCE
Senior ETL & Data Governance Developer Sept 2022 – Present DATSON360 • CLIENT: KAISER PERMANENTE, CALIFORNIA, US Implemented and managed comprehensive Data Lineage and Data Quality solutions within Informatica IDMC to protect enterprise data assets.
Performed detailed data profiling, structural metadata cataloging, and automated data quality rule configurations across multiple domains.
Analyzed end-to-end data flows, operational metadata records, and rigid source-to-target mapping logic definitions using PowerCenter and IDMC.
Collaborated actively with data governance teams, business stakeholders, and technical engineers to enforce data compliance.
Engineered secure variant and structured landing tables inside Snowflake to seamlessly ingest semi-structured API data payloads.
Reworked downstream consumption views and analytical querying scripts within Snowflake to improve data velocity for multi-tenant vendors.
Implemented Type 2 Slowly Changing Dimensions (SCD Type 2) in Snowflake cluster schemas using unified MERGE conditions.
Designed idempotent warehouse ingestion blocks to eliminate duplicate processing spikes caused by distributed network retries.
Senior Data Engineer / ETL Developer Oct 2021 – Aug 2022 VIRTUSA LTD • CLIENT: NATIONAL WESTMINSTER BANK, LONDON, UK Supported metadata management architectures and end-to-end lineage documentation initiatives via Informatica EDC, AXON, and CDGC frameworks.
Prepared comprehensive code-based mapping specifications by extracting precise functional parameters from business user profiles.
Designed physical target objects in Informatica BDM/DEI from relational Oracle tables and unstructured MongoDB collections.
Developed robust ETL mapping trees to transform assets seamlessly across disparate sources using advanced BDM/DEI transformations.
Configured large-volume INSERT and UPDATE bulk patterns within BDM/DEI mappings running in Hive execution mode. Extracted, flattened, and parsed complex unstructured XML and JSON payloads from distributed source arrays into structured dimensions.
Orchestrated large-scale cloud data migrations from legacy Oracle storage arrays into Google BigQuery platforms via IDMC Taskflows.
Monitored execution statistics, managed testing workflows, and successfully resolved environment and performance bottlenecks.
Senior Data Engineer / ETL Developer Apr 2020 – Sept 2021 VIRTUSA PTE LTD • CLIENT: MONETARY AUTHORITY OF SINGAPORE, SINGAPORE Extracted and enriched unstructured complex XML schema payloads, loading them safely into structured Hive and MSSQL tables.
Manually designed rich dimension and lookup source frameworks to accelerate data enrichment and reporting efficiencies. Developed, maintained, and supported core PowerCenter workflows leveraging Expression, Filter, Joiner, Sorter, and Router transformations.
Reworked legacy PowerCenter code trees to support shifting payroll and CoreHR functional business requirements. Managed multi-tenant Hadoop environment permissions, directories, and HDFS space quotas securely via Kerberos configurations.
Orchestrated data lake access controls and security perimeters using Apache Knox and Apache Ranger architectures via Informatica DEI.
Built and deployed automated CI/CD code transport mechanisms utilizing Bitbucket repositories and Jenkins execution paths.
Conducted exhaustive data validation, rigorous reconciliation loops, and duplicate checks to certify high-quality asset delivery.
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Senior Data Engineer / ETL Developer July 2018 – Mar 2020 TECH MAHINDRA • CLIENT: UOB BANK, SINGAPORE
Extracted, cleansed, and loaded banking assets into the enterprise Data Lake while gathering functional metadata requirements.
Analyzed business rules to define technical mapping instructions, logical schemas, and structural physical table configurations.
Developed high-velocity mappings leveraging advanced transformations such as Lookups, Routers, Aggregators, and Update Strategies in PowerCenter.
Deployed robust data lineage tracing setups using Informatica Enterprise Data Catalog (EDC) to boost transparency metrics.
Automated high-volume batch runs and complex scheduling cross-dependencies inside the Control-M Enterprise scheduling application.
Programmed connected and unconnected lookup strategies to conduct rigorous data validation before reporting layer exposures.
Managed heavy data lake workloads by optimizing DEI/BDM jobs to execute via both Spark and Native engines, reducing overall compute costs.
Governed secure storage definitions (HDFS) and cluster access paths utilizing Kerberos authentication and Apache Ranger.
ETL Developer Jan 2016 – Jan 2018
JOBLINE AGENCY • CLIENT: NEC ASIA PACIFIC, SINGAPORE Analyzed business requirements to establish precise ETL rules, functional specs, and relational target transformations. Designed, developed, and maintained complex PowerCenter mapping logic using Sequence Generators, Aggregators, and Stored Procedures.
Developed and orchestrated automated workflows and physical execution tasks inside the Informatica Workflow Manager interface.
Extracted, aggregated, and loaded relational data pipelines from multiple sources (SQL Server, Oracle) into target systems.
Maintained repository metadata integrity across environments using PowerCenter Designer, Workflow Monitor, and Repository Manager tools.
Migrated release deployments systematically through multi-tiered environments from Development to QA, UAT, and Production.
Supported QA and UAT testing phases by conducting source-to-target tracking, code defect remediation, and system validations.
Utilized PowerCenter Designer to guarantee environment and repository schema stability. EDUCATION & CREDENTIALS
B.Tech in Information Technology 2012
Jawaharlal Nehru Technological University, Hyderabad Professional Certifications: Snowflake Pro Certification (2026) • AWS Cloud Solutions Architecture Training • Google Cloud Platform (GCP) Data Engineering Training.
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Contact this candidate