Data Production Support Engineer

Are you a Data Production Support/Operational Engineer seeking a new interesting challenge?

If your answer is yes, it’s your lucky day so keep reading, it can be just what you're looking for!

🧐 WHAT WE ARE LOOKING FOR IN YOU?

• Bachelor's or Master's degree in Computer Science, Information Systems, Data Engineering, or a related field.
• 6+ years of experience in Data Warehouse, ETL, Data Integration, or Production Support environments.
• 5+ years of hands-on experience with Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS/IDMC).
• Strong understanding of ETL processes, Data Integration, and Data Warehouse concepts.
• Advanced SQL knowledge, with proven experience analyzing complex queries and supporting database performance optimization.
• Experience working with enterprise job scheduling and orchestration tools such as Airflow and TWS (Tivoli Workload Scheduler).
• Hands-on experience with Git, Azure DevOps, and version control best practices.
• Strong experience in production support and operations management within Data Warehouse environments.
• Proven track record in incident management, problem management, change management, and root cause analysis (RCA).
• Experience monitoring ETL workflows, batch processes, and enterprise data platforms.
• Familiarity with SLA management, KPI tracking, and operational reporting.
• Strong documentation skills, including the creation and maintenance of operational runbooks, support procedures, and knowledge repositories.
• Excellent analytical, troubleshooting, communication, and stakeholder management skills.
• Experience working in Agile and cross-functional environments.

GOOD TO HAVE:

• Knowledge and hands-on experience with Azure Data Factory (ADF).
• Understanding of data modeling concepts, preferably Data Vault methodology.
• Exposure to CI/CD implementation for ETL and Data Warehouse solutions.
• Experience supporting cloud-based data integration and analytics platforms.
• Familiarity with enterprise monitoring and alerting frameworks.

🧐 HOW WILL YOUR DAILY JOB BE?

• Monitor and support daily Data Warehouse production operations, ensuring platform stability and reliability.
• Ensure the successful execution of ETL workflows, batch jobs, and data processing activities.
• Investigate, troubleshoot, and resolve production incidents, data load failures, and system issues.
• Perform root cause analysis (RCA) and implement preventive measures to avoid recurring incidents.
• Coordinate with business and technical teams to ensure timely resolution of issues within agreed SLA targets.
• Execute operational activities, including job restarts, reruns, recovery procedures, and production support tasks.
• Analyze ETL performance and identify opportunities for optimization and efficiency improvements.
• Support the deployment of Informatica solutions across Development, Test, Acceptance, and Production environments.
• Monitor scheduling and orchestration platforms such as Airflow and TWS, ensuring smooth execution of workflows.
• Maintain and continuously improve operational documentation, runbooks, and recovery procedures.
• Analyze SQL queries and collaborate with database teams to support performance tuning initiatives.
• Validate data loads and ensure consistency and integrity between source and target systems.
• Perform data reconciliation and validation checks to ensure high-quality data delivery.
• Monitor data quality KPIs, investigate anomalies, and support data quality improvement initiatives.
• Participate in major incident management, problem management, and service improvement activities.
• Support CI/CD deployment processes for ETL and Data Warehouse solutions.
• Maintain source code repositories and deployment artifacts using Git and Azure DevOps.
• Collaborate with cross-functional teams to enhance operational excellence, process automation, and service reliability.
• Contribute to continuous improvement initiatives, ensuring efficient and scalable Data warehouse operations.

WHERE AND WHEN?

• Workplace: Lisbon + hybrid work
• Work Schedule: 9AM to 6PM

🤝 WHAT WE CAN OFFER YOU?

• Permanent contract
• Pay and benefits - Competitive salary and a flexible compensation plan adapted to your needs (Ticket restaurant plan + Health Insurance).
• Opportunity knocks - Being a part of a growing company, we want to support your path with a career development plan and annual performance-based compensation reviews.
• Learn as you grow - Starting with a fantastic onboarding program, TCS has robust learning platforms that will allow you to learn and grow personal as professionally.
• Bring your buddy - If you have referred a friend for an open position under the BYB Scheme and she/he is hired you’ll receive a very attractive cash award.
• Connect globally - Work with people from all over the world. You can feel the multicultural workforce.
• And so on - Appreciations, incentives, Team Building activities, diversity and inclusion programs, sustainability activities, corporative events... This has only just begun!

WHO ARE WE?

Tata Consultancy Services (TCS) is an Information Technology (IT) company founded in 1968, being part of the Tata Group.

With a presence in 55 countries and over 600,000 employees, TCS is recognized as the #1 Employer in Europe by the Top Employers Institute 🥇

In our portfolio of services, we have information technology services, asset-based solutions, global consulting, engineering and industrial services, digital solutions and services, application maintenance and development, quality assurance and testing services, IT infrastructure and BPS

We stand out for our experience, reliability, passion, confidence, creativity and skills

WELCOME, WE ARE WAITING FOR YOU! 🚀