TEKsystems is seeking a Sr. Data Engineer for a contract to hire opportunity with our client in Anaheim, California. This is a hybrid position and candidates must be willing to be onsite once a month. Per the client's request, only candidates who live in the Southern California area will be considered due to the hybrid nature of the role.
Must Have
- Minimum 5+ years of SQL Development experience
- 3+ years of Informatica
- Azure
- 2+ years of Snowflake
Really Nice To Have
- MDM – He said this was a nice to have but he also made it seem like a must have
- Microsoft Dynamics 360
- CoPilot
- Customer Insights
They are adding MDM into Informatica and moving away from Informatica on-prem
Currently Informatica is the only thing in their environment that is on-prem - everything else is in the cloud
MDM – They are trying to figure out if they are going to move Informatica to the cloud or build their own
A lot of their data is in SQL
Position Summary
Responsible for managing and supporting the corporate Master Data Management (MDM), Operational Data Stores (ODS) and Enterprise Data Warehouse (EDW) platforms. This will include collaborating with the Data Analytics Steering Committee (DASC), Technology team and product stakeholders to design, implement and maintain these enterprise platforms.
Develop innovative and best practice techniques for modeling, developing, enhancing, and deploying database, reporting, and integration solutions. Lead new data integration and reporting initiatives that support organizational priorities while complying with the organization's IT and architectural standards. Establish organization wide Common Data Platform (CDP) and data integration standards. Participate in systems strategy, developing systems requirements, designing and prototyping, testing, training, defining support procedures, and implementing practical business solutions under multiple deadlines.
Essential Position Functions
Design, construct, install, test and maintain highly scalable MDM, ODS, CRM and EDW platforms with state-of-the-art security, monitoring and logging practices.
RDBMS (Microsoft SQL) and NoSQL design, implementation and maintenance for purposes of integration to other platforms.
Bring together large, complex and sparse data sets to meet functional and non-functional business requirements.
Design and implement data tools for analytics and data analyst team members to help them in building, optimizing and tuning our product.
Integrate new data management technologies and software engineering tools into existing structures.
Help in building high-performance algorithms, prototypes, predictive models and proof of concepts.
Assist business teams to better understand, consume and appreciate the implications and benefits of MDM, ODS, CRW and EDW solutions.
Experience, Skills And Abilities
At least five (5) years of experience in architecting, designing and configuring multi-domain MDM and Enterprise Data Warehouse (EDW)
At least five (5) years of relevant data management consulting or industry experience (master data, metadata, data architecture, data governance, data quality, data modeling)
At least five (5) years of experience with relational SQL systems including PL/SQL, T-SQL, Job configuration/management and performance tuning.
At least five (5) years of experience with designing, implementing and supporting ETL, ELT, Change Data Capture (CDC), streaming and similar data ingestion processes.
At least three (3) years of experience with non RDBMS platforms.
At least three (3) years of experience with modern programming languages.
At least three (3) years of experience leading work streams with significant experience leading components of data engagements.
Deep understanding of MDM and upstream and downstream integration
Knowledgeable in ETL design development.
Experience in Pub/Sub model for data integration both on premise and cloud.
Strong oral and written communication skills, including presentation skills (MS Visio, MS PowerPoint).
Proficient in Microsoft applications (Word, Excel, Outlook)
Bachelor’s Degree in Computer Science or related field or 5+ years equivalent professional experience
Preferred Skills
Experience in the latest components of Informatica multi-domain MDM editions including Entity 360 and ActiveVOS
Experience with other data management toolsets: Informatica Powercenter, Informatica Data Quality, IICS, etc.
Experience in designing and architecting integrations between Informatica MDM and other systems using standard connectors, publish-subscribe, and other mechanisms
Experience with iPaaS toolsets: MuleSoft, Informatica Cloud, TIBCO
Experience with Microsoft SQL versions 2008 and higher including high availability.
Experience with non RDBMS platforms: HBase, Cassandra, Hadoop, MongoDB, Snowflake, etc.
Experience with one or more of Python, PySpark, Java, Databricks, Node.JS, React JS, Restful APIs.
Experience with one or more Cloud platforms (Azure, AWS).
Experience with one or more data and reporting tools such as Informatica, SSIS, SSRS, Tableau, Power BI, Micro Strategy.
Experience in a Project Management and/or Busines Analyst or similar role(s)
Experience with CRM platforms: Salesforce, Microsoft Dynamics
o
Requirements
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
- Medical, dental & vision
- Critical Illness, Accident, and Hospital
- 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
- Life Insurance (Voluntary Life & AD&D for the employee and dependents)
- Short and long-term disability
- Health Spending Account (HSA)
- Transportation benefits
- Employee Assistance Program
- Time Off/Leave (PTO, Vacation or Sick Leave)
About TEKsystems
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.