ETL/Migration Specialist

Security Clearance required: No clearance required Cognosante is on a mission to transform our country’s healthcare and national security systems.
With our health and security-focused solutions, we help public sector organizations achieve the important task of providing the best possible public services to American Citizens.
From Enterprise IT, Data Science, and Security Services, to full-scale Consumer Engagement and Interoperability solutions, we are moving government services forward with transformation and innovation.
Learn how we are making a difference in people’s lives today! Job Description Cognosante is looking for a motivated, hands-on ETL/Migrations Specialist with Talend experience joining a high-performing Data Ecosystem (DE) team.
As a ETL/Migrations Specialist, you will serve as part of a migration team reporting to the Technical Manager.
The Technical Manager will serve as the technical subject matter expert and Solution Architect over the Contractor’s team implementing the Data Ecosystem.
The Technical Manager will lead the strategy and implementation for the end-to-end Data Lake solution by taking into consideration the client’s business case, objectives, requirements, constraints, technology landscape, and technology standards.
At Cognosante we foster a supportive, collaborative, and fun environment where team members are empowered to push the envelope of learning and creativity.
Key Responsibilities Collaborate with business analysts and stakeholders to understand data integration requirements and objectives.
Translate business requirements into technical specifications for ETL processes.
Update and maintain all production technologies ensuring proper maintenance and installation.
Identify and connect to various data sources, including databases, APIs, flat files, and external systems.
Develop scripts or use ETL tools to extract data from source systems while ensuring data integrity.
Design and implement data transformation logic to cleanse, format, and enrich data.
Convert data into a consistent format for integration into the target system.
Handle data validation, standardization, and deduplication.
Define and implement processes to load transformed data into the target data lake.
Optimize loading processes for performance and efficiency.
Use ETL tools (such as Talend) or custom scripting to develop ETL workflows and jobs.
Configure ETL components and transformations to ensure data accuracy and integrity.
Required Qualifications Proven experience as an ETL developer or data integration specialist.
Strong expertise in designing, developing, and implementing ETL processes using Talend.
Proficiency with: Demonstrated expertise in using Talend Studio for ETL development.
Ability to create complex ETL jobs using Talend components, transformations, and connectors.
Experience with Talend's built-in debugging and error handling mechanisms.
In-depth knowledge of data warehousing concepts, data modeling, and data normalization.
Proficiency in SQL for data manipulation, querying, and optimization.
Familiarity with various data sources and file formats, such as databases, APIs, flat files, XML, JSON, etc.
Understanding of data integration best practices and methodologies.
Ability to design ETL processes that ensure data quality, consistency, and accuracy.
Knowledge of data profiling and cleansing techniques to improve data quality.
Familiarity with scripting languages (e.
g.
, Python) for automation and data manipulation tasks.
Ability to develop custom scripts to enhance ETL processes as needed.
Willingness to stay updated with the latest ETL and data integration trends, tools, and technologies.
Understanding of data security best practices and compliance requirements Preferred Qualifications Two (2) years of experience Implementing large-scale healthcare IT solutions within environments similar to that of the Medicaid Management Information System (MMIS) Building and supporting mission critical, multi- tier large scale healthcare applications Data Management / Data Lake experience with MMIS data being the prime data source.
Snowflake implementations for healthcare related projects Agile/Scrum Certification Lean Six Sigma Compensation $72,268.
51 - $115,627.
49 The pay range for this job is determined by various factors, including but not necessarily limited to location, responsibilities of the job, and alignment with market data.
When determining a salary for this role, the following factors may will be taken into consideration - contract-specific affordability, education, knowledge, skills, competencies and experience.
The estimate displayed represents the salary range for this position and is just one component of Cognosante’s total compensation package for employees and is not necessarily reflective of actual compensation that may be earned, nor a promise of any specific pay for any specific employee.
Cognosante will not provide sponsorship for employment-based immigration benefits for this position.
Like many other growing companies, Cognosante has been targeted by scammers attempting to make fraudulent job offers to potential candidates.
Communication from Cognosante recruiting will only be sent with an official corporate domain email (e.
g.
, @cognosante.
com or @accurate.
com) and not a commercial domain e-mail (e.
g.
, @gmail.
com or @yahoo.
com).
We will never request payment from you, nor will we send payment to you, prior to your start date.
If you have been asked to send or receive any payment, or if you have any doubt about whether you have been contacted by a Cognosante employee, please contact us at jobs@cognosante.
com.
Thank you.
Cognosante is an Equal Opportunity/Affirmative Action employer.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.