We are looking for an experienced *Software Engineer - Informatica* with 4 to 6 years of hands-on expertise* in designing developing and optimizing large-scale *ETL solutions* using *Informatica PowerCenter*. The ideal candidate will lead ETL projects mentor junior developers and ensure high-performance data integration across enterprise systems.
About The Role
In this role as Software Engineer you will:
- Analyze business and functional requirements to design and implement scalable data integration solutions
- Understand and interpret High-Level Design (HLD) documents and convert them into detailed Low-Level Design (LLD)
- Develop robust reusable and optimized Informatica mappings sessions and workflows
- Apply mapping optimization and performance tuning techniques to ensure efficient ETL processes
- Conduct peer code reviews and suggest improvements for reliability and performance
- Prepare and execute comprehensive unit test cases and support system/integration testing
- Maintain detailed technical documentation including LLDs data flow diagrams and test cases
- Build data pipelines and transformation logic in Snowflake ensuring performance and scalability
- Develop and manage Unix shell scripts for automation scheduling and monitoring of ETL jobs
- Collaborate with cross-functional teams to support UAT deployments and production issues.
About You
You are a fit for this position if your background includes:
- 46 years of strong hands-on experience with Informatica PowerCenter
- Proficient in developing and optimizing ETL mappings workflows and sessions
- Solid experience with performance tuning techniques and best practices in ETL processes
- Hands-on experience with Snowflake for data loading SQL transformations and optimization
- Strong skills in Unix/Linux scripting for job automation
- Experience in converting HLDs into LLDs and defining unit test cases
- Knowledge of data warehousing concepts data modelling and data quality frameworks
Good to Have
- Knowledge of Salesforce data model and integration (via Informatica or API-based solutions)
- Exposure to AWS cloud services like S3 Glue Redshift Lambda etc.
- Familiarity with relational databases such as SQL Server and PostgreSQL
- Experience with job schedulers like Control-M ESP or equivalent
- Agile methodology experience and tools such as JIRA Confluence and Git
- Knowledge of DBT (Data Build Tool) for data transformation and orchestration
- Experience with Python scripting for data manipulation automation or integration tasks.
#LI-SM1
Whats in it For You
Hybrid Work Model: Weve adopted a flexible hybrid working environment (2-3 days a week in the office depending on the role) for our office-based roles while delivering a seamless experience that is digitally and physically connected.
Flexibility & Work-Life Balance: Flex My Way is a set of supportive workplace policies designed to help manage personal and professional responsibilities whether caring for family giving back to the community or finding time to refresh and reset. This builds upon our flexible work arrangements including work from anywhere for up to 8 weeks per year empowering employees to achieve a better work-life balance.
Career Development and Growth: By fostering a culture of continuous learning and skill development we prepare our talent to tackle tomorrows challenges and deliver real-world solutions. Our Grow My Way programming and skills-first approach ensures you have the tools and knowledge to grow lead and thrive in an AI-enabled future.
Industry Competitive Benefits: We offer comprehensive benefit plans to include flexible vacation two company-wide Mental Health Days off access to the Headspace app retirement savings tuition reimbursement employee incentive programs and resources for mental physical and financial wellbeing.
Culture: Globally recognized award-winning reputation for inclusion and belonging flexibility work-life balance and more. We live by our values: Obsess over our Customers Compete to Win Challenge (Y)our Thinking Act Fast / Learn Fast and Stronger Together.
Social Impact: Make an impact in your community with our Social Impact Institute. We offer employees two paid volunteer days off annually and opportunities to get involved with pro-bono consulting projects and Environmental Social and Governance (ESG) initiatives.
Making a Real-World Impact:We are one of the few companies globally that helps its customers pursue justice truth and transparency. Together with the professionals and institutions we serve we help uphold the rule of law turn the wheels of commerce catch bad actors report the facts and provide trusted unbiased information to people all over the world.
About Us
Thomson Reuters informs the way forward by bringing together the trusted content and technology that people and organizations need to make the right decisions. We serve professionals across legal tax accounting compliance government and media. Our products combine highly specialized software and insights to empower professionals with the data intelligence and solutions needed to make informed decisions and to help institutions in their pursuit of justice truth and transparency. Reuters part of Thomson Reuters is a world leading provider of trusted journalism and news.
As a global business we rely on the unique backgrounds perspectives and experiences of all employees to deliver on our business goals. To ensure we can do that we seek talented qualified employees in all our operations around the world regardless of race color sex/gender including pregnancy gender identity and expression national origin religion sexual orientation disability age marital status citizen status veteran status or any other protected classification under applicable law. Thomson Reuters is proud to be an Equal Employment Opportunity Employer providing a drug-free workplace.
We also make reasonable accommodations for qualified individuals with disabilities and for sincerely held religious beliefs in accordance with applicable law. More information on requesting an accommodation here.
Learn more on how to protect yourself from fraudulent job postings here.
More information about Thomson Reuters can be found on .
Document Intelligence from Thomson Reuters makes analyzing contracts and documents easy by leveraging the power of A.I. and the expertise of Practical Law.