Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sayantan Dutta

Kolkata

Summary

Experienced IT professional with 4 years of expertise in batch job scheduling, ETL administration, and data analytics. Proven track record in managing Control-M and Autosys for workflow automation, optimizing job schedules, and ensuring timely execution of batch processes. Skilled in Informatica administration, including installation, configuration, performance tuning, and security implementation for seamless data integration. Proficient in data analysis using tools like PowerBI, MS Excel, and SQL to create insightful dashboards and reports that drive business decisions.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Scheduler

Wipro
Kolkata
05.2021 - Current
  • Create, configure, and schedule jobs in Control-M/Autosys based on project requirements and timelines.
  • Created box jobs and independent jobs in Control-M for Informatica workflows, ensuring alignment with workflow calendars and project timelines.
  • Continuously monitor the execution of scheduled jobs to ensure that they run as expected.
  • Check for job failures, delays, or any anomalies, and take immediate corrective actions when necessary.
  • Managed weekly maintenance activities for the Informatica environment using Control-M jobs, ensuring system stability and performance.
  • Placed jobs on hold during maintenance to prevent failures, and restarted them post-maintenance based on service requests and change requests.
  • Regularly update job schedules to accommodate new requirements, changes in dependencies, or optimization needs.
  • Restarted jobs in both development and production environments after resolving issues, ensuring minimal downtime.
  • Worked closely with Informatica developers, and operations teams to ensure smooth job execution and maintenance activities.

Informatica Administrator

Wipro
Pune
05.2021 - 05.2024
  • Maintained and supported four Informatica environments (Batch, CDC, CDCRC, and QA) to ensure optimal performance and availability.
  • Used Linux commands and PowerCenter clients to maintain and troubleshoot workflows, ensuring smooth execution.
  • Conducted weekly health checks of Informatica jobs using Control-M, proactively identifying and resolving issues.
  • Responsible for workflow migration across various environments (e.g., development to QA, QA to production), ensuring seamless transitions.
  • Checked workflow logs and debugging sessions to identify and resolve workflow failures, minimizing downtime.
  • Collaborated with vendors to resolve long-pending issues related to PowerCenter clients, improving system stability.
  • Imported data sources and created relational connections for workflows, enabling seamless data integration.
  • Managed permissions for developers, ensuring secure and controlled access to Informatica resources.
  • Worked with PowerExchange to import data into CDC and CDCRC environments, ensuring accurate and timely data synchronization.
  • Maintained Informatica repositories and resolved issues related to repository and integration services, ensuring data integrity and system reliability.

Governance Analyst

Wipro
Pune
05.2021 - 05.2024
  • Designed and developed Power BI dashboards to analyze monthly Informatica tickets, service requests, and change requests, ensuring alignment with SLA requirements.
  • Conducted in-depth data analysis using DBeaver and MSSQL to identify trends, bottlenecks, and areas for improvement in ticket resolution processes.
  • Created dynamic MS Excel reports with advanced formulas, macros, and pivot tables to track KPIs, and present actionable insights to clients.
  • Collaborated with cross-functional teams to ensure data accuracy and timely reporting for client meetings.
  • Presented dashboards and reports to clients, highlighting key metrics, SLA compliance, and recommendations for process optimization.
  • Automated reporting processes reduce manual effort and improve efficiency in governance analytics.

Education

Master of Technology - Computer Science

Birla Institute of Technology
Remote
12-2024

Bachelor of Computer Applications - Computer Applications Development

Techno India
Kolkata
06-2020

Skills

  • Database tools: DBeaver, MSSQL
  • ETL Tools: Informatica PowerCenter, PowerExchange
  • Scheduling tools: Control-M, Autosys
  • Governance Tools: ITIL, ServiceNow
  • Data Visualization: Power BI, MS Excel

Certification

  • Informatica Development(Udemy)
  • PowerBI complete crash course(Udemy)
  • Autosys Scheduling(Wipro)
  • Full Stack Development(Ejob India - 2021)

Timeline

Scheduler

Wipro
05.2021 - Current

Informatica Administrator

Wipro
05.2021 - 05.2024

Governance Analyst

Wipro
05.2021 - 05.2024

Master of Technology - Computer Science

Birla Institute of Technology

Bachelor of Computer Applications - Computer Applications Development

Techno India

Similar Profiles

CREATE PROFILE
Sayantan Dutta