ETL Development/Integration Lead Resume

PROFESSIONAL SUMMARY:

8+ years of IT experience in Data Warehousing and Business Intelligence projects to provide software solutions to Capital Market and Insurance domain clients
Expertise in Informatica, SQL, Unix, Autosys technologies
Responsible for requirements gathering, analysis and design of applications and convert the business requirements into technical applications and solutions
Developing innovative high - quality solutions to clients using a variety of technologies conferring with users following the Software Development Lifecycle and Agile models
Collaborated with other software developers, business analysts and software architects to plan, design, develop, test and maintain business applications
Managing and leading the software development teams of 6-8 members with the delivery of multiple complex simultaneous system development projects from design through to release
Responsible for creation and maintenance of technical documentation, performing the peer code reviews for quality deliverables and implementation of best practices
Utilized excellent problem solving and analytical skills to troubleshoot the issues in integration systems and develop the solutions to improve the performance

TECHNICAL SKILLS:

Technologies: Informatica PowerCenter 9.8.x, SQL, Unix, DevOps, Autosys

Databases: Teradata, SQL Server, Toad DB2, Sybase

Tools: CA Workload Automation, Perforce versioning, HP ALM, Atlassian tools (JIRA, Confluence), SecureCRT, DevOps (Bamboo, Bitbucket, SourceTree)Trained in SSIS, QlikView, PL/SQL, MuleSoft ESB, Python scripting, Cognos, Tibco BusinessWorks

WORK EXPERIENCE:

Confidential

ETL Development/Integration Lead

Responsibilities:

Interacted with Business users to know the business requirements and create the Confluence (Atlassian tool) design
Designed and developed the complex mappings, mentoring the team, identifying the automation areas in the project
Proficient in using various transformation like Expression, Filter, Joiner, Aggregator, Lookup, Router, etc. and complex transformations like Transaction Control, Normalizer, XML generator in Informatica PowerCenter
Troubleshooting the invalid mappings and fixing the technical problems, debugging the sessions by utilizing the logs
Understood various client applications, performed the analysis and proposed the end-to-end solution for integration testing
Responsible for application support during UAT testing and acted as an SME in the project
Ensure proper process are established and followed for work that needs to be done on a daily basis
Built the Tibco BW and SSIS capability in the team based on client requirement and deliver the codes as part of the integration
Worked in DevOps to migrate the code and code versioning tools (SourceTree, Bitbucket, Bamboo)
Coordination with various teams to debug and resolve the defects/issues as part of the integration team
Worked on Unix shell scripting to create the automation scripts for file move/edit from one system to another
Worked on SSIS for short-term to replace the existing legacy system with third party vendor tool and integrate the data between upstream and the new portfolio accounting system
In SSIS, I have worked on Containers, Fuzzy Lookup, SCD, XML, flat file and database sources and targets
Created the APIs in Mulesoft ESB to deliver the XML data for integration between upstream and downstream applications in order to replace the existing WSO2 API
Worked on Agile and SDLC delivery framework
ETL Developer/Tester • • Liberty Mutual Client Responsibilities:
Worked on various complex transformations during development and created stored procedures in SQL
Created complex queries as a tester to validate test scenarios in Teradata, SQL Server, and DB2
Coordinated with the client for the enhancement development projects and work requests
Created the test plan and test cases for various work requests and maintain them on HP Quality Center
Performed end-to-end testing to ensure the completeness of deliverable
Event coordinator for project GPTW and organized team outings, fun activities.
Felicitated with Star of the Month twice
Direct communication with the client for offshore deliverables
Quality deliverables within a timeline with zero defects in production

ETL Developer/Tester

Confidential

Responsibilities:

Created the complex mappings from the design documents and analyzed them to understand the flow and defect fixing
Created complex SQL queries in DB2 as a tester and create test cases from the RTM, DDR
Worked on post-production code to analyze the data issue and fixed the defect
Worked with onsite coordinators to understand the requirements
Delivered various modules successfully with zero defects

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship