Sandeep N Email & Phone Number

Hicksville, Ny , Us

• Administered DataStage application in windows platform. Built new DataStage servers, applied WebSphere/infosphere patches, Infosphere 11.5 migration, Infosphere 11.7 migration, Infosphere 11.7.1.4 migration, applied log4j patches and other vulnerability patches, resolved Infosphere DataStage performance issues with AV tools like Carbon black & Sentinel One. Collaborated with various teams and external vendors and that’s the key for successful administration.• Led & created Datamart’s in Snowflake Platform. Designed Reusable CDC stored procedures, masking polices, implemented time travel queries, implemented role based access control, implemented AWS S3 integration, implemented Snow pipe, Streams• Led and designed ETL pipelines to a Postgres application using Infosphere DataStage,AWS DMS services & Lambda functions• Mentored Technical team works on Informatica PowerCenter and helped them to resolve the data lineage issues and created few shell scripts and partially automated the ETL lineage extract process from Infosphere DataStage.• Mentored a big group of ETL consultants for a large conversion program and have provided them necessary domain knowledge, provided best practices & internal coding standards and also addressed their daily roadblocks, deployment issues, mock run issues.• Designed ETL jobs in Informatica/IDMC and loaded data into Salesforce and Snowflake and vice versa• Designed ETL pipelines for Data warehouse with 80 different source systems. As part of these designs over the years gained SME knowledge in various banking domain concepts like QRM, Sub-Servicing, Mortgage servicing (Black knight), Mortgage origination (Mortrac), Commercial Loan origination (NCINO), Commercial Servicing (AFS), Community Banking, Servicing Deposits (FISERV), Anti-Money Laundering (AML) data feeds to Actimize • Led & converted legacy MDM PL/SQL code to Latest DataStage version.

Mumbai, Maharashtra, In

• Led team to convert intricate business rules into ETL application that involves fee calculation based on multiple factors for the sub-servicing line of business. Challenge was given here to identify all the data points and convert these into rules and automate these on daily basis.• Developed deployment scripts to semi automate the deployment process and reduce manual errors and human effort. Used GIT, Batch scripting.• Developed common ETL audit framework for the Datawarehouse and used it for multiple applications to meet compliance needs. Used routines, DataStage RCP• Assisted data modeling team in various banking domains like supporting transactions, sub-servicing, servicing, origination., master data management.• Implemented various transformations in Parallel jobs using Joiner, Lookup, Transformer, Stage variables, Loop, Sort, Merger, Oracle Connector, Snowflake Connector, Unstructured, Sequential file, Vertical Pivot, Horizontal Pivot, XML, Hierarchy, Sparse Lookup, Standardize, Survive, ODBC Connector, JDBC Connector, Real Time, Change Capture, Aggregator stages, Before Routine, After routines, Parameter Sets in IBM Infosphere DataStage in 11.7, • Implemented automated workflows (Sequencers) using Job activity, Nested Condition, Notification activity, execute command, Start Loop, End Loop, Wait for File activity, Exception Handler in IBM Infosphere DataStage 11.7• Worked with PL/SQL procedures and converted legacy codes into new ETL applications. Modified Oracle External tables, Partitions, Packages, Functions, Procedures, Triggers, Cursors, Indexes, Analytical functions• Worked with Enterprise scheduler tools like CISCO tidal, Control M to schedule ETL jobs. Used dsjob commands framework.• Worked with Cloud data platforms like Snowflake, Postgress.• Worked closely with Delivery managers, Project managers, CDO’s and assisted them to prepare project plan, resource estimates.

Bangalore, Karnataka, In

• Developed Informatica ETL jobs and created mappings, maplets, workflows to migrate data from one system to another.• Created reconciliation reports in excel at the closure of the project.• Prepared Functional requirements, Business requirements.• Created Unit test cases and execute for the Jobs.• Reviewed code with Architects and accommodate changes.• Worked as Production support for a tier 1 application and created mapping documents for legacy application.• Prepared Generic SQL from meta data tables to simplify testing on staging tables• Created FTP scripts to copy files from Dropzone to ETL server