Mayuri Tiwari

Extensive expertise in Informatica PowerCenter, Teradata and Oracle SQL PL/SQL, UNIX Shell Scripting, and Data Integration technologies.

Skilled

Informatica IICS Developer experienced in leveraging Cloud Data Integration (CDI) and Cloud Application Integration (CAI) to build scalable ETL workflows and seamlessly integrate multi-cloud and on-premises environments. Strong experience in building scalable ETL pipelines for extracting, transforming, validating and loading data from multiple heterogeneous source systems. Skilled in data analysis, data modeling support, performance tuning, query optimization and implementing data quality and reconciliation processes.

Hands-on experience in developing database objects including stored procedures, views, functions, packages and scripts to support business reporting and analytics. Detail-oriented Data Modeler with expertise in dimensional modeling, Star and Snowflake schemas to optimize database performance and streamline business analytics. Experienced ETL Tester skilled in verifying source-to-target mappings, data transformations and data completeness across complex pipelines.

Proficient in workflow scheduling, automation, production support, incident management, root cause analysis, and ensuring high availability of enterprise ETL applications. Knowledgeable in the complete Software Development Life Cycle (SDLC), including requirements analysis, design, development, testing, deployment and post-production support. Strong collaborator with business stakeholders, product owners, architects and cross-functional teams to translate business requirements into reliable and scalable data solutions.

Recognized for delivering high-quality, maintainable and performance-driven data integration solutions while mentoring team members and contributing to continuous process improvements.

Principal Engineer at Wissen Technology (2024-08 – Present)

Domain: Wealth Management, Finance And Banking

• Architecting and maintaining end-to-end ETL pipelines using Informatica PowerCenter, Teradata SQL, IICS and stored procedures to ingest, transform, validate and load data from multiple source systems into business-ready data models.
• Building and optimizing mapping in informatica powercenter and taskflows in IICS for extracting data from on-premises databases and integrating it into cloud data warehouses, ensuring reliable and scalable data pipelines.
• Designed and optimized end-to-end cloud data integration pipelines using IICS Cloud Data Integration(CDI) to ingest, transform, and load large volumes of data into cloud data warehouses
• Designing and optimizing Teradata stored procedures for high-volume data processing, improving pipeline reliability and execution efficiency.
• Delivering customized data analysis and reporting solutions by translating complex business requirements into actionable insights.
• Developing scalable ingestion frameworks supporting flat files, database extracts, schema mapping, data type standardization and incremental data loading.
• Implementing comprehensive data quality frameworks, including completeness checks, referential integrity validation, threshold monitoring and reconciliation reporting.
• Collaborating with product owners and business stakeholders to align ETL transformations with reporting requirements and optimize data models for UI performance.
• Optimizing Teradata queries through indexing, statistics collection, partitioning and SQL tuning to improve performance and reduce compute costs.
• Automating workflow scheduling, dependency management, and alerting using Informatica Scheduler, AutoSys and TWS, minimizing manual intervention.
• Developing reusable UNIX Shell scripts for process automation, log monitoring, file transfers and operational maintenance.
• Producing ad hoc and scheduled analytical reports tailored to evolving business scenarios.
• Creating technical documentation, operational runbooks and knowledge transfer materials while providing production support, root cause analysis and permanent issue resolution.

Senior ETL Developer at Accenture (2021-09 – 2024-08)

Domain: Finance and Banking

• Designed and implemented scalable Teradata views and database objects based on business and analytical requirements.
• Developed and maintained enterprise ETL solutions using Informatica PowerCenter mappings, workflow, sessions, and reusable components.
• Improved ETL performance through workflow optimization, session tuning, and SQL performance enhancements.
• Proactively monitored ETL workflow, investigated failures, and performed root cause analysis to ensure high platform availability.
• Developed real-time integration processes, APIs, and event-driven workflows using IICS Cloud Application Integration (CAI) to connect cloud and on-premises applications.
• Configured REST and SOAP service connectors, system services, and process objects in CAI to handle asynchronous request-response messaging and microservices orchestration.
• Implemented long-term corrective actions that reduced recurring production incidents and improved operational stability.
• Performed Unit Testing and System Integration Testing (SIT) to validate data quality, transformation accuracy, and end-to-end ETL functionality.
• Collaborated closely with business analysts, DBAs, infrastructure teams, and application owners to troubleshoot integration issues and deliver reliable solutions.
• Scheduled, executed, and monitored Informatica workflow and batch processes across multiple environments.
• Automated repetitive operational activities using UNIX Shell scripting, reduced manual effort and improving process efficiency.
• Designed, developed, and maintained Conceptual, Logical, and Physical data models for enterprise data platforms, ensuring alignment with business logic and analytical requirements with ERwin.
• Prepared technical design documents, mapping specifications, test plans and operational support documentation.
• Supported production and downstream applications by resolving ETL and data-related incidents within defined SLA timelines.

ETL Informatica Developer at Wipro Technologies (2015-06 – 2021-09)

Domain: Telecommunication, Fuel and Energy and Finance and Banking

• Collaborated with business stakeholders, solution architects, and end users to gather, analyze, and document functional and technical requirements.
• Developed PL/SQL trigger-based audit mechanisms to ensure data integrity, regulatory compliance and comprehensive change tracking.
• Performed source system analysis, data profiling, and impact assessments to support enterprise data integration initiatives.
• Participated throughout the Software Development Life Cycle (SDLC), including requirements gathering, design, development, testing, deployment, production support, user training, and maintenance.
• Designed and developed Informatica PowerCenter mappings utilizing advanced transformations to build scalable ETL solutions.
• Improved ETL performance using Pushdown Optimization, workflow partitioning, session tuning, and parallel processing techniques.
• Implemented Slowly Changing Dimension (SCD Type 2 and Type 3) methodologies to effectively manage historical data.
• Designed incremental data loading strategies to optimize processing time and reduce system resource utilization.
• Developed pre-session and post-session UNIX Shell scripts to automate ETL execution and operational activities.
• Engineered high-performance Dimensional Data Models (Star and Snowflake Schemas) and 3NF relational models in ERwin, optimizing query performance and simplifying analytics workflows.
• Implemented Slowly Changing Dimensions structures in ERwin to preserve historical data integrity across evolving enterprise systems
• Built UNIX-based workflow triggering mechanisms to ensure uninterrupted ETL execution during scheduler outages.
• Managed ETL code deployments across Development, QA, UAT, and Production environments following release management best practices.
• Planned, designed, and executed comprehensive ETL test strategies, test plans, and test cases based on source-to-target mapping specifications and business requirements.

M.Tech. (Part-Time) – Birla Institute of Technology and Science, Pilani (2019 – 2019)

BCA – Sant Gadge Baba Amravati University (2015 – 2015)