Role overview

Qualifications

11-15 years of overall experience in data/IT, with mandatory consulting background
Deep understanding of data models, data mapping documents, SQL, ETL design and ETL coding (Informatica or any ETL tool)
Proficiency in at least one scripting language
Excellent communication skills and ability to scale to an Architect role

Responsibilities

Lead analysis, estimation, design, development, testing, and implementation of data archiving, test data management, and data privacy solutions
Establish repeatable processes to support multiple applications, including data masking, data reset, and update procedures
Collaborate with IT Security and Compliance to ensure policies are followed and coordinate across Storage, OS, and DBA teams
Provide test data for performance, UAT, QA, and other non-production environments; leverage Oracle, SQL Server, and DB2, and experience with TDM tools (Informatica TDM primary; others as applicable)

Key facts

Remote from: Anywhere
Full time
Data Architect
English

Other skills

Teamwork
Communication

About the company

AceStack LLC

Staffing & Recruiting

OUR STORYAceStack is a global IT consulting & Staffing agency. We deal in Health care (Nursing, Allied, Clinical/Non-clinical) Staffing, Engineering Staffing & I.T. Staffing. Founded in 2017 in New Jersey, AceStack has reported consistent growth and profit every year and carries zero debt. AceStack consultants are placed across USA, Canada, Mexico, and Asia. In addition to our headquarters in New Jersey – USA, we also have offices in Canada, Noida, and Ahmedabad.OUR MISSIONWe are committed to providing exceptional staffing solutions that meet our clients' specific job requirements. Our mission is to deliver highly skilled and qualified personnel who exceed expectations and drive results. We believe in investing in our people, providing exceptional service, and fostering strong relationships with our clients and personnel. Our dedication to excellence sets us apart from competitors and helps us to create long-term value for our clients and personnel alike.WHY USAceStack’s exceptionally high-touch service keeps our clients satisfied and our Consultants/Travelers engaged. We believe in investing in our Consultants/Clients in a variety of ways. We employ AceStack ambassador who helps guide Consultants through the on-boarding process and ensure the transition into their new role with our Client is seamless. We also have dedicated Consultant care representatives located throughout our organization who provide the same level of attention throughout our Consultant’s tenure. Due to this level of attention and care, AceStack enjoys not only one of the highest retention rates in the staffing industry but also one of the highest redeployment rates in the industry.

Company details

Company typeScaleup

IndustryStaffing & Recruiting

Company size51 - 200

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Job Description-

Position: Data Architect

Location: Remote

MUST HAVES:

1) TDM - Understanding of data models, data mapping documents, SQL, ETL design and ETL coding (Informatica /any ETL Tool)

2) Any Scripting Language

3) Senior enough to be able to scale up to Architect role

4) Excellent communication skills

Exp- 11-15 years overall

Consulting background- Mandatory

Analysis, Estimation, Design, Development, Testing, Implementation of data Archiving /Test Data Management/ Data Privacy solutions

Provide a consistent and repeatable process to support multiple Applications including identifying data elements for masking in Applications, Data Reset and Update Process

Understanding of data models, data mapping documents, ETL design and ETL coding

Work directly with IT Security and Compliance to ensure Policies were consistently followed

Coordinated activities across multiple operations teams including Storage, OS , and DBA teams

Provide required Test data for Performance Test, User Acceptance Test, QA Test, Application Development, and other Non-Production Environments

Expertise on DBs Oracle, SQL Server, DB2

Experience in managing and using TDM tools like Optim, Informatica, CA TDM, Solix tools Ab initio / Informatica session (Informatica TDM is Primary rest nice to have )