Role: Informatica ETL Architect
Location: Westlake , TX
Duration : Full Time/ Contract
Overall IT experience for 10+
7+ Experience in Informatica PowerCenter 10.x and IICS (Cloud version )
7+ Years of ETL and Database(SQL and PL/SQL) experience .
5+ Experience in writing Unix shell scripting
Collaborate with business users to identify attributes that require data quality and corresponding business rules
Lead and guide development of an Informatica based ETL architecture.
Develop solution in highly demanding environment and provide hands on guidance to other team members.
Head complex ETL requirements and design.
Implement an Informatica based ETL solution fulfilling stringent performance requirements.
Collaborate with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with product.
Assess requirements for completeness and accuracy.
Determine if requirements are actionable for ETL team.
Conduct impact assessment and determine size of effort based on requirements.
Develop full SDLC project plans to implement ETL solution and identify resource requirements.
Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture.
Identify, recommend, and implement ETL process and architecture improvements.
Assist and verify design of solution and production of all design phase deliverables.
Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture.
Resolve difficult design and develop issues.
Identify bugs when developers are not able to do so.
5+ integration experience with (informatica) etl workflow with test automation platform
5+ Strong skills in writing SQL queries
5+ strong python scripting experience
Architect looks after the performance tuning for the ETL jobs , Scripts and Database.