Test Data Management Engineer / Admin

The Travelers Companies Alpharetta , GA 30023

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 Engineer III


Posted 4 days ago

VIEW JOBS 4/19/2019 12:00:00 AM 2019-07-18T00:00 Overview Leveraging deep integrations into retailers' point-of-sale systems, InComm provides connectivity to a variety of service providers that allow consumers to conduct everyday business at more than 450,000 points of retail distribution worldwide. Whether those consumers are activating prepaid products, paying bills, enjoying real-time discounts through a membership card, purchasing digital goods in-store or adding funds to an online account, InComm is there to provide unique gift-gifting opportunities, cater to on-the-go shoppers, deliver added value through loyalty programs and serve cash-based consumers. With 186 global patents, InComm is headquartered in Atlanta with a presence in over 30 countries in North and South America, Europe and the Asia-Pacific region. Learn more at www.incomm.com or connect with us on www.twitter.com/incomm, www.facebook.com/incomm, www.linkedin.com/company/incomm or www.incomm.com/blog. About This Opportunity The Data Engineer will be a part of our EDM Data Platform & Strategy group. The group is respoonsible for overseeing systems & processes related to the movement, transformation, cleansing, organization and storage of data across the enterprise. Their main responsiblities include: * Maintain/evolve the company's EDW and associated mart/semantic layer components * Create integrations that move data between platforms (including into the EDW) * Collect information necessary to facilitate critical accounting and analysis functions * Configure/evolve the company's master data management platform, which cleanses, conforms, and categorizes data from disparate systems to create a universal view of InComm's business landscape The Data Engineer will be a part of the EDM Data Platforms team. This team is responsible for ETL Development, EMDM – (Enterprise Master Data Management), and EDW – (Enterprise Data Warehousing). Responsibilities * Analyze and implement business intelligence solutions for business * Full SDLC for processes to automate manual data integration tasks, including the development of management reports to support the operations * Responsible for the development of a support plan (FAQ, Guidelines for routing trouble tickets, etc.) * Perform impact analysis, build supporting business case for new projects * Design, develop and implement data integration processes ingesting data from varied source platforms * Troubleshoot integration problems and recommend appropriate solutions * Responsible for the development of a communication and end user support plan * Responsible for ongoing Data Quality/Support/Data Stewardship * Other duties may vary depending upon departmental requirements. Qualifications * Minimum 5, Preferred 7+ years experience in Data warehousing or related position * 4-year degree in related field * Extensive knowledge of Microsoft BI Stack (SSIS, SSAS, SSRS) * Extensive knowledge of Microsoft SQL Server and query performance tuning * Extensive knowledge of ETL and best practices * Extensive knowledge of C# and VB as it pertains to Scripting in SSIS * Knowledge of data warehouse modeling and design * Knowledge of creating and managing restfull services for accessing data warehouses * Strong collaboration skills and ability to build strong working relationships across multiple teams to include Data * Integration, Network, DBA, Server Systems, etc. * Strong written and oral communication skills InComm provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity or national origin, citizenship, veteran's status, age, disability status, genetics or any other category protected by federal, state, or local law. * This position is eligible for the Employee Referral Bonus Program - Tiet 4 Incomm Alpharetta GA

Test Data Management Engineer / Admin

The Travelers Companies