12+ years of experience in Design, Development, Testing, and Implementation of ETL applications using IBM DataStage 11.5/11.7, Informatica Intelligent Cloud Services, Informatica PowerCenter tools, SSIS, SSRS. 8 years (recent) of experience in Design & Development of ETL jobs with DataStage & IICS 4+ years of experience in testing ETL, Database, DataMart, Reports. Experience in Mortgages, Banking & Digital Payments. Design and Development of ETL jobs with IBM DataStage Components - Designer, Director, Admin. Development of ETL Data flows with Informatica Intelligent Cloud Services (IICS) – Data Integration. Development of ETL jobs with Informatica PowerCenter tools - Workflow Manager, Designer, Workflow Monitor Working with various Data Sources & targets – MS SQL Server, Oracle, DB2, Teradata, Flat files, Kafka Topics, XML files. Experience in creating, modifying and maintaining the Autosys scheduling jobs Experience in Developing Unix Shell Scripts and Complex SQL queries (Source Queries, Pre & Post queries), Stored Procedures, Functions Designed & Developed DataStage Jobs using Oracle Connector, Teradata Connector, ODBC Connector, Aggregator, Copy, Data Set, Filter, Funnel, Join, Lookup, Row Generator, Peek, Switch, Transformer stages; Good understanding of Hierarchical Data, Pivot stages; Execute command, Exception handling, Job activity, Notification activity, Sequencer stages. Designed & Developed IICS Mappings with different transformations, IICS scheduler tasks. Expertise in testing ETL jobs, Database, Reports, Web Services and Web based applications. Experience in Automating the complex and most reusable functionalities of various applications using reusable SQL Scripts & QTP, VB Script. Expertise in performing functional testing & regression testing at system level; working knowledge of integration testing. Experience of test planning, preparation & management Working Knowledge & expertise in test management tools ALM, Quality Center Experience in all phases of Developing the End-To-End ETL solutions – Includes Requirements Analysis, Prototyping, Design, Development, Testing, Implementation & Production Support Collaborate with various business and technical teams to gather requirements of data flows, propose the optimized ETL solution, then design and develop the Data pipelines Strong understanding on agile methodologies, Quality procedures Descent understanding of Hadoop ecosystem and Cloud ecosystem (GCP) Identification & Implementation of process & product improvement opportunities