Company Description
About ACC
ACC is an AWS Advance Partner with AWS Mobility Competency. Awarded The Best BFSI industry Consulting Partner for the year 2019, ACC has had several successful cloud migration and application development projects to its credit.
Our business offerings include Digitalisation, Cloud Services, Product Engineering, Big Data & Analytics and Cloud Security. ACC has developed several products to its credit. These include Ottohm Enterprise Video and OTT Platform, Atlas API API Management and Development Platform, Atlas CLM Cloud Life Cycle Management, Atlas HCM HR Digital Onboarding and Employee Management, Atlas ITSM Vendor Onboarding and Service Management and Smart Contracts Contract Automation and Management.
Website -
http://www.appliedcloudcomputing.com/
Job Description
Job Description:
We are looking for a 6-8 years experienced ODI & DB Senior Developer.
- Should have good querying skills on MSSQL & Oracle & Postgres databases with ability to understand & debug PL/SQL procedures.
- SQL proficiency with experience in constructing/deconstructing complex reports and queries
- Experience in modifying PowerShell scripts
- Experience in performance tuning of mappings, error handling, testing, debugging, troubleshooting skills and migration of objects.
- Experience in managing Files, MSSQL DB, XML's through ODI
- Experience in developing Load Plans, Scheduling Jobs
- Experience in integrating ODI with multiple Source / Target
- Excellent verbal and written communication skills
- Skilled problem-solver and detail oriented
- Requires ability to work on assigned tasks independently with limited direction.
- Takes personal responsibility for the quality and timeliness of work and achieves results with minimal oversight.
- Must be a team player and work well in a deadline-driven environment with multiple priorities.
- Data modeling experience using dimensional data modeling, star/snowflake schema, fact and dimension tables, physical and logical data modeling.
Roles & Responsibilities:
- AWS working knowledge
- Responsible for design, development, customizations, deployment, and post-implementation support for ODI, and ETL solutions
- Provide expertise in performing application development, configuration and unit testing of data integration (using ODI, PL/SQL, SQL).
- Work closely with business stakeholders and database administrators to plan, design, develop and implement applications, scripts, procedures and metadata for relational databases.
- Responsible for performing analysis, design, development, testing and performance improvements of complex queries based upon the specific needs of USP
- Responsible for troubleshooting, debugging, optimizing and performance tuning of data warehouse and ETL(ODI) scripts.
- Responsible to develop and maintain documentation for ongoing operational activities.
- Perform thorough ETL testing, debugging & troubleshooting ETL mappings to resolve issues
- Perform notifications (email etc) to alert on exceptions and error.
- Ready to work in 2nd Shift & also flexible hours when needed
Qualifications
Engineer/MBA/Masters degree
