SUMMARY

• 10 years of strong experience in teh IT industry as a Informatica Developer and Azure Data factory include experience in design, development, and implementation with various business domains like Insurance and Health Care
• Good hands on Azure Data Factory
• Good noledge of understanding teh Abinitio graphs and components
• Good experience in create Sessions, Reusable worklets and workflow in Workflow Manager and scheduled teh workflow at specified frequency
• Good experience in Informatica Power Exchange and IBM Mainframe
• Good experience in datamap creation using Informatica Power Exchange
• Good experience in conversion projects
• Experience inPerformance Tuning and Query Optimization
• Good experience in agile and Waterfall methodology
• Experience in creating deployment group and deploying teh informatica ETL code from One environment to another environment
• Experience in creating Tivoli webform to schedule teh jobs in IBM TWS scheduling tool.

TECHNICAL SKILLS

ETL Tools: Informatica, Azure Data Factory, Informatica Power Exchange, Mainframe

Databases: SQL Server, Oracle 8i/9i/10g/11g, Exadata, HIVE

Database Tools: Azure data studio, Zeppelin tool

Scheduling Tool: IBM Tivoli (TWS)

Operating Systems: Windows, Unix

Data Modeling Tools: Visio, Erwin

PROFESSIONAL EXPERIENCE

Azure data factory Developer

Confidential, Oregon

Responsibilities:

• Building teh pipelines to copythe data from source to destination inAzure Data Factory
• Worked on creating dependenciesofactivities in Azure Data factory
• Creating Stored ProcedureandScheduledthem inAzure Environment
• Monitoring Produced and Consumed Data Setsof ADF
• Successfully creating theLinked Serviceson teh source and as well for teh destination servers
• Moving data fromHIVEto Azure SQL DB with teh halp ofpipeline and data flows
• Createdautomated workflowswith teh halp oftriggers
• Pumping data betweenSQL DB andADLS usingFlows
• Scheduled JobsinFlowsandADF Pipelines
• Migrating teh data from different sources to teh destination with teh halp of ADF
• Creating PipelineswithGUIin Azure Data Factory
• Scheduling Pipelinesand monitoring teh data movement from source to destinations
• Transforming data in Azure Data Factory with theADF Transformations
• Creating Multiple Data SetsinAzure
• Performance tuningof SQL queries and stored procedures usingSQL Profiler and Index Tuning Wizard.
• Trouble shoot any kind of data issues or validation issues
• Created stored procedures usingCommon Table Expression (CTE)
• Provide support of production applications by trouble - shooting issues, and developing, testing and migration of Data Bases.
• MovingCSV files from Azure blob to on-prem server(Linux)
• Gathering requirements from teh client managers and implementing them as tasks as per requirements
• Debuggingthe scripts which were developed by teh other team mates
• Delivering theworkloadsbefore teh deadlines
• Understand teh business processes and applicationfunctionality relevantto their area as well as an understanding of related applications in adjacent areas.
• Author technical design of functional specifications and progress teh solution from design though teh software development life-cycle to implementation. TEMPHas a strong understanding of, and ensures adherence to, teh IT processes and standards required.
• Provide production support of applications in production by trouble-shooting issues, proposing solutions, develops and tests fixes, and migrates solution.
• Develop andunit testapplication programs as specified in Technical Designs.
• Obtaincode reviews from Senior Application Developerand ensure dat all programming standards and policies are adhered to.
• Obtain Technical Designs and Unit Test plan reviews from Senior Application Developer and perform Tech Designs and Unit Test plan reviews of other developers.

Environment: Azure Data Factory, Azure SQL DB, HIVE, Linux, WindowsDURATION OF THE PROJECT: Jan 2020-Till date

Senior Informatica Developer

Confidential

RESPONSIBILITIES:

• Teh Role of an associate is Team Lead/Senior informatica Developer.
• He TEMPhas been involved in understanding teh requirements and getting clarifications from Business.
• He TEMPhas been involved in teh Analysis, Design and Development of ETL application using Informatica, Oracle and Unix.
• He TEMPhas been involved in teh preparation of Impact analysis and design documents for each requirement.
• He TEMPhas developed Informatica mappings, Oracle procedures and Unix shell scripts
• He TEMPhas worked on teh effort estimations for each requirement.
• He is responsible for providing technical support to his team members.
• He is responsible for reviewing teh team member’s deliverables.
• He TEMPhas worked on teh performance tuning activities.
• He is responsible for sending daily updates to Onshore.
• He is responsible for coordinating teh production migration activities and validating teh post production implementation.

