Senior Software Engineer, Software developer, ETL Developer

Employer: TIETO INDIA PUNE3 /
Project : Megapolis PMI
Duration: Sep-2017-- TillDate

* Worked on PMI delivery, where we are developing data warehouse on AWS
Cloud using Amazon Redshift. We used Amazon Web Service for this solution.?

* Worked on AWS Redshift, AWS S3, AWS EC2,SQS,SNS,Lymda and Matillion ETL Tool etc.

Created daily audit job which helps analyzing daily data load and job status?

* Extensively used different Components of matillion in transformation and Orchestration job *

* Used Different data compression techniques, Zone maps, Efficient used of Redshift

Architecture to load data.?

* Worked on Amazon S3 bucket for storing files and extracted files from S3 to Redshift. *

* Worked on late changing dimension which is general problem in traditional datawarehouse and resolved *

using Matillion**

* Worked on Security Group , IAM Roles, EC2 Instaces and cluster creation. *

* Understanding and analyzing the application related documents.?

* Developed ETL programs using Informatica to implement the business requirements.
Communicated with business customers to discuss the issues and requirements.
Created shell scripts to fine tune the ETL flow of the Informatica workflows. Production
Support has been done to resolve the ongoing issues and troubleshoot the problems.*

* Developed Informatica jobs by using various transformations to load data
from Flat Files (source systems) to Target Databases using Informatica.?

Informatica Designer was utilized for developing Transformation logics using
transformations, which includes External Source, Transformer, Join, Lookup,
Union and Filter.
* * Used debugger in identifying bugs in existing mappings by analyzing data
flow, evaluating transformations.

* * Pre and post session assignment variables were used to pass the variable values from
one session to other.

* * Designed workflows with many sessions with decision, assignment task, event wait,
and event raise tasks, used informatica scheduler to schedule jobs.

* * Through Tivoli job are scheduled.

* * Debug, and resolved the loading failures by verifying the log files
Tuning and optimizing the mappings to achieve better
performance.

PAST EMPLOYMENT

2)Software developer
Employer: Atos India
Project : Vdfn Telecom BI
Duration: 2013-10- 2017-05

* Understanding and analyzing the application related documents.?
* Developed ETL programs using Informatica to implement the business requirements.

Communicated with business customers to discuss the issues and requirements.
Created shell scripts to fine tune the ETL flow of the Informatica workflows.
Production Support has been done to resolve the ongoing issues and troubleshoot
the problems.?
* Worked on Informatica IDQ as ETL tool for extracting, transforming, loading and cleansing data from various source
data inputs to various targets, in batch and real time.?

* Also used Filter Transformation to Filer data from Mapping and Used Parameterization for the

mapping to load data dynamically.?
* Imported the Jobs from Informatica Powercenter to Informatica Cloud using Powercenter

Application on Informatica Cloud.?