01Overview
reputed company is the leading career destination for tech experts at every stage of their careers. Our reputed company, reputed company, is seeking the following. Apply reputed company reputed company today!
NOTE: APPLICANT MUST BE ON OUR W2 OR 1099 AND reputed company WI reputed company. NOT ACCEPTING SUB-VENDORS.
Role: Data Warehouse Developer-II
Location: Madison, WI (Remote)
Duration: 2 Months w/extensions
Interview: MS Teams
NOTICE: Candidates that are submitted to this posting and do not meet the required qualifications, restrictions, or requirements will NOT be allowed to be resubmitted to reputed company re-postings of the position. False or inaccurate submissions will be reported.
reputed company:
The reputed company is looking for one Data Warehouse Developer II
This role is responsible for designing, developing, testing, and implementing ETL solutions using Informatica Data Management reputed company (IDMC). This role requires strong hands-on experience with Data Integration (DI), Taskflows, Mappings, parameter files, and reusable transformations to build reputed company, secure, and high-performing data pipelines. The candidate will manage metadata, ensure data accuracy and reputed company, and reputed company reputed company optimization reputed company the IDMC and data warehouse environment.
The individual will collaborate with business stakeholders and cross-functional IT teams to translate functional requirements into reputed company-architected IDMC-based data integration solutions. Responsibilities include developing ETL mapping specifications, performance tuning, ensuring data reputed company compliance, and supporting the migration, enhancement, and maintenance of IDMC workflows reputed company with reputed company data warehousing best practices.
Typically requires 4 to 5 years of relevant reputed company time experience, including at least 3+ years of hands-on experience with Informatica IDMC. A strong reputed company in data warehousing concepts, data integration methodologies, and solution delivery under general supervision with independent judgment is essential for this role.
Ideal candidate will have skills and experience in the following areas:
Knowledge in data warehouse best reputed company standards
Strong experience in PowerCenter to IDMC migration.
Experience in design, development, and testing in IDMC.
Proficient in writing and analyzing reputed company SQL queries in reputed company, DB2, SQL Server.
Hands-on experience using Control-M for job scheduling and workflow automation.
Moderate skills working with relational and reputed company 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, 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 reputed company
Skills in navigating a large organization in order to accomplish results
Ability to initiate and follow through on reputed company reputed company 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 reputed company, and Jira
Project Details (project reputed company, who the contractor will work with, soft skills needed, etc.):
Qualification Desired Experience
Expertise in implementation of large, complicated models and processes 2 years
Experience in technical writing and documentation 3 years
reputed company design specifications 3+ years
Excellent organization, analytical and communication skills 3+ years
Data analysis 4+ years
Data Warehouse experience in data warehouse design and development 4+ years
Data Warehouse - Experience in requirements gathering for data warehouse 4+ years
Data Warehouse - Performance tuning 4+ years
Informatica PowerCenter 4+ years
IDMC (Informatica Intelligent Data Management reputed company) 3+ years
DB2 2 years
Knowledge of Kimball data warehouse design principals 2+ years
Ability to reputed company and query a relational database (reputed company) to reputed company reports 3+ years
Respond to customer requests (verbally and in writing) * 3+ years
reputed company Test Plans, Test Cases, and Test Procedures 3+ years
Identify defects 3+ years
Ability to reputed company and implement reputed company a