ETL Developer
New Carrollton, MD
Applications have closed
eTelligent Group
We connect thought leaders together with experts to assist our customers to address challenges and solve problems.Position: ETL Developer
Location: New Carrollton, MD
Duration: Long Term CTH
Security Clearance: Active MBI clearance required
Company Overview:
For the past 10+ years, eTelligent Group has consistently delivered excellent services that are demonstrated through our exceptional past performances. As a HUBZone, WOSB, and small business, we have distinguished our company as effective problem solvers with innovative, scalable solutions.
We integrate CMMI Level 3 processes, tools, and techniques with innovative, cost-efficient, and secure solutions to address complex challenges. We also hold ISO 9001:2015, ISO/IEC 27001:2013, and ISO/IEC 20000-1:2018 certifications.
Task Description:
This individual will act as the ETL Developer and will be responsible for developing ETL application using Informatica for high volume data. This position requires demonstrated experience using the Informatica Suite of tools including Power Center, B2B, and Power in an Agile/Scrum environment. This position will develop Extract, Transformation and Loading (ETL) procedures for implementing data integration and data loading tasks in support of CDR Data Repository from client and non-client data sources. The Database environment for the project is Oracle and for the data sources, it will vary depending upon the data source (XML, flat file, Relational Databases). Prior experience with SQL on Oracle databases will be required.
Primary Duties:
- Develop new ETL application using Informatica Power Center to load large amount of data from multiple data sources into CDR/IRDB Repository using Oracle database.
- Develop Data Integration procedures using Informatica suite of tools including B2B and Power Exchange.
- Develop SQL programs and Stored Procedures as required for the ETL processes and Data Integration activities.
- Provide support to technical team, write the necessary required documentation as per the Client’s development methodology for ETL processes, and Develop unit test plan, test cases and resolve ETL related test problems.
- Coordinate the DRIVE build deployment with EAD team from EST to PROD.
Required skills/Level of Experience:
- Demonstrated experience in designing ETL processes using Informatica for high-volume, complex data environments in an Agile environment– 2 years
- Demonstrated Strong experience using the Informatica Suite of Tools - Power Center, Power Exchange, B2B Data Transformation – 2 years
- Strong experience in the design and development of mappings, transformations, sessions, and workflows in PowerCenter – 2 years
- Strong experience in SQL in the Oracle environment – 3 years
- Data warehouse data modeling experience – 2 years
- Develop and implement solution against identified masked data issues while function/performance testing – 1 year
Preferred skills:
- Healthcare system experience
Tags: Agile ETL Informatica Oracle RDBMS Scrum Security SQL Testing XML
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Data Science Manager jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Manager jobs
- Open Data Engineer II jobs
- Open Power BI Developer jobs
- Open Principal Data Engineer jobs
- Open Sr Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Data Scientist II jobs
- Open Product Data Analyst jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Business Data Analyst jobs
- Open Big Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Azure Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Product Manager jobs
- Open Data Quality Analyst jobs
- Open Junior Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open GCP-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Java-related jobs
- Open Privacy-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open APIs-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open Snowflake-related jobs
- Open Consulting-related jobs
- Open PhD-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Hadoop-related jobs
- Open LLMs-related jobs
- Open Databricks-related jobs
- Open Generative AI-related jobs