RobertSuriyha.BG

ETL Developer

MobileNo-647-***-****

ac4qbl@r.postjobfree.com

Over 6 years of Data Warehousing experience in various Components of Warehouse tools using IBM, Ascential Datastage (Administrator, Manager, Designer and Director, Parallel Extender)

• Expertise in Data warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies.

• Efficient in all phases of the Software development lifecycle (SDLC), coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.

• Experience in dimensional and relational database design.

• Extensive knowledge of business process and functioning of Storage and Data Management, Financial, Retail and Insurance sectors.

• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements and Aggregate tables for the data warehouse design and development.

• Experience in Mapping parallel Jobs in DataStage to populate tables in Data warehouse and Data marts.

• Experience in UNIX Shell Scripting.

• Experienced in Fine-tuning, Performance Enhancement, Performance Analysis, Bug Fixing and Trouble Shooting of Datastage Jobs.

• Have exposure to Tableau reporting tool.

• Primary objectives are to provide custom software development, quality assurance, production support, or related services preferably with exposure to new skills.

• Self-Starter and Team Player with excellent communication, organizational and interpersonal skills with the ability to grasp things quickly.

Work Experience

Datastage Consultant

Sky Global Services ( Nov 2015 - Oct 2017)

Travelers Canada

Responsibilities:

• Worked with Business Analysts to analyze the business requirements and functional specifications.

• Designed and developed ETL processes using DataStage designer to load data from XML files to staging Oracle database and from staging to the target Data Warehouse database.

• Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter etc

• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.

• Extensively worked with sequential file, dataset, file set and look up file set stages.

• Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.

• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.

• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

• Participated in Daily status meetings.

• Developed Test Plan that included the scope of the release, entrance and exit criteria and overall test strategy. Created detailed Test Cases and Test sets and executed them manually.

• Performed debugging and unit testing and System Integrated testing of the jobs.

Sky Global Services( Nov 2013 – Oct 2015)

Customer Knowledge Services

Responsibilities:

• Interacted with end user community to understand the business requirements and in identifying data sources.

• Assisted in preparing the mapping document from source to target.

• Developed Gap Analysis, Functional and Technical Design documents.

• Designed and Developed Datastage Jobs to Extract data from heterogeneous sources, Applied transformation logics to extracted data and Loaded into Data Warehouse Databases.

• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.

• Developed job sequencer with proper job dependencies, job control stages, triggers.

• Created complex logical summary facts as per business requirements.

• Worked with Datastage Manager for importing metadata from repository, new job Categories and creating new data elements

• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

• Extensively worked on Slowly Changing Dimensions (SCD)

• Used DataStage Director to validate, schedule, run and monitor DataStage jobs.

• Developing shell scripts to automate file manipulation and data loading procedures.

• Participated in weekly status meetings.

Cognizant Technologies Solutions -( Mar 2012 – Nov 2013)

ETL Support

Northern Trust Corporation- Strategic Transfer Agency

Responsibilities:

Support the Datastage jobs that extract, transform and load the data from GFP databases in to GFR database

Support the Unix Scripts & Stored procedures that control the execution of ETL mappings

Periodically monitor GFR Control-M Jobs

Enhance existing GFR ETL mappings

Change requests for Creating new mappings or modifications to the existing mappings

Cognizant Technologies Solutions ( Apr2011 – Mar 2012)

ETL Developer

Northern Trust Corporation-AML KYC(Anti Laundering-Know Your Customer)

Responsibilities:

Involved in project design phase gathering all the requirements

Designed and developed ETL processes using DataStage designer to load data from Oracle, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database

Used DataStage stages namely Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.

Deployed different partitioning methods like Hash by column, Round Robin, Entire, Modulus, and Range for bulk data loading and for performance boost

Developed job sequencer with proper job dependencies, job control stages, triggers.

Used Parsing XML data, XML Composer with Regroup, H-Pivot, or sort steps. Also, used XML Parsing with Switch, Aggregate, V-pivot steps in Datastage

Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.

Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing prepared test data for testing, error handling and analysis.

Involved in Code Migration to SIT and UAT Regions and provided the required support.

Cognizant Technologies Solutions Sep 2010 – Mar 2011)

ETL Developer

Royal Bank of Canada-PDW

Responsibilities:

Designed and developed Datastage jobs

Used various Stages to develop the jobs in Data Stage Designer like Transformer, Aggregator, Lookup, Copy, Join and Filter

Extracting data from oracle/Flat files and loaded in to Data Warehouse

Validating business logic against the requirements,

Populating mock up data to perform Unit Test

Analyzing the source and target data.

Used DataStage job sequencer to schedule the batch jobs

rked with the Business Analyst Team and prepared Documents relevant to the given specification according to the system specification.

TECHNICAL SKILLS:

ETL Tools

IBM InfoSphere Information Server, Ascential Data stage 7.5 (Enterprise Edition) (Designer, Director, Manager, Administrator, Server Edition/Parallel Extender/Orchestrate and Server Jobs & Quality Stage)

Dimensional Data Modeling

Dimensional Data Modeling, Star Schema, Snow-Flake Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 3.5.2/3.x.

Databases […] SQL Server […] Teradata V2R6/V2R5, IBM DB2/UDB, SQL, MySQL

Operating Systems IBM AIX 5.2/5.1, Windows […] Unix, Linux

Tools

Tableau,Control M, Toad, Putty, FTP, FileZilla, Jira, Rally, Perforce, Microsoft Visio.

Languages C, C++, UNIX Shell Programming, SQL, PL/SQL, SOQL

Contact this candidate