ETL Developer 1
ETL Developer 1
Posted on :
08-12-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Title: ETL Developer 1
Location: 120 Broadway 30th Floor New York NY 10271
Job Description
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.
DESIRABLE SKILLS/EXPERIENCE: Note: candidates who do not have the required skills will not be considered.
The selected candidate must have excellent verbal and written communication skills and have the ability to interact professionally with a diverse group including executives managers and subject matter experts. The candidate should be a team player.
"If you are: bright motivated skilled a differencemaker able to get things done work with minimum direction enthusiastic a thinker able to juggle and multitask communicate effectively and lead then we would like to hear from you. We need exceptionally capable people for this role for our client so get back to us and tell us why you think you are a fit."
About Us:
Since 2000 TriForce Consulting Services () has been an MBE/SDB certified IT Consulting firm in the Philadelphia region. TriForce specializes in IT staffing software development (web and mobile apps) systems integration data analytics system automation cybersecurity and cloud technology solutions for government and commercial clients. TriForce works with clients to overcome obstacles such as increasing productivity increasing efficiencies through automation and lowering costs. Our clients benefit from our three distinguishing core values: integrity diligence and technological excellence. TriForce is a sixtime winner among the fastestgrowing companies in Philadelphia and a fourtime winner on the Inc. 5000 list of the nations fastestgrowing companies.
Bachelor's 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 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. ETL certifications on Microsoft SQL Server or Oracle will be a plus
Education
Education: Bachelor s degree in Computer Science, Information or related field.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
