Test Data Management Engineer / Admin

The Travelers Companies Norcross , GA 30071

Posted 2 weeks ago

Primary Job Duties & Responsibilities


  • Adhere to and implement established departmental concepts and principles.

  • Produces essential reports on a daily, weekly, monthly or ad hoc as necessary

  • Monitors project deliverables, as directed, to ensure project and functional leaders receive accurate, timely updates as required

  • Maintains knowledge on current and emerging developments/trends for assigned area(s) of responsibility, assesses the impact, and collaborates with management to incorporate new trends and developments in current and future solutions.

  • Serves as a resource to team members and applicable internal/external stakeholders on more complex assignments/projects for his/her assigned area(s) of responsibility

Test Data Management

  • Applies and promotes established enterprise test data management best practices and guidelines and recommends improvements

  • Determine data provisioning and masking requirements, to assist in the design and review of Informatica workflows, working with enterprise TDM development teams

  • Designs and implements test data management approaches and frameworks

  • Designs and develops Test Data Management workflows for Proof of Concept situations when new technologies or new use cases are encountered by the enterprise.

  • Conforms with and ensures compliance with established data security protocols

  • Manages and coordinates product upgrades and testing of TDM toolsets with enterprise development teams.

  • Assists enterprise TDM development teams with data profiling, and the development of new test data provisioning and test data masking use cases, researching solutions and addressing issues with the tool vendor, as necessary.

  • Develops solutions for provisioning and masking test data when out-of-the-box capabilities are found to be insufficient for use case requirements.

  • Provides DevOps support for migrating data provisioning code through a centralized infrastructure to production

  • Assists in the management of the Informatica infrastructure, including installing, configuration changes, performance tuning, monitoring, sizing, upgrading, etc.

  • Facilitates, design and/or integrates self service capabilities into the Test Data Management enterprise framework

  • Recommends improvement in test automation practices, techniques and tools.

Job Specific & Technical Skills & Competencies

  • Troubleshooting skills providing solution to proactively resolve any future problems

  • Excellent project management or coordination skills

  • Excellent oral and written communication skills and strong attention to detail

  • Ability to work effectively as a member of a team and independently

  • Ability to work or lead a technical team from diversified geography and culture to complete strategic planning and support work

  • Strong results-oriented awareness, with an optimistic and enterprising attitude

  • Ability to multitask and work effective with little supervision

  • Ability to co-ordinate onsite and offsite resources deliverables/activities.

  • Ability to work with various technology areas and manage their expectations & priorities

  • Proficient with Informatica TDM tools, DQ, Powercenter, PowerExchange for IMS, and mainframe.

  • Proficient in SQL and Unix scripting

  • Good understanding of SDLC concepts in a DevOps "Continuous Integration" environment

  • Working knowledge of Relational DBMS like DB2, Oracle, SQL Server, Sybase, Mainframe data store and files, and NoSQL Databases like MongoDB

  • Good understanding of database validations, constraints, syntax and data types.

  • Prefer someone with .net, Java, Jenkins skills

  • Understanding of SharePoint is a plus

Job Summary

As a Technology Engineer on the Test Data Management (TDM) Center of Excellence (CoE) and Infrastructure support team within the Data Administration area of Global Technology Services at Travelers, you'll be supporting and managing the enterprise-wide implementation and adoption of Test Data Management practices and toolsets. You'll work closely with TDM development teams in various Lines of Business (LOB) who are designing and building solutions to provision and mask production data to lower test environments. You'll participate in design and code reviews to ensure that Line of Business solutions meet CoE guidelines and implement well into the common enterprise TDM infrastructure. You'll participate in the administration the Informatica TDM infrastructure. You'll also lead or develop solutions for various projects targeted at improving, patching, or upgrading the TDM Infrastructure, and making the TDM assets more accessible to end-users via Self-Service capabilities, the development of which you may coordinate or participate in.

Education, Work Experience & Knowledge

