Etl Developer
Resume:
SUMMARY
Experienced ETL Developer with * years of hands-on experience in Informatica
Powercenter, Python & Oracle SQL analyzing, architecting, developing and designing solutions (ETL,Data Warehouse, Data Mart, ODS) in OLTP technologies using star and snowflake dimensional modeling. Self-motivated team performer with experience as Informatica Developer/Informatica cloud(IICS)Developer/SQL Developer/Python.Very flexible at adapting to changing client needs and deadlines. EXPERIENCE
ADP Private - Senior ETL Developer
11/2021 - 06/2023
Automatic Data Processing, Inc. (ADP) is an American provider of human resources management software and services. As a Senior Developer,I have Interacted with Business partners to identify/understand requirements, design specifications, expectations, and Identify ETL specifications & python code requirements based on business requirements and creating ETL Mapping Documents, high level documentation for product owners and data managers. Responsibilities:
CONTACT
*************@*****.***
SKILLS
EDUCATION AND TRAININ
G
Bachelor of Technology
(Computers and Electronics)
Sreenidhi Institute of Science
And Technology – Hyderabad
01/2017
Percentage: 82.88
Basani Bhavana
Created Worklets, Reusable Transformations, and Reusable sessions which are used across most functionalities of the ETL applications using tools like Informatica Powercenter 10.2/9.6/9.1/8.6,Informatica Cloud Intelligent Services(IICS)
•
Worked on Decoding the Python scripts for the automation of monthly runs in informatica.
•
Extensive Experience in Unix Shell scripting,AWK and File manipulation techniques.
•
Good Knowledge in creating ETL design documents,Strong experience in complex PL/SQL packages,functions,cursors,views,materialized views
•
Good problem solving and troubleshooting skills incase of any issues with mappings and their failures
•
Worked on Business Objects technology as part of report generations from Informatica target tables
•
Developed Staging mappings,workflows in Informatica,complex Mapplets,PL/SQL Procedures triggers and performed unit testing and Involved SCD types Type1 and type2.
•
Coordination with the Data modelers and DBAs for helping in understanding the performance bottlenecks and to understand business requirements
•
Involved in Unit Testing and Code reviews of the components to ensure defect free code delivery
•
Informatica Power Center
Developer
•
• Informatica Administration
• Python
• IICS
• Oracle,DB2
• PL/SQL
• Unix Shell Scripting
• Control-M
• Tivoli(TWS)
• Informatica Scheduler
• Tool : TOAD,Tidal
Ticketing tools :
JIRA,Service-Now,BMC
Remedy,Confluence
•
• Health & Finance Domain
LibertyGlobal(Accenture) & Argos (Accenture) - ETL Developer 11/2017 - 11/2021
Liberty Global is a multinational telecommunications company,as a developer,I have Created Complex mappings, sessions, and workflows for real-time migration of data from different sources like Legacy Systems, flat files and other Relational Sources. Argos is a Sainsbury's supermarket chain Operated in UK.In this Project,O have dealt with critical Sales & revenue and annual growth of the stores. Responsibilities:
As the project deals with sensitive Sales data, PROD Data is being monitored carefully
•
Created the projects and groups, plans for developing informatica workflows and applied rules for masking the data and Performing Unit testing and created UT documents
•
Created Unit Test Case document to test various negative scenarios along with positive scenarios as per the Business requirements
•
Participate in Daily Status meetings and providing detailed Status Reports with Business Analysts to meet the Target date to accommodate the new changes in the design
•
Handled Code migration process, which needs to be fulfilled to move the code to other environments.
•
Understanding the Business requirements & Specifications and Extraction Transformation and Loading of data by using Informatica Power center ETL tool
•
Worked on various Tools such as Informatica Powercentre 9,10.2.0, SQL developer, Putty, Toad, Interacting with the clients on a regular basis to discuss day-to-day issues and matters
•
Extensively worked on the transformations like Source qualifier, Lookups(Static & Dynamic Cache), expressions, and joiner, Aggregators, Filter, Rank and Update Strategy transformation and other transformations
•
• Have Good SQL knowledge on joins,sub-queries etc Worked on UNIX scripts to automate Informatica jobs and have good hang of Unix commands
•
Experience in Performance tuning of Informatica mappings by analyzing the mapping & the involved transformations
•
Involved in data analysis and handling the Service Now requests by interacting with business analysts, clients and customers and resolve the issues as part of production support
•
Involved in tracing the issues ahead of reaching to any kind of priority issues hence preventing serious business scenarios and Leading major incident calls, leading problem management and writing post problem reviews
•
Conduct knowledge sharing sessions for the offshore supporters during KT transitions.
•
Provide support for Informatica workflows/mappings developed using informatica 10.2 which are running into production environment at client location
•
Deploying the Code changes to production environment as part of monthly code release
•
DISCLAIMER
I hereby declare that all the information furnished above by me is true to the best of my knowledge.
• Provided support for Pre-Live rehearsals and Production fixes.
Contact this candidate