Amit Prakash

• Worked on Agile & Waterfall model based pods on Data Analytics and Business Intelligence focusing on ETL process, Data integration, Data Migration.
• Have worked directly with Clients, BA, DEV and interacted with TLs/SMEs in onshore-offshore on daily basis to understand the requirement, issues and future plans & designing of test cases as per the requirements.
• Created mapping documents to outline data flow from sources to targets.
• Develop/Modify mapping, maplet, session and workflow for new business requirement.
• Developed mapping parameters and variables to support SQL override.
• Used existing ETL standards to develop/modify these mappings.
• Have worked on Optimize sessions using Pushdown Optimization to enable them to insert bulk data in less amount of time.
• Performed Code Review, Defect fixing, Unit Testing.
• Performed data migration from Dev to Test and Prod environment.
• Handled critical Priority 1 issues in the application.
• Planning and successfully executing the knowledge transition to the other members of the Project.
• Created the technical and High level design documents.
• Deployed various SIPs and BUGFIXES.
• Worked in the Performance tuning of Informatica mappings/ SQL.

• Create, execute, and document unit test plans for ETL and data integration processes and programs
• Data Extraction from various sources relational database and loading into the staging tables and target tables.
• Performed data migration from Dev to Test and Prod environment.
• Responsible for creating new Informatica jobs or performing changes in existing jobs according to changing client requirements.
• Written UNIX shell scripts to archieve back-end process of ETLs as well as schedule ETL job runs.
• Performed data migration from Dev to Test and Prod environment.

• Worked on Major and Minor enhancements in the application involving changes in the Oracle PL/SQL and Unix coding according to client’s different requirements.
• Have worked on monitoring various Informatica jobs running on daily basis checking their performance.
• Have Worked in the Performance tuning of Informatica mappings..
• Worked on different types of issues in the execution of Informatica jobs i.e. issues in transferring data from various flat files to Oracle database, issues in the connection of Informatica jobs with different servers.
• Have solved more that 500 SLA based tickets.
• Performed Defect identification and reporting on Jira tool.