02/29/2024 updated
partially available
info: Available evenings and weekends
Informatica Developer, Informatica Developer, Informatica Developer
hyderabad, India
Only remote
B techAgile MethodologyData AnalysisUnit TestingBusiness SoftwareCloud ComputingCode ReviewDatabasesData ValidationData DiscoveryExtract Transform Load (ETL)Data MappingData MartData MiningData WarehousingIBM DB2
Agile methodology, business applications, cloud technology, code reviewing, Control M, Data Analysis, data Discovery, data mapping, Data Mart, Data Extraction, Data validation, Data warehousing, data warehouse, Databases, Database, ETL, Extract, Transform and Load, data loading, ETL Process, GIT, DB2, Informatica PowerCenter, JSON data, Microsoft SQL server, Windows, Routers, Operating Systems, oracle, Oracle 9i, oracle database, performance tuning, SAP, SQL, Design documents, Tableau, test data, Toad, Unit Testing, Unit Test, version one
Languages
EnglishGoodTeluguNative speaker
Project history
Project 1:
Project : DATA-FP-Informatica Upgrade
Client : Protective Insurance Company
Role : Informatica Developer
Description:
Protective Insurance Company specializes in providing insurance for the transportation industry. We
are licensed in all 50 states, the District of Columbia, Puerto Rico and all Canadian provinces to
provide comprehensive insurance programs to trucking fleets, motorcoach operations and limousine
services.
Responsibilities:
* This project we will be upgrading informatica power center version 10.0 to 10.5.3.
* It involves supporting install/upgrade activities and validating/testing DEV, INT, PRE-PROD
and PROD environments.
* Validated all connections in all the environments.
* validated all the mappings, sessions, and workflows in all the environments.
* validated all scripts and paths to make sure whether all scripts are parametrized or
hardcoded.
* updated the scripts as required for the updated versions. Involved in meetings and discussed
with the team for any modifications needs to be done.
Project : DATA-FP-Informatica Upgrade
Client : Protective Insurance Company
Role : Informatica Developer
Description:
Protective Insurance Company specializes in providing insurance for the transportation industry. We
are licensed in all 50 states, the District of Columbia, Puerto Rico and all Canadian provinces to
provide comprehensive insurance programs to trucking fleets, motorcoach operations and limousine
services.
Responsibilities:
* This project we will be upgrading informatica power center version 10.0 to 10.5.3.
* It involves supporting install/upgrade activities and validating/testing DEV, INT, PRE-PROD
and PROD environments.
* Validated all connections in all the environments.
* validated all the mappings, sessions, and workflows in all the environments.
* validated all scripts and paths to make sure whether all scripts are parametrized or
hardcoded.
* updated the scripts as required for the updated versions. Involved in meetings and discussed
with the team for any modifications needs to be done.
Project 2:
Project : LFG Dashboard
Client : LFG
Role : Informatica Developer
Description:
Lincoln National Corporation is a Fortune 250 American holding company, which operates multiple
insurance and investment management businesses through subsidiary companies. Lincoln Financial Group
is the marketing name for LNC and its subsidiary companies.
Responsibilities:
* Good understanding of requirements and test data needs for testing the application.
* Created mapping & session and workflow using Informatica power center based on the business
requirement.
* Worked on different transformations like masking, filter, router etc.
* Develop the Data Obfuscation process with 100 percent accuracy.
* develop Development reports as per the data Discovery reports.
* use Different Databases like oracle, Microsoft SQL server, DB2.
* use Different type of sources such as JSON data and tables.
* perform Data validation between source system and target system so that there should be zero
data mismatch.
* check Constraints and index on target tables.
* Regressive Testing after obfuscation so that obfuscation should not impact other attributes.
* performance tuning of SQLs and long running jobs.
* Understand the requirements, architecture and analyzed JSON data.
* List down various solution approaches, which can be used to implement a given requirement.
* Learn and develop domain, rule and project using INFORMATICA TDM.
* interested in learning cloud technology and IDQ.
* As per your client requirement we are changing workflows and plans. Adding the new plans and
deleting unwanted plans.
* Creating data discovery report after that having discussion with client and preparing
development report and uploading all details in the GIT Lab for documentation for that
end-to-end process we covered in the documentation.
* We are maintance the stories in version one.
* Following the Agile methodology, we are following sprint, we have weekly call with direct form
client.
Project : LFG Dashboard
Client : LFG
Role : Informatica Developer
Description:
Lincoln National Corporation is a Fortune 250 American holding company, which operates multiple
insurance and investment management businesses through subsidiary companies. Lincoln Financial Group
is the marketing name for LNC and its subsidiary companies.
Responsibilities:
* Good understanding of requirements and test data needs for testing the application.
* Created mapping & session and workflow using Informatica power center based on the business
requirement.
* Worked on different transformations like masking, filter, router etc.
* Develop the Data Obfuscation process with 100 percent accuracy.
* develop Development reports as per the data Discovery reports.
* use Different Databases like oracle, Microsoft SQL server, DB2.
* use Different type of sources such as JSON data and tables.
* perform Data validation between source system and target system so that there should be zero
data mismatch.
* check Constraints and index on target tables.
* Regressive Testing after obfuscation so that obfuscation should not impact other attributes.
* performance tuning of SQLs and long running jobs.
* Understand the requirements, architecture and analyzed JSON data.
* List down various solution approaches, which can be used to implement a given requirement.
* Learn and develop domain, rule and project using INFORMATICA TDM.
* interested in learning cloud technology and IDQ.
* As per your client requirement we are changing workflows and plans. Adding the new plans and
deleting unwanted plans.
* Creating data discovery report after that having discussion with client and preparing
development report and uploading all details in the GIT Lab for documentation for that
end-to-end process we covered in the documentation.
* We are maintance the stories in version one.
* Following the Agile methodology, we are following sprint, we have weekly call with direct form
client.
Project 3:
Project : ASDM (After Sales Data Mart)
Client : Nissan North America (USA)
Role : Informatica Developer
Description:
This project is being developed for building the After Sales Data Mart in Nissan. It provides
information about all the parts that are being sold including the full details of them. Based
on particular Part Number we will be tracking the status of each and every part. As this
involves a huge domain and business knowledge it's a very huge data mart and the processing of
data should be very fast. The details will tracked from ordering of parts and then finally
until dispatch of parts to the end users.
Mainframe acts as the source for fetching the data in the form of files and will be loading
the same into the Database tables. Tableau will generate reports and the same will be used for
business analysis.
Responsibilities:
* Involved in requirements Gathering and Analysis, Creating Mapping/Workflows designing/coding,
coordinating with the Client, Business Analyst and QA Team, working for product development.
* Worked extensively in analyzing the new requirements and Data Analysis.
* Designing the mappings/workflows according to the business/Technical specifications.
* Understanding and thorough implementation of new requirements.
* Communication with client regarding the improvement of the product.
* Ensuring that all the tasks are completed as per the schedule and based on the priority.
* Creating source to target mappings and developing the ETL mappings using Informatica Power
center.
* Migration of objects across environments in (Dev. => QA => Prod) and Production support.
* Involved in Deployment activities e.g. code deployment, raising CMT for Production
Deployments/Issues.
* Involved in Unit Testing and performance tuning at the mapping level and also involved inCode
Review.
Project : ASDM (After Sales Data Mart)
Client : Nissan North America (USA)
Role : Informatica Developer
Description:
This project is being developed for building the After Sales Data Mart in Nissan. It provides
information about all the parts that are being sold including the full details of them. Based
on particular Part Number we will be tracking the status of each and every part. As this
involves a huge domain and business knowledge it's a very huge data mart and the processing of
data should be very fast. The details will tracked from ordering of parts and then finally
until dispatch of parts to the end users.
Mainframe acts as the source for fetching the data in the form of files and will be loading
the same into the Database tables. Tableau will generate reports and the same will be used for
business analysis.
Responsibilities:
* Involved in requirements Gathering and Analysis, Creating Mapping/Workflows designing/coding,
coordinating with the Client, Business Analyst and QA Team, working for product development.
* Worked extensively in analyzing the new requirements and Data Analysis.
* Designing the mappings/workflows according to the business/Technical specifications.
* Understanding and thorough implementation of new requirements.
* Communication with client regarding the improvement of the product.
* Ensuring that all the tasks are completed as per the schedule and based on the priority.
* Creating source to target mappings and developing the ETL mappings using Informatica Power
center.
* Migration of objects across environments in (Dev. => QA => Prod) and Production support.
* Involved in Deployment activities e.g. code deployment, raising CMT for Production
Deployments/Issues.
* Involved in Unit Testing and performance tuning at the mapping level and also involved inCode
Review.