Priya Ramkumar Email & Phone Number

Tampa/St. Petersburg, Florida Area

Created some routines (Before-After, Transform function) used across the project.Experienced in PX file stages that include Complex Flat File stage, DataSet stage, LookUp File Stage, Sequential file stage.Implemented Shared container for multiple jobs and Local containers for same job as per requirements.Adept knowledge and experience in mapping source to target data using IBM Data Stage 8.xImplemented multi-node declaration using configuration files (APT_Config_file) for performance enhancement.Experienced in developing parallel jobs using various Development/debug stages (Peek stage, Head & Tail Stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)Debug, test and fix the transformation logic applied in the parallel jobsInvolved in creating UNIX shell scripts for database connectivity and executing queries in parallel job execution.Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.Experienced in using SQL *Loader and import utility in TOAD to populate tables in the data warehouse.Successfully implemented pipeline and partitioning parallelism techniques and ensured load balancing of data.Deployed different partitioning methods like Hash by column, Round Robin, Entire, Modulus, and Range for bulk data loading and for performance boost.Repartitioned job flow by determining DataStage PX best available resource consumption.Created Universes and reports in Business object Designer.

Florida

Generation of Surrogate Keys for the dimensions and fact tables for indexing and faster access of data in Data Warehouse.Tuned transformations and jobs for Performance Enhancement.Extracted data from flat files and then transformed according to the requirement and Loaded into target tables using various stages like sequential file, Look up, Aggregator, Transformer, Join, Remove Duplicates, Change capture data, Sort, Column generators, Funnel and Oracle Enterprise.Created Batches (DS job controls) and Sequences to control set of jobs.Extensively used DataStage Change Data Capture for DB2 and Oracle files and employed change capture stage in parallel jobs.Executed Pre and Post session commands on Source and Target database using Shell scripting.Collaborated in design testing using HP Quality Center.Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.Collaborated in Extraction of OLAP data from SSAS using SSIS.Extensively usedSAP R/3 and SAP BW packsCollaborated with BI and BO teams to find how reports are affected by a change to the corporate data model.Collaborated with BO teams in designing dashboards and scorecards for Analysis and Tracking of key business metrics and goals.Utilized Parallelism through different partition methods to optimize performance in a large database environment.Developed DS jobs to populate the data into staging and Data Mart.Executed jobs through sequencer for better performance and easy maintenance.

Miami

Work with subject matter experts to derive data requirements and design appropriate data models.Design and develop ETL processes for cleansing and loading data into the operational warehouse, as well as developing batch and real-time solutions to support application and integration initiatives.Perform data profiling tasks including column analysis, structural analysis, simple rule analysis, and complex rule analysis.Successfully implemented a large scale project involving integration with Salesforce to create dashboards for revenue data in Salesforce.Assist with resolving data anomalies and data quality issues.Perform performance tuning based on Informatica velocity best practices.Assist with writing and maintaining project documentation, including but not limited to formal requirements, design documents and test plans.Interact with UNIX/Windows system administration and DBA groups to resolve issues.Support development initiatives by working with application design and development teams to reach optimal data design, quality, and integration patterns.Support development of ad-hoc and canned reports to support business initiatives and objectives.Took responsibility of individual projects and ensured timely completion without data quality issues.Being a part of the data services team and the nature of work, had to work on varied projects simultaneously.Participated in design reviews, code reviews and brain storming sessions for various projects and tasks.Co-ordinated with offshore teams and remote teams to ensure smooth functioning of a project and resolve data issues.Gave presentations and documented various Informatica processes and best practices for enterprise level reference.Worked on R&D projects and implemented them successfully as a part of the Data Services Center of Excellence (COE).

Mumbai Area, India

Provided Technical support to the team as the ETL developer. Addressed best practices and productivity enhancing issues.Worked on designing and developing the Quality stage.Loaded data into load, staging and lookup tables. Staging area was implemented using flat files.Created jobs in DataStage to import data from heterogeneous data sources like Oracle 9i, Text files and SQL Server.Generation of Surrogate IDs for the dimensions in the fact table for indexed and faster access of data in server jobs.Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.Dicing and Slicing of the input data for the Business feedback. Testing of the system.Designing Data masking techniques to mask sensitive information when working with offshoreAssisted Mapping team to transform the business requirements into ETL specific mapping rules.Enhanced various complex jobs for performance tuning.Responsible for version controlling and promoting code to higher environments.Worked on Teradata optimization and performance tuning.Performed Unit Testing, System Integration Testing and User acceptance testingInvolved in ongoing production support and process improvements. Ran the DataStage jobs through third party schedulers