Data Warehouse Developer ,Remote

Data Warehouse Developer ,Remote

Posted Today by ERPA

Apply
Negotiable
Undetermined
Remote
Remote
Apply
Automation Control-M (Batch Scheduling Software) Data Analysis Data Integration Data Management Data Warehouse Architectures Data Warehousing Extract Transform Load (ETL) File Servers IBM DB2 Informatica Input/Output JIRA Job Scheduling (Batch Processing) Life Cycle Planning Management Microsoft Office Microsoft SQL Servers Microsoft Visio Process Design Query Performance Relational Databases Scheduling Software Coding Software Development SQL (Programming Language) Stakeholder Management Time Management Workflow Automation Workflows

Summary: The Data Warehouse Developer role focuses on designing, developing, and optimizing data warehousing processes using Informatica tools. The position requires strong SQL skills and experience with various relational database technologies. The developer will also be involved in data integration strategies and solutions, ensuring best practices in data management. This is a remote position that emphasizes collaboration and communication with both technical and non-technical stakeholders.

Key Responsibilities:

  • Design and develop data warehousing processes using Informatica tools.
  • Optimize performance and tuning of data warehousing solutions.
  • Implement data integration strategies and solutions.
  • Write and analyze complex SQL queries across various relational databases.
  • Manage ETL processes and diagnose performance bottlenecks.
  • Collaborate with customers and technical staff to gather requirements and facilitate meetings.
  • Utilize Control-M for job scheduling and workflow automation.
  • Participate in the project development life cycle from planning to implementation.
  • Work independently on complex projects while maintaining effective communication.

Key Skills:

  • Moderate experience in data warehousing process design and development (4+ years).
  • Developing skills in data warehouse architecture and integration strategies.
  • Knowledge of relational database technologies (Oracle, DB2, SQL Server) (3+ years).
  • Strong data management and analysis skills using SQL (4+ years).
  • Hands-on experience with Informatica IDMC (3+ years).
  • Experience in PowerCenter to IDMC migration.
  • Proficient in writing complex SQL queries.
  • Experience with Control-M for job scheduling.
  • Strong communication and interpersonal skills.
  • Excellent organizational and time management skills.
  • Proficiency with MS Office suite, MS Visio, MS Outlook, and Jira.

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Top Skills:

  • Moderate experience in data warehousing process design, development, performance & tuning using the Informatica data warehousing tool suite (4+ years)
  • Developing skills in the architecture of data warehouse and data integration strategies and solutions
  • Knowledge in relational database technologies, e.g. Oracle, DB2, SQL Server (3+ years)
  • Strong data management and data analysis using SQL (4+ years)
  • Must have strong hands-on experience with Informatica IDMC. (3+ years)

  • Knowledge in data warehouse best practice standards
  • Strong experience in PowerCenter to IDMC migration.
  • Experience in design, development, and testing in IDMC.
  • Proficient in writing and analyzing complex SQL queries in Oracle, DB2, SQL Server.
  • Hands-on experience using Control-M for job scheduling and workflow automation.
  • Moderate skills working with relational and dimensional data models
  • Moderate skills working with slowly changing dimensions
  • Proven ability to diagnose and remediate ETL and DB Query performance bottlenecks.
  • Strong verbal and written communication skills, including facilitation of meetings with customers and technical staff
  • Knowledge and skills in the project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support)
  • Demonstrated knowledge and skills in requirements gathering
  • Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team
  • Skills in navigating a large organization in order to accomplish results
  • Ability to initiate and follow through on complex projects of both short- and long-term duration
  • Excellent organizational and time management skills.
  • Excellent analytical and problem-solving skills
  • Ability to work independently, assume responsibility for job development and training, researching and resolving questions and problems, requesting supervisor input and keeping supervisor informed
  • Proficiency with MS Office suite, MS Visio, MS Outlook, and Jira
Apply
Similar Jobs
Loading data...