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 robust

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 flexible 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 [email protected] 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