Bachelor's degree in Technology or a related field preferred. 5 years of experience in Technology preferred.

  • Experience with proprietary and open source databases, include SQL, Oracle, Mongo, DB2, etc.

  • Minimum 3 years of current experience writing SQL queries, triggers, stored procedures, investigating and mitigating performance issues, testing and verifying results

  • Minimum 2-3 years of experience on Setup of Test Data Services, Data masking, Test Data Management strategy and implementation, Test Data strategies.

  • Minimum 3 years of experience with test data management tools like Informatica TDM / IBM Optim / Delphix or other industry standard tools and technologies for Test Data Management

  • 1-3 years of Informatica Power Center and/or Test Data Management console experience, designing and developing data provision workflows

  • Experience administering Informatica development infrastructure, code management and deployment, software version upgrades and patch implementation and testing, including working with the vendor on problem trouble-shooting.

  • Experience in diagnosing complex technical issues

  • Experience in DevOps techniques and tools such as Jenkins, Puppet, Git Hub, etc.

  • Experience in Continuous Integration and Continuous Delivery Framework, (CI/CD) and tools supporting such automation of the process

Physical Requirements

Operates standard office equipment

Minimum Qualifications

High School diploma or equivalent required. 3 years of experience in Technology required.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Scientist And Computer Engineer


Posted 1 week ago

VIEW JOBS 4/10/2019 12:00:00 AM 2019-07-09T00:00 WHY DO WE LOVE COMING TO WORK EVERY DAY? With over 10,000 superstars across 48 different countries globally, it is hard not to be inspired every single day. At Finastra we celebrate in global knowledge sharing, diversity and an opportunity to make a difference for each other and for our customers. We are on a journey. After bringing two global Fintech leaders together in June 2017, Finastra has truly recognized the opportunity and power we have, by combining our expertise, successes and passion together. Whether it is in a collaboration hub or innovating with colleagues across our global landscape, we are one team creating a network of talent and creativity in a stimulating environment, to do what we can to make a difference for our customers. Our people are leaders in their role and are always looking for new ways to help our customers grow, compete and optimize their business. From a graduate Software Engineer to an experienced Sales Executive – we are looking for personal leadership and people with the appetite to understand the markets and customers we serve. We drive innovation that challenges the status quo and feel proud of the positive differences that we make every day. We recognize talent and provide a work environment where leaders can drive results, develop and grow their careers. Success is what you do, success is what we achieve, together. The future of Finance is open – combine your talents with Finastra opportunities to create an exciting career with us. For more information, visit Finastra.com What you will contribute? Finastra has opened its global innovation lab for new talents and is looking for an exceptional data scientist to join our Innovation Lab. This team is responsible for performing research and development with regards to artificial intelligence and developing innovative applications from ideation to demo-able products. You should be passionate about digging through data, looking for insights, uncovering trends, making forecasts, and communicating the results. Reporting to the VP, Chief Innovation Officer, the Data Scientist and Computer Engineer will collaborate with a multidisciplinary team of software developers, product managers, and engineers all over the world to tackle interesting problems in a wide variety of financial domains. Responsibilities & Deliverables: Your deliverables as a Data Scientist and Computer Engineer will include, but nit limited to the following:w * Analyze large, complex data sets and develop predictive models and analytical insights * Research the latest machine learning methods, forecasting techniques, and optimization methods and apply them in practice * Create data pipelines ranging from data collection to pre-processing to feature generation * Be a highly motivated, self-starter who is passionate about technology and solving problems in a creative manner * Work with multidisciplinary teams ranging from UI/UX designers to product managers to software engineers all over the world Job Requirements: * Bachelors/Masters/PHD in a quantitative discipline such as Computer Science, Mathematics, Statistics, or Operations Research * Experience with a scripting language such as python * Development experience with data analysis libraries such as numpy and pandas * Understanding of Machine Learning principles and familiarity with libraries such as sklearn * Experience using deep learning frameworks such as tensorflow, pytorch, MXnet, or keras * Applied experience with machine learning on large datasets * Experience collecting, pre-processing, and generating features for machine learning models * Demonstrated skill in selecting the right statistical tools for a data analysis problem * Full-stack development is a plus * A go-getter who can take ideas and bring them to life * Ability to fail fast and obtain quick wins * Passion to succeed and takes pride in their work * Ability to work independently as well as work effectively with a team #LI-MG1 The above statements describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties, and skills required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. If you need assistance or an accommodation due to disability please contact us at 800-274-7280. The Future is Collaborative. The Future is Open. The Future is Now. Finastra Norcross GA

Test Data Management Engineer / Admin

The Travelers Companies