Informatica Cloud Data Engineer

Avenue 45; Cypress (CA); Hybrid; USD 125,000 - 135,000; Full time

Benefits offered by this job

Annual bonus opportunity

401K matching

Comprehensive benefits package

Job summary

A technology solutions provider in Cypress, CA is looking for a Mid-Senior level Informatica Cloud Data Engineer. This full-time role requires a hybrid schedule, focusing on designing data integration solutions and managing data workflows using tools like IDMC and AWS. Candidates should have a strong background in ETL processes and excellent communication skills. The position offers a competitive salary of $125,000 - $135,000 with bonuses and benefits.

Qualifications

• 4+ years of relevant experience in design and execution of data analysis techniques.
• Advanced experience in Informatica Data Management Cloud (IDMC).
• Experience with programming languages such as Python and R.

Responsibilities

• Design and create framework for data processing.
• Collect and curate data for analysis.
• Develop knowledge of the company's applications.

Skills

ETL/ELT workflows

SQL development

cloud platforms

real-time data streaming tools

data pipelines

problem-solving skills

communication skills

collaboration skills

Education

Bachelor’s degree in computer science, Data Science, Mathematics

Tools

Informatica Data Management Cloud (IDMC)

Python

R

AWS GLUE ETL

Job description

Get AI-powered advice on this job and more exclusive features.

This range is provided by Avenue 45. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$125,000.00/yr - $135,000.00/yr

Additional compensation types

Annual Bonus

Direct message the job poster from Avenue 45

Our direct client is seeking an Informatica Cloud Data Engineer for a full-time, direct-hire position.

This role follows a hybrid schedule, requiring 3 days per week onsite at the Cypress, CA (90630) office

• Full Time Direct Hire
• 3 days week Hybrid in the Office
• Location: Cypress, CA 90630
• Salary $125k - $135k
• Plus up to 10% annual bonus.
• Merit increase eligibility, 401K matching, and a comprehensive benefits package.

Local candidates Only, No relocation. Onsite Interview is required.

U.S. Citizens and those authorized to work in the U.S. without sponsorship are encouraged to apply.

The Data Engineer II will be an integral member of the IT Data Integration team and will be expected to clean, prepare, and optimize data for consumption. The Data Engineer II will work with the team to create high end data and analytics driven ETL solutions leveraging IDMC, Amazon Web Services (AWS), Big Data tools and technologies. The Data Engineer II will collect and curate data from disparate sources to perform data interrogation, develop analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics.

Should have experience with

• Proven ability in ETL/ELT workflows and SQL development.
• Hands-on experience with cloud platforms (AWS, Azure, or GCP).
• Familiarity with real-time data streaming tools (e.g., Kafka, Spark) a plus.
• Strong background in building and maintaining data pipelines that enable reporting/analytics.
• Solid problem-solving, communication, and collaboration skills for working across teams.

The Data Engineer II will communicate with stakeholders and conduct research to develop a comprehensive understanding of relevant business needs and requirements. The role will identify and collect structured and unstructured data from various sources, evaluate the data to ensure that they meet analytic needs, and prepare the data for analysis. The role will require business and technical requirements gathering and documentation (BRD, PRD) experience, as well as data workflow design and presentations.

Qualifications:

• Bachelor’s degree in computer science, Data Science, Mathematics, or equivalent work experience in a related field required.
• 4+ years of relevant experience in design, execution, and the use of a wide array of data analysis techniques and tools in designing solutions required.
• Advanced experience in Informatica Data Management Cloud (IDMC) required.
• Experience with programming languages such as Python, R, etc. required.
• Experience with relational SQL and NoSQL databases required.
• Experience with AWS GLUE ETL and AWS Analytics Services: Lambda, Step Functions, EMR, Athena preferred.
• Must be self-motivated and able to work independently, with minimal supervision and as part of a team.
• Detail oriented with excellent interpersonal communication skills (verbal and written), with the ability to interact with all levels of an organization.
• Excellent analytical skills: expertise in statistical and data science principles and methods.
• Advanced experience in data quality, data wrangling, cleansing, and standardization required.
• Experience implementing and working with on-premise and cloud infrastructure required.
• Strong project management and organizational skills. Experience using a version control system is a plus (GitHub, Subversion, Azure Dev Ops).
• Proven history of delivering analytic solutions to solve complex problems using a data-driven approach and technical innovation. Demonstrated success in interpreting analytic output and providing strategic recommendations.

Responsibilities:

Technical Design - Able to identify, analyze, specify, design, and translate functional design to technical design. Create and document technical designs for medium to high complexity solutions that may include integration with external systems.

• Create and document technical designs for medium to high complexity solutions that may include integrations with external systems.
• Design systems that span multiple technologies/platforms
• Define and documents work processes/standards.
• Create and apply design standards across all applications.
• Design solutions to meet performance requirements and scalability expectations.
• Conduct data analysis and modeling to design medium to complex systems utilizing multiple technologies (may have a specific area of expertise), including integrations with external systems.
• Collect and curate data from disparate sources to perform data wrangling to clean, prepare, and standardize data for consumption.
• Design and create framework, program controls and services that can be utilized by other developers in creation of applications.
• Apply mathematical principles or statistical approaches to solve complex problems in scientific or applied fields.

Data Modeling - Able to write, test, debug, and maintain data workflows for end-user adoption, productivity improvement and efficiency.

• Analyze data to discover and interpret patterns, trends, and variances.
• Assist with technical design.
• Troubleshoot and resolve technical issues.
• Develop knowledge of the company's applications.
• Research, analyze, and identify data requirements and business processes.
• Develop data science models to automate manual processes and to scale pipelines.
• Derive insight driven outcomes while utilizing the latest technologies and programming languages.
• Extract and transform data through normalization, field mapping, merging, and other techniques to standardize and prepare data for analysis.
• Collaborate with cross functional teams to identify and solve business intelligence and data issues.
• Proactively enhances systems for stability, efficiency, scalability, and robustness.
• Develops, sponsors, and supports the introduction of new and improved methods, products, procedures, and technologies.
• Devise, makes recommendations, and guide implementation of corrective and/or preventive actions.
• Suggest better alternatives and solutions to given requirements based on experience.
• Construct new data assets by combining data from multiple sources, which may be ambiguous, incomplete, or inconsistently formatted.
• Advanced knowledge of mathematical and statistical algorithms to apply toward decision analytic modeling.

Requirements Elicitation – Ability to identify a desired future state that addresses a business problem.

Requirements Management and Analysis – Ability to define, document, and manage business requirements to the smallest set that will provide the biggest impact in advancing business objectives.

Provide Accurate Project Effort Estimates - Ability to quantify and meet individual and project phase level efforts.

Adherence to Standards - Ability to create solutions that adhere to and incorporate RTS standards.

This position qualifies for:

• Annual Merit Increase opportunity
• Annual bonus opportunity Up-to 10% annually
• Paid Sick & Vacation/Health/Dental/401K & Other Benefits

Salary plus bonus and great benefits, the client offers a comprehensive benefits package.

Local candidates Only, No relocation. Onsite Interview is required.

U.S. Citizens and those authorized work in the U.S without sponsorship are encouraged to apply.

If you are interested, please send me your updated Word Resume, along with your direct phone number and email.

Notes

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Information Technology
• Industries: Manufacturing and Staffing and Recruiting

This job description is provided for informational purposes and reflects current information; postings may be updated without notice.