[Hiring] ETL Informatica Developer @Software Technology

Role Description

Remote Position - 6 Months C2H - EST Hours

Job Title: ETL Informatica Developer (EST Hours)

Duration: 6 Months C2H

• Eligible consultants must be able to convert perm without sponsorship now or in the future
• Senior Level Informatica ETL Developer
• Senior Level SQL (SQL Server) skills
• Senior Level PowerCenter experience
• 1-2 years+ MDM experience

Essential Functions:

• Demonstrates expertise in a variety of the field's concepts, practices, and procedures related to ETL/Data design and development.
• Implementing solutions using Informatica PowerCenter 10x (Designer/Monitor).
• Develop and recommend strategies and specifications for (technical) data solutions based on the analysis of the business goals, objectives, needs, and existing data systems infrastructure.
• Data Modeling and experience in developing new logical, conceptual, and physical models for data and system flows.
• Develop technical strategies and architectures for high-performance, scalable and complex enterprise-grade systems.
• Work with ETL developers, business analysts, DBAs, system administrators, to architect data model, design and implement database as well as write ETL related programs.
• Work closely with the team responsible for maintaining the data model, including data dictionary/metadata registry.
• Document programming problems and resolutions for future reference.

Qualifications

• At least 8 years' experience in a large Data Warehouse environment.
• 8+ years' experience in Informatica PowerCenter including extensive experience with v10x, focused on utilizing push down optimization, mapplets and worklets.
• Experience working complex transformations including update strategies, routers, normalizers etc.
• 8+ years of SQL Server including 5+ years of ETL/SSIS for SQL Server.
• 2+ years of experience with MDM (Master Data Management) including loading data into MDM.
• Expert SQL writing/tuning.
• Strong understanding of Data Warehouse/MDM concepts (ETL, Star Schema, slowly changing dimensions).
• Strong knowledge of relational databases, Data Warehouse and business Intelligence solutions.
• Excellent teamwork and collaboration skills.
• Proficient in shell scripting and performance tuning within a Unix/Linux Environment.
• Excellent written/verbal communications skills.
• Ability to meet deadlines with attention to detail and accuracy.
• Ability to handle multiple concurrent tasks/projects according to priorities.
• Ability to work in a group or team environment.

Preferred Skills/Nice to Have

• Experience with IICS (Informatica Intelligent Cloud Services)
• Healthcare Experience
• Familiarity with Salesforce