Skip to content

Nageswara Reddy Nattla

Senior Informatica Developer • n*******************@gmail.com • +19******776 • linkedin.com/••••• • drivetube.ai/•••••

Professional Summary

Senior Informatica Developer with 11+ years of experience designing, developing and migrating enterprise ETL pipelines and cloud data warehouses. Skilled in Informatica PowerCenter and IICS/IDMC, Snowflake migrations, AWS-based ingestion, Unix/Python scripting, data profiling (IDQ/CDQ), and DevOps-driven deployments using Ansible, Datical and Jenkins. Proven ability to translate business requirements into scalable ETL architectures, optimize performance through partitioning and tuning, and support end-to-end SDLC including SIT/UAT and production monitoring.

Technical Skills

Databases: Oracle 11g,12c,Snowflake,Teradata,SQL Server,DB2,MongoDB,SQL
Cloud and DevOps: AWS EC2,AWS S3,AWS RDS,AWS IAM,AWS SQS,AWS SNS,AWS DynamoDB,Amazon CloudFront,Ansible,Jenkins,Datical
Testing: Informatica Data Quality IDQ,Cloud Data Quality CDQ,Informatica MDM
Data and Analytics: Tableau
Tools and Methodologies: Informatica PowerCenter,Informatica Intelligent Cloud Services IICS,IDMC,Informatica PowerExchange,Pentaho Kettle,SAP BODS,IBM DataStage,Qlik Attunity,GitHub,Bitbucket,JIRA,Change Data Capture CDC,Snowpipe,SnowSQL
Skills: Unix Shell Scripting,Python 3.x,PL
Scheduling and Orchestration: Autosys,Control-M,CA7,Tivoli
BI and Reporting: PowerBI,Qlik

Work Experience

Comerica Bank
Senior Informatica Developer
September 2024 – Present
Worked at Comerica Bank on Commercial Loan Servicing Modernization migrating DB2/mainframe data to Snowflake and building cloud-based ETL pipelines.
Tech Stack: IICS, IDMC, Informatica PowerCenter, Informatica PowerExchange, AWS S3, Snowflake, CA7, Control-M, Ansible, Datical, Jira, Shell Scripts, Oracle, DB2, Bitbucket
  • Designed and deployed Informatica PowerCenter and IICS mappings to migrate DB2 mainframe datasets into Snowflake, using PowerExchange for mainframe extraction and AWS S3 as staging.
  • Developed IICS synchronization tasks to incrementally ingest MongoDB source data into S3 and integrated Snowpipe for automated Snowflake ingestion.
  • Tuned Informatica sessions (pipeline and partitioning parallelism, block size, data cache, target-based commits) to improve throughput for large-file ETL jobs.
  • Led ETL development and unit testing; authored HLD/LLD and deployment documentation and coordinated SIT/UAT with QA and business stakeholders.
  • Automated environment deployments and code migrations using Ansible and Datical; scheduled and monitored production jobs via CA7 and Control-M.
  • Performed data profiling with Cloud Data Quality (CDQ), monitored production jobs, diagnosed failures with shell scripts and PMCMD, and tracked defects in Jira.
Bank of America
Senior Informatica Developer
May 2022 – July 2024
Supported a financial-services data hub and DWH, ingesting diverse sources into SQL Server and Snowflake to enable reporting and analytics (PowerBI/Tableau).
Tech Stack: Informatica PowerCenter, IICS, IDMC, Snowflake, Snowpipe, SnowSQL, SQL Server, Informatica IDQ, Informatica MDM, Jira, Bitbucket, Datical, Ansible, Jenkins, Autosys, Shell Scripts, PowerBI, Tableau
  • Developed Informatica PowerCenter and IICS mappings to ingest flat files, XML/JSON, PDFs and RDBMS tables into staging/ODS and DWH layers for the Enterprise Sub Issues Reporting System.
  • Built a near-real-time pipeline to integrate cloud financial data into Snowflake via IICS; configured Snowpipe and SnowSQL for automated S3-to-Snowflake loads.
  • Improved ETL performance with partitioning and cache tuning; implemented stored-procedure transformations to invoke SQL Server procedures within mappings.
  • Led ETL development activities, created parameterized mapplets/variables to eliminate hardcoding, and supported SIT/UAT and QA handoffs.
  • Executed data profiling with Informatica IDQ and managed metadata using Informatica MDM; logged defects and tracked work through Jira and Bitbucket.
  • Automated migrations of SQL and mapping assets using Datical and Ansible; integrated CI pipelines with Jenkins and scheduled production runs via Autosys/Control-M.
