KARTHIK.

N
Phone: +91-8668056328 | Email: nkarthik22111987@[Link] | Preferred Location: Chennai,
Bangalore, Hyderabad
Email ID: mailmekarthikn22@[Link]

SUMMARY
Cloud Data Engineer and ETL Developer with around 10 years of experience in designing,
migrating, and optimizing enterprise data pipelines using Informatica (PowerCenter & IICS), Azure
Synapse Analytics, Snowflake, and AWS. Proven success in modernizing data platforms across
Banking, Healthcare, Life Sciences, and Insurance domains with a strong focus on automation,
scalability, and best practices.

KEY HIGHLIGHTS
 Proven expertise in IDMC migration projects, including mapping conversion, cloud pipeline
development, unit testing, and deployment.
 Strong understanding of ETL architecture, data modeling, and cloud-native integration
strategies.
 Added advantage of hands-on experience in enhancement and issue resolution of existing
PowerCenter workflows, contributing to overall system reliability and optimization.
 Adept at collaborating with cross-functional teams and delivering business-driven data solutions
with a focus on quality and performance.

TECHNICAL SKILLS
 ETL Tools: Informatica IICS, PowerCenter (v10.4/10.2/9.6)
 Cloud Platforms: AWS (Redshift), Stonebranch
 Databases: Teradata, SQL Server, DB2, TOAD
 Scripting & Utilities: UNIX Shell Scripting, Jira
 Version Control: Jira
 Schedulers: Autosys, Stonebranch
 OS: Windows, UNIX

PROJECT HIGHLIGHTS
 Cloud Migration: Migrated ETL workloads from on-premises to IDMC.
 Standardization: Created ETL best practices and reusable templates to ensure consistency and
scalability
 Automation: Automated workflows with Stonebranch and implemented parameterization for
dynamic ingestion

PREFERENCE
 Preferred Location: Chennai, Bangalore and Hyderabad
 Open to: Cloud Data Engineering or ETL roles in both product-based and service-based firms
SPECIALIST – CLOUD DATA ENGINEER | LTIMINDTREE (APR 2022 – PRESENT)
Client: Lincoln Financial Services
 Designed and implemented scalable ETL workflows using Informatica Intelligent Cloud Services
(IICS).
 Developed parameterized, reusable ETL templates for SCD Type 1/2, CDC, and incremental
loads to standardize integration patterns.
 Created comprehensive source-to-target mapping documents, data dictionaries, and metadata
repositories to ensure traceability and compliance.
 Managed and configured Secure Agents, cloud connections, and performance-tuned jobs to
optimize data load efficiency.
 Applied cloud transformation techniques (Joiner, Lookup, Router, Aggregator, Expression) to
meet complex business logic.
 Worked closely with architects and project managers to gather business requirements, plan
sprints, and deliver robust cloud data pipelines.
 Utilized expression macros, IICS parameterization, and source partitioning to improve job
performance and reusability.
 Ensured data quality, logging, and exception handling were built into all workflows as part of
best practices.

ASSOCIATE – DATA ENGINEER (ETL) | COGNIZANT TECHNOLOGY SOLUTIONS (MAR 2014 – APR 2020)
Client: Abbive

 Developed complex ETL mappings, mapplets, sessions, and workflows using Informatica
PowerCenter (v10.4/10.2) to transform and load data from heterogeneous sources.
 Designed reusable ETL components for data cleansing, transformation, and aggregation using
transformations like Lookup, Router, Aggregator, Joiner, and Update Strategy.
 Created and maintained UNIX Shell Scripts to automate file handling, job orchestration, and
environment setups.
 Worked with parameter files, workflow variables, and Informatica scheduler for job
configuration and dynamic execution.
 Performed peer code reviews, validated performance benchmarks, and enforced best coding
practices across the team.
 Managed repositories for version control and ensured seamless migration across environments.
 Coordinated with onshore teams during requirement gathering, technical design reviews, and
defect triage meetings.
 Provided production support, resolved performance bottlenecks, and ensured data accuracy and
SLA adherence.
PROJECT HIGHLIGHTS
• Cloud Migration: Migrated on-premise ETL workloads from Informatica to Azure Synapse
Analytics using IICS, with data ingestion from ADLS Gen2 and AWS S3.
• ETL Standardization: Developed reusable ETL templates and established best practices to
enhance maintainability, scalability, and performance.
• Workflow Automation: Automated data workflows using Stonebranch and implemented
parameterization for dynamic and environment-specific file ingestion.

EDUCATION QUALIFICATION
• [Link] (Computer Science) – SRM University, Chennai.
• M.C.A (Master of Computer Application) – Shanmuga Industries Arts and Science College,
Tiruvannamalai.
• B.C.A (Bachelor of Computer Application) – Shanmuga Industries Arts and Science College,
Tiruvannamalai.