KRISHNENDU GHOSH

Serve as the primary contact responsible for overall infrastruture health, peformance and capacity

Perform routine analysis during normal of information technology (IT) infrastructure, including on networks, firewalls, servers, operating systems, applications and devices.

Support the acquiring, installing, and upgrading components and software and planning for service outages and other problems

Provide Informatica IDQ, IICS , Dataiku, Alation, Rundeck Infrastructure management, enhancement and support

Deploy and Managed infrastructure deployed to GCP
Deploy, manage and monitor applications and services on the Kubernetes environment

Provide infrastructure operational support

Work on Production systems and understand the importance of SDLC to ensure that all fixes/changes are fully tested in Non production environments before releasing on production

Work with the various stakeholder on the Audit, regulatory requirements

Implment Identity & Access Management (IAM)

• Managed a team of 8+ individuals to meet the data ingestion requests of Data Platform consumers.
• Designing and developing ETL (Extract, Transform
• Load) workflows for data ingestion and transformation
• I utilized tools such as Informatica
• BDM (Big Data Management), Hadoop Sqoop utility, and NIFI, integrating data lake concepts on both Hadoop and Azure platforms
• This ensured seamless data flow to downstream consumers on
• Google Cloud (bucket) and Azure Cloud (blob storage).
• Ensuring the reliable and efficient delivery of data from various sources, including RDBMS, flat files, and APIs, to the Data Hub.
• Establishing a framework for specific API systems, enabling controlled data retrieval through pagination.

• Managed a team of 10+ team members.
• Provide Level 2 (L2) support and act as a liaison for communication with business segments.
• Perform activities related to data flow maintenance using technologies such as
• Informatica, Big Data, SQL, and Unix.
• Demonstrate a positive attitude and a strong team focus by mentoring fellow team members through knowledge-sharing sessions.
• In the event of execution failures, troubleshoot the issues by analyzing logs and following predefined procedures for problem resolution, including reinitiating failed tasks and notifying the appropriate application/solution team.
• Analyze issues reported by the Level 1 (L1) team, provide Level 2 support, and escalate issues as necessary.
• Engage in change management and incident management activities.
• Collaborate closely with other teams, including
• ETL/Hadoop (HDP) administration, to identify and resolve issues.

• Provide support for 50+ ETL (Extract, Transform
• Load) applications.
• Conduct daily health checks for all applications and submit daily status reports to clients.
• Address bug fixes and contribute to process improvements.
• Maintain communication with upstream and downstream teams regarding incidents.
• Handle production Change Requests (CRs).
• Resolve incidents and communicate the resolutions to clients via email, tracking them in issue logs.

• Led a team of 3 offshore members, successfully achieving project objectives.
• Conducted extensive analysis to comprehend business requirements, assess the existing environment, and understand the ETL (Extract
• Transform, Load) structure.
• Examined the design architecture, scripts, and jobs to be migrated to the new GFB (Global Financial
• Business) environment.
• Managed the installation of Informatica, applied necessary hot fixes, and executed the migration and upgrade of repositories from version 8.1.1 to 9.6.1.
• Installed and configured DAC11g on Unix servers.
• Created new repositories and Integration services through the admin console, overseeing repository backup and restoration processes.
• Collaborated on enhancements to numerous
• Informatica code segments, optimizing data extraction, conversion, and loading in alignment with business rules to resolve performance issues.

• Analyzed project requirements and prepared
• Design Documents (HLD/LLD).
• Created and reviewed ETL mapping specifications.
• Developed ETL mappings, sessions, and workflows, along with crafting Unix scripts as per project requirements.
• Successfully established SFTP connections and transferred necessary files to the target server.
• Conducted code reviews to ensure proper logic implementation and adherence to quality standards in the mappings.
• Conducted testing and prepared Unit Test Cases based on the Unit Test Plan.
• Worked with data pump utility (impdp and expdp) for database import and export tasks.
• Managed and provided support for DEV (Development) and QA (Quality Assurance) databases.
• Created necessary users, roles, and tablespaces as per application and request specifications.
• Executed schema-level, table-level, and full database imports and exports.
• Utilized SQL
• Loader for efficient bulk data loading.
• Employed LiteSpeed tools for SQL databases and
• Microsoft SQL Server Management Studio for executing queries.