Novartis
ETL Developer
June 2021 – May 2022
Worked on Novartis APQR data hub migrations and integrations, moving SAP/SQL Server data into Snowflake and integrating Salesforce sources.
Tech Stack: IICS, IDMC, Informatica PowerCenter, DataStage, Snowflake, Snowpipe, Control-M, Shell Scripts, Python 3.x, Oracle, AWS S3, Attunity
  • Designed and implemented IICS mappings to migrate APQR data from on-prem SQL Server to Snowflake using S3 staging and Snowpipe for streaming loads.
  • Migrated ETL code from DataStage to Informatica using migration utilities and validated data with source teams and business users.
  • Developed Salesforce-to-Snowflake integration workflows in IICS for near real-time synchronization of CRM data into the warehouse.
  • Authored UNIX shell and Python scripts to orchestrate Informatica jobs, execute mappings and automate extraction from diverse sources.
  • Performed performance tuning and monitoring with Control-M to meet SLA windows and reduced job runtimes through mapping optimizations.
  • Prepared HLD/LLD, estimated efforts based on technical impact analysis, and produced deployment and test documentation for deliveries.
State of Rhode Island
ETL Developer
June 2019 – June 2021
Delivered offshore techno-functional ETL support for a Long Term Services & Support program including AWS-based integrations and Curam data migration.
Tech Stack: IICS, IDMC, Pentaho Kettle, Tableau, AWS EC2, DynamoDB, SNS, SQS, IAM, Oracle, Shell Scripts
  • Developed IICS/IDMC transformations and jobs to support Long Term Services and Support dataflows, leveraging AWS EC2, DynamoDB, SNS, SQS and IAM for integrations.
  • Led data migration into IBM Curam using Pentaho Kettle, performing rigorous data validation and testing to ensure integrity and model conformance.
  • Created high-performance SQL scripts and SCD Type 1/Type 2 mappings to support monthly and weekly reporting and recurring adhoc requests.
  • Built Tableau dashboards and reports to visualize operational KPIs and support stakeholder decision-making.
  • Performed daily database maintenance, monitoring and performance tuning; executed unit tests and supported configuration management across environments.
  • Automated ETL execution with shell scripts and managed code migrations and versioning for release cycles.
Novartis
ETL Developer
May 2018 – June 2019
Participated in Novartis migration from DataStage to Informatica and supported DWH operations, ETL design and production support activities.
Tech Stack: Informatica PowerCenter, DataStage, PL, SQL, Oracle, Autosys, Shell Scripts, SFTP
  • Migrated workloads from DataStage to Informatica PowerCenter and developed parameterized mappings, taskflows and mass ingestion processes into the DWH.
  • Authored PL/SQL procedures, functions and packages to support complex transformation logic and ODI integration processes.
  • Supported production operations for normal, bulk, initial and incremental loads; diagnosed and resolved data and performance issues.
  • Collaborated with enterprise DW peers to expand the data warehouse platform and applied SQL performance tuning to critical queries.
  • Automated ETL workflows using UNIX shell scripts and Autosys; integrated SFTP for secure file transfers and process automation.
  • Maintained technical design documentation, data flow diagrams and configuration management for migrations and deployments.
Barclays
ETL Developer
February 2015 – April 2018
Worked on customer correspondence and lifecycle ETL initiatives, extracting from legacy sources and loading into Teradata for reporting and notification processes.
Tech Stack: Informatica PowerCenter, PowerExchange, VSAM, Teradata, BTEQ, MLOAD, TPUMP, Unix Shell Scripts, XML Transformations, Remedy, Jira
  • Developed 14 Informatica mappings across 8 source files and validated inputs using Unix scripts to support customer-letter generation workflows.
  • Integrated VSAM mainframe sources with PowerExchange for synchronous CDC processing and loaded transformed data into Teradata using BTEQ/MLOAD/TPUMP.
  • Built XML parsing and generation transformations (XML Source Qualifier, XML Parser/Generator) to handle complex source/target formats.
  • Implemented CDC-based ETL patterns to streamline incremental processing and reduce full-load overhead for correspondence timelines.
  • Performed mapping debugging and performance tuning to remove bottlenecks, resolved production incidents via Remedy and tracked defects in JIRA.
  • Scheduled and automated report deliveries and ETL workflows; created documentation and detail reports to support analysis and validation.

Education

Jawaharlal Nehru Technological University Hyderabad (JNTUH)
Bachelor of Technology in Computer Science and Engineering • June 2014

Certifications

Oracle SQL Expert — Oracle

Powered by Drivetube · Create your own profile at drivetube.ai