Source description
About the role
Title: ETL (Informatica) Developer Location: Remote (EST Hours) Duration: 6 Month Contact to Hire (candidates will need to be able to convert to Full-Time with no current or future sponsorship needs)
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 technical strategies and architectures for high-performance, scalable and complex enterprise-grade system Work with ETL developers, business analyst, 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 the maintaining the data model, including data dictionary/metadata registry. Document programming problems and resolutions for future reference.
Experience 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
Bhargavi Ankam IT Recruiter Staffing | Thought wave Software and Solutions Limited 6306891366 bhargavi@wavsols.com www.thoughtwavesoft.com 314 N. Lake St, Suite 6, Aurora IL 60506
More at Thoughtwave Software and Solutions