Required Skills

DBA approval SQL requirements/design ETL

Work Authorization

  • Us Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 18th Nov 2020

JOB DETAIL

Job Description                

                               

- Codes and performs unit and integration testing of software to ensure proper and efficient execution and adherence to business and technical requirements                     

- Codes, tests, and debugs new software or makes enhancements to existing software                               

- Writes programs according to specifications from higher level staff or business analysts                             

- Develops technical documentation                      

- Resolves in a timely manner problems that arise with existing production applications to ensure the efficient and proper functioning of application components                 

- Collaborates with technical staff to learn and understand software problems                  

- Generates a variety of complex and periodic reports and/or data through database management, data administration and data extraction techniques                         

- Provides general system users and management with system analysis and feedback                   

- Influences system design by identifying and recommending design and requirements needs for software enhancements                               

- Mentors and coaches less experienced staff                   

- Maximizes the efficiency of the various software systems by implementing, monitoring, testing and auditing new software programs                        

- Analyzes and resolves computer related problems by coordinating with in‐house personnel to diagnose and fix operational difficulty, as well as consulting, advising and training on specialized features and functions                  

- Follows established configuration/change control processes                   

                               

                               

Academic/Experience/Competency                       

                               

BA/BS in Information Technology, Computer Science, related field or equivalent work experience.                         

                               

- Advanced capability in software construction, testing, infrastructure, configuration and operating standards                   

- Advanced corporate knowledge, and understands how a change would affect multiple applications                    

- Advanced ability to make recommendations/decisions in application and program design, standards and program enhancements                

- Advanced ability to utilize system traces and debugging tools for problem/issue resolution                      

- Advanced ability to analyze and model business functions, processes and information flow within or between systems                               

- Advanced ability to provide guidance and mentoring on programming practices and techniques to individuals and cross‐functional teams                             

- Advanced knowledge of software design, construction, programming trends, programming and scripting languages in multiple application and data management systems                       

- Advanced ability to work with users at all levels to define system requirements, design and system topologies to meet operational needs and system performance objectives                

                               

                               

Business Experience                      

                               

- 5 plus years experience with major DBMS                        

- 5 plus years experience with coding, testing and design                             

- 5 plus years experience with software development methodologies                   

                               

                               

Daily Tasks Performed                  

                               

                               

* Create/Modify SQL Server code/packages including SSIS/Stored Procedures/Handle error conditions                

* Database tables design based transactional and analytical requirements                           

* Create complex queries                           

* Design and develop an end to end ETL to load/store data                         

* Schedule processes and reports                           

* Trouble shoot production issues affecting database issues, performance issues, and answer/investigate data issues                  

* Work with DBA on reviewing design and attain DBA approval                 

* Attend various meetings with project team                    

* Create and execute SQL statements and perform complex data analysis                           

                               

Wants                  

                               

* Must have experience working on SQL Sever databases                           

* Experience working on transactional database dealing with high number of transactions                           

* Work closely with team members in requirements/design sessions to assure quality of end product                   

* Work closely and take direction from Team leads                         

* Experienced with Microsoft Office suite (including Visio and project)                  

                               

Unique Skill Set                

                               

MS SQL Server Developer                             

Please fill below submission details and send with visa and DL card photo ASAP

Company Information