Current Openings

Job Title: Senior Oracle Developer

  • Employer: American Technology Labs Inc.
  • Job Duties: Design and develop client-server and distributed applications using Oracle Forms and Reports, Informatica, UNIX, SSRS, SSIS, and SSAS. Perform system analysis and design using Data Flow Diagrams, Data Dictionary techniques, Case tools, Entity Relation Modeling tools, and Design technique. Perform PL/SQL programming and maintain applications using Oracle development tools such as SQL Plus, SQL Developer, Toad, SQL Navigator and SQL Loader. Develop Database Models using ERWIN tool and scripts using Perl and Unix shell scripts. Develop Data Access Objects using Hibernate, JDBC, and JP API. Design and develop Data Warehouses, Data Marts, and manage SharePoint databases. Perform Extract, Transform, and Load (ETL) techniques in Informatica Power Center Designer tool and SQL Loader tools. Store reformatted data form Relational, Flat file, XML files using Informatica (ETL). Develop Integrating Services using REST API, JSON services and a Cassandra database. Utilize Java IO, text, Utils (Collection Framework) packages, Procedures and Exception handling. Development Mobile applications in Android manifest XML file to include all database permissions such as GPS, SMS READ / SEND / RECEIVE within UNIX/Oracle environment. Responsible for resolving application development technical issues as they arise. Will work in Clifton Park, NY and/or various client sites throughout the U.S. Must be willing to travel and/or relocate.

Job Title: Senior ETL Developer

  • Employer: American Technology Labs Inc.
  • Job Duties: Design, build, test, tune and deploy ETL/ETL infrastructures including ETL applications, Data Warehouse, and Data Marts in order to support reporting applications. Work on multiple projects to maintain and develop applications for both enterprise releases and smaller maintenance releases using Agile methodology. Responsible for implementing data strategies, build data flows and develop logical and physical data models. Performs analysis and research of application functionality and interpret reporting requirements in order to develop technical specifications for data warehouse ETL's and Data Marts. Prepare data lineage and source to target mapping specification documents to support development plan using MS Visio and Informatica Metadata Manager. Perform data profiling using IBM Quality Stage stages like standardize, match frequency, duplicate and unduplicated match and survive stages. Perform data modeling as well as reverse engineering using tools Erwin, PL/SQL, Oracle Designer and SQL server management studio, SSIS and Stored Procedures. Design the ETL processes using tools like IBM Infosphere Datastage / Informatica/ Teradata/ SSIS to perform data acquisition from heterogeneous data sources like Oracle, Netezza, Teradata, DB2, MS SQL Server and load onto landing, staging and eventually onto the Enterprise Data Warehouse/Datamarts /ETL applications. Perform data extraction and load using Teradata utilities like multiload, fast load and fast export for large warehouse and for DataMart’s in Teradata. Integrate various data sources like DB2-UDB, SQL Server, PL/SQL, Oracle, Teradata, XML and MS-Access into Enterprise Data warehouse to support the analytical systems. Design, set up and manage continuous Integration of ETL applications and CICD processes to build end to end large scale enterprise wise ETL/analytical applications. Automate and schedule Data Acquisition, Data Transformation and Data Load processes as predefined. Write test plans, test scenarios, test cases and test scripts to perform unit, integration, system testing and user acceptance testing. Package the software for deploying into different environments and perform ETL code version controlling and management using tools like Tortoise/Git hub. Strategize, synchronize and deploy ETL applications on various environments like dev/test/prod servers. Enforce and implement predefined coding standards, quality standards and best practices. Document Data Lineage, Source to Target mapping specifications and Data Acquisition/ Transformation/ Load artifacts and Scheduling artifacts. Monitor, support and propose performance improvements for ETL/Big Data Hadoop applications post deployment. Will work in Clifton Park, NY and/or various client sites throughout the U.S. Must be willing to travel and/or relocate.

Job Title: Technical Lead

  • Employer: American Technology Labs Inc.
  • Job Duties:Work on the design of business processes and application configuration for Oracle Transportation Management (OTM) system based on industry best practices. Perform OTM customizations and integrations with Oracle, other ERPs and legacy applications and carrier systems. Interact with the key end users and business owners to map applications to standard business processes and conduct gap analysis. Provide the best business solution to the client for the gaps identified. Lead and conduct project activities at the client site. Support all formal documentation of solutions. Lead and support all solution activities including testing and verification. Contribute to the training and development of key users. Manage and guide the project team (Onsite / Offsite) with technical and functional inputs. Manage client relationship and grow the account. Adhere to the project policies and guidelines. Work in: Oracle Transportation Management (OTM), Oracle Databases, PL/SQL, XML, XSL, XSLT, Unix, Java, JSPX, ADF, and SOA. Will work in Clifton Park, NY and/or various client sites throughout the U.S. Must be willing to travel and/or relocate.

Job Title: Java Software Engineer

  • Employer: American Technology Labs Inc.
  • Job Duties:Perform design and development of software applications working in Java, J2EE, Swing, Design Patterns, RMI, JSF, Tomcat, WebSphere, CVS. Develop the code, unit test the application and deploy the software. Will work in Clifton Park, NY and/or various client sites throughout the U.S. Must be willing to travel and/or relocate.

Attn: HR

American Technology Labs Inc
800 Route 146 Suite 496
Clifton Park NY 12065

Or E-Mail to hr@amtechlabs.com