Data Warehouse Developer (EDW)

About the job Data Warehouse Developer (EDW)

Responsibilities:

• Design, develop, and maintain data warehouse solutions using Cloudera Hadoop distribution (6.X), TeraData Inteliflex, AS400, Informatica Data Integration suite, and MS Business Intelligence tools.
• Develop and manage ETL processes using Informatica BDM, IDQ, and IDL, ensuring high performance and data accuracy.
• Collaborate with cross-functional teams to gather requirements, design data models, and create data integration workflows.
• Utilize AS400 DB2, TeraData, Oracle, SQL Server, and Postgres databases to manage and store data.
• Develop complex SQL queries and use Oracle SQL Developer, TeraData Studio, and other query tools for data extraction and manipulation.
• Implement data visualization and reporting solutions using QlikSense Discovery, Microsoft Power BI, Business Objects, and SAS.
• Work with Cloudera Data Science Workbench, Spark, HUE, Hive, Impala, and Kafka for big data processing and analytics.
• Use tools such as JIRA, Jenkins, Bit Bucket, SonarCube, PUTTY, Aldon, and Control-M for project management, version control, code quality, and job scheduling.

Requirements:

• Bachelors degree in Computer Science, Information Technology, or a related field.
• 6-9 years of experience in data warehouse development and data integration projects.
• Proficiency with Cloudera Hadoop distribution (6.X), TeraData Inteliflex, and AS400.
• Extensive experience with Informatica Data Integration suite, including BDM, IDQ, and IDL.
• Strong SQL skills and experience with databases such as AS400 DB2, TeraData, Oracle, SQL Server, and Postgres.
• Experience with data visualization tools like QlikSense Discovery, Microsoft Power BI, Business Objects, and SAS.
• Hands-on experience with big data tools and technologies including Cloudera Data Science Workbench, Spark, HUE, Hive, Impala, and Kafka.
• Familiarity with project management, version control, and code quality tools such as JIRA, Jenkins, Bit Bucket, SonarCube, PUTTY, Aldon, and Control-M.

Technical Skills:

• Platform/Product: Cloudera Hadoop distribution (6.X), TeraData Inteliflex, AS400, Informatica Data Integration suite, MS Business Intelligence, QlikSense Discovery, SAS, Microsoft R, Experian PowerCurve
• Language: SQL, Microsoft R, SAS

Other Requirements:

• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Ability to work on the Global Data Warehouse (GDW) platform.
• Experience with data quality and validation tools such as Query Surge.
• Knowledge of Microservices architecture and APIs is a plus.