ETL

MANGALA TRIPATHI

469-***-**** ********.*******@*****.***

EDUCATION: Bachelor of Technology, Computer Science Engineering, Gandhi Engineering College, India

SUMMARY

●5 years of experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation using Informatica PowerCenter.

●Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration, and user acceptance testing.

●Extensive ETL experience using Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor and Repository Manager).

●Experienced in reporting tools like Business Objects (BO).

●Experience in designing and Developing complex Mappings using Informatica PowerCenter with Transformations such as Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter and Sequence Generator.

●Experience in SCD Type1, SCD Type 2, and SCD Type 3 mappings, Dimensional Data Modeling, Star/Snowflake Modeling, Data Marts, OLAP and FACT and Dimensions tables, Physical and Logical data modeling.

●Worked with warehouse modules like Informatica Server and Client tools, experience in the Data Analysis, Design, Development, Implementation and Testing of Database/Data warehousing/Client/Server/Legacy applications using Data Extraction, Data Transformation, Data Loading and Data Analysis.

●Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica Sources, Targets, Mappings and Sessions and fine-tuned transformations to make them more efficient in terms of session performance.

●Experience in designing ETL procedures and strategies to extract data from different heterogeneous source systems like oracle, SQL Server, Flat files etc.

●Experience in MySql and basic UNIX shell scripting.

●Exposure to different development methodologies like Waterfall Model and Agile development.

●Highly motivated team player with analytical, organizational and technical skills, unique ability to adapt quickly to challenges and changing environment.

●Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.

Skills & Knowledge:

●ETL: Informatica PowerCenter, SAP BO Data Services (BODS)

●BI: SAP BO 3.1(Business Objects)

●Database: Oracle 11g/10g

●Reporting Tools: BO, Control-M

●Operating Systems: Windows, Unix(Basics)

●Languages: C, C++, Java, HTML, XML, SQL, PL/SQL.

●Software / Applications: MS Word, MS Excel, MS PowerPoint, Outlook, Visual Studio.

●Tools: Eclipse, NetBeans, Notepad++, Rally, Jira

Experience:

KrtrimaIQ (CLIENT - Aviana Global; Remote) December 2022- March 2022

ETL Developer

●Involved in Data migration from Sagent to Informatica power center.

Infosys Limited (CLIENT - L’OREAL; Bangalore, India) February 2018- December 2018

ETL Developer

●Designed, built and deployed effective mappings and workflows.

●Developed ETL programs using Informatica to implement the business requirements.

●Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer/BODS.

●Communicated with business customers to discuss the issues and requirements.

●Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

●Implemented stored procedures and effectively used oracle queries.

●Translated requirements from the business and analyst into technical code.

●Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

●Fixed the invalid mappings and troubleshoot the technical problems of the database.

●Ensure the best possible performance and quality in the packages.

●Provided support and fixed issues in the packages.

Accenture (CLIENT - ABINBEV; Bangalore, India) January 2017 – January 2018

ETL PRODUCTION SUPPORT ENGINEER

●Supported moonwalk application of the HR module which refreshed 6 critical down streams used by the client.

●Co-ordinated with the global admins for the clean flow of the data across applications.

●Monitored Workflows and Sessions using Workflow Monitor.

●Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy,Joiner, Router, Sorter and Union.

●Interacted with the clients directly for continuous improvements, suggestions and issues.

●Learnt the basic info types of SAP to check the source data on own.

●Mentored the new members of the team about the application and technology involved.

Accenture (CLIENT - AUTODESK; Kolkata, India) Dec 2013 – December 2016

ETL DEVELOPER

●Gathered requirements and provided the solution to the client.

●Worked on various technologies as INFORMATICA 9.1.0, ORACLE, SAP BO 3.1.

●Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer to extract the data from multiple source systems that comprise databases like Oracle to the Staging area then to the Data Marts.

●Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.

●Effectively used Informatica parameter files for defining mapping variables, parameters and workflow variables.

●Developed the mappings using needed Transformations in Informatica tool according to technical specifications.

●Experienced in creating Oracle queries which is highly used in Informatica.

●Fixed the invalid mappings and troubleshoot the technical problems of the database.

●Created and monitored sessions using workflow manager and workflow monitor.

●Managed the process of troubleshooting and debugging the bugs or issues found during test execution.

●Involved in incorporating new changes as per business requirements.

●Developed Reports in SAP BO InfoView for the different data sources.

●Experienced in modifying and maintaining Universes in SAP BO.

●Experienced in creating new classes and objects of BO Universe based on the business requirements.

●Have considerable knowledge on SAP. I have used SAP as one of the sources in Informatica.

●Have knowledge on some of the t-codes used in SAP and can reprocess the orders with its accounting documents as per the business requirements.

●Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.

●Experienced in working with Project Management Tools as Rally and JIRA.

Certifications:

●Certificate Of Completion - Informatica Power center (Udemy)

●Data Analysis with Python(Provided by IBM)

●Data Science Orientation (IBM Certified)

●Certificate Of Completion – SQL for Testers (Linkedin)

●Certificate Of Completion – Learning Microsoft SQL Server 2022 (Linkedin)

●Certificate Of Completion - SQL Server Integration Services (Linkedin)

Education:

Qualification

Major/Board

Institution

CGPA/PERCENTAGE

B.Tech

Computer Science Engineering

Gandhi Engineering College, India

8.00/10.00

12th

C.B.S.E.

Kendriya Vidyalaya, India

83.2%

10th

C.B.S.E.

Kendriya Vidyalaya, India

80.6%

Contact this candidate