Nitin J. Email & Phone Number

Pune, Maharashtra, In

Pune, Maharashtra, In

ETL Architect and Senior Data Modeller.

Dublin 2, Ie

Informatica ETL Tech. Arch. with 9 years of Extensive Exp in Development, Admin and Support Data-warehousing projects. Exp in Designing End to end ETL solution for Data Migration, Integration and DWH projects. Exp in Data Modelling, Unix, Oracle, SQL server, Perl Scripting, Informatica cloudEngage with clients and advisory teams to understand requirement and create functional and Tech Solution. Design and develop solutions for reporting and analytics. Experience gathering requirements and liaising with clients (either internal or external) and the ability to translate requirements into technical specificationsAs offshore team lead, I had driven the offshore development effort, design documentation, and enhancement effort for the projectCreated the ETL solution for customer master data management implementation, along with detailed design document and mapping document.Successfully delivered phase 1 of the project to production which adds tremendous value to the project, and allow the client to use the Informatica MDM solution as their new systemDelivered Legacy and New system synchronization requirement using Informatica real time edition.

Chesterfield, Mo, Us

Informatica Admin and Support Role. ● Informatica Server Installation and Upgrade ● 3rd party tools installation● Application Support for BO ( upgrades and Patches)● Informatica Code Migration and Unix code migration● Apache and tomcat upgrade. ● Taking care of issues related to the servers outage, WSH patching etc.● Troubleshooting issues related to OBIEE process failures● Accommodating OS upgrade● Working with Oracle on SRs to get the issues resolved● Informatica User and password management.● Patch installation on BO and BO deployment● Informatica mapping development ● Troubleshooting (Infra support) to informatica and Unix● Unix shell scripting ● server maintenance through automation and alert script● User and connection creation and management. ● Informatica Server migration activity● Informatica User and folder creation● Monitor Informatica services and notifications● SSL certificate renewal ● Server Maintenance (Start/Stop)● Co-Ordination with Vendor on new release and Bug fixes for our Environments Monthly Basis● Provide KT for team members, Conduct Training session, Document the Project asset and conduct interview for new recruitment etc.

Mumbai, Maharashtra, In

● Collect the design information from client● Prepare the test plan and design doc ● Creating ETL jobs and code review document● Loading the data by configuring and running the sessions.● Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter and Update Strategy.● Involved in the preparation of documentation for ETL standards, procedures and naming conventions. ● Created Source to Target document for all the mappings which will be helpful in Maintenance phase.● Created Data maps in Informatica Power Exchange using Mainframe Copybooks (COBOL Files).● Modifying the existing mappings to incorporate changes requested by client.

Bangalore, Karnataka, In

● Importing source and Target definitions.● Analyzing the HLD and preparing LLD and UTP documents.● Creating Mappings and Datamaps. ● Loading the data by configuring and running the sessions.● Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter and Update Strategy.● Involved in the preparation of documentation for ETL standards, procedures and naming conventions. ● Created Source to Target document for all the mappings which will be helpful in Maintenance phase.● Created Datamaps in Informatica Power Exchange using Mainframe Copybooks (COBOL Files).● Wrote Unix Shell scripts to Automate Workflows and to Populate Parameter files.● Modifying the existing mappings to incorporate changes requested by client.

Bachelor Of Engineering - Be, Electronics And Communications Engineering

Hsc, Mathematics