Praveenraj Natesan Email:**************@*****.*** Phone : 860-***-****
SKILL SET:
Informatica 10.x GIT Udeploy
Teradata 15.10 Jenkins. Agile Methodology
SQL Hive ESP CA Work Station
HQL Python
PROFESSIONAL SUMMARY:
Data warehousing Resource and in specific Informatica, Datastage Oracle & Teradata SQL developer with 7+ years of experience.
Strong experience in designing and developing ETL solution for enterprise data warehousing, Data integration, Analytics project and having experience prod support activities .
AREA OF EXPERTISE :
7 years of experience in designing, developing and Implementing advanced ETL solution using Informatica, Datastage, Terdata, SQL, Oracle,Hadoop, Python and Data warehousing
Deploying the code using web applications tools GIT, Jenkins, Udeploy with Continuous Integration (CI) & Continuous Deployment (CD) pipelines.
Work on ESP Scheduling tool that defines, monitor and manage schedules and event-based workloads across all enterprise applications and platforms.
Extensive Experience in Informatica power center ETL tool
Strong Knowledge in developing mappings, sessions and workflows
Used Teradata utilities like BTEQ, fast load, fast export, multiload for data loading.
Expertise with Performance Tuning methods, Partitioning and Pushdown Optimization and concurrent workflow execution in Informatica with large volumes of data load.
Expertise with Performance Tuning of SQL by reading the explain plain and elimination the CPU skew, Product join, reducing spool usage, best choice of PI,
Assisted in building the ETL source to Target specification documents by understanding the business requirements
Folder Creation and Code Migration – Export/Import, Folder Migration, Deployment Group
Worked on Agile based methodologies to iterate quickly on product changes and work through project backlogs.
Responsible for monitoring the production jobs and resolve production issues.
Involve in Release management and deployment activities, work with IT Prod Support to ensure solutions are releasable, maintainable, and scalable
PROFESSIONAL EXPERIENCE :
Client : CIGNA
Accenture : Application Development Senior Analyst\Tech Lead (Hartford – USA)
Project : Cigna - Data and Analytics Dec 2017 –Till date
Responsibilities:
As a Tech Lead I am Responsible for development and Implementation of ETL’s using Informatica and Teradata, BTEQ\Python framework for integration
Lead a team upto 7 members madeup of Client and multiple vendor operating at different geo location
Developed ETL jobs using Datastage
Creating scripts to load data into Teradata that runs through Python Framework
Involved in Requirement gathering, Analysis and propose design for the module.
Assisted in the development and training related to best coding standards and practices for the team
Ensure all the Teradata SQL met the acceptable threshold of metric like Impact CPU, spool space, UPI, NPI, PJI,CPU,I/O Skew.
Analysis on the ETL mapping documents and preparing the design documents as per the Requirement.
Parsed high-level design specification to simple ETL coding and mapping standards.
Involved in Performance tuning at source, target, mappings, sessions, and system levels.
Reviewing the code developed by other team members
Migrate to higher environment using web applications tools GIT, Jenkins, Udeploy
End-to-end experience with the traditional software development lifecycle (SDLC) – from requirements gathering to post-deployment support.
Experience in writing Hive Sql
Used Python to load data into files
Made Scheduling changes as per Client's Requirement such as defining a new job, modifying an existing job, calendar updates, adding predecessors and successors to the existing job in ESP scheduler.
Wrote test plans and executed it at unit testing and also supported for system testing, Performance testing and User Acceptance Testing.
Creation of Production Runbook and supporting release activities
Responsible for monitoring the production jobs and resolve production issues.
Participate on Agile based methodologies to iterate quickly on product changes and work through project backlogs.
Identify areas of improvement and automate the process.
Implemented Audit and Exception Handling process for ETL jobs.
Responsible for setting up of Infrastructure for creating and loading data such as Connection setup, Creating ID to read/write data into database, space requirements.
Worked on Critical production issue tickets.
Using Git for Code Versioning and migration.
Accenture : Senior Informatica Developer ( Chennai – India\ Hartford USA)
CIGNA - Medical Claims Dec 2014 –Dec 2017
Responsibilities:
Developed various simple to complex mappings using transformations such as Aggregator, Expression, Lookup, Filter, Router, Rank, Sequence Generator, Source Qualifier using Informatica
Created and used different tasks like command and email tasks for session status
Used Workflow Manager to create Sessions and scheduled them to run at specified time with required frequency
Monitored and configured the sessions that are running, scheduled, completed and failed
Migrating the Mappings and sessions from Dev-UAT-PROD for any CR request
Analysis on the ETL mapping documents and preparing the design documents as per the Requirement.
Parsed high-level design specification to simple ETL coding and mapping standards.
Implemented Audit and Exception Handling process for ETL jobs that captures Source count, Target count, Rejected count of the ETL job.
Automate the process of Importing Informatica workflows and Dynamic Param file creation.
Involved in Performance tuning at source, target, mappings, sessions, and system levels.
Reviewing the developed code and Migrate to higher environment using web applications tools GIT, Jenkins, Udeploy
Made Scheduling changes as per Client's Requirement such as defining a new job, modifying an existing job, calendar updates, adding predecessors and successors to the existing job in ESP scheduler.
Responsible for setting up of Infrastructure for creating and loading data such as Connection setup, Creating ID to read/write data into database, space requirements.
Create technical design documentation, as required, used to define ETL mappings.
Created Runbook that has instructions to Production Support team on Job details and Scheduling
Used Unix for processing and validation of file and Archiving
Participate on Agile based methodologies to iterate quickly on product changes and work through project backlogs.
Responsible for setting up of Infrastructure for creating and loading data such as Connection setup, Creating ID to read/write data into database, space requirements.
Responsible for monitoring the production jobs and resolve production issues.
Involve in Release management and deployment activities, work with IT Prod Support to ensure solutions are releasable, maintainable, and scalable
Accenture : ETL Informatica Developer ( Chennai – India)
Project : CIGNA Eligibiity and Benefits Feb 2013 –Dec 2014
Extracted the data from Oracle, Flat files and loaded into Cigna Corporate data warehouse.
Used different transformations like filter, Router, lookups, stored procedure, joiner, update strategy, expression, sequence Generator and aggregator transformations to pipeline data to Data Warehouse.
Created Tasks, Workflows, Sessions to move the data at using workflow manager and workflow monitor.
Involved in Performance tuning of various mappings and sessions to increase the performance.
Performed Unit Testing and validated the data.
Worked on Code migration using UDeploy and SVN tools by creating Informatica deployment groups
Create technical design documentation, as required, used to define ETL mappings.
Created Runbook that has instructions to Production Support team on Job details and Scheduling
Worked on ESP Tool which is used to run the Informatica jobs and Schedule it.
Created and used different tasks like command and email tasks for session status.
Worked on implementation of Change Data Capture (CDC) process.
Used Unix for processing and validation of file and Archiving
EDUCATIONAL QUALIFICATIONS:
Bachelor degree in Computer Science and Engineering