Description

Experienced Technical Consultant with a strong background in delivering end-to-end data integration, analytics, and digital transformation projects across hybrid platforms. Proven expertise in bridging business needs with technical solutions, leading cross-functional teams, and driving continuous improvement through Agile methodologies. Recognized for strategic thinking, stakeholder collaboration, and delivering customer-centric outcomes with a consistent 100% client satisfaction rating.

Languages

English
Native or bilingual
Tamil
Native or bilingual
French
Basic

Workplace preferences

Remote only

Primarily works remotely

tataconsultanyservices
Technical Architect
DIGITAL AND IT
June 2013 - September 2025 (12 years and 3 months)
Chennai, India
Core Responsibilities
ETL Development & Data Integration
Designed, developed, and maintained ETL workflows using Informatica (PowerCentre, IDMC, IICS) for seamless data extraction, transformation, and loading
Led data migration projects from legacy systems to cloud platforms (AWS Redshift, S3, Glue, Airflow) and enterprise data warehouses
Developed Mapping documents, defined mapping rules, and ensured data quality
Maintenance, Performance & Troubleshooting
Carried out corrective and preventive maintenance of ETL processes
Optimized workflows with partitioning, session tuning, and SQL query optimization across Oracle, SQL Server, Teradata, and Redshift
Diagnosed failures, debugged issues, and resolved incidents (via ServiceNow, Jira), ensuring SLAs and uptime
Project Leadership & Collaboration
Gathered and prioritized requirements with business stakeholders; provided estimations, execution plans, and secured sign-offs.
Led sprint planning, task assignment, code reviews, and unit/SIT/UAT support across distributed teams.
Coordinated with DBAs, data architects, and other applications for schema design, validation, and integration
Data Analysis & Process Improvement
Interpreted measurement results, validated datasets, and ensured data reliability
Conducted root cause analysis for defects and implemented technical/process improvements
Organized brainstorming and innovation sessions to foster continuous improvement within teams
Prepared technical files, functional documents, intervention reports, and operational procedures
Ensured adherence to QSSE, regulatory compliance, and enterprise standards in all deliverables
Training & Knowledge Sharing
Served as Senior Faculty for SQL, PL/SQL, Unix, ETL (Informatica), and BI reporting (SAP BO)

Tools & Technologies
ETL: Informatica PowerCentre, IDMC, IICS, ETL Glue, Airflow
DB: Oracle, SQL Server, Teradata, AWS Redshift
Scheduling: Control-M, Linux/Unix scripting
Business: Jira, Confluence

Agile method Atlassian Confluence Atlassian JIRA Data science GDPR
Cognizant
Associate Engineer
TECH
November 2010 - June 2013 (2 years and 7 months)
Chennai, India
Analyse and define clients' business strategy and determine system
architecture requirements to achieve business goals.
• Understanding business requirements and model AS-IS and TO-BE
process flow for gap analysis and business process.
• Chairing idea qualification/validation sessions with clients to
understand and validate requirements and determining the scope
of the project.
• Advising strategic /tactical solutions.
• Translating business requirements into technical solutions,
impacting and estimating work, release planning for continuous
integration.
• Manage and Mentor a cross-functional team of developers,
testers and user assistance specialists on life sciences & banking and
financial services.
• Managing risks, expectations and escalating to senior management
when required.
• Work with the team to provide optimum productivity to the
business and ensure that the team are motivated and following
agile best practice.
• Facilitate all sprint ceremonies, including the Sprint Review session
with external clients, both on and off-site.
• Coach internal and external SMEs on the creation of ‘development
ready’ user stories.

Tools & Technologies
ETL & Data Integration: Informatica PowerCentre
Databases: Oracle, SQL Server, Teradata,
Workflow & Job Scheduling: Control-M, Linux/Unix scripting
Business & Collaboration: ServiceNow
BI & Domain-Specific: Veeva Network, SAP BO

ETL Data visualization SQL UNIX Data analysis
ComputerSciencesCorporation
Developer
June 2007 - November 2010 (3 years and 5 months)
Chennai, India
As a senior developer, involved in development of mapping using various transformations to meet the requirements.

Creation of Control M jobs to execute the respective workflows and applying the dependencies of each jobs.

Involved in changing the source system of each SOR to STG mapping due to change in source system migration.

Validation of jobs after the change in source system and compare with the existing jobs.

Coordinating with CAB team for the Change request and successfully implemented the Production deployment
SQL ETL Linux Data analysis