Accomplished Technical Architect offering 10 years' experience in comprehensive design and development of infrastructure and architecture for software projects. Attentive collaborator and communicator from project conception to completion. Creative in devising solutions to improve business operations and meet clients technical needs. Seasoned team leader possessing the technical and interpersonal skills to provide exceptional project deliverables.
AREAS OF EXPERTISE
ETL Team Leader
Informatica PowerCenter 10.x/9.x/8.x
IICS (Informatica Cloud) Data Integration, App & API Integration
IICS - Cloud Data Integration for AWS S3
IICS - API/WebService Integration using REST endpoints
AWS - Cloud Practitioner
Data Modelling, ETL, High/Low Level Design
Strong knowledge on SQL Server and Oracle (PL/SQL)
KPIs and Reporting specific calculations
Tuning ETL/Informatica mappings/process
Migration from PowerCenter to IICS
UNIX Shell Scripting and Autosys Implementation
Performance tuning in Oracle using indexes, joins, partitioning etc.
Root cause analysis of business driven issues.
Strong knowledge on Oracle BIP and OBIEE
Education
Anna UniversityChennai, Expected in 04/2011 ā āBachelor of Engineering:Computer Science - GPA:
Certifications
Informatica Cloud Data and Application Integration R36
Certified SAFeĀ® 5 Agilist (SA)
Work History
Tata Consultancy Services - IICS Developer City, STATE, 04/2018 - Current
Interacted with Business partners to identify/understand requirements, design specifications, expectations and vision in key projects like Enterprise Paymentus Channel (EPCS), Vendor Integrations (like Mitchell, Enterprise, etc).
Identify ETL specifications based on business requirements and creating ETL Mapping documents, high level documentation for product owners.
Handled end-to-end development and implementation of Reconciliation reports between Farmers Insurance (Guidewire) system and payment vendors (like Paymentus, Hyperwallet, etc).
Managed code reviews and ensure that all solutions and process are aligned to architectural specifications and standards.
Handled App & API Integration of Informatica Intelligent Cloud Services (IICS).
Developed integrations using IICS - CDI service for 3rd party vendor Integrations.
Developed Informatica Cloud mappings , Data Synchronization tasks, Data Replication tasks using IICS.
Worked with API/Web Services using application integrations for 3rd party application using JSON Web Token (JWT) authentication.
Configured the IAM policy through the AWS console to securely control access to Amazon S3 resources.
Developed Source & Target transformations to connect Amazon S3 V2 object to read/write data.
Worked with Server Side Encryption (SSE-S3 & SSE-KMS) Encryption before writing the data to Amazon bucket.
Extensively worked on XML Parser/generator, Java transformation through MQ messaging systems.
Implemented a POC using FiveTran - HVR (High Volume Replication) in order to populate a data warehouse from cloud.
Performed configuration and scripting development for Siebel tools to introduce new enhancements and updates.
Created documentation for managed Siebel environments to support multi-disciplinary development efforts.
Collaborated with Mule and Sterling Indicator developers to address integration bugs and performance defects in operational assets.
Analyzed production logs and data for potential issues during troubleshooting investigations.
Developed monitoring for 3rd party integrations with Inbuilt
automation tools like SPLUNK.
Provided solution using eScripting to develop complex business rules based on client requirements.
Implemented auto service request creation using workflows and process invocation methods.
Led corporate-wide initiatives to help guide enterprise and business level goals.
Worked with team colleagues, internal IT and vendor partner to troubleshoot system issues and verify timely completion of upgrades, resolutions and maintenance tasks.
Created workflow diagrams and Gantt charts to clearly demonstrate processes and timelines.
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume: