Job Openings 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
  • Server/Database: AS400 DB2, TeraData, Oracle, SQL Server, Postgres
  • Language: SQL, Microsoft R, SAS
  • OS: AS400, AIX, Linux, Windows

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.



Or refer someone