Greetings from ALIS Software LLC.
Myself Anil Kumar, Staffing Specialist at ALIS Software LLC. I am reaching out to you on an exciting job opportunity with one of our clients.
You can reach me at [email protected]
JOB TITLE : Data Engineer
LOCATION: Austin, TX – Hybrid role – Should be local to TX
Client: State of Texas
• Developing complex SQL scripts to transform the source data to fit into a dimensional model, then to create views and materialized views in Oracle.
• Developing automation with Informatica Power Center/IICS to pull data from external data sources and transform it to fit into a dimensional model.
• Collaborating with other members of the Data Engineering Team on the design and implementation of an optimal data design.
• Verification and validation of SQL scripts, Informatica automation and database views.
• Developing automated means of performing verification and validation.
• Work closely with the Architects and Data Engineering Team on implementation designs and data acquisition strategies.
II. CANDIDATE SKILLS AND QUALIFICATIONS
|
|
|
|
Required/Preferred
|
Experience
|
|
Required
|
Experience designing and developing complex Oracle SQL scripts that are fast and efficient
|
|
Required
|
Experience in interfacing with ETL tools such as Informatica PowerCenter, IICS, ADF and supporting ETL jobs.
|
|
Required
|
Experience writing UNIX scripts
|
|
Required
|
Strong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project.
|
|
Required
|
Technical writing and diagraming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.
|
|
Required
|
Experience with JIRA software
|
|
Required
|
Experience making technical presentations and working closely with customers
|
|
Required
|
Experience acquiring and integrating data from multiple data sources/technologies using Informatica Power Center for use by a Tableau data visualization object. Data source techs should include Oracle, SQL Server, Excel, Access and Adobe PDF.
|
|
Required
|
Experience working with Snowflake
|
|
Preferred
|
Excellent oral and written communication skills.
|
|
Preferred
|
Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required.
|
|
Preferred
|
Proven ability to write well designed, testable, efficient code by using best software development practices
|
|
Preferred
|
Understanding of security principles and how they apply to healthcare data
|
|
Preferred
|
Master’s degree in Computer Science, Information Systems, or Business or equivalent experience.
|
|
Preferred
|
Prior experience in the Healthcare Industry
|
Best Regards
Anil Kumar
Lead Technical Recruiter
ALIS Software LLC
Email: [email protected]
Phone: 5127226283
Follow Us On: Facebook | LinkedIn | Twitter| Website| Instagram
Texas HUB Certified
Certified Minority Business Enterprise (MBE)
Certified Disadvantaged Business Enterprise (DBE)
DIR ITSAC Contract: DIR-CPO-4557