ETL DEVELOPER GIS data exp Job at ACS Consultancy Services, New York, NY

dDc3VzdQNHN3ZGZGNzkrTUtjN0NORy9T
  • ACS Consultancy Services
  • New York, NY

Job Description

Job Title: ETL DEVELOPER (GIS data exp )

Location: New York NY (Onsite)

We are currently seeking candidates who meet the following qualification

SCOPE OF SERVICES
Extract geographic and nongeographic data from Oracle and SQL Server databases
ensuring the integrity and quality of the data.
Transform raw data into structured formats suitable for analysis reporting and system
integration.
Design and implement data pipelines for efficient handling of large datasets.
Automate ETL integrations using SQL Server Integration Services (SSIS).
Perform data analysis to drive key business objectives.
Document ETL processes data models and API specifications for transparency and
knowledge sharing.
Develop test and maintain ETL workflows and scripts to automate data processing.
Monitor ETL processes to ensure reliability scalability and performance.
Perform data modeling and database design for application development and product
implementation initiatives under the guidance of Database Administrator and Architect.
Create reporting solutions using SQL Server Reporting Services (SSRS) by analyzing user
needs and information availability.
Troubleshoot and resolve datarelated issues promptly.
Create APIs to enable data access and integration with various applications and systems.
Ensure APIs are secure performant and adhere to industry standards.
Collaborate with developers and analysts to design API endpoints that meet business
requirements.
Work with GIS analysts developers and stakeholders to understand data requirements.
Participate in requirements definition analysis and design.
Work closely with business analysts subject matter experts and development teams in
design development testing implementation and support of application projects.
Facilitate creation migration and maintenance of database objects across
development/QA/production environments.
Follow best practices in data modeling including use of standard naming conventions
processes and templates to ensure consistency of data models.
Monitor and optimize database performance and capacity utilization to provide high
availability and redundancy.
Take ownership of database performance scalability and security.
Define and implement data testing strategies with business stakeholders application
development teams and QA groups.
Participate in the software testing process including identification and resolution of
defects.
Contribute to and support rollout strategies.
Participate in and contribute to formal/informal technical reviews and presentations.
Accurately estimate time required to complete development tasks.
Demonstrate the ability to cooperate with a variety of people and achieve results.
Mentor and guide development team members on databaserelated tasks.
Provide technical support and knowledge transition to team members and end users as
needed.



REQUIRED QUALIFICATIONS SKILLS AND EXPERIENCE


Note: candidates who do not have the required skills will not be considered.
Bachelors degree in Computer Science Information Systems Geographic Information
Systems (GIS) or a related field.
Minimum of 5 years as ETL Developer Data Engineer or similar role with a focus on
geographic data.

Proficiency in TSQL and PL/SQL with experience working with Microsoft SQL Server
Oracle and PostgreSQL databases.
Familiarity with SSRS SSAS SSIS and data warehousing concepts like ETL Dimensions
Facts Cubes.
Demonstrated knowledge of designing developing and integrating databases data
warehouses and multidimensional databases in MSSQL Server.
Knowledge of data integration patterns database design and data modeling principles.
Strong programming skills in Python C# or other relevant languages for ETL and API
development.
Experience with API frameworks (e.g. Flask FastAPI or Django REST Framework).
Experience with geographic data formats (e.g. shapefiles GeoJSON) and geospatial tools
(e.g. ArcGIS QGIS).
Experience with cloud platforms (e.g. AWS Azure GCP) and related data services.
Familiarity with ETL tools like Talend Apache Nifi or Informatica.
Ability to write and optimize complex SQL queries stored procedures triggers and
functions.
Experience in code migration database change management and data management
through the various stages of the development life cycle.
Familiarity with application lifecycle management (ALM) tools such as Azure DevOps and
GitHub.
Experience with version control and release management practices.
Excellent problemsolving collaboration and communication skills.
ETL certifications on Microsoft SQL Server or Oracle will be a plus.

If you meet these qualifications please submit your application via link provided in Linkedin.
Kindly do not call the general line to submit your application.

Job Tags

Similar Jobs

Beacon of Hope Restorations LLC

Canvasser - Roofing, Gutters, and Siding Lead Generator Job at Beacon of Hope Restorations LLC

 ...Canvasser specializing in lead generation for roofing, gutters, and siding in hail-affected areas: Job Title: Canvasser Roofing, Gutters, and Siding Lead Generator Overview: Beacon of Hope Restorations is seeking motivated and energetic Canvassers to join... 

BCI Brands

Sweater Design (Intern) Job at BCI Brands

 ...BCI has continually evolved to become a leader in the womens fashion industry. Launching initially with CHAUS and private label lines...  ..._____________________________________ Reports to: Assistant Designer Responsibilities : Assist in day-to-day operations of... 

Truck with Jed Logistics

Truck Driver/CDL-A /Dedicated/Home Weekly Job at Truck with Jed Logistics

 ...Driver Responsibilities: ~ Dry Van ~ Automatics ~ Home weekly for 34 hour reset ~ Work Tues-Sat; start time is 3pm; 12 hour shift ~$.88cpm ~$50 per live load and live unload ~$10 per drop; $30 per load under 100 miles ~ Average $1200-$1500 per week gross... 

Summit Technologies, Inc.

Policy and Publications Analyst Job at Summit Technologies, Inc.

Policy and Publications AnalystBackground: United States Army Chaplain Corps builds Army spiritual readiness to deploy, fight,...  .... This job requires technical, analytical, educational, and administrative services in support of emerging information management requirements... 

Larry Rosenthal & Associates Inc.

Embedded Software Engineer Job at Larry Rosenthal & Associates Inc.

 ...The Staff Embedded Software Engineer on the Platform Software team participates in the architecture, design, development, test, and integration of software required to produce displays and video systems used in commercial passenger aircraft. Must have experience with...