Syeda Tayyaba

• Over 2 years of IT experience with a strong background in SDLC, Data Integration tools including Informatica Intelligent Cloud Services(IICS).
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design,development, System testing, Implementation and production support.
• Experience working with Informatica IICS tool effectively using it for Data Integration and Data Migration from multiple source systems.
• Experience working with IICS concepts relating to data integration, Monitor, Administrator, deployments, permissions, schedules.
• Expertise in IICS extracting data from Oracle, SQL Server, Teradata, DB2 databases, Flat files, Web Services, API's, XML & Json files.
• Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookups, joiner, sequence generator, sorter, SQLT, stored procedure, Update strategy, Source Qualifier, Transaction Control, Union etc.,
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
• Experience in Performance Tuning and Debugging of existing ETL processes.
• Experience in Integration of various data sources like Oracle, Teradata, SQL Server, DB2 and Flat Files in various formats like fixed width, CSV and excel.
• Designed complex mappings to load into Snowflake.
• Expertise in SQL/PLSQL programming, developing & executing Packages, Stored Procedures, Functions, Triggers, Table Partitioning, Materialized Views.

Experienced Developer with [2.6] years of experience in creating programs based on specific requirements. Adaptable, diligent and knowledgeable in [English].