Shiva D.

WORK HISTORY

EDUCATION

ABOUT SHIVA D.

Around 7+years of IT experience in ETL Architecture, Development, Enhancement, Maintenance, Production support, Reporting including Business requirement, system requirement gathering of Enterprise Data warehouses. • Involved in the Waterfall model and Agile Implementation Methodologies. • Experience in Ab-initio EME version control, Data Lineage, Data dependency, Oracle, UNIX-Shell Scripting, XML, JSON file format. • Intensive hands-on ETL workflow design and implementation experience in Ab Initio for enterprise applications. • Experience in designing and creating scripts/processes on UNIX and LINUX to automate Processes. • Involved in working with users, identifying functional and technical gaps, estimating work to fulfill business requirements, designing custom solutions, programming, scheduling, documentation, and production support. • Involved in all the phases of SDLC starting from project assessment till deployment • Experience in end to end ETL design and development, requirements gathering, Data Mapping, Transformation and Loading in a complex, high-volume environment. • Provide leadership, guidance, and advice in order to effectively resolve issues, and escalations. • Strong skills in Data Analysis, Data Requirement Analysis, Data Modeling (Physical), and Data Mapping for ETL processes. • Expertise in Developing Mappings, Define Workflows and Tasks, Monitoring Sessions, Export and Import Mappings and Workflows and Backup, Recovery. • Expertise in designing and developing Informatica mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, Transaction Control, Java, and update strategy. • Analyzed, designed, and implemented Data warehouse, Data marts, and operational databases. • Hands-on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions. • Strong skills in analyzing the database design, Coding using SQL and PL/SQL, Oracle 10g/11g, SQL Server, and Sybase database applications. Coded Stored Procedures, Packages, and Triggers using PL/SQL. Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.