Experience

• 

  Tech mahindra

  Jun 2012 - Apr 2015

  Software engineer

  1. Project: LynxRole: DataStage DeveloperDescription: Project Lynx is an initiative by the Supply Optimization Group (SOG) unit of Chevron Corporation's Downstream Business Unit to optimize the Oil Supply Chain for Chevron. The technical description of the project is to create a warehouse for the Chevron's downstream production data and to generate reports for business users to enable them to make quicker business decisions optimizing returns in terms of operational excellence and financial benefits for Chevron.Responsibilities:• Involved in constant interaction with the client and understanding the various transformation rules• Experience in Data warehousing, Application development, Data Migration• Developed DataStage jobs to implement the transformations and validation of the output data by carrying out unit testing.• Designed and developed mappings between sources and operational staging targets, using Star and Snow Flake Schemas.• Performed troubleshooting and performance tuning for DataStage 8.5 ETL jobs. Analyzed error table entries and resolved related issues.• Involved in change of existing Datastage jobs to improve performance in production environment and ensure data integrity. Show less

• 

  Accenture

  Apr 2015 - Mar 2019

  Senior etl developer

  Worked in Several projects which included Financial Services,Electricity and Gas Domain,Retail and Security domain1.West Midland Police: Senior Talend Developer2. Michaels Holding LLC: Talend Developer3.National Grid : Senior Datastage Developer4.Cariparma :Datastage Developer

• 

  Hcltech

  Mar 2019 - Feb 2020

  Technical lead

  • Working as a Technical Lead to maintain the existing ETL's and doing enhancements as per business requirements and simultaneously development for another system.• Extraction of data from multiple feed files and loading data in multiple staging tables simultaneously in Oracle DB. • Post creation and loading of Staging tables extracting data from them after doing certain lookups and joins and loading data into Target tables on top of which reports are generated.• Worked on Talend components like tDBSCD, tFilterRow, tJava, tOracleRow,tJoin etc.• Involved in code migration from physical servers to Cloud.• Using Autosys scheduling tool in order to maintain logs and checks for individual successful completion of jobs. Show less

• 

  Northern trust

  Feb 2020 - now

  Consultant