Data Warehouse Designer Jobs (NOW HIRING)

Job Summary:
ClifyX is seeking an Informatica Developer for a contract position based in Carlsbad, CA or Pittsburg, PA. The role involves developing and maintaining ETL processes using Informatica, ensuring data quality, and translating business requirements into technical designs.
Responsibilities:
• Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager , Workflow Monitor (Infa 9x / 10x).
• Strong database Analysis skill using SQL/PLSQL
• Strong expertise in SQL Server & Oracle database
• Understand reusability, parameterization, workflow design, ETL
• Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc. Must have good communication skills
• Must be able to develop and maintain documentation to our standards / provide feedback on standards where they can be improved
• Responsible for designing, developing, testing and troubleshooting and implement complex ETL processes
• Ability to work with multiple different personality types while managing work load within a fast paced, energetic, and dynamic workplace.
• Good problem solving, design, coding and debugging skills.
• Develop, code, test, and deliver data warehouse solutions.
• Translate business requirements into technical designs to map and load data from source systems to data warehouses.
• Ensure quality and accuracy of the data mapped from staging environments to the target reporting environments.
• Knowledge of data modeling and database design at the conceptual, logical, and physical level.
• Provide support to existing production ETL jobs.
• Develop ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds.
• Communicate open items and issues to key stakeholders, including management, development teams, and business areas.
• Maintaining data repository with data definitions, relationships, linkages and sources.
• Expertise in IDQ is a plus.
Qualifications:
Required:
• Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor (Infa 9x / 10x).
• Strong database Analysis skill using SQL/PLSQL
• Strong expertise in SQL Server & Oracle database
• Understand reusability, parameterization, workflow design, ETL
• Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc.
• Must have good communication skills
• Must be able to develop and maintain documentation to our standards / provide feedback on standards where they can be improved
• Responsible for designing, developing, testing and troubleshooting and implement complex ETL processes
• Ability to work with multiple different personality types while managing work load within a fast paced, energetic, and dynamic workplace.
• Good problem solving, design, coding and debugging skills.
• Develop, code, test, and deliver data warehouse solutions.
• Translate business requirements into technical designs to map and load data from source systems to data warehouses.
• Ensure quality and accuracy of the data mapped from staging environments to the target reporting environments.
• Knowledge of data modeling and database design at the conceptual, logical, and physical level.
• Provide support to existing production ETL jobs.
• Develop ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds.
• Communicate open items and issues to key stakeholders, including management, development teams, and business areas.
• Maintaining data repository with data definitions, relationships, linkages and sources.
Preferred:
• Expertise in IDQ is a plus.
Company:
ClifyX provides innovative business solutions which satisfy requirements for mission-critical reliability, scalability, interoperations. Founded in 1998, the company is headquartered in South Plainfield, USA, with a team of 501-1000 employees. The company is currently Late Stage.