Princeton IT Services, Inc ยท 1 month ago
ETL Developer
New York, NY
Contract
Onsite
Mid Level
4+ years expPrinceton IT Services, Inc is seeking an ETL Developer to extract and transform data from various databases while ensuring data integrity and quality. The role involves designing and implementing data pipelines, automating ETL processes, and collaborating with cross-functional teams to meet business needs.
Big DataCloud ComputingCloud InfrastructureCloud ManagementCloud SecurityInformation TechnologySoftwareStaffing Agency
Responsibilities
Extract geographic and non-geographic 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 data-related 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 roll-out 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 database-related tasks
Provide technical support and knowledge transition to team members and end users as needed
Communicate effectively with team members, stakeholders, and project managers to gather requirements, provide updates, and manage expectations
Create and maintain technical documentation, including system designs, workflows, and user guides
Ensure solutions comply with industry best practices, standards, and security protocols
Prepare documentation and conduct knowledge transition to support adoption across the organization and other city agencies
Stay current with industry trends and emerging technologies to propose innovative solutions and improve development processes
Qualification
Required
Bachelor's degree in Computer Science, Software Engineering, Information Systems, Geographic Information Systems (GIS), or a related field
Minimum of 4 years as ETL Developer, Data Engineer, or similar role, with a focus on geographic data
Proficiency in T-SQL 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 MS-SQL 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 problem-solving, collaboration, and communication skills
Experience with MS-SQL Server, PostgreSQL, Oracle, and/or other geospatial databases
Ability to collaborate effectively within a team environment
Strong knowledge of software architecture principles, design patterns, and best practices
Familiarity with DevOps practices and tools for continuous integration and delivery
Familiarity with application lifecycle management (ALM) tools such as Azure DevOps and GitHub extensions
Experience with version control using Git and GitHub and release management practices
Excellent problem-solving skills and ability to work effectively in a collaborative team environment
Strong communication skills, both written and verbal
Demonstrated experience working with technical and non-technical staff
Preferred
Master's degree is a plus
ETL certifications on Microsoft SQL Server or Oracle will be a plus
Company
Princeton IT Services, Inc
Princeton IT Services, Inc.
11-50 employees
H1B Sponsorship
Princeton IT Services, Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (10)
2024 (7)
2023 (2)
2022 (4)
2021 (7)
2020 (5)
Funding
Current Stage
Early StageLeadership Team
Ravi Karamsetty
Chief Executive Officer
Company data provided by crunchbase