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
#LI-RR1
RR03
Required Skills
Optional Skills
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 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).