Mohit B. Email & Phone Number

Bangalore, Karnataka, In

San Antonio, Texas, Us

• Lead team of 15 Data Engineers for Netezza to Snowflake Data Migration project plan.• Create ETL jobs inventory and generate report ETL jobs changes by end of every month to get convert updated jobs to Snowflake.• Work with Admin teams for Linus server setup• Setup CICD pipeline from gitlab using UCD application • Create Python script to discover scripts which are used to execute Informatica workflows to update repository and integration service for 300+ projects.• Create Python script to update 1000+ scripts with required repository name and integration service.• Create Python script to update 2000+ Param file new connections.• Create Python to get directory of 300+ projects and generate report using that.• Automate the process to create Dir. Structure for all 300+ projects using csv file as input • Having planned and unplanned discussions with the respective stakeholders to ensure all the work items are running on time and any factor to delay the work is escalated proactively and followed up until the closure.• Use and follow the Jira tool for story execution and tracking.• Use Wiki pages to keep all knowledge gained from analysis for all 300+ projects like design, process, ETL Process etc.• Conduct periodic knowledge sharing sessions on technical design of business processes, and cross-skilling of technologies within the team to increase the proficiency levels.• Guide and fix informatica code which is converted for Snowflake.• Create Control-M jobs to point to Snowflake.• Plan & execute performance & Unit testing of Informatica-Snowflake jobs.

Chiyoda-Ku, Tokyo, Jp

• As Data Lead closely work with Infrastructure Team, Architects, co-ordinate among Business analyst, Data Analyst, Data Engineering and QA Teams to make sure the delivery of all planned interfaces of current sprint by following Bank coding standards. • Hands on Data Modeling using ERWin and Analytics tools as Data Analyst• As part of Data Engineering team, hands on AWS S3, Step function, lambda function, Cloud Watch logs, Python, Spark, Hive, RDS. • Involved in Business discussion on requirement gathering along with BA Team. • Bitbucket is used for code check-in.

New York, Ny, Us

• Requirements Gathering, impact analysis, project estimations and documentation.• Data warehouse design and Involves interpreting architecture and design, data modeling. • Responsible for design, provide solution while working in Architect Team and development using various DW related tools and frameworks i.e. Informatica 10.2, Pentaho, Sybase, UNIX, Control-M, Python, SVN, Bitbucket, and GitHub. Responsible for reviewing source code written by other programmers and doing bug fixes. • Mentoring team in compiling and writing documentation of program development and subsequent revisions, inserting comments in the coded instructions to ensure right understanding of code behavior in real time. • Review test cases, test scripts, execution of test cases and all artifacts into the documents, ensuring effective with (System Integration, Performance, User acceptance), Squad lead and Project Manager signed off and rolled out. • Guiding Team how to Maintain, Optimize and improve the existing applications while working on enhancement and production code fixes.• Indulge in scheduling scrum calls and clear road blockers for Development/Business Analyst/Architect Teams and keeping the projects on track.• Responsible for successful Production migration and document data/code validation.• As part of L3-team, supporting applications SFG, GPS and CDOROM by doing analysis and code fixes of production issues.

Chiyoda-Ku, Tokyo, Jp

• Resource Planning and Strategy, Researching, identifying (any) potential problems while code migration and devising ways to rectify or overcome the problems, producing cohesive and intelligent plans to bring the successful outcome for the end user. • Requirements Gathering, impact analysis and documentation.• Data warehouse design and Involves interpreting architecture and design, adherence to programming and documentation policies defined by EPLC. • Responsible for design, provide solution while working with Architect Team and development using various DW related tools and frameworks i.e. Informatica 10.2, Wherescape Red, Oracle, Greenplum, Unix, Autosys, Bitbucket, and GitHub. Responsible for reviewing source code written by other programmers and doing bug fixes. • Compiling and writing documentation of program development and subsequent revisions, inserting comments in the coded instructions to ensure right understanding of code behavior in real time. • Writing test cases, test scripts, execution of test cases and logging all these artifacts into the documents, adherence to policies defined by EPLC. Ensuring effective with (System Integration, Performance, User acceptance), Enterprise Change Management and Release Management signed off and rolled out. • Maintaining, Optimizing and improving the existing Data warehouse applications while working on System Commission project.• Responsible for successful Production migration and document data/code validation.

