Nityo Infotech Corporation
Pittsburgh, PA
Post Resume to
View Contact Details &
Apply for Job
Job Description :
Title: Informatica ETL Architect
Location: Wilmington, DE
Duration: Full time


Informatica ETL Architect with 15+ years’ experience in implementing data warehouse/ODS project, including experience in Enterprise Data Architecture, Data integration using leading ETL tools like Informatica and Database expertise in Sqlserver and Oracle. A very good Architect having good knowledge on Informatica and BODS too

Key Responsibilities:
Plan and coordinate for interface and data migration requirements
Design ETL Mapping using Informatica
Data cleansing, profiling and data quality dashboard using IDQ toolset
Testing and ETL performance management
Performance optimization of EDW/ODS environment
Work in onsite – offshore model for solution delivery
Responsible for creating solution architecture and design as per business requirements.
Create overall enterprise data architecture and data model
Manage project plan and milestone based delivery

Qualifications:
12+ years of overall experience implementing end to end EDW projects
Experience in implementing at least 3 large ETL projects
5+ Experience in Informatica PowerCentre
Experience in various relational databases like SqlServer, Oracle
Experience in data modeling tools like Erwin etc.
Data Migration experience
Experience in analysis, design, development , deployment & documentation of EDW solutions
Excellent communication & team management skills
Good written and verbal skills & team skills
Strong problem solving skills & proactive attitude
Manufacturing industry knowledge will be an added advantage
Additional Requirements -

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 different development teams and senior designers to develop architectural requirements to ensure 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.
             

Similar Jobs you may be interested in ..