ETL Developer

2 weeks ago

Albany, United States Sigma Full time
13392 ETL Developer, Albany, NY, 30 months Contract
Sigma Inc is currently looking for an ETL Developer at Albany, NY.

Working Hours: 7:00am - 5:30pm (Starting time is negotiable)
50% On-Site, mandatory no exceptions, Applicants should be prepared to report on-site 100%
50% non negotiable

Description:
  • Ensuring application documentation is complete, organized, accessible, and follows office standards.
  • Writing, testing, debugging new and existing code based on program area knowledge, conceptual and technical design specifications.
  • Write and test procedures, parameters and other specifications required to implement programs.
  • Develop or assist with the development of unit, component and program test plans.
  • Implement program changes and provides user support as required.
  • Database design, development, support and data mining related to new and existing complex Extract, Transform, Load (ETL) routines related to Work Protections.
  • Develop, test and implement program logic for data mining and ETL development;
  • Implement ETL technical specifications from development through test, staging and production environments;
  • Optimize ETL data load jobs to improve performance and automate;
  • Investigating and resolving data loading and/or data integrity issues;
  • Create solutions to improve system performance and availability;
  • Develop and maintain logical and physical dimensional data models for data warehouse/data mart;
  • Write clear documentation of process and data modeling and all associated tasks and documents including unit and quality assurance test plans.
