Nikhil Harode - Informatica DEveloper at Nice Software Solution - Pune

Nikhil Harode
Informatica Powercenterdeveloper
Pune, Maharashtra, India
MySql PL SQL Informática SQL Plus
RTMNU-Rashtrasant Tukadoji Maharaj Nagpur University

About Nikhil Harode

Nikhil Harode works as Informatica DEveloper at Nice Software Solution and is based in Pune, India. Nikhil studied Bachelor of Engineering or Technology at Rashtrasant Tukadoji Maharaj Nagpur University (2008-2012). On Youth4work, Nikhil has taken skill tests in MySql (rank 4,544 of 71,796, top 7%) and PL SQL (rank 676 of 11,147, top 7%). Nikhil also lists talents in Informática, SQL Plus, Unix and Linux and Unix Shell Scripting.

Talents

RDBMS

... among ... users in Pune

…

among … users worldwide
Scheduling

... among ... users in Pune

…

among … users worldwide
Unix Shell Scripting

... among ... users in Pune

…

among … users worldwide
DBMS

... among ... users in Pune

…

among … users worldwide

Complete Talent Profile »

Professional Path

Informatica DEveloper

Nice Software Solution Full Time

Mar-2016 To present 10 years 6 months

Did analysis and extract all the views required to migrate. Converted the Teradata SQL to Oracle SQL in efficient time.
Developed mapping for Initial load, ongoing load.
Develop all object into development environment. Migrate the same to Pre-Prod environment and tested successfully.
In case of issues, provided complete solution with documentation of steps.
Identify and verify number of jobs to be migrated, Extract the logic from Teradata and implement the same into Oracle mapping.
Understand and explained the relationship and dependencies of objects to team member.
Performed the data validation and mapping testing in all environment.
Checked the Control-M jobs and verify the logic and sequence of job in Teradata server. Migrated the same into Oracle server.
Validated data through data count compare of Teradata and Oracle.
Provided complete support to the onshore team.

Data Processing Analyst / ETL Developer

Muneris Service Network Full Time

Jan-2013 To Feb-2016 3 years 1 months

Analysis, Design, Development, Implementation, Testing and Support of Data Integration solution using Informatica Power Center and Informatica Data Quality.
Have experience in migration project and development of DWH.
Scheduling jobs using Informatica Scheduler .
Strong knowledge of RDBMS and data warehousing concept.
Experience in Installation of Informatica Power Center on Windows platforms.
Extracting data from admin using SQL, collecting and providing required information from/to sales department.
Analyzing data and present to higher level management department.
Co-ordinating with interdepartmental team to resolve back-end issues like mismatch of table structure, Missing Constraints.
Reporting Management about ongoing business. Maintaining data, Generating Reports & Charts. Coordinating with other department for data to analyze and present the same.