Ulkar Alizada

• Worked with end-users and functional analysts to identify and develop Business Specification Documents (BSD) and transform it into technical requirements. • Extracted data from various source systems ranging from Mainframes like DB2, Flat Files, JSON/XML files, VSAM files, etc. to RDBMS like Oracle, SQL Server, Teradata etc. • Created SCD Type1 and Type2 dimensions and facts to maintain historical data using MD5. • Worked with Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository. • Designed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, Update Strategy from varied transformation logics in Informatica. • Implemented Stored Procedures in PL/SQL. • Designed data Pipelines using IICS. • Involved in Dimensional modeling (Star Schema) of the Data warehouse • Worked with production team to resolve data issues in Production database of OLAP and OLTP systems. • Created Salesforce connection, Implemented Salesforce business process with Informatica IICS data Integration. • Improved performance by using Oracle Partitions, Indexes and other Performance Tuning techniques.

• Worked with Data Warehouse team in developing Dimensional Model. • Designed and developed Star Schema and created Fact and Dimension Tables for the Warehouse. • Designed ETL specification documents to load the data in target using various transformations according to the business requirements. • Used Informatica Designer to create Load, Update and CDC mappings using different transformations to move data to different data marts in Data Warehouse. • Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, SQL and Rank. • Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. • Scheduled the sessions to extract, transform and load data in to warehouse database on Business requirements. • Created different jobs using UNIX shell scripting to call the workflow and run the preload and post load on UNIX server. • Optimized the performance of the mappings by various tests on sources, targets and transformations. Involved in performance tuning of reports and unit testing and documenting the processes • Identified the Bottlenecks, Removed the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance. • Involved in performance tuning of reports and unit testing and documenting the processes.

• Studied the existing environment, validating the requirements and gathering source data • Created mappings, sessions, workflows and variables • Good experience using data replication and synchronization tasks in IICS • ETL design of the flow and the logic for the Data warehouse project using Informatica • Created complex mapping using transformations like Joiner, Lookups, Transaction Control and Aggregator • Created reusable object like UDF, Mapplet, Sessions and Worklets • Transferred data from flat files and heterogeneous data to and from DB2, UDB and Teradata • Prepared testing strategy, testing schedule, test cases depending upon the Requirement documents for integration and system testing • Promoted Unix/Informatica application releases from DEVELOPMENT to QA and then UAT environments • Worked in creating UNIX scripts for file transfer and file manipulation • Involved in writing the Test cases and based on Source to Target Mapping documents and Data Model diagrams • Developed Traceability Matrix • Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems • Worked on Informatica cloud and created mapping, tasks, subtask flow and task flows • Worked with Informatica Cloud to create Source /Target connections, monitor, and synchronize the data in sfdc • Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables • Performed Functional, Screen flow and Workflow test scripts as per the requirements • Tested Informatica mappings and workflows, PL/SQL procedures and worked extensively with Informatica for data sourcing, data transformation and data loading • Developed data integration scripts and resolved data related issues during initial loads from different sources • Troubleshoot the problems related to batch jobs for the various customer specific applications on UNIX platform • Loaded diverse types (Structured, JSON, flat files etc.) into the Snowflake cloud data warehouse

Involved in the analysis of the user requirements and identifying the sources. Created technical specification documents based on the requirements by using S2T Documents. Involved in the preparation of High-level design documents and Low-level design documents. Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart. Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart. Administered the repository by creating folders and logins for the group members and assigning necessary privileges. Used Trillium as a Data Cleansing tool to correct the data before loading into the staging area. Designed process flows to link metadata from diverse sources, including relational databases and flat files. Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.