Developer ETL Informatica Professional

Developer ETL Informatica Professional
Location: (Hybrid) in Virginia 
Years of experience: 3+
Job Type: W2 C2H
"Not open to sponsored candidates at this time"

Must Haves: Must have 2+ years of experience with ETL tools, but Informatica Power Center is strongly preferred. Must have 2+ years of experience with relational databases, with a preference for experience with Sybase and/or MSSQL. Unix and Shell scripting are must haves. Strong preference for Java development experience.

Position Description:
Should be having at least 2 – 4 years of hands-on experience in ETL Informatica power center or similar ETL tool, but Informatica is strongly preferred.
Familiar with relational databases like Sybase (preferred), MSSQL (preferred), Redshift, PostgreSQL, DB2, SQL Server, Oracle with development experience.
Full understanding of Data warehousing concepts and must be able to understand data models.
Should have experience in Unix, Java, Snowflake (preferred).
Should have good communication skills, analytical ability, and problem-solving skills.
Should be able to articulate the issues and propose viable solutions.
Should be a self-starter who can work independently.
Be able to collaborate, develop and maintain excellent working relationships across all organization levels with both internal and external stakeholders.
Must be able to work with Business Analyst and Technical Architect to define technical requirements.
Must be able to fix the issues within the defined SLAs.
Create sources, targets, mappings, and workflows for ETL jobs as per the design (using Informatica or other ETL tool).
Create transformations in ETL jobs/ to achieve data cleansing and standardization during initial data load.
Work with databases, ETL tools (Informatica, similar others) and SQL for querying and manipulating datasets.
Work with source system architects/ SMEs to understand integration needs.
Must be able design and document integration architecture.
Work on migration and upgrade projects.
Hands on experience in cloud technology.
Ready to learn and adapt to changing technology landscape.