ETL Developer - Informatica,Teradata, Oracle
Resume:
Yamuna Doraiswamy
***********@*****.***
Summary:
ETL Developer and Application Production Support Engineer, with 8 years of progressively responsible IT experience with specialization in Informatica Power Center, Teradata SQL and its utilities, Oracle, UNIX scripting, and ITIL concepts like Incident management, Change and problem management
Experience in development, testing and deployments of Data Ware Housing solutions using ETL Tool Informatica Power center versions 9.x and 10.x
Proficient in understanding business processes / requirements and translating them into technical requirements
Experience in performing the gap analysis and fine tuning the long running processes by applying performance tuning techniques in Informatica, Oracle and Teradata
Worked in Agile and well versed with all the Agile Scrum framework and process
Having Knowledge of UNIX Commands and Shell Scripting
Having Basic knowledge on Reporting tool Business Objects
Having Basic Knowledge of Hadoop ecosystem and different frameworks inside it
Having Basic Knowledge of KAFKA distributed streaming platform
Proven track of adding values to the customer by developing innovative solutions
Extensive knowledge in resolving application related issues experienced by end-users
Focused, results driven and highly Flexible
Skills:
ETL
Informatica Power center 9.1,9.6 and 10.1,Informatica Power exchange 9.x, Teradata SQL and Utilities – BTEQ,FLOAD,MLOAD,TPT,FEXPORT, TPUMP, Oracle, Big data
Operating Systems
Windows, UNIX,LINUX
RDBMS
Oracle PL/SQL, Teradata SQL, DB2 and SQL server basics
RDBMS SQL tools
Teradata SQL Assistant 14.0,16.0,Oracle SQL Developer, Toad for Oracle, Data Analyst and DB2, SQL Server
Languages
SQL,PL/SQL, Teradata BTEQ, MLOAD,FLOAD, TPT, FEXPORT, Shell Scripting, JCL, JAVA Programming
Scheduling and Monitoring Tools
Control-M, IBM Tivoli Workload Scheduler, CA WA Workstation(ESP)
Ticketing Tools
BMC Remedy, Service Now, HPSM
Server Monitoring Tools
Teradata View Point, OEM, Team Quest
Big data Tools
Cloud era HUE, Info Works
Versioning Tools
Tortoise SVN, Serena Version Manager, GitLab
Other Tools
Mainframes, Hive, HP ALM, Python, Jenkins, Eclipse, Python. Putty, Secure CRT, Win SCP, mRemoteNG, FileZilla, KAFKA
Methods
Agile Scrum and Water fall
Domain
Insurance, Banking and Financial Services, Healthcare
Certifications:
Process : Agile Delivery Foundation
BIPM : Informatica Power Centre Intermediate
Teradata 14 Basics
Experience Summary:
Project Name
Information Management
Duration
From Nov 2019 to Present
Client
Genpact
Line of business
Healthcare
About the project
EDW (Enterprise Data Warehouse)
The project involves building enterprise Data Warehouse, where information are sourced from various Upstream systems (Rxclaims, Anthem, Recap etc.), from which centralized data warehousing is built for data analysis and ensuring the availability of near real time data ready for users
Role
Developer/Production Support
Responsibilities
Responsible for analysis, providing the solutions and implementing the solutions as per Compliance and Standards defined
Worked on large data sets by performing extraction and loading
Providing the Estimates and assigning the workaround and update the status to stake holders
Support the System Testing Team while ST and UAT and provided the required clarifications and solutions for smooth Production Roll-out
Provided the analysis for many Bugs and flaws and fixed it within less time to make sure it won't impact the large group of customers
Provided the Guidance and support to the team while doing the analysis and in bug fixing
Reviewing the Bug fix and Unit Testing
Having Discussion for the Solutions, Fixes and impact analysis with Team and Onsite Counterpart
Worked on developing Informatica, mappings, mapplets, sessions, worklets and workflows
Configured pre- session and post- session tasks involving in calling of shell scripts
Mappings created using various simple and complex transformations
Working on multiple and alternative solutions to reduce the efforts and time to complete the deliverables on/ before time
Working on Automation of the process and providing the support and guidance to the team
Technical Platform
Informatica Power Centre 10.1, Oracle PL/SQL, Teradata 14.1 and its utilities – BTEQ/FLOAD/MLOAD/TPT, LINUX, Big data,KAFKA
Specialized Tools
Tivoli, Teradata SQL Assistant, Oracle SQL Developer, HPSM, Info Works, Git Lab, Jenkins
Location
Richardson, TX
Project Name
Information Management
Duration
From June 2017 to Nov 2019
Client
CIGNA
Line of business
Health Insurance
About the project
The Cigna TSG Operations Organization currently maintains a wide variety of Informatica, Teradata, Oracle, Web, Client-Server, Client-Only, and Vendor/Packaged Applications in support of business organizations across the Cigna Enterprise.
Information Management team integrates the data from different domains like pharmacy, Medical, clinical etc. and convert them in a meaningful format by applying business logics and get its stored in a centralized location for organizations decision making, analysis and reporting purpose.
Role
Developer/Production Support
Responsibilities
Responsible for analysis, providing the solutions and implementing the solutions
Having Discussion for the Solutions, Fixes and impact analysis with Team and Offshore Counterpart
Working on creating solutions and responsible for implementing the solutions
Analysing the business requirements and design the necessary logic for the Creating Automation Tools for monitoring the applications and alert generation in case of any potential issues
Resolving application related issues experienced by end-users
Managing the various escalation processes for multiple work efforts including HPSM tickets, Coding Request issues, Root cause analysis and Escalated workarounds
Resolving ad-hoc requests raised by end-users
Detailed analysis of the existing functionalities and issues for providing optimal solutions
Identifying bottlenecks in the systems and notifying corresponding owners
Identifying performance issues on the existing applications and providing targeted solutions to mitigate and address these issues
Review of Root cause analysis for issues and problems that occur frequently
Consolidating open items/issues on a daily basis and documenting the path forward and steps taken to mitigate these issues to provide as a hand over to the next shift personnel
Addressing production job failures in accordance with their respective SLA's and engaging the corresponding source system counterparts to identify the issue and resolve it
Maintaining Knowledge Repository on an on-going basis and ensure accessibility to this Repository for process betterment as outlined in the Standard Operating Procedures
Technical Platform
Informatica Power Centre 10.1, Teradata 14.1 – BTEQ/TPT, LINUX, Python, Hadoop, Hive,Oracle
Specialized Tools
CA WA Workstation, Teradata SQL Assistant, TOAD for Oracle /Data Analyst 3.1, HPSM, Cloud era
Location
Bloomfield, CT
Project Name
Claim Financials Auto
Duration
From Nov 2016 to June 2017
Client
Continental Casualty Company(CNA)
Line of business
Insurance
About the project
Claim Financials AUTO project aims on introducing a new system to perform claim functionalities for Auto line of business by decommissioning legacy system in focus of mitigating the bottlenecks being faced in legacy system.
Role
ETL Lead Developer
Responsibilities
Creating new interfaces for processing new transformation codes from new Source systems introduced as part of Auto claim migration using Informatica ETL Tool
Participate in Sprint planning session, daily scrum call, Backlog grooming session, Task creation/assignment and burning assigned effort on a daily basis in the Version One Agile project tracking tool
Presenting validation results to the customers to get signoff else move the story to next sprint
Technical Platform
Informatica Power Centre, Informatica Power Exchange, UNIX, Oracle PL/SQL, JAVA
Specialized Tools
Version One, Win SCP, Secure CRT, Control-M,HP-ALM, Service Now
Location
Chennai, India
Project Name
Informatica Upgrade from 8.1 to 9.6
Duration
From April 2016 to Oct 2016
Client
Continental Casualty Company(CNA)
Line of business
Insurance
About the project
The project involves the migration of all the Informatica components from the version 8.1 to 9.6.
Role
Developer/Tester/Production Support
Responsibilities
Devise test cases on the scenarios to be tested post upgrade.
Unit testing and Integration Testing for the Informatica 9.6 code components and check the results with the 8.1 to make sure there is no difference in the data.
Provide support to make sure the service is up and running as expected without issues.
Project Name
BCBS (BASEL Committee for Banking Supervision)
Duration
From Dec 2014 to Mar 2016
Client
JP Morgan Chase
Line of business
Banking and Financial Services
About the project
This project involves the single risk aggregation platform which will provide one source of all CCB (Consumer and Community Banking) risk reporting data at the lowest grain and reconciled to Finance.
Role
Developer/Production Support
Responsibilities
Writing the Teradata BTEQ Script for performing ETL (Extraction, Transformation and Loading)
POC and owned the End to end delivery for the Modules, and worked on Data model reviews with Data modellers, Data element mapping with the BAs and Coding, Code reviews, Unit and Integration Testing and UAT, PROD install and Validation
Design the data flow for loading the data into the Semantic Data Model.
Work with the SME and get the sign-off on the Design for loading the data to summary tables
Design the load process as per the business requirement which demands the different design techniques to be followed in order to meet the business specifications
Work with Business Analyst to get more knowledge on the specifications so that to improve the design and load the data as expected
Analyse the business/technical requirements which is given in the Data Element Mapping Document (DEM) and build the tables and views accordingly which incorporates the transformation rules mentioned as per DEM
Built the Teradata ETL code from the DEM specifications
Perform unit testing thorough UNIX Generic scripts to run the BTEQ by invoking and passing the audit parameters/entries
Check and validate the process flow and data flow from the source till the final FACT/Dimension tables
Data profiling on the Source tables to get the valid values and permissible values
Implemented potent RECON and AUDIT strategies
Once the code is migrated to QA, Coordinate with tester for closure of defects and Sign off
Provided the Post Implementation Validation for the code when the code is migrated to UAT
Coordinate with QA team for closure of defects and Sign off
Refresh the data according to the data refresh process happening in the source
Technical Platform
Teradata, Informatica power centre 9.6, UNIX
Specialized Tools
HP ALM, Win SCP, Tivoli Workload Scheduler
Location
Chennai, India
Project Name
Cards Remodeling – Wave 1
Duration
March 2014 to Nov 2014
Client
JP Morgan chase
Line of business
Banking and Financial Services
About the project
This project is to build an integrated customer data warehouse with a high-performance, scalable, extensible, and providing a 360 view of the customer.
Role
Developer
Responsibilities
Building views according to the business requirement in semantic layer on top of integration layer
Track the Apps throughout the LC and target/track it to completion/PROD migration within the estimated time
Work with the SME and get the sign-off on the DEM (Data Element mapping), Tech Spec and Code approvals
Analyse the business/technical requirements and cascaded the information into the Data Element Mapping Document (DEM)
Built the Informatica/Teradata code from the DEM specifications
Deploying the code in Informatica and perform unit testing
Implementing Semantic view definitions in Teradata and perform unit testing/RECON to compare the IDW
And ICDW Semantic data
Retrofitting the Semantic Jobs with the SOR and INTG Jobs
Once code migrated to QA, Coordinate with tester for closure of defects and Sign off
Provided the Post Implementation Validation for the DCAP and Balance Transfer when the code is migrated to UAT
Coordinate with QA team for closure of defects and Sign off
Provide warranty support for the Apps moved to PROD
Headed the Post Implementation Validation for the Apps moved to PROD - Analyse/Do RECON on the ICDW PROD data with the IDW PROD data to find out mismatches
Building and maintaining customer relationships
Project Name
ITM – Integrated Testing Management
Duration
From April 2013 to Feb 2014
Client
Bank Of America
Line of business
Banking and Financial Services
Role
Tester
Project
The project involves the setting up PROD like environment and perform disaster recovery testing before go live for all the cards related applications.
Responsibilities
Handled BAU projects which involved UAT environment build
Involved in executing huge number of scripts validations in Teradata
Writing SQL test cases and test scripts
Performed Regression Testing of Mainframe Code components
Defect tracking and updates through the Quality Centre Tool
Technical Platform
Mainframe, Teradata and its utilities – BTEQ/MLOAD/FLOAD
Specialized Tools
HP ALM
Location
Chennai, India
EDUCATION
MCA from Anna University.
Contact this candidate