Texas - Plano

8 Years

- /- ( )

Required Skills

Oracle PL/SQL SQL and ETL( Informatica) Good communication

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 7th Dec 2024

JOB DETAIL

  • Translate business requirements into technical specifications.
  • Design and implement ETL (Informatica) process using SQL, ETL tool and Linux shell scripting to deliver high quality solutions.
  • Strong data analysis, advance SQL query writing skill and resolving the defects by working across multiple teams
  • Collaborate with other development teams to manage interdependency, set up test cases, debug and maintain data quality.
  • Ensure software stability via documentation, code reviews, regression, unit and user acceptance testing.
  • Hands on logical and physical data modeling and database design responsibilities.
  • Good understanding of Dimensional modeling
  • Be able to lead and develop Informatica Power Center ETL complex flows connecting to heterogeneous database such as oracle/MS SQL server.
  • Develop complex oracle procedures ,functions, and packages to support database applications(API calls / DW reporting )
  • Conduct both proactive and reactive performance tuning activities during course of development of new applications and existing legacy applications.
  • Hands on experience to develop and support Unix Shell Scripting.
  • Should have understanding of scheduler (Autosys)
  • Perform data analysis and data profiling. Identify data quality issues.
  • Participate and guide team in estimating work necessary to realize a story/requirement through the delivery lifecycle.
  • Contribute to story refinement/defining requirements.
  • Perform spike/proof of concept as necessary to mitigate risk or implement new ideas.
  • Code solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements.
  • Utilize multiple architectural components (across data, application, business) in design and development of client requirements.
  • Assist team with resolving technical complexities involved in realizing story work.

 

Company Information

TEK Inspirations LLC

roshani.kumari@tekinspirations.com

8303559008