ETL SSIS Developer

1 week ago

Reston, Virginia, United States Diverse Lynx Full time

Job Description

Primary Skills:
Data warehousing, ETL, SSIS, Data model, MSBI

Responsibilities:

  • 7+ yrs. of experience with MS BI, with strong experience on ETL looks like SSIS with SQL Development, SSRS, including Python
  • Lead and guide the Rapid Deployment team and ensure team follow best practices and standards defined for Data Warehousing development (ETL, SSIS and TSQL)
  • Participate and guide the team in design related discussions (data modeling using Erwin, Visio, ER Studio)
  • Look for gaps and optimize existing processes
  • Lead the RD team to Support/enhance/create Daily/Monthly ETL/ELT processes to ensure business continuity, ensuring all related data pipelines meets best-in-class standards offering high performance.

Support:

  • cknowledge user created tickets or Business Analysts' assigned tickets through SNOW ticketing platform, ADO or Activities or other effort/work assignments as mutually agreed upon Accept, resolve, status, coordinate with other teams to resolve identified issues with production batch work or other DWH services, perform Root Cause Analysis and status both SNOW and ADO tasks as appropriate for work performed
  • Inform and follow up with change coordinator for production implementation approval and actual deployment
  • Validate the deployed components in production and obtain user or business analyst sign off on the production outcome after execution
  • Update the results and status of the ticket in the SNOW portal / ADO
  • Perform Batch Monitoring for all Data Management supported processes, and data related stores / Workloads, from Monday through Saturday including on / off-shore Holidays. Provide solution for issues by performing SLA adherence and relay communications to customer
  • Perform/Participate in platform maintenance and upgrade activities, including Micro Segmentation, DR Testing, Unit testing of ETL, SSRS, WinApps and other DW workloads regarding Server Upgrades and patch installations.
  • Support and create CICD implementation of Database and ETL workloads for all existing ETL and Database pipelines.
  • Support Internal and EY Audit requests to provide evidence on Data Warehousing ETL workloads.
  • Identify the long running processes and provide solutions for performance tuning by creating self-identified ticket in SNOW portal and ADO. Provide Monthly metrics and weekly status on requests to Customer
  • Perform platform housekeeping activities like Lower environment data refresh, Database server Transaction log clean up, Source file Archival, Trigger file clean up

Development & Enhancement:

  • nalyze the assigned work and understand the business or technical requirements. Follow up with user or BSDA for resolution of any clarifications on the requirements.
  • Understand functional/technical requirements for Data Management Short-term Development or other Activities/work assignments as mutually agreed upon.
  • Design technical components to achieve intended functionality.
  • Build the technical components or solution in the lower environment and perform necessary QA validations on the process/report/data
  • Request user or business analyst validation on the final process/report/data outcomes built for the requirement on the lower environment.
  • Get sign-off from the User or BSDA on validation and obtain confirmation on the production process scheduling frequency and timing
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination.

All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role.

