Informatica Cloud Data Engineer

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. J-18808-Ljbffr