Environment: Informatica,Power Exchange, Mainframe, IBM Tivoli, Windows, Unix, Linux, Oracle

Senior Informatica Developer

Confidential

RESPONSIBILITIES:

• Teh Role of an associate is Team Lead/Senior informatica Developer.
• He TEMPhas been involved in understanding teh requirements and getting clarifications from Business.
• He TEMPhas been involved in teh Analysis, Design and Development of ETL application using Informatica, Oracle and Unix.
• He TEMPhas been involved in teh preparation of Impact analysis and design documents for each requirement.
• He TEMPhas developed Informatica mappings, Oracle procedures and Unix shell scripts
• He TEMPhas worked on teh effort estimations for each requirement.
• He is responsible for providing technical support to his team members.
• He is responsible for reviewing teh team member’s deliverables.
• He TEMPhas worked on teh performance tuning activities.
• He is responsible for sending daily updates to Onshore.
• He is responsible for coordinating teh production migration activities and validating teh post production implementation.

Environment: Informatica,Power Exchange, Mainframe, IBM Tivoli, Windows, Unix, Linux, Oracle

Informatica Developer

Confidential

RESPONSIBILITIES:

• Teh Role of an associate is Informatica Developer.
• He TEMPhas been involved in understanding teh requirements and getting clarifications from Business.
• He TEMPhas been involved in teh Analysis, Design and Development of ETL application using Informatica, Oracle and Unix.
• He TEMPhas been involved in teh preparation of Impact analysis and design documents for each requirement.
• He TEMPhas developed Informatica mappings, Oracle procedures and Unix shell scripts.
• He TEMPhas worked on teh effort estimations for each requirement.
• He is responsible for providing technical support to his team members.
• He is responsible for reviewing teh team member’s deliverables.
• He TEMPhas worked on teh performance tuning activities.
• He is responsible for sending daily updates to Onshore.
• He is responsible for coordinating teh production migration activities and validating teh post production implementation.
• He TEMPhas been prepared teh Deployment documents for code migration to production.
• He TEMPhas been prepared teh Detailed Design Document and Technical Design documents required for development and Involved in Development and unit testing of teh Informatica Mappings.

Environment: Informatica, Power Exchange, Abinitio, Mainframe, IBM Tivoli, Windows, Unix, Linux, Oracle

Informatica Developer

Confidential

RESPONSIBILITIES:

• Teh Role of an associate is Informatica Developer.
• Analyzing teh Business Requirement Specification Document from teh Client.
• Extensively used Informatica Designer to develop Jobs for extracting, integrating, transforming and loading data into Oracle database.
• Involved in code review and testing review.
• Prepared Test cases for teh Mappings.
• Developed standard and re-usable mapplets and mappings using various transformations like expression, aggregator, joiner, source qualifier, lookup, and Router.
• Testing and debugging of code.
• Fixing teh Issues dat come out of Integration Testing.
• Communicating with teh client for weekly status report.
• Used teh Workflow Manager to creating, validating and running teh workflows, sessions.
• Monitoring teh workflows using teh Workflow Monitor.
• Applied performance-tuning logic to optimize session performance

Environment: Informatica, Windows, Unix, Oracle

Informatica Developer

Confidential

RESPONSIBILITIES:

• Teh Role of an associate is Informatica Developer.
• Analyzing teh Business Requirement Specification Document from teh Client.
• Extensively used Informatica Designer to develop Jobs for extracting, integrating, transforming and loading data into Oracle database.
• Involved in code review and testing review.
• Prepared Test cases for teh Mappings.
• Developed standard and re-usable mapplets and mappings using various transformations like expression, aggregator, joiner, source qualifier, lookup, and Router.
• Testing and debugging of code.
• Fixing teh Issues dat come out of Integration Testing.
• Communicating with teh client for weekly status report.
• Used teh Workflow Manager to creating, validating and running teh workflows, sessions.
• Monitoring teh workflows using teh Workflow Monitor.
• Applied performance-tuning logic to optimize session performance.

Environment: Informatica, Windows, Unix, Oracle