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.
• 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.
• 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.
• Designed ETL jobs in Informatica/IDMC and loaded data into Salesforce and Snowflake and vice versa

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.
• 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.
• 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

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.