Job Title: ETL Informatica senior
Location: Virginia-Hybrid
Experience: 8+ years
"Open to W2 and C2C Candidates"
-Must have experience in IICS/IDMC, Informatica Powercenter (ver.8 and above), Java and/or Python, basic Shell scripting (moving files, updating parameters), basic knowledge of Linux/Unix (ETL’s installed on Linux server) and Selenium.
-This role will be a culmination of developing code in Informatica IICS (critical skill)/Informatica PowerCenter and Automation Testing.
-Automation test suite is built using Java and Python.
-Experience in Java and Python is required from a testing standpoint.
-Experience in Cucumber is highly preferred.
-Must Haves: 5+ years of experience in Informatica PowerCenter, Informatica cloud IICS, Shell Scripting, Automation testing: Selenium & Cucumber and either Java or Python.
Responsibilities:
-Work with product owners, developers, and analysts to define, develop, and deliver code enhancements, and regression test suite.
-Assist in the design, development, test, maintenance, and support of Data mart applications.
-Troubleshoot and tune existing data mart applications. Assist in creating new or enhanced components of the data mart.
-Help with updating Automated testing routines.
-Implement best practices and methodologies and function as a technical expert in the design, development, modification and debugging of ETL code.
-Work with team to clarify the requirements and scope and test developed solutions to ensure accurate business outcomes.
-Support the development of new software or enhances existing software and integrate into new or modified systems and/or operational environments.
-Troubleshooting any issues that may arise.
-Provide maintenance, and Production support when needed.
Requirements:
-5 or more years of experience in the Data warehousing field.
-3+ years of experience using Informatica Powercenter 8x/9x/10x.
-2+ years of experience with Informatica Cloud tool – IICS / IDMC.
-Experience with Automation test suites – Selenium, Cucumber, and Java/Python.
-Expertise with scripting languages including SQL, Unix Scripting.
-Strong experience with Data Modeling and Dimensional Modeling techniques, proficiency in design and implementation of Star and Snowflake schemas.
-Bachelor’s degree in Computer Science, Information Technology, or related field.
-Experience with Columnar Databases.
-Clear communication skills.
-Strong quantitative, analytical, and problem-solving skills.
-Ability to troubleshoot and solve complex technical problems
Any Graduate