Jobs via Dice
3 days ago Be among the first 25 applicants
Get AI-powered advice on this job and more exclusive features.
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Swanktek, is seeking the following. Apply via Dice today!
Job Title:
ETL Informatica Developer
Location:
Providence, RI or Boston, MA 3-4 days onsite role
DESIRED SKILLS AND EXPERIENCE:
Minimum of 12-15 years of Software experience with 5+ on Data Warehousing 3+ years of Informatica (9.6+) development with Power Centre, Power Exchange, IICS, Sybase and SQL Server
Mandatory Technical Skills:
Sound Knowledge of Data warehousing concepts, terminology and Architecture. Excellent ETL (Including XML) Design and development Experience Good understanding of the commonly used transformations like Source qualifier, joiners, union, aggregator, sorter, expressions, transaction control, xml transformation, lookups etc Ability to understand mapping document and translate the same to Informatica Mapping Ability to create CDC, SCD, Fact loads and complex mappings with ETL Sound concepts of RDBMS with hands on with performance tuning of ETL / DB / SQL Queries Good knowledge of UNIX with ability to create Unix/Linux shell scripts to run ETL jobs and trap any failures. Skill in gathering and documenting user requirements and writing technical specifications Good knowledge of SDLC for projects using DW concepts and Client/Server technologies. Create detail mapping documents, module spec and unit test cases Hand on with informatica development, Configuration and Performance tuning Experienced in Migrating from Informatica PC to IICS
Interpersonal Skills
Well developed analytical & problem-solving skills Strong oral and written communication skills Excellent team player, able to work with virtual teams Ability to learn quickly in a dynamic start-up environment Able to talk to client directly and report to client/onsite Flexibility to work on different Shifts and Stretch
Good to have :
Olap Tools Data Modelling Worked on Finance domain related data Java Coding skills Agile Development Experience Worked on cloud environment
Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Other Industries Software Development Referrals increase your chances of interviewing at Jobs via Dice by 2x Sign in to set job alerts for “Informatica Developer” roles.
Attleboro, MA $107,000.00-$147,070.00 5 days ago Software Quality Assurance (SQA) Engineer
Middletown, RI $80,000.00-$120,000.00 2 weeks ago Software Engineer II/Sr. Software Engineer/Lead Software Engineer
Johnston, RI $75,200.00-$156,300.00 1 week ago Middletown, RI $80,000.00-$115,000.00 1 week ago Software Engineer - Fidelity RESUME Program
Software Engineering Specialist - Human Data
Freelance Software Developer (C/C++ - Rust) - AI Trainer
Indication of Interest; Future Job Possibilities
Rhode Island, United States $149,629.00-$205,024.00 3 days ago Middletown, RI $67,800.00-$113,200.00 6 days ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Job Title:
ETL Informatica Developer
Location:
Providence, RI or Boston, MA 3-4 days onsite role
DESIRED SKILLS AND EXPERIENCE:
Minimum of 12-15 years of Software experience with 5+ on Data Warehousing 3+ years of Informatica (9.6+) development with Power Centre, Power Exchange, IICS, Sybase and SQL Server
Mandatory Technical Skills:
Sound Knowledge of Data warehousing concepts, terminology and Architecture. Excellent ETL (Including XML) Design and development Experience Good understanding of the commonly used transformations like Source qualifier, joiners, union, aggregator, sorter, expressions, transaction control, xml transformation, lookups etc Ability to understand mapping document and translate the same to Informatica Mapping Ability to create CDC, SCD, Fact loads and complex mappings with ETL Sound concepts of RDBMS with hands on with performance tuning of ETL / DB / SQL Queries Good knowledge of UNIX with ability to create Unix/Linux shell scripts to run ETL jobs and trap any failures. Skill in gathering and documenting user requirements and writing technical specifications Good knowledge of SDLC for projects using DW concepts and Client/Server technologies. Create detail mapping documents, module spec and unit test cases Hand on with informatica development, Configuration and Performance tuning Experienced in Migrating from Informatica PC to IICS
Interpersonal Skills
Well developed analytical & problem-solving skills Strong oral and written communication skills Excellent team player, able to work with virtual teams Ability to learn quickly in a dynamic start-up environment Able to talk to client directly and report to client/onsite Flexibility to work on different Shifts and Stretch
Good to have :
Olap Tools Data Modelling Worked on Finance domain related data Java Coding skills Agile Development Experience Worked on cloud environment
Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Other Industries Software Development Referrals increase your chances of interviewing at Jobs via Dice by 2x Sign in to set job alerts for “Informatica Developer” roles.
Attleboro, MA $107,000.00-$147,070.00 5 days ago Software Quality Assurance (SQA) Engineer
Middletown, RI $80,000.00-$120,000.00 2 weeks ago Software Engineer II/Sr. Software Engineer/Lead Software Engineer
Johnston, RI $75,200.00-$156,300.00 1 week ago Middletown, RI $80,000.00-$115,000.00 1 week ago Software Engineer - Fidelity RESUME Program
Software Engineering Specialist - Human Data
Freelance Software Developer (C/C++ - Rust) - AI Trainer
Indication of Interest; Future Job Possibilities
Rhode Island, United States $149,629.00-$205,024.00 3 days ago Middletown, RI $67,800.00-$113,200.00 6 days ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr