ANSHAD CHEMBICATTE ASHRAF

Designing and implementing Hadoop infrastructure using MapReduce, Hive, Spark and Oozie
Developing data integration jobs in the Hadoop environment, including hands-on experience with MapReduce, Spark, Pig and Hive
Designing and developing Hadoop ecosystems and different frameworks in it - HDFS, YARN, MapReduce, Apache Pig, Hive, Flume, Sqoop, ZooKeeper, Oozie, Impala and Kafka
Data retrieval, manipulation and analysis using Python and Java.
Developed Real-time processing and Data integration framework (Apache Spark)
Created mappings and workflows in Informatica 10.4.1 (BDM) according to the design and functional specification document.

Created mappings and workflows in Informatica 10.4.1 (BDM) according to the design and functional specification document.
Created dynamic mappings in Informatica BDM 10.4.0 for implementing SCD Type-1 and Type-2 loads.
Implemented the ETL jobs and mappings in Informatica BDM 10.4.0 which was earlier running in Oracle Data Integrator.
Performed and Data Analytics and proposed ETL solution according to the business requirement.
Developed mapplets for increasing the reusability.
Modified several of the existing mappings based on the user requirements.
Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
Prepared SQL Queries to validate the data in both source and target databases.
Extensively worked on Mapping Variables and Mapping Parameters and workflow parameters.
Created Test cases for the mappings developed and then created integration Testing Document.
Prepared the error handling document to maintain the error handling process.
Closely worked with the reporting team to ensure that correct data is presented in the reports.

Created mappings and workflows in Informatica 10.2.1 (BDM) according to the design and functional specification document.
Prepared source and target queries to validate SAP HANA tables through its interface.
Created dynamic mappings in Informatica BDM 10.2.1 for implementing SCD Type-1 and Type-2 loads.
Developed various target load order mappings according to functional specification.
Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Router, Sorter and Update Strategy.
Developed full push down mappings in order to achieve performance improvement.
Developed mapplets for increasing the reusability.
Modified several of the existing mappings based on the user requirements.
Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
Prepared SQL Queries to validate the data in both source and target databases.
Extensively worked on Mapping Variables and Mapping Parameters and workflow parameters.
Created Test cases for the mappings developed and then created integration Testing Document.
Prepared the error handling document to maintain the error handling process.
Closely worked with the reporting team to ensure that correct data is presented in the reports.

Created mappings, sessions and workflows in Informatica 9.6.1 / 10.2.1 (BDM) according to the design and functional specification document.
Prepared source and target queries to validate hive tables through Ambari interface and Beeline SSH tectia terminal.
Was part of development team for creating fact and dimension tables based on specifications provided by client.
Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads in Informatica 9.6.1.
Created dynamic mappings in Informatica BDM 10.2.1 for implementing SCD Type-1 and Type-2 loads.
Prepared various mappings to load the data into different layers like interface and data warehouse.
Developed various target load order mappings according to functional specification.
Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Router, Sorter and Update Strategy.
Developed tasks and workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
Developed mapplets in mapplet designer for increasing the reusability.
Created various tasks like Session, Command, Timer and Event wait.
Modified several of the existing mappings based on the user requirements.
Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
Prepared SQL Queries to validate the data in both source and target databases.
Worked on MS SQL Server to develop queries and stored procedures.
Created various batch Scripts for scheduling various data cleansing scripts and loading process.
Created multiple workflow instances in workflow manager for increasing the reusability.
Extensively worked on Mapping Variables, Mapping Parameters, Session Parameters and workflow parameters.
Created post-session and pre-session shell scripts and mail-notifications.
Created Test cases for the mappings developed and then created integration Testing Document.
Prepared the error handling document to maintain the error handling process.
Closely worked with the reporting team to ensure that correct data is presented in the reports.
Created jobs in Autosys for scheduling various ETL jobs based on their dependencies and conditions.
Interaction with the offshore and onshore team on a daily basis on the development activities.

Analyzed the business requirements and functional specifications provided by the client.
Extracted data from oracle database and flatfiles and staged into a single place and applied business logic to load them in the central oracle database.
Used Informatica Power Center 9.6.1 for extraction, transformation and load (ETL) of data in the data warehouse.
Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
Developed complex mappings in Informatica to load the data from various sources.
Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
Parameterized the mappings and increased the re-usability.
Used Informatica Power Center Workflow manager to create sessions and workflows to run with the logic embedded in the mappings.
Created procedures to truncate data in the target before the session run.
Extensively used Informatica debugger to figure out the errors in mapping.
Involved in troubleshooting existing ETL bugs.
Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
Written documentation to describe program development, logic, coding, testing, changes and corrections.
Created Test cases for the mappings developed and then created integration Testing Document.
Monitoring of ETL loads in Tivoli Workload scheduler.
Followed Informatica recommendations, methodologies and best practices.
Created Informatica standards document by having a discussion with higher management and client.
This was used within the team as a reference to coding standards.

Designing and developing Hadoop ecosystems and different frameworks in it - HDFS, YARN, MapReduce, Apache Pig, Hive, Flume, Sqoop, ZooKeeper, Oozie, Impala and Kafka
Developed Real-time processing and Data integration framework (Apache Spark)
Created mappings and workflows in Informatica 10.2.1 (BDM) according to the design and functional specification document.
Prepared source and target queries to validate SAP HANA tables through its interface.
Dedicated, self-motivated achiever who is committed to success and adept at handling multiple tasks in a high-pressured environment and experience with working on a Scrum Agile team.
Created dynamic mappings in Informatica BDM 10.2.1 for implementing SCD Type-1 and Type-2 loads.
Developed various target load order mappings according to functional specification.

functional specification document.
Prepared source and target queries to validate hive tables through Ambari interface and Beeline SSH tectia terminal
Was part of development team for creating fact and dimension tables based on specifications provided by client.
Dedicated, self-motivated achiever who is committed to success and adept at handling multiple tasks in a high-pressured environment and experience with working on a Scrum Agile team.
Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads in Informatica 9.6.1.
Created dynamic mappings in Informatica BDM 10.2.1 for implementing SCD Type-1 and Type-2 loads.
Prepared various mappings to load the data into different layers like interface and data warehouse.
Developed various target load order mappings according to functional specification.
Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Router, Lookup, Sorter and Update Strategy.