Senior ETL Developer

217 FLEXTRONICS TECHNOLOGIES (INDIA) PRIVATE LIMITED; Chennai; On-site; INR 1,200,000 - 1,900,000; Full time

Benefits offered by this job

Health Insurance

Paid Time Off

Job summary

Flex Ltd in Chennai, India is seeking a Senior ETL Developer to design and optimize data integration pipelines for data warehousing projects. You will analyze requirements, build scalable ETL solutions, and implement data validation with SQL scripts.

The role emphasizes hands-on work with Informatica PowerCenter, Snowflake, Oracle and cloud data integration tools, while also leveraging Python/Unix shell scripts for automation and Continuous Improvement.

Qualifications

• 4 to 6 years of Development experience in Data Warehousing environment with very strong knowledge of Data Integration, migration & replication by using Informatica PowerCenter/products, Oracle, MySQL, 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 like Matillion, Snowflake OpenFlow, Kafka Streaming and Mulesoft platform.
• Able to write the complex Unix shell and Python scripts.
• 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.
• 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.

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.

Skills

Data modelling

SQL proficiency

Mentoring teammates

Tools

Informatica PowerCenter

Oracle

MySQL

Snowflake

Unix shell scripting

Python

Matillion

Snowflake OpenFlow

Kafka Streaming

Mulesoft

Qlik Replicate

APIs

Job description

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.

Job Summary: To support our extraordinary teams who build great products and contribute to our growth, we’re looking to add a Senior ETL Developer in Chennai, India.

What a typical day looks like:

• 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

The experience we’re looking to add to our team:

• 4 to 6 years of Development experience in Data Warehousing environment with very strong knowledge of Data Integration, migration & replication by using Informatica PowerCenter/products, Oracle, MySQL, 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 like Matillion, Snowflake OpenFlow, Kafka Streaming and Mulesoft platform.
• Able to write the complex Unix shell and Python scripts
• 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
• 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

What you’ll receive for the great work you provide:

• Health Insurance PTO

Job Category IT

Flex pays for all costs associated with the application, interview or offer process, a candidate will not be asked for any payment related to these costs.

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 [e-mail] 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).

Through the collective strength of ~150,000 team members across 30 countries and responsible, sustainable operations, 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 with Flex offers the opportunity to make a difference, invest in your growth, and build great products for our customers that improve people’s lives. Together, let’s create the extraordinary! Join our talent community to learn more about job opportunities, company news and events.