Flex is the diversified manufacturing partner of choice that helps market-leading brands design, build and deliver innovative products that improve the world. A career at Flex offers the opportunity to make a difference and invest in your growth in a respectful, inclusive, and collaborative environment. If you are excited about a role but don't meet every bullet point, we encourage you to apply and join us to create the extraordinary.

To Support Data Integration Engineer – Informatica PowerCenter

Primary tool : Informatica PowerCenter and exposure of Informatica's

other products and cloud-based data integration tools like Matillion

What a Typical Day Looks Like:

- 3 to 5 years of experience in Data Warehousing environment with very strong

knowledge of Data Integration, migration & replication by using Informatica

PowerCenter/products, Oracle, Snowflake & Unix shell scripting

- Proficient in Data modelling & Strong Exposure to Data Warehousing

Concepts.

- Implementation of larger Data Warehousing/Data Lake projects
- Strong hands-on experience on Databases including PL/SQL & SQL
- Hands on experience in SQL query tuning, query re-writing & fine tuning
- Preferred to have exposure on cloud data integration tools
- Able to write the complex Unix shell and Python scripts
- Good Written & Verbal Communication.

The Experience We're Looking to Add to Our Team:

- Hands on experience of Informatica Power Center and other products,

preferred to have worked on CDC (Change Data Capture) environment

- Strong knowledge of Oracle, SQL server, postgres & Snowflake database and

write/optimizing complex SQL queries





- Experience with scripting languages such as Unix Shell and Python
- Strong knowledge of data analysis, data transformation, conceptual data

modelling, data transformation and metadata management.

- Preferred to have knowledge on Qlik Replicate, Big data, APIs, and Cloud data

integration tools experience

- Experience in handling various file types for sending/receiving data

(CSV/API/XML/JSON/AVRO)

- Should be proficient enough to design and develop ETL for any data

warehouse projects

- Should have very good technical skills to optimize/tune the SQL queries or

workflow to reduce cycle times to process huge data set

- Understanding of industry standards for data security and privacy
- Must have good communication and problem-solving skills
- Design and Develop Informatica mappings, mapplets and workflows using

Informatica products

- Share the workload and adaptable enough to get into other technologies as

applicable and need basis

- Coach and guide other members in the team and implement best practices

and automate some of routine day to day activities

- Prepare High & Low-level design documents and Test cases for various Data

Warehousing projects.

Roles and Responsibilities:

- Analyze data requirements, data model and determine the best methods in

extracting,



transforming, and loading the data into the data warehouse and

other system integration projects

- Perform source system analysis and design the extract logic
- Architect the solution, Code Design, Implement and continuously expand data

pipelines by performing extraction, transformation and loading activities

- Investigate data to identify potential issues within ETL pipelines
- Write SQL scripts to perform data comparison checks to unit test data

integration jobs

- Prepare high- and low-level design documentation
- PoCs for various Data Integration uses cases by using various Data

Integration tools and Databases.

- Write Shell scripts or Python scripts for various in-house automation activities

What You'll Receive for the Great Work You Provide:

- Health Insurance
- Paid Time Off (PTO)

CF17

Flex is an Equal Opportunity Employer and employment selection decisions are based on merit, qualifications, and abilities. We do not discriminate based on: age, race, religion, color, sex, national origin, marital status, sexual orientation, gender identity, veteran status, disability, pregnancy status, or any other status protected by law. We're happy to provide reasonable accommodations to those with a disability for assistance in the application process. Please email [HIDDEN TEXT] and we'll discuss your specific situation and next steps (NOTE: this email does not accept or consider resumes or applications. This is only for disability assistance. To be considered for a position at Flex, you must complete the application process first).

📌 ETL Informatica Developer-IT (Chennai)
🏢 Flex
📍 Chennai