Software Engineer - Informatica
- Thomson Reuters
- 4 - 6 years
- Bengaluru
- 29 days ago
- Email to a friend
- Report this job
Job Description
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:
- 4-6 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.
Job Classification
Industry: Advertising & MarketingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database Developer / EngineerEmployement Type: Full timeContact Details:
Company: Thomson ReutersLocation(s): Bengaluru
Keyskills: Informatica S3 ESP Glue Confluence PostgreSQL Control-M SQL Server JIRA Lambda Redshift
Similar positions
Thomson Reuters
About KBL:\n\nKirloskar Brothers Limited (KBL) is a world-class pump manufacturing company with expertise in engineering and the manufacture of systems for fluid management. Established in 1888 and incorporated in 1920. KBL is the flagship company of the $ 2.1 billion Kirloskar Group. The marke...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in