o Understand requirements, build codes, and guide other developers during development activities to develop high standard stable codes within the limits of Confidential and clients’ processes, standards, and guidelines.o Develop mappings to be implemented based on client requirements and for the analytics team, using informatica cloud and PowerCenter.o Optimize the data quality process for our business with Informatica Data Quality (IDQ).o Worked on transformations to transform the data required by analytics team and setup visualizations using tools like Power BI, Apache Superset, Metabase , Splunk etc.o Review plan and provide feedback on gaps, timeline and execution feasibility etc. as required in the projecto Involved in migrating the client data warehouse architecture from on-premises into Azure cloud.o Create pipelines in ADF using linked services to extract, transform and load data from multiple sources like Azure SQL, Blob storage and Azure SQL Data warehouse.o Implement Azure Data Factory operations and deployment into Azure for moving data from on-premises into cloud.o Design data auditing and data masking for security purpose.o Monitoring end to end integration using Azure monitor.o Implemented Lamda architectures using Azure Data platform capabilities like Azure Data Lake, Azure Data Factory, HDInsight, Azure SQL Server, Azure ML and Power BI.o Demonstrated expert level technical capabilities in areas of Azure Batch and Interactive solutions, Azure Machine learning solutions and operationalizing end to end Azure Cloud Analytics solutions.o Sized and designed scalable Big Data landscapes with central Hadoop processing platforms and associated technologies like Spark, ETL tools and NoSQL databases on both Cloud and On-Prem hardware to enable end to end business use cases.

• Responsible for creating and modifying the PL and SQL procedure, function according to the business requirement.• Used SQL LOADER to upload the information into the database tables.• Created database objects like stored procedures, function, packages, Cursor, Ref Cursor and Triggers.• Extensively analyze the security holes in the PLSQL and Java script coding. Fixed all the security hole and bugs in most of the packages and also fixed security hole in control file’s of the Sql*loader.• Wrote and modified Oracle PL and SQL, Sql statements procedures and functions that are called in the Java.• Worked on OLTP for optimization and to facilitate the processing of large numbers of concurrent updates to an database.• Involved in analysis, design, coding and Testing.• Involved in creating Database Design (Physical and logical) as per the requirement given by business.• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.• UNIX Shell Scripting to automate procedure execution from UNIX box.• Involved in Performance Tuning.• Worked on Erwin Data Modeler for mapping both user-defined and default data types.• Planned version control of production source code using SVN.

o Developing database solutions for European clients Orange France, Zalando, Phones4u, O2 etc.o Maintained exceptional performance in processing large volumes of data through clean, crisp codes.o Designed ETL processes that accelerated extraction, transformation, and loading of massive structured and unstructured data o Architected logical and physical database schemas, stored procedures, interfaceso Developing and supporting ETL applications using Informatica, pentaho, Oracle PL/SQL and UNIX scripting.o Pentaho for generating reports and Charts as per Business Requirements.o Developing Oracle procedures, functions, triggers, and Netezza/Oracle SQL scripts based on client business requirements, data modeling and performance tuning.o Closely worked with Project Managers to manage project scope, identify & deploy appropriate resources to support system development efforts.o Scheduling and monitoring jobs using Jenkins and UNIX crontab.

o Monitored Compass DW Daily. Also, handling the jobs when failed and fixing the issue by making detailed analysis within SLA time and testing the same for all business flows.o Documented the issue backlogs and enhancements.o Create data mapping and modelling for data migration.o Create end-to-end solution for ETL transformation jobs that involve writing Informatica workflows and mappings.o Used various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, and Router etc. to implement complex logics while coding a Mapping.o Worked on Client requests about enhancements/ Modifications in the application/ Product o Prepared test cases and test reports.o Analysed ETL mappings, process flow, Oracle SQLs, PLSQL and modifying the same for improved performance.o Coach team members on Agile principles and providing general guidance on the methodology and to become a self-governing high-performance team.o Work with Product Owners and assist in maintaining and prioritizing the product backlog, writing, and breaking down user stories, estimate user stories and refines the teamwork capacity.o Worked on bug or issue tracking using JIRA tools and manage the progress of the project with JIRA.o Collaborate with scrum teams to effectively manage work and resolve issues and conflict.o Create and maintain work visibility using Kanban boards and other Agile tools like Jira, and charts.