Chiyoda-Ku, Tokyo, Jp

• Planning and Strategy, Research, identifying (any) potential problems and devising ways to rectify or overcome the problems, producing cohesive and intelligent plans to bring the successful outcome for the end user. • Requirements Gathering and documentation; Use case analysis. • Data warehouse design and Involves interpreting architecture and design, adherence to programming and documentation policies defined by EPLC. • Responsible for programming and development using various DW related tools and frameworks i.e. Informatica 10.2, Wherescape Red, Oracle, Greenplum, Unix, Autosys, Bitbucket, and GitHub. Responsible for reviewing source code written by other programmers and doing bug fixes. • Compiles and writes documentation of program development and subsequent revisions, inserting comments in the coded instructions to ensure right understanding of code behavior in real time. • Writing test cases, test scripts, execution of test cases and logging all these artifacts into the documents, adherence to policies defined by EPLC. Ensuring effective with (System Integration, Performance, User acceptance), Enterprise Change Management and Release Management signed off and rolled out. • Maintaining, Optimizing and improving the Data warehouse applications. This involves the logic in existing applications as a part of application maintenance activities. Direct revision, repair, or expansion of existing programs to increase operating efficiency or adapt new requirements.

Chiyoda-Ku, Tokyo, Jp

• Understand Business requirements. • Interaction with Business team and stakeholders for the product analysis. • Design and develop complex mappings by using Informatica 10.2. • Develop and maintain both ETL & ELT to extract data from Mainframe, Database and Flat file to load the data in data warehouse. • Conduct research, data analysis and implementation for consulting Data warehouse & Business Intelligence projects. • Create Autosys jobs to schedule the ETL jobs. • Expert in optimizing various processes with the help of Table Partitioning, Stats Collection, Indexing and Index Monitoring.

Norwalk, Ct, Us

• Participating in business discussion to gather requirement and document it.• Familiarize the team with the customer needs, specifications, design targets, the development process, design standards, techniques and tools to support task performance.• Provide subject matter expertise to support reporting needs for multiple functional areas.• Experience in data analysis as per requirement and document impact analysis.• Develop functional and technical requirement document by coordinating with business team and freeze requirement using Teradata, Informatica, Business Objects and Unix tools.• Coordinate with Data Management team to hand over requirement.• Experience in trouble shooting and long-term solution & fix.• Participate in the process of UAT and Data Modeling.• Perform Unit testing, regression testing and integration testing for any kind of enhancement or new requirement logics developed by data management team.

New York City, Ny, Us

• Participating in Client calls to discuss and understand the business requirements and prioritizing the task as per requirement. • Develop mappings, workflows and scripts using ETL Tools Informatica, Teradata and UNIX as per business needs.• Familiarize the team with the customer needs, specifications, design targets, the development process, design standards, techniques and tools to support task performance.• Provide subject matter expertise to support reporting needs for multiple functional areas.• Hands-on data analysis the data as per requirement and document it.• Manage offshore team, assigning various tasks to the team as per Business requirements.• Hands-on data analysis, trouble shooting of issues.• Develop various Scripts to automate the population of Data in the warehouse as per Business Need.• Participate in the process of UAT and Data Modeling.

New York City, Ny, Us

• Interact with Onsite Lead and client to understand business requirement.• Document the requirement after data and impact analysis. • Prepare Detailed Design Document and data flow diagram to start development. • Develop mappings, workflows and scripts using ETL Tools Informatica, Teradata and UNIX as per business requirements. • Teradata utilities such as MLOAD, FLOAD and TPUMP are used to increase performance.• Prepared test plan, test scripts, failure mode effective analysis document and production. • Support document and SQL Quires for generating reports. • Prepare UNIX scripts to automate load. • Responsible for Production Support, worked various issues and implemented permanent fix.