Senior ETL Administrator
2 weeks ago
Sr. ETL Administrator
Department:
Technology Services
Location:
Remote/Reston, VA
Description
We are currently seeking an Application Administrator to work within a team that provides Data Warehouse and Business Intelligence services to our government customer using Agile scrum processes. You will work with varying data sources with different schemas and data elements to ultimately produce an effective and efficient Data Warehouse. You have an eye for spotting data correlations and a desire to dig into large datasets to find technical solutions and deliver business value. This role will interact with officially designated product owners, system owners, and business owners of the source systems to understand transactional system data models and elicit requirements and logic for the ETLs. As a senior admin, we seek an individual who is self-driven with the ability to adapt quickly, work independently in a challenging and fast paced environment within cross-functional teams, and to promote creative problem solving within their team as well.
Program Details
The program you will be supporting has a mission to provide development, security, and operations (DevSecOps) support to U.S. Citizenship and Immigration Services (USCIS) with a focus on development, operations, and modernization of the agency’s Enterprise Data Warehouse/Data Lake. The team utilizes open-source, AWS Cloud, and Big Data technologies, Agile project management practices, and modern DevSecOps delivery to provide the business intelligence support systems to meet the reporting, data analytics, and machine learning/artificial intelligence needs critical to USCIS leadership, data/business analysts, data scientists, and other decision-makers.
Responsibilities:
Work with Information System Security Officers (ISSO) to mitigate and/or improve security posture
Troubleshoot data discrepancies and missing data issues resulting from daily ETL loads
Work with operations team to promote ETL code/jobs across all environments and debug /troubleshoot critical production issues
Implement procedures to maintain, monitor, backup and recover operations for ETL/BI environment
Report regularly on health and performance of ETL/BI environment and jobs
Conduct ETL/BI optimization, troubleshooting and debugging
Maintain ownership of release activities interacting with ETL/BI projects
Perform import and export ETL jobs across various ETL projects and servers
Establish projects, roles, users, privileges in different ETL/BI environments (DEV, QA, PROD)
Collaborate with various ETL/BI developers to implement solutions per requirements
Record and maintain ETL/BI software and operational procedures. Provide detailed analysis of problems and recommend solutions.
Conduct troubleshooting of production and ETL/BI job issues and mitigate performance issues.
Perform independently with little direct supervision in administration of ETL/BI application (Informatica IICS and Tableau)
Actively participate in Agile release and sprint planning, sprint grooming, artifact creation, sprint testing, demonstrations and retrospectives and solution releases.
Execute other activities related to development work, such as participate in meetings, provide briefings, presentations and other support materials that will promote the program, assist in achieving user buy-in, and explain technical concepts to non-technical audiences.
Perform and assume other duties and responsibilities as required at direction of management.
Required Skills :
5+ years of experience with ETL (Informatica/Power Center/IICS)
5+ years of experience in application administration on Linux environments
3+ years of experience with Tableau administration
3+ years of experience with supporting BI applications using relational databases and Data Lake
3+ years of experience in technical development and leadership roles on BI projects, including designing and developing with ETL Tools
3+ years of experience working in AWS Cloud environment
Experience with ETL/BI Process Management to include establishing boundaries of data processing, building system architecture for the data pipeline, drawing up technical documentation for system requirements, and participate in the determination and implementation off ETL/BI and testing tools
Experience with scripting languages e.g., Bash and UNIX
Experience with building automated ETL/BI pipelines using DevOps tools like Jenkins
Strong teamwork, communication, co-ordination, planning and leadership skills
Experience with GitHub and branching strategies
Experience with Microsoft Office Suite including Excel, PowerPoint, and Visio
Desired Skills:
Experience with Microsoft Office Suite including Excel, PowerPoint, and Visio
Knowledge of Agile, including Scrum and Kanban, and management tools (e.g., Jira, Confluence)
Knowledge of Scripting languages e.g., Python
Experience with Databricks/Apache Spark, AWS Data Migration Service (DMS), and/or Informatica PowerCenter and/or IICS
Experience with Postgres, Oracle, and Data Lake environments
Education:
Bachelor’s degree in a technical discipline preferred – Computer Science, Mathematics, or equivalent technical degree, or the equivalent combination of education, professional training, and work experience
Location:
Reston, VA – Currently fully remote
Clearance:
Must be a US Citizen and be able to obtain a government agency Suitability Clearance. USCIS Entry on Duty (EOD) preferred
#J-18808-Ljbffr
-
Senior ETL Administrator
2 weeks ago
Reston, United States TekStream Solutions Full timeSr. ETL AdministratorDepartment:Technology ServicesLocation:Remote/Reston, VADescriptionWe are currently seeking an Application Administrator to work within a team that provides Data Warehouse and Business Intelligence services to our government customer using Agile scrum processes. You will work with varying data sources with different schemas and data...
-
Senior ETL Administrator
2 weeks ago
Reston, United States TekStream Solutions Full timeSr. ETL AdministratorDepartment:Technology ServicesLocation:Remote/Reston, VADescriptionWe are currently seeking an Application Administrator to work within a team that provides Data Warehouse and Business Intelligence services to our government customer using Agile scrum processes. You will work with varying data sources with different schemas and data...
-
Senior ETL Administrator
2 weeks ago
Reston, United States TekStream Solutions Full timeSr. ETL AdministratorDepartment:Technology ServicesLocation:Remote/Reston, VADescriptionWe are currently seeking an Application Administrator to work within a team that provides Data Warehouse and Business Intelligence services to our government customer using Agile scrum processes. You will work with varying data sources with different schemas and data...
-
Full Stack/ETL Developer with Security Clearance
2 weeks ago
Reston, United States Leidos Full timeR-00129263 Description Why wake up every day and want more when YOU CAN HAVE IT? Do you love KNOWING at the end of each day that your work made a difference? We embrace and solve some of the world's toughest challenges. We’re focused on ensuring our intelligence customers have the right tools, technologies, and tactics to keep pace with an ever...
-
Data Engineer
3 days ago
Reston, United States NS2 Mission Full timeJob DescriptionJob DescriptionAre you interested in working in a dynamic environment that offers opportunities for professional growth and new responsibilities by helping clients drive alignment with their business, advising through critical and complex issues, while allowing you to develop personally and professionally? Then consider a career at NS2...
-
Data Engineer
2 weeks ago
Reston, United States NS2 Mission Full timeJob DescriptionJob DescriptionAre you interested in working in a dynamic environment that offers opportunities for professional growth and new responsibilities by helping clients drive alignment with their business, advising through critical and complex issues, while allowing you to develop personally and professionally? Then consider a career at NS2...
-
Senior Software Developer
2 weeks ago
Reston, United States Evolver Commercial Full timeJob DescriptionJob DescriptionEvolver LLC (Reston, VA) seeks Senior Software Developer - SQL to develop ETL processes with SQL integration Services. Req. Bachelor's in Computer Science, Software Engineering, Computer Engineering, Computer Information Systems, Information Technology or related field, plus 5 years' of experience to include: development...
-
Data Engineer
2 weeks ago
Reston, United States NS2 Mission Full timeAre you interested in working in a dynamic environment that offers opportunities for professional growth and new responsibilities by helping clients drive alignment with their business, advising through critical and complex issues, while allowing you to develop personally and professionally? Then consider a career at NS2 Mission. We have grown into an...
-
Big Data Administrator
1 week ago
Reston, United States Ageatia Global Solutions Full timePURPOSE: This is a Big Data Administrator position and not a developer position.The Senior Data Engineer is responsible for orchestrating, deploying, maintaining and scaling cloud OR on-premise infrastructure targeting big data and platform data management (Relational and NoSQL, distributed and converged) with emphasis on reliability, automation and...
-
Senior Salesforce Developer
2 months ago
Reston, United States AVM Consulting Inc Full timeCompany DescriptionAVM Consulting is a global technology consultancy focusing on secure, observable cloud architectures and an Everything as Code (EAC) approach. We provide strategy, design, implementation, and support for data intensive cloud applications supported by RDBMS and NoSQL solutions. Our expertise also includes CI/CD using DevOps and DevSecOps...
-
Senior Salesforce Developer
2 months ago
Reston, United States AVM Consulting Inc Full timeCompany DescriptionAVM Consulting is a global technology consultancy focusing on secure, observable cloud architectures and an Everything as Code (EAC) approach. We provide strategy, design, implementation, and support for data intensive cloud applications supported by RDBMS and NoSQL solutions. Our expertise also includes CI/CD using DevOps and DevSecOps...
-
Senior Salesforce Developer
2 weeks ago
Reston, United States AVM Consulting Inc Full timeCompany DescriptionAVM Consulting is a global technology consultancy focusing on secure, observable cloud architectures and an Everything as Code (EAC) approach. We provide strategy, design, implementation, and support for data intensive cloud applications supported by RDBMS and NoSQL solutions. Our expertise also includes CI/CD using DevOps and DevSecOps...
-
Linux/UNIX Systems Administrator
6 days ago
Reston, United States SilverEdge Full timeRequired Skills Overview The Systems Administrator will be responsible for data extraction, transformation and load (ETL), data mapping, data extraction, analytical support, operational support, database support, application development and associated maintenance of production systems. This is a fast-paced, dynamic team in a process oriented environment....
-
Senior Ab Initio Developer
2 weeks ago
Reston, United States Abidi Solutions Full timeJob DescriptionJob DescriptionJob Title: Senior Ab Initio Developer Location: Hybrid - Onsite in Reston, VA 1x per week. Candidates must reside in DV region Duration: 12 monthsProject Summary: Abidi Solutions seeks a Senior Ab Initio Developer to assist in developing data pipelines that transfer data from multiple mainframe source systems to various cloud...
-
Reston, United States SilverEdge Full timeOverview The Systems Administrator will be responsible for data extraction, transformation and load (ETL), data mapping, data extraction, analytical support, operational support, database support, application development and associated maintenance of production systems. This is a fast-paced, dynamic team in a process oriented environment. Experience with...
-
Senior Ab-Initio developer
6 days ago
Reston, United States Adameservices Full timemust be local to the DMMV area., Candidates must be located in PA, MD, VA, DC or WVa., This position is Hybrid based. Job Details Contract to Hire Position in Reston VA. Candidate will be required to be onsite at least once a week.*** Searching for a Senior Ab-Initio developer for a 12 month Contract to hire job opportunity with our direct client. This...
-
Senior AbInitio Developer
1 month ago
Reston, United States Resource Informatics Group Inc Full timeJob DescriptionJob DescriptionRole:-Senior AbInitio DeveloperLocation:Reston,VAVisa:- NO OPT/CPTDuration:- 12 Months Interview:- Phone/SkypeJob Description :Total of 7+ Years of IT Experience predominantly in Data Integration/ Data Warehouse areaMust have 5 years of ETL Design and Development experience using Ab Initio1-2 years of Data Integration project...
-
Senior AbInitio Developer
3 weeks ago
Reston, United States Resource Informatics Group Inc Full timeJob DescriptionJob DescriptionRole:-Senior AbInitio DeveloperLocation:Reston,VAVisa:- NO OPT/CPTDuration:- 12 Months Interview:- Phone/SkypeJob Description :Total of 7+ Years of IT Experience predominantly in Data Integration/ Data Warehouse areaMust have 5 years of ETL Design and Development experience using Ab Initio1-2 years of Data Integration project...
-
Big Data Administrator Lead
2 weeks ago
Reston, United States Ageatia Global Solutions Full timePURPOSE This is a Big Data Administrator Lead position and not a developer position. The Lead Data Engineer is responsible for orchestrating, deploying, maintaining and scaling cloud OR on-premise infrastructure targeting big data and platform data management (e.g., data warehouses, data lakes) including data access APIs. Prepares and manipulates data using...
-
Big Data Administrator Lead
3 weeks ago
Reston, United States Ageatia Global Solutions Full timePURPOSE This is a Big Data Administrator Lead position and not a developer position. The Lead Data Engineer is responsible for orchestrating, deploying, maintaining and scaling cloud OR on-premise infrastructure targeting big data and platform data management (e.g., data warehouses, data lakes) including data access APIs. Prepares and manipulates data...