Send me more jobs like this

SQL Developer / Database Expert / Data Migration

Keywords / Skills : sql, Data Migration

2 - 6 years
Posted: 2019-09-18

IT/Computers - Software
Software Engineer/ Programmer
Posted On
18th Sep 2019
Job Description
What We Need 

• Proven experience with Extract, Transform, Load tools – Informatica, SSIS, ODI, Pentaho Data Integration etc.

• Solid understanding of the software development process, including requirement gathering, analysis/design, development tools/technologies, release/version control, contemporary testing methodologies, and deployment management.

• Strong experience working with dedicated and matrixed resources as well as:
  •  Informatica Power Center
  •  Writing Complex SQL Queries
  •  Unix Shell Scripting
  •  Warehousing
  •  Relational Database
  •  Other BI Tools with Business Objects, ECM; Archival experience a plus
  •  Data Mapping, Data Modeling, Data Mining, and Data Warehousing/Mart
  •  Relational databases and SQL Query performance tuning
• Demonstrated ability to prepare complex data models.

• Demonstrated experience in data integration and the specification of data services.

• Familiar with highly complex logical data design and data mapping or data conversion.

• Advanced problem-solving skills.

• Able to learn effectively and meet deadlines.

• Self-motivated and works independently and as part of a team.

What You will Do
 • Design, develop, and test data processes per business requirements, following the development standards and best practices as well as participate in code peer reviews to ensure our applications comply with best practices.

• Work with business analysts to gather business requirements from end users and translate them into technical specifications.

• Gather requirements to define data definitions, transformation logic, and data model logical and physical designs, data flow, and process.

• To be responsible for providing technical guidance / solutions.

• Provide estimates for development.

• Perform data analysis and data profiling against source systems and data warehouse.

• Design data marts to support Business Intelligence reporting.

• Design ETL processes using Informatica Power Center.

• Assist developers with difficult Oracle PL/SQL /Netezza / Teradata code and stored procedures.

• Design, develop, implement and maintain custom oracle/Netezza / teradata applications written in PL/SQL.

• Conduct reviews of developed code.

• Test solutions to validate whether requirements have been met; develop test plans, test scripts, and test conditions based on the business and system requirements.

• Provide end-user support in post-deployment phases; assess and evaluate all feedback to ensure that the requirements necessary to correct issues are addressed.

• Degree – Graduates/Postgraduate in CSE or related field

Key Skill(s)

About Company

About Impetus:

Impetus Infotech India Pvt. Ltd. is a software solutions, products and services company focused on creating powerful and intelligent enterprises through deep data awareness, integration and advanced analytics. Our products and services are designed to empower the real-time data driven enterprise to help our clients win in the modern world of digital transformation.

Impetus offers full life-cycle services for big data technology implementations, including technology strategy, solution architecture, proof of concept, production implementation and on-going support to its clients.

Impetus is proud to partner with such Fortune 100 clients as American Express, Bank of America, Capital One, Fannie Mae, McKesson, Toyota, United Airlines, Verizon and many more.

Awards and Recognitions:

• Impetus Infotech India Pvt. Ltd. has been conferred with Dream Companies to Work for in India 2018 for the fourth time in a row by the World HRD Congress.

• In 2017, it was recognized among Top 50 India’s Best Workplaces in IT & IT-BPM and was ranked 74 in Top 100
India’s Best Companies to Work by Great Places to Work For.

• Impetus StreamAnalytix has also been recognized as a ‘Hot Vendor’ in Aragon Research’s Hot Vendors in AI & Streaming Analytics 2017 report and was mentioned as a ‘Strong Performer’ in the Forrester Wave – Streaming Analytics Q3 2017 report.

Our Global Presence:

The company is headquartered in Los Gatos, California with international offices in Australia, Canada and has development centers in NOIDA, Indore, Gurgaon, and Bengaluru, India.
Similar Jobs
View All Similar Jobs
Walkin for you