Information Engineer

In an uncertain world, Travelers is an insurance leader, committed to keeping pace with the ever-changing needs of our customers, and anticipating their needs for the future. There is no stronger testament to our dedication to protecting customers from loss than our continued innovation and ability to transform our industry.

Plans at an operational level and manages the effective use of resources to implement a medium sized or multiple smaller assigned projects

* Participate in Business requirements analysis * Participate in all phases of project life cycle * Participates in high level and detail design session for projects * Responsible for successful development and delivery of data warehousing projects involving ETL, Database, Reporting and Unix scripting components * Drive strong collaborative partnerships between business, IT, and enterprise technology teams in the following areas * Quality, Testing and Excellence: Drive solution quality through appropriate unit testing execution, and support for test planning and case creation, integrated system testing, release management, and production turnover and warranty support.

* Candidate should have a bachelor’s degree with at least 5 years of experience or a masters degree with 3 years of over all experience in designing and developing end to end data warehousing solutions. * Core Technical Requirements (Abinitio) * Should have strong knowledge in Ab Initio Co>Operating system, EME, Conduct>It, Continuous flows, Data Profiler, BRE , ACE, Meta programming, Metadata Hub, Elementum, Operational Console, Key Server, etc * Should have experience in Ab Initio Environment set up (User & application Security Setup, Project/Sandbox setup, etc) and to perform application audits and assessments, capacity management, disaster recovery management. * Should have experience in Ab Initio migration projects and other Ab Initio environment related installation/upgrades (Co>op, GDE, EME, Database client, etc). * Should have strong knowledge in optimization and provide setup monitoring/alerts for jobs/processes, ETL performance testing, troubleshooting environmental issues, etc * Should have experience in process automation, log analytics and strong knowledge in UNIX/Windows environment with various scripting languages such as UNIX Shell scripts, VB macros, python, etc * Should have experience in EME branching/cleanup, shutdown and start up activities, version control tool (Subversion) and Ab Initio code deployments to various environments * Should have strong knowledge on Connect direct, NAS setup, MVS connectivity, job schedulers, Continuous flow interface setup and debugging, MQ, Database utilities associated with Teradata, Oracle, SQL Server, DB2, IMS, Red brick, etc * Should have experience in Planning, defining, designing and managing Data Integration standards, principles, guidelines, frameworks, knowledge management, etc * Experience in advanced components of abinitio including Scans, Rollups, Normalize, Multi update table. * Experience in delivering batch and continuous flow applications using abinitio product * Experience in processing XML, mainframe and SAS data sets in abinitio. * Experience in delivering web services applications using abinitio product suite. * Experience in advanced concepts of abinitio including PDL, conditional DML, Meta programming, common components architecture and dealing with Vector data formats * Experience in data profiling activities leveraging abinitio data profiler product. * Experience in leveraging abinitio EME for configuration management, dependency analysis, impact analysis and branching activities. * Proficiency with data modeling * Thorough understanding of relational databases, ROLAP and MOLAP concepts * Proficiency in working with Oracle, SQL Server and Teradata databases ,database modeling, data warehouses, data profiling, ability to write/interpret SQL statements * Proficiency in writing SQL, procedures, functions and triggers * Proficiency in optimizing sql and tuning business intelligence applications * Proficiency in Unix/Linux , Windows operating systems and in scripting languages (Shell scripting and Windows batch scripting). * Experience in at least one of the job scheduling and automation tools ( Autosys, Control-M, Unix-Crontab, Tivoli) * Experience in at least one of the configuration management tools (Rational Suite, VSS, Abinitio EME, PVCS,CVS, SCCS) * Certification in Teradata (V2R6 or above) in SQl and Physical Implementation is a must and any other Teradata certifications are a Plus * Experience in implementing Teradata Macros, Procedures and Functions * Experience in writing optimized SQL and experience in SQL tuning * Experience in utilizing various Teradata utilities ( Fastload, Mload, Fast Export, BTEQ, Tpump) * Experience and Knowledge with various indexing schemes and materialized views * Core Technical Requirements (Hadoop) * Experience in delivering Hadoop solution in conjunction with RDBMS **Technical Knowledge** Has master level knowledge of multiple programming disciplines and a thorough understanding of the business that the assigned projects are supporting. Uses this understanding of the business and systems environment to develop appropriate and timely solutions to daily issues. Has conceptual knowledge of varying technologies and the ability to make decisions based on that knowledge **Business Knowledge & Partnership** Creates an atmosphere where business partner's issues are dealt with professionally, and in a timely manner. Suggests solutions that make sense and optimize the value of assigned projects. Communicates openly and effectively in a manner consistent with the audience. Recognizes the importance of superior quality in providing a competitive edge. Ensures that reports are precise, timely and accurate **Problem Solving & Decision Making** Demonstrates sound analytic and diagnostic skills dealing with issues that are loosely defined and/or where information is available but must be further manipulated. Once decisions are made, is able to follow and direct action to implement intended results. Breaks a problem down to manageable pieces and implements effective, timely solutions. Openly and directly confronts conflict until resolved **Team Orientation** Builds relationships with peers and other departments to achieve objectives, to work as one team and to secure necessary resources not under his/her personal control. Balances team and individual responsibilities. Exhibits objectivity and openness to others' views. Gives and welcomes feedback. Puts success of team above own interest **Leadership** Supports a distinct business unit or several smaller functions. Responsibilities are assigned with some latitude for setting priorities and decision-making using established policies and procedures. Results are reviewed with next level manager for clarification and direction before proceeding **Planning and Project Management** Works with the project manager/manager in identifying those project tasks that are most important, establishes clear priorities and understands the larger picture. Anticipates and effectively responds to changes in workload and resources **Financial Awareness** Understands, has input to the budget process, and shares responsibility for cost-effective expense control of assigned projects. Is responsible for important and confidential information