Subhankar Bhattacharjee Email & Phone Number

Having 12 years of experience in requirement analysis, design, development, unit testing and supporting all testing phases of software applications. Exposure to Agile methodology as well.Having Strong experience in design & implementation in developing ETL process for Data warehousing, Data integration & migrations projects using applications like DataStage® v11.5/9.1/8.7/8.5 Parallel jobs and UNIX, SQL, Oracle, etc.Build of DataStage® parallel jobs using different processing, file stages like: Sequential file, Dataset, Transformer, Aggregator Stage, CDC Stage, Surrogate Key Generator, Lookup, Join, Merge, Filter, Sort, Funnel, Switch, XML Connector, XML Output and Sequencer etc.2 years of hands-on Development and Unit testing experience in Informatica powercenter Mapping designer, Workflow manager, monitor (certified developer).Hands on experience in Hierarchical Stage / XML Connector, input and output stage, to generate XML file from DB2 database.Experience in tuning Jobs, process identifying & resolve performance issue in Parallel Jobs in DataStage®.Having good knowledge on UNIX, Oracle 9i/10g/11g, Teradata v13, SQL.Good knowledge on Data Warehousing concepts like ODS, Data mart, Slowly Changing Dimension phenomenon, Star Schema, Snowflake Schema Dimension and Fact table.Knowledge of loading and maintaining Data Warehouses and Data marts using DataStage® ETL processes.Having diverse background with fast learning skills and creative analytical abilities with good communication and technical skills.Ability to work effectively as a member of a team and ability to make decisions including ability to prioritize tasks effectively.

Listed skills include Teradata, Sql, Etl, Unix, and 4 others.