Requirements:
  • 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field
  • 72 Months ETL development experience in Oracle environment with IBM DataStage
  • 84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming
  • 84 Months Experience tuning SQL within an Oracle environment to improve timely and efficient execution of queries
  • 84 Months UNIX Shell Scripting experience
  • 60 months experience in program and unit testing.
  • 60 months experience in program code documentation, mentoring and assisting other developers.
  • 60 months experience working with PPI and SSA data security requirements (working with data contained in Employee Records in a State Agency, Federal Agency or Private Organization) for production system error diagnosis, debugging, and code modification
  • 84 Months Experience developing dimensional data models for Cognos data analytics
  • 84 Months Experience developing data analysis and metrics queries for operational oversight.
  • 84 Months DataStage Administrator experience on AIX environments that includes implementing and maintaining business and technical rules; automating ETL code migration process and standards for
    Stop/start services; monitor logs; setting up security; assigning roles; project permissions; Create/Delete projects; create/modify environmental parameters; Platform Issue resolution; troubleshooting and root cause analysis; Configuration and tuning of production and lower-level environments; and capacity planning.

  • ETL Developer

    2 weeks ago

    Albany, United States VGroup Inc Full time

    Job DescriptionJob DescriptionClient: State of New York Job Title: ETL Developer Duration: 30 Months Start Date: ASAP Position Type: Contract Location: Albany, NY 12240 (HYBRID) Interview Type: Web Cam Interview Ceipal ID: SNY_ETL392_AM Position ID: NYS DOL - 13392Descsription: This position will assist in supporting critical DOL operational functions...

  • Oracle ETL Developer

    2 days ago

    Albany, United States Software People, Inc. Full time

    Job DescriptionJob DescriptionPhone/Skype Hire. Onsite from day 1 Location: Albany, NYDuration: 12+ monthsResponsibilitiesResolves/responds to Level 3 helpdesk tickets. Monitors ETL data loading process on a daily basis. Codes/Administers reports, maintains data feeds to external entities, performs analysis of database structure/data.Skills Needed60 Months...

  • Oracle ETL Developer

    5 days ago

    Albany, United States Software People, Inc. Full time

    Job DescriptionJob DescriptionPhone/Skype Hire. Onsite from day 1 Location: Albany, NYDuration: 12+ monthsResponsibilitiesResolves/responds to Level 3 helpdesk tickets. Monitors ETL data loading process on a daily basis. Codes/Administers reports, maintains data feeds to external entities, performs analysis of database structure/data.Skills Needed60 Months...

  • Sr. IBM ETL DataStage Developer

    2 weeks ago

    Albany, United States Sligo Software Solutions Full time

    Job DescriptionJob DescriptionDescriptionThis position will assist in supporting critical DOL operational functions focused on the development and optimization of DOL Data Management processes, respond to critical requests, and assist in the transition of legacy processes to the Worker Protection Consolidation Project. DutiesEnsuring application...

  • Database Developer

    24 hours ago

    Albany, United States Vichara Full time

    Company Description Vichara is a Financial Services focused products and services firm headquartered in NY and building systems for some of the largest i-banks and hedge funds in the world. Job Description Day-to-Day tasks: - The candidates will analyze, design/functional specifications which adhere to IT standards and policies. - Migrate data to appropriate...

  • Etl Informatica Consultant

    2 weeks ago

    Albany, United States Maira Technologies private limited Full time

    **Location**: Albany, NY, 12204 **Duration**: Long-term - 7 years’ Experience using Informatica Powercenter 9.6.x or higher in a data warehouse environment including familiarity with advanced warehousing concepts, and design and development of complex mappings - 7 years’ Experience with Informatica Powercenter Administration including Installation,...

  • ETL Data Warehouse Architect

    6 days ago

    Albany, United States Xyant Technology Full time

    Job Description _ Please send your updated resume to vinoth.xyant@gmail. com _ Job Title: ETL / Data Warehouse Architect. Location: Albany, NY (Onsite) Duration: Long-term Contract Direct Client Need Responsibilities: Manages the planning and delivery of data warehouse and storage architecture. Manages relationships stays capable of working with software and...

  • ETL Data Warehouse Architect

    3 weeks ago

    Albany, United States Xyant Technology Full time

    Job Description _ Please send your updated resume to vinoth.xyant@gmail. com_ Job Title: ETL / Data Warehouse Architect. Location: Albany, NY (Onsite) Duration: Long-term Contract Direct Client Need Responsibilities: Manages the planning and delivery of data warehouse and storage architecture. Manages relationships stays capable of working with software and...

  • Need for INFORMATICA ETL + ALBANY,NY

    2 weeks ago

    Albany, United States 3A Soft Inc Full time

    84 Months Experience using Informatica Powercenter 9.6.x or higher in a data warehouse environment including familiarity with advanced warehousing concepts, and design and development of complex mappings 84 Months Experience with Informatica Powercenter Administration including Installation, Patching, Metadata analysis, ETL code migration, and repository...

  • Systems Developer Expert

    3 weeks ago

    Albany, United States Cedar Park Group Full time

    Cedar Park Group is looking for an Expert Systems Developer. 50% Remote. Full-time. 8AM-5PM. 11 month contract. Duties: Develops and implements applications and programs for the backend processing systems used in businesses and organizations. Work in coordination with a team of developers to write the new Facility Application Management system in ASP.net...

  • Software Developer Senior

    3 weeks ago

    Albany, United States Cedar Park Group Full time

    Cedar Park Group is looking for a Software Developer (Senior level). Full-time. 9am-5.30pm (negotiable). 50% remote. 30 month contract. Duties: Customization and Configuration: Customize JIRA and Confluence to meet the specific needs of our organization, including creating JIRA projects/queries/reports, configuring workflows and custom fields, issue types,...

  • IT Specialist

    2 days ago

    Albany, United States Experienced Recruiting Partners Full time

    Job DescriptionJob DescriptionContract RoleHybrid Location – 50% Remote / 50% Onsite in Albany, NY areaLength: 30 MonthsOverview:This position will assist in supporting critical operational functions focused on the development and optimization of Data Management processes, respond to critical requests, and assist in the transition of legacy processes to...

  • IT Specialist

    2 weeks ago

    Albany, United States Experienced Recruiting Partners Full time

    Job DescriptionJob DescriptionContract RoleHybrid Location – 50% Remote / 50% Onsite in Albany, NY areaLength: 30 MonthsOverview:This position will assist in supporting critical operational functions focused on the development and optimization of Data Management processes, respond to critical requests, and assist in the transition of legacy processes to...

  • IT Specialist Oracle Datastage focus Contract

    1 week ago

    Albany, United States Experienced Recruiting Partners Full time

    Contract Role Hybrid Location – 50% Remote / 50% Onsite in Albany, NY area Length: 30 Months Overview: This position will assist in supporting critical operational functions focused on the development and optimization of Data Management processes, respond to critical requests, and assist in the transition of legacy processes to the corporate Project. ...

  • .Net Developer

    2 weeks ago

    Albany, United States CyberTec Full time

    Direct end client NYSTEC in Albany, NY. Rate: $60-75H C2C .Net Developer USC, GC (independent consultants) Location: Albany Hybrid - Remote work permitted at 50%. Job Qualifications: Bachelor's Degree 5 years of relevant experience Required Skills: 60 months of experience developing applications with JavaScript Framework 60 Months of...

  • Need for Oracle SQL Developer with healthcare Exp + ALBANY, NY

    2 weeks ago

    Albany, United States 3A Soft Inc Full time

    84 months experience in the area of: Public Health information Systems such as Medicaid or the Childs Health Insurance Program 84 months experience using Oracle products including: SQL Developer, SQL plus and executing SQL scripts using DBeaver to query Vertica and Oracle Databases 84 months experience Working with Stakeholders and vendor in the entire...

  • IT Specialist Expert

    2 weeks ago

    Albany, United States Quality Healthcare Staffing Full time

    Position: IT Specialist ExpertLocation: State Offices Harriman Campus, Building 12, Albany, NY 12240Pay Rate: $55 to $58 per hourSchedule: Monday to Friday, 7:00 AM 5:30 PM (Starting time is negotiable), 50% On-Site, mandatory no exceptionsJob Description:This position will assist in supporting critical Department of Labor (DOL) operational functions focused...

  • IT Specialist Expert

    2 weeks ago

    Albany, United States UrBench Full time

    Job DescriptionJob DescriptionHBITS-05-13392 - IT Specialist ExpertNew York State Department of LaborState Offices Harriman Campus Building 12 Albany, NY 12240USC/GC/GC-EAD/H4-EAD$65/hr72 Months ETL development experience in Oracle environment with IBM DataStage.84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming.84...

  • IT Specialist Expert

    2 weeks ago

    Albany, United States UrBench Full time

    Job Description Job Description HBITS-05-13392 - IT Specialist Expert New York State Department of Labor State Offices Harriman Campus Building 12 Albany, NY 12240 USC/GC/GC-EAD/H4-EAD $65/hr 72 Months ETL development experience in Oracle environment with IBM DataStage. 84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL...

  • IT Specialist Expert

    1 week ago

    Albany, United States Quality Healthcare Staffing Full time

    Quality Healthcare Staffing IT Specialist Expert ALBANY , New York Apply Now Position: IT Specialist ExpertLocation: State Offices Harriman Campus, Building 12, Albany, NY 12240Pay Rate: $55 to $58 per hourSchedule: Monday to Friday, 7:00 AM 5:30 PM (Starting time is negotiable), 50% On-Site, mandatory no exceptionsJob Description:This position will assist...