Praveenraj Natesan Email:ade9ev@r.postjobfree.com 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

Contact this candidate