A M Email & Phone Number

Flowood, Mississippi, United States

• Design and development, unit testing, integration, deployment packaging and checkout, scheduling, of various components in Informatica Power Center, Azure Data Factory and Azure Data Bricks through several SDLCs for.
• Performed analysis of ETL/ELT applications and database systems, data structure analysis, data profiling for application design and defects resolution.
• Converted legacy ETL processes into Azure synapse compatible architecture using regular expression driven metadata conversion such as ODBC/ JDBC reads and OLAP writers and replacements such as bulk merges, deletes with.
• Performed process enhancements such as capacity improvement, tuning/optimization and performance improvement of the Azure Hyperscale based ETL/Upsert processes.
• Performed extensive metadata gathering and analysis of database and metadata repositories for understanding data lineage, data flow, process design, process statistics and identifying storage elements and access to.
• Partnered with DBA/SA to optimize database tables/indexes, partitioning, parallelization and in implementing database/client configurations to support pipeline partitioning and multi-threaded processing.

Woonsocket, Rhode Island, United States

• Design and development, unit testing, integration, deployment packaging and checkout, scheduling, of various components in Informatica Power Center, Azure Data Factory and Azure Data Bricks through several SDLCs for.
• Performed analysis of ETL/ELT applications and database systems, data structure analysis, data profiling for application design and defects resolution.
• Performed process enhancements such as capacity improvement, tuning/optimization and performance improvement of the Azure Hyperscale based ETL/Upsert processes.
• Performed extensive metadata gathering and analysis of database and metadata repositories for understanding data lineage, data flow, process design, process statistics and identifying storage elements and access to.
• Partnered with DBA/SA to optimize database tables/indexes, partitioning, parallelization and in implementing database/client configurations to support pipeline partitioning and multi-threaded processing.
• In the event human intervention is required for correction, build a flexible error correction management workflow with ability for effective workload management while providing visibility on the error corrections.

Hyderabad, Telangana, India

• Conceptualized Audit and Control Framework for ETL application system for Enterprise Data Warehouse initiative at SSA on Informatica Power Center platform. Implemented the framework by designing and developing ETL.
• Troubleshoot with Informatica to rebrand the ODBC drivers by identifying parallel performance and driver error issues.
• Involved in managing and monitoring Hadoop clusters using Cloudera Manager.
• Used Python and Shell scripting to build pipelines.
• Developed data pipeline using Sqoop, HQL, Spark and Kafka to ingest Enterprise message delivery data into HDFS.
• Implementing Data Security Policies in the Informatica Dynamic Data Masking server.