Required Skills

ETL Developer with Testing

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 26th Aug 2021

JOB DETAIL

Looking for 9+ years of experience candidates

Hands-on with K2View/any other ETL tool, with experience in developing ETL scripts and Data Warehousing for real world use cases. They must be at ease working with on-prem Big Data ecosystem in an agile environment with little supervision. The person should be a self-motivated person with a passion for problem solving and continuous learning.

The Business Intelligence (BI) Specialist is responsible for the design, development, implementation, management and support of mission- critical enterprise BI reporting and Extract, Transform, Load (ETL) processes and environments.

Developing architectural solutions utilizing K2View/any other ETL tool

Work with project management to provide effort estimates and timelines.

Interact with Business and IT team members to move the project forward in every Sprint.

Contribute the development of ETL scripts using K2View/any other ETL tool

Knowledge of Java and PHP is required to develop solutions for the ETL in use (K2View)

Work with Internal stakeholder and development teams during project lifecycle

Analyzing Business requirements and Preparing functional documents and detail design documents.

Deep knowledge of implementing K2View/any other ETL tool Mappings based on the requirement by writing functions, translations using SQL/BTEQ scripts.

Creating Corresponding Maps and Flows for that translation to run and check for any error and load the data into Staging.

Interacting directly with Product support team (K2View) to fix any K2View Admin bugs by raising case with them.

Debug the issues related to Process, Daily Runs and weekly Migration & Data.

Ability to interact with all levels of management

ETL Tools: K2View OR Informatica 9.x & 10.x

ETL experience is mandatory (ETL – Data Extract, Transform, Load)

PHP scripting language knowledge/experience would be added advantage

Should have very good SQL & Unix knowledge and skills

Should have JAVA Basic Coding knowledge

Bachelor's degree in Science/ IT/ Computer Science or equivalent

Experience/knowledge in ETL Programming, testing tools and testing methodologies

Hands-on troubleshooting issues in ETL solution

Telecom experience/knowledge is an advantage

 

Company Information