Job Description :
Informatica Architect
Portland, OR
12 Months
Please send Architect profiles if you have. Developers will not be considered
Required Skills :
Informatica, ETL, SQL, Architect level Informatica knowledge and skill
Job Description :
Informatica Architect
Work with Business, Architects and data Modeler to fully understand the business requirements and translate Business requirement into System Requirements for Data warehouse and Reporting project
Lead technical delivery team for large Analytics project in a Global delivery model.
Work with technical team to generate Automation opportunities in areas like Data Migration from Legacy system to Big data platform.
Design complex solutions based on business requirement and develop mappings, Sessions, workflows for solution implementation
Coordinate data models, data dictionaries, and other database documentation across multiple applications
Leads design reviews of data deliverables such as models, data flows, and data quality assessments
Develop processes and templates to migrate and sync legacy Mainframe data to data lake, in discussion with data modeler and develop solution templates to increased the speed of data mappings while creating reusable components.
Develop JIRA Stories and docs by Translating Business Requirements to System Requirements for Agile global delivery model.
Partner with QA teams to communicate the business rules, data models and ensure test cases target the quality and integrity of data model
Partner with DBAs to transform logical data models into physical database designs while optimizing the performance and maintainability of the physical database
Perform data analysis, discovery, profiling and identify cause of data issues and work with broader team to resolve
Develop solid understanding of the various source data sets and assist in laying out the overall data design solutions
Promotes data modeling standardization, defines and drives adoption of the standards
Work with Data Management to establish governance processes around metadata to ensure an integrated
definition of data for enterprise information, and to ensure the accuracy, validity, and reusability of metadata
Develop ETL (Extract, Transform, Load) processes according to company and industry Best Practices
Lead the efforts to pilot ETL solutions for Microsoft Azure Cloud, Talend Big data and Informatica in Virtual Machine
Coordinate data and reporting requirements with off-shore developers and review work products for accuracy and completeness in meeting those requirements
Architect and Automate Store procedures using Control-M file watcher and ETL solutions
Strong knowledge with BI tools, standards and practices
Strong knowledge of core ETL processing, reporting and dashboards
SKILLS
Strong experience in Informatica Power Center & Power Exchange. Skilled in a various informatica ETL solution
Experience with SQL Developer and MySQL
Experience on platforms like Hadoop (HDFS, Hive, Spark), Microsoft Azure, IBM Mainframe and languages like COBOL, JCL , DB2, BMC Remedy 9, EDI
Experience on Agile tools like JIRA is must.
Skills to Architect, design and implement enterprise-class ETL solution using relational database. A strong knowledge of standard ETL solutions and best practices
The skills to work with many diverse data domains including Supply Chain , Financial cost data, Customer Master Data, Equipment data, Manufacturing data, Sales data etc.
Skills to develop well designed ETL processes using Informatica Power Center
Experience working closely with data architects, subject matter and technical experts, and system data models in order to accurately represent as-is and to-be processes
Hands on experience with data management platforms (Db2 Blu, DB2, Sql server etc)
SQL Performance Tuning
Experience communicating requirements to off-shore ETL developers and Report developers
The skills to perform data modeling activities. Expertise with enterprise level data modeling tool such as ER/Studio. Expert knowledge of data architecture strategies and data governance strategies
Experience with logical data modeling (ERwin Experience with enterprise integration patterns and best practices
15+ years in IT experience in end-to-end Software Development in SDLC and Agile methodology
8+ years of experience with Informatica design and development experience
8+ years of experience with IBM Mainframes, COBOL , JCL , DB2
3+ years of experience with data modeling activities, using industry standard tools, preferable Erwin
PREFERRED SKILLS & EXPERIENCE
Current Industry knowledge of forward looking data technologies (Big Data, Hadoop, MongoDB, In memory DB’s and streaming data)
Demonstrated ability to partner and collaborate across organizations to craft innovative solutions that drive customer-centric outcomes
Ability to think strategically and translate plans into phased actions in a fast paced, high pressure environment
Strong presentation skills necessary to communicate with, and persuade, a wide range of audiences
Experience with scaled systems and understanding of data and system integration; should also have a good understanding of security from a data and process perspective
Customer-driven mindset and insatiable appetite for engineering excellence and drive for outcomes
Informatica Power Center Developer Certification
Knowledge of AIX Unix commands
Experience in Db2 Stored procedures
Agile Development Methodology