top of page

Data Engineer - Informatica

Bangalore, Karnataka, India

Job Type

Full Time

About the Role

As an Informatica Developer, you will be responsible for designing, developing, and implementing Informatica-based solutions to meet the data integration and data management needs of GSC business. You will collaborate with cross-functional teams, including business analysts, data architects, and project managers, to understand requirements, design efficient data integration workflows, and deliver high-quality solutions within established timelines. You will also be involved in troubleshooting, performance tuning, and optimizing existing Informatica processes to enhance overall system performance.

Primary Skills:

ETL tools: Informatica power center / IICS
Additional skills : Snaplogic / AWS Glue

DB: SQL server / Redshift.

SUMMARY OF JOB:

1. Design, develop, and implement data integration workflows using Informatica PowerCenter or other Informatica products and snap logic and AWS glue.
2. Collaborate with business analysts, data architects, and project managers to gather and analyze requirements, translating them into technical specifications and data integration workflows.
3. Build and maintain ETL mappings, workflows, and transformations to extract, transform, and load data from various sources into target systems.
4. Perform data profiling, data cleansing, and data validation activities to ensure data quality and accuracy.
5. Develop and maintain documentation, including technical specifications, data mappings, and process flow diagrams.
6. Collaborate with cross-functional teams to troubleshoot and resolve issues related to data integration, data quality, and system performance.
7. Conduct performance tuning and optimization of existing Informatica workflows to improve system efficiency and throughput.
8. Stay updated with the latest Informatica technologies, best practices, and industry trends, and apply them to enhance data integration processes.
9. Participate in code reviews, ensuring adherence to coding standards and best practices.
10. Provide technical guidance and mentorship to junior developers as needed.

Requirements

Experience & Education: 4 - 6 years of experience

Qualifications: 

 

1.      Bachelor's degree in Computer Science, Information Technology, or a related field.

2.      4-6 years of hands-on experience in designing, developing, and implementing data integration solutions using Informatica PowerCenter.

3.      Strong understanding of data integration concepts, ETL processes, and data warehousing principles.

4.      Proficiency in Informatica PowerCenter, including experience with transformations, mappings, workflows, and scheduling.

5.      Create various active and passive transformations to support voluminous loading of data target table using Informatica PowerCenter.

6.      Good knowledge on data warehouse and schemas.

7.      Experience with data profiling, data cleansing, and data validation techniques.

8.      Solid SQL and database skills, with proficiency in writing complex SQL queries.

9.      Familiarity with data modeling and database design concepts.

10.   Strong problem-solving and troubleshooting skills with the ability to analyze and resolve complex data-related issues.

11.   Excellent verbal and written communication skills, with the ability to effectively collaborate with cross-functional teams.

12.   Ability to work independently and manage multiple priorities in a fast-paced, deadline-driven environment.

13.   Informatica certification(s) will be a plus.

 

Optional or additional skills: 

1.      Other ETL tools like SSIS, AWS Glue, Pyspark

2.      Programming languages like Python etc

3.      Functional knowledge in ERP and especially supply chain industry relevant.

About the Company

Cigres Technologies Private Limited is a technology consulting and services company that focuses on helping clients resolve their significant digital problems and enabling radical digital transformation using multiple technologies on premise or in the cloud. The company was founded with the goal of leveraging cutting-edge technology to deliver innovative solutions to clients across various industries.

bottom of page