Developer Informatica IICS_PowerCenter at Zillion Technologies Inc

***THIS ROLE IS OPEN FOR SPONSORED CANDIDATES***

***CANDIDATES WITHIN 25 MILES FROM MCLEAN, VA ARE ENCOURAGED TO APPLY***

***THIS ROLE REQUIRES THE DEVELOPER TO BE ONSITE (HYBRID), 3 DAYS A WEEK***

Developer Informatica IICS_PowerCenter Senior

Duration: 6 months. Opportunity for extension.

Location: Onsite (Hybrid) in McLean, VA on Tuesday, Wednesday and Thursday

Years of experience: 6+

Must Haves: Informatica IDMC, previous Informatica PowerCenter, databases specifically Snowflake and Data marts.

Preferred: MicroStrategy or Tableau, Scripting in Unix or Python and Data modeling

Responsibilities:

• Work with product owners, developers, and analysts to define, develop, and deliver product enhancements and new products.
• 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.
• Implement best practices and methodologies and function as a technical expert in the design, development, modification and debugging of ETL code.
• Partner with Development Tech Lead and Architects to find innovative solutions.
• 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.

Requirements:

• 8 or more years of experience in the Data warehousing field.
• 4+ years of experience using Informatica PowerCenter 8x/9x/10x.
• 3+ years of experience with Informatica Cloud tool IICS / IDMC.
• 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.
• Knowledge on Snowflake DB.
• Bachelor s degree in Computer Science, Information Technology, or related field.
• Experience with Columnar Databases.
• Clear communication skills.
• Ability to troubleshoot and solve complex technical problems.