Flex
Website:
flex.com
Job details:
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 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 accessibility@flex.com 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).
Click on Apply to know more.
