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! 🚀