ETL Informatica Developer-IT

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.

Job Description

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:

1. 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
2. Proficient in Data modelling & Strong Exposure to Data Warehousing
   Concepts.
3. Implementation of larger Data Warehousing/Data Lake projects
4. Strong hands-on experience on Databases including PL/SQL & SQL
5. Hands on experience in SQL query tuning, query re-writing & fine tuning
6. Preferred to have exposure on cloud data integration tools
7. Able to write the complex Unix shell and Python scripts
8. Good Written & Verbal Communication.

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

1. Hands on experience of Informatica Power Center and other products,
   preferred to have worked on CDC (Change Data Capture) environment
2. Strong knowledge of Oracle, SQL server, postgres & Snowflake database and
   write/optimizing complex SQL queries
3. Experience with scripting languages such as Unix Shell and Python
4. Strong knowledge of data analysis, data transformation, conceptual data
   modelling, data transformation and metadata management.
5. Preferred to have knowledge on Qlik Replicate, Big data, APIs, and Cloud data
   integration tools experience
6. Experience in handling various file types for sending/receiving data
   (CSV/API/XML/JSON/AVRO)
7. Should be proficient enough to design and develop ETL for any data
   warehouse projects
8. Should have very good technical skills to optimize/tune the SQL queries or
   workflow to reduce cycle times to process huge data set
9. Understanding of industry standards for data security and privacy
   10.Must have good communication and problem-solving skills
   11.Design and Develop Informatica mappings, mapplets and workflows using
   Informatica products
   12.Share the workload and flexible enough to get into other technologies as
   applicable and need basis
   13.Coach and guide other members in the team and implement best practices
   and automate some of routine day to day activities
   14.Prepare High & Low-level design documents and Test cases for various Data
   Warehousing projects.

Roles and Responsibilities:

1. 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
2. Perform source system analysis and design the extract logic
3. Architect the solution, Code Design, Implement and continuously expand data
   pipelines by performing extraction, transformation and loading activities
4. Investigate data to identify potential issues within ETL pipelines
5. Write SQL scripts to perform data comparison checks to unit test data
   integration jobs
6. Prepare high- and low-level design documentation
7. PoCs for various Data Integration uses cases by using various Data
   Integration tools and Databases.
8. 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

Job Category

ITFlex 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 does not accept unsolicited resumes from headhunters, recruitment agencies or fee based recruitment services. Flex is an Equal Opportunity Employer and employment selection decisions are based on merit, qualifications, and abilities. Flex does not discriminate in employment opportunities or practices 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. Flex provides reasonable accommodation so that qualified applicants with a disability may participate in the selection process. Please advise us of any accommodations you request to express interest in a position by e-mailing: [email protected]. Please state your request for assistance in your message. Only reasonable accommodation requests related to applying for a specific position within Flex will be reviewed at the e-mail address. Flex will contact you if it is determined that your background is a match to the required skills required for this position. Thank you for considering a career with Flex.