USEReady Inc. was founded in 2011 and our mission is to help organizations succeed by fast tracking their business performance. We relentlessly strive towards value-driven innovation using advanced BI, data management, and infrastructure management services.
With offices in New York, New Jersey, Seattle, Austin, and Bangalore. Our global delivery service is enriched with winning strategies, technology expertise, and customer fanaticism. We have a proven track record of success in various domains such as capital markets, insurance, healthcare, pharma, retail, and media.
- Ranked #113 in Inc. 5000
- Tableau Gold Partner for 5 consecutive years
- Tableau Services Partner of the Year 2015 and 2017
- Tableau Services & Training and Alliance partner nominee of the year 2016
- Alteryx, Collibra, Snowflake, AWS & Micros
Job Description
USEReady has an immediate Direct Hire opportunity for a Senior Application Systems Developer in NY City. This position provides a competitive salary and amazing benefits! The ideal candidate will be responsible for technical design and implementation of lifecycle activities associated with the extract, transform, and loading (ETL) of database tables with automated utilities, ETL tools (i.e. Business Objects Data Services – BODS) and SQL programs.
Responsibilities:
- Deploys code across Dev, QA, and Production environments using central repositories.
- Develops/Maintains/Supports new and existing data flows from multiple source systems.
- Develops/Maintains/Supports business rules and processes around data cleansing, consolidation, and validation.
- Troubleshoots/debugs ETL and SQL query issues and provides solutions.
- Develops views and ad hoc/scheduled SQL queries to analyze data, produce exception reports, validate data, and as required by the functional team.
- Creates ETL solutions using data warehouse design best practices, such as Star-Schema design and Change Data Capture.
- Assists in the design and creation of logical and physical data models for reporting databases.
- Produces data flow diagrams and other documentation as needed.
- Works with Director and Project Manager to develop and follow project plans and resource estimates.
- Collaborates with Reporting team and data integration team to define and develop user data requirements.
- Integrates, collaborates, and leads projects, working hand in hand with Business Analysts, Data Warehouse team, DBA, and the infrastructure team.
- Works with the functional team to assist in the preparation of source to target data maps.
- Assists in gathering/reviewing business requirements, partnering with business analysts, providing feedback on functional request feasibility and scope.
- All other duties as assigned.
- Ability to work weekends and off-hours.
Required Skills:
4+ years’ working in SAP Business Objects Data Services (BODS) – or, one of the leading enterprise ETL tools, such as Informatica PowerCenter, Microsoft SSIS, IBM InfoSphere DataStage, Pentaho or Talend – for designing and developing ETL solutions.
SAP Business Objects Data Services (BODS) proficiency needs to include:
- Audit Rules
- Built-in Functions
- Interactive Debugger
- Transforms, such as Query, Key Generation, Table Comparison, History Preserving, and Validation
Develop ETL logic utilizing various features available in the Data Integrator component, including:
- Expert in SQL and stored procedure for development, debugging, and implementing complex transformations.
- Needs to be a self-starter and able to lead ETL projects or ETL activities within a project.
- Familiarity with Systems Development Life Cycle (SDLC) and software development best practices.
- Development experience with two or more of the following: SQL, PL/SQL, TSQL, PERL, SQL Server, Oracle.
- Experience in the implementation of Web applications in a Unix/Linux environment, including knowledge of scripting languages and standard tools and utilities.
- Experience collaborating with DevOps, Security, Network, Systems, and other IT teams.
Bachelor's Degree or equivalent and/or its equivalent.
Ability to work weekends and off-hour work.
Qualifications
SAP BODS
Additional Information
All your information will be kept confidential according to EEO guidelines.
#J-18808-Ljbffr