back Back to Jobs

ETL Informatica Technical Architect

Location: Saint Louis, MO
Job # 10178215
Date Posted: 11-20-2017
Mavensoft is looking for ETL Informatica Technical Architect in Saint Louis, MO for 6 +  months contract. If you are interested and meet below requirements please email or apply online for immediate considerations with your salary expectations.  Thank you for your time.
 
Job Title:  ETL Informatica Technical Architect
Location:   Saint Louis, MO

Duration:   6 + months 
 
Skills: Informatica PowerCenter, Oracle Stored Procedures, Data Modeling , Shell Scripting, Unix/Linus Scripting, SQL/Database/Oracle, Data Model Concepts, ETL

Job Description:
  • The ETL Architect is responsible for all ETL development and ETL architectural components within the data warehouse environment including standards, design practices, code management, tool optimization, implementation, operations, and production releases.
  • The individual is also responsible for being aware of, and applying, corporate standards and industry best practices to all of the data movement processes within the data warehouse environment as well as documenting the standards used and configuration details of the data movement logic.
Job Complexity
  • Responsible for most complex ETL processes, including the business rules, data gathering, data profiling, ETL development and deployment 
Job Duties:
  • Develops overall architecture approach for data integration
  • Collaborates with ETL architects from the company’s international partners to develop a reference architecture and ensures that developers abide by the reference architecture during ETL development
  • Consults with other database and IT professionals within the organization to ensure adherence to enterprise direction and standards within the data warehouse environment
  • Develops a common monitoring framework for ETL metadata across the data warehouse environment
  • Assesses infrastructure and enterprise data movement and recommends solutions for upgrading the enterprise data architecture
  • Reviews infrastructure and data warehouse expansion projects and recommends solutions for to meet business needs
  • Oversees ETL code peer reviews for the data integration team
  • Acts as a subject matter expert in data integration projects
  • Ensures that all ETL code develop follows standards and appropriate practices for code management, change control, version control and release management
Required Skills:
  • Informatica
  • Unix/Linus Scripting
  • SQL/Database/Oracle
  • Data Model Concepts
  • Experience with shell scripting
  • Clear understanding of RDBMS fundamentals
  • Ability to write clear documentation of operating procedures, and ability to write specifications
  • Exceptional communication, problem solving, and teamwork skills
  • Extremely detail-oriented and able to follow clear methodologies for troubleshooting and development
  • Ability to support and work within standard software development life cycle practices
  • Analytical thinking, strong judgment and problem analysis techniques
Optional Skills:
  • DBA
  • BI/Reporting
  • DW Architecture
  • Data Model, Physical/Logical
Please Apply Online. To learn more about Mavensoft visit us at www.mavensoft.com
this job portal is powered by CATS