F

Flex

Global contract manufacturer offering design engineering

Senior ETL Developer

Data EngineeringPosted on Nov 12
Full-timeChennai, Tamil Nadu, IndiaNo salary listedIn-person

About the Job

Requirements

  • Four to six years of development experience in a data warehousing environment, with strong knowledge of data integration, migration, and replication using Informatica PowerCenter/products, Oracle, MySQL, Snowflake, and Unix shell scripting.
  • Proficiency in data modeling and strong exposure to data warehousing concepts.
  • Experience implementing large data warehousing or data lake projects.
  • Hands-on experience with databases, including PL/SQL and SQL.
  • Hands-on experience with SQL query tuning, query rewriting, and fine-tuning.
  • Ability to write complex Unix shell and Python scripts.
  • Hands-on experience with Informatica PowerCenter and other Informatica products.
  • Strong knowledge of Oracle, SQL Server, PostgreSQL, and Snowflake databases, and ability to write and optimize complex SQL queries.
  • Experience with scripting languages such as Unix shell and Python.
  • Strong knowledge of data analysis, data transformation, conceptual data modeling, and metadata management.
  • Experience handling file types for sending and receiving data, including CSV, API, XML, JSON, and AVRO.
  • Ability to design and develop ETL for data warehouse projects.
  • Technical skill in optimizing and tuning SQL queries or workflows to reduce processing cycle times for large datasets.
  • Understanding of industry standards for data security and privacy.

Responsibilities

  • Analyze data requirements and data models, and determine methods for extracting, transforming, and loading data into data warehouses and other system integration projects.
  • Perform source-system analysis and design extract logic.
  • Architect solutions; design code; implement and expand data pipelines through extraction, transformation, and loading activities.
  • Investigate data to identify potential issues within ETL pipelines.
  • Write SQL scripts to perform data comparison checks and unit test data integration jobs.
  • Prepare high- and low-level design documentation.
  • Create proofs of concept for data integration use cases using data integration tools and databases.
  • Write shell scripts or Python scripts for in-house automation activities.
  • Design and develop Informatica mappings, mapplets, and workflows using Informatica products.
  • Coach and guide team members, implement best practices, and automate routine activities.
  • Prepare high- and low-level design documents and test cases for data warehousing projects.

Desired Qualifications

  • Exposure to cloud data integration tools such as Matillion, Snowflake OpenFlow, Kafka Streaming, and the MuleSoft platform.
  • Experience working in a Change Data Capture (CDC) environment.
  • Knowledge of Qlik Replicate, big data, APIs, and cloud data integration tools.

About the Company

Flex

Global contract manufacturer offering design engineering

Flex is a global manufacturing partner that designs, engineers, manufactures, and manages the supply chain for products across diverse industries. Its offering starts with product design and engineering, followed by manufacturing and testing, and extends to sourcing, logistics, and end-to-end delivery of finished goods. Unlike many players that focus on a single niche, Flex provides end-to-end, globally integrated services across multiple industries, leveraging a large worldwide network and scalable operations. The company’s goal is to help customers bring products to market quickly and efficiently by handling development, manufacturing, and supply chain management at scale.

Company size
10,001+
Company stage
IPO
Headquarters
Singapore, Singapore
Founded
1969

Recently Posted Jobs

Explore more opportunities at Flex

See more jobs