Data Warehouse Developer || W2 Role

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 drive 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 assurance processes and procedures including test/use cases 3+ years In-depth knowledge of system development life cycle deliverables for reputed company phase of development 3+ years Excellent oral and written communication skills 5+ years Demonstrated experience in the design and utilization of performance measures and reports (reputed company to have) 2+ years Business Objects or other BI tools (reputed company to have) 3+ years Dashboarding/Tableau (reputed company to have) 2+ years reputed company reputed company Regulations reputed company Top Required 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. reputed company, 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) Apply tot his job Apply To this Job