We promote and support a diverse workforce across all levels in the company.

  • Net Developer with SSIS

    1 week ago

    Reston, Virginia, United States Omni Inclusive Full time

    Technical Skills / Knowledge Required:Minimum of eight years developing web applications in C#, ASP.NET using MVC architecture with at least one year using .NET Core. Minimum 8 years of advanced technical skills with creating and modifying SQL procedures, stored procedures, triggers, and database technologies using MS Sql Server. Experience in designing and...

  • ETL Java Developer

    1 week ago

    Reston, Virginia, United States Byte Systems, LLC Full time

    Candidate MUST possess a TS/SCI clearance with Intel Polygraph Job Description:We have an IMMEDIATE NEED for a ETL Java Developer SME to provide Agile DevOps support to mission critical systems. As a ETL Java Developer on this program, you will have the opportunity to build strong systems, software, and cloud environments and provide operations and...

  • Mainframe ETL Developer

    1 week ago

    Reston, Virginia, United States Zenius Full time

    Job DescriptionMainframe ETL DeveloperCandidates must be a US Citizen or a Legal Permanent Resident for 3 years and be Federal Tax compliantActive IRS MBI Clearance is highly desirable.Remote PositionStatement of Work:Business Master File Modernization (BMF Mod) is a part of the programs created to update the Internal Revenue Services (IRS) legacy Tax...

  • Senior SQL Developer

    1 month ago

    Reston, Virginia, United States DT Professional Services Full time

    Job SummaryDT Professional Services is seeking an Enterprise Data Warehouse (EDW) Consultant with SQL Developer and cloud environment experience to support the Office of Information Systems (TC) within the Drug Enforcement Administration(DEA). The DEA's SQL Server-based EDW is used by a majority of DEA's applications and is a critical component of...

  • Senior SQL Developer

    3 weeks ago

    Reston, Virginia, United States DT Professional Services Full time

    Job SummaryDT Professional Services is seeking an Enterprise Data Warehouse (EDW) Consultant with SQL Developer and cloud environment experience to support the Office of Information Systems (TC) within the Drug Enforcement Administration(DEA). The DEA's SQL Server-based EDW is used by a majority of DEA's applications and is a critical component of...

  • SQL / BI Developer (remote)

    2 months ago

    Reston, Virginia, United States ASRC Federal Full time

    Job DescriptionAgile Decision Sciences is actively seeking a SQL BI Developer to join our team and support development efforts for a government clientThe SQL Developer role will provide support to the operations of the Energy Compensation System (ECS), Division of Energy Employee Occupational Illness Compensation while providing expertise in software...

  • Senior AbInitio Developer

    1 week ago

    Reston, Virginia, United States Resource Informatics Group Inc Full time

    Job 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 Analytics Senior Developer

    2 months ago

    Reston, Virginia, United States Atechstar Full time

    Key ResponsibilitiesThe right candidate will be expected to be a significant player in the project evolution & deployment shouldering the following responsibilitiesContribute to full development life cycle including requirements analysis functional design technical design programming testing documentation implementation and on-going technical support Analyse...

  • Data Engineer

    1 week ago

    Reston, Virginia, United States Metric5 Full time

    Data EngineerDescription Metric5 is currently seeking a Data Engineer to work within a team providing Data Warehouse and Business Intelligence services to our government customer using Agile processes. As a Data Engineer, you will work with varying huge data sources with different schemas and data elements to produce an effective and efficient Data...

  • Software Engineer

    1 week ago

    Reston, Virginia, United States Crimson Phoenix Full time

    Software Engineer- SME Required Skills: Demonstrated experience developing and documenting scripts on Linux OS. Demonstrated experience with Scripting Languages (SSH, Python, JavaScript). Demonstrated experience using advanced query functions in relational databases. Demonstrated experience using AWS to include S3, EBS, and EC2. Demonstrated experience...

  • Azure Architect

    2 months ago

    Reston, Virginia, United States Atechstar Full time

    Job description 1-12+ Years experience in Azure Space across Architecture Design Development testing Deployment full understanding in SDLC. 1-5+ years hands-on experience with architectures in a Microsoft Azure based platform Solid experience leading data teams in developing data engineering platforms. Good working Experience of Azure Data Bricks Data Bricks...

  • Azure Architect

    3 weeks ago

    Reston, Virginia, United States Atechstar Full time

    Job description 1-12+ Years experience in Azure Space across Architecture Design Development testing Deployment full understanding in SDLC. 1-5+ years hands-on experience with architectures in a Microsoft Azure based platform Solid experience leading data teams in developing data engineering platforms. Good working Experience of Azure Data Bricks Data Bricks...

  • Lead Ab Initio Engineer

    1 week ago

    Reston, Virginia, United States Dexian - DISYS Full time

    Position: Lead Ab Initio Engineer Location: Reston VA (Hybrid) Job Type: 12 months Contract To Hire Job Description: PURPOSE: The Lead 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)...

  • Database Developer $215,000.00 with Security

    1 week ago

    Reston, Virginia, United States B4Corp Full time

    : Position Requires a Top Secret (TS/SCI) Clearance with a Polygraph. The Database Engineer in this role will perform high level database engineering and management tasks. This includes leading, data design, data structure identification, database schema definition, data access privilege management, data query optimization, documentation, database instance...

  • Bigdata Architect

    3 weeks ago

    Reston, Virginia, United States Atechstar Full time

    Job description 1-12+ Years experience in Bigdata Space across Architecture Design Development testing Deployment full understanding in SDLC. Experience of Hadoop and related technology stack experience Experience of the Hadoop Eco-system(HDP+CDP) / Big Data (especially HIVE) Hand on experience with programming languages such as Java/Scala/python Hand-on...

  • Bigdata Architect

    2 months ago

    Reston, Virginia, United States Atechstar Full time

    Job description 1-12+ Years experience in Bigdata Space across Architecture Design Development testing Deployment full understanding in SDLC. Experience of Hadoop and related technology stack experience Experience of the Hadoop Eco-system(HDP+CDP) / Big Data (especially HIVE) Hand on experience with programming languages such as Java/Scala/python Hand-on...

  • Business Intelligence Engineer

    3 weeks ago

    Reston, Virginia, United States Atechstar Full time

    Responsibilities Include Enable effective decision making by retrieving and aggregating data from multiple sources and compiling it into a digestible and actionable format Partnering with other analysts and engineers to build analytical solutions to deliver on business goals Propose and implement business metrics for senior management reviews and work with...

  • Business Intelligence Engineer

    2 months ago

    Reston, Virginia, United States Atechstar Full time

    Responsibilities Include Enable effective decision making by retrieving and aggregating data from multiple sources and compiling it into a digestible and actionable format Partnering with other analysts and engineers to build analytical solutions to deliver on business goals Propose and implement business metrics for senior management reviews and work with...

  • Data Solution Architect

    2 months ago

    Reston, Virginia, United States Atechstar Full time

    Job description1-5 years of experience managing and delivering ETL/Hadoop/Bigdata Solutions in a large enterprise environment and would take a lead role in the design and analysis of a Big Data and Analytics solution in a variety of industries and computing environments. Provide data architecture solution design and architectural leadership that includes...

  • Data Solution Architect

    3 weeks ago

    Reston, Virginia, United States Atechstar Full time

    Job description1-5 years of experience managing and delivering ETL/Hadoop/Bigdata Solutions in a large enterprise environment and would take a lead role in the design and analysis of a Big Data and Analytics solution in a variety of industries and computing environments. Provide data architecture solution design and architectural leadership that includes...