• Save Job
  • 6 - 9 Years
  • Posted : above 1 month

Job Description:

5 - 10 Ahmedabad

Looking for an experienced ETL, SQL Server Integrated Services (SSIS) Developer who will work with business users and members of the technical team on the architecture, design, and development of highly scalable ETL processes and Data Warehouse (EDW) utilizing tools such as Microsoft SQL Server, Oracle and MicroStrategy for a diverse set of clients The Senior Developer must have 5 years experience with the Data Warehouse architecture, design, development and deployment of business intelligence systems

Additional responsibilities of this role will include the following

Deliver projects/work on-time, on-budget, and in a way that accomplishes client goals
Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL-related activities Develop and ensure adherence to locally defined standards for all developed components
Understand and experience maintaining a multi-terabyte enterprise data warehouse with an accompanying nightly update cycle within a team of like-minded and skilled professionals
ETL Repository Management, maintain appropriate backups and Multi-project/Multi-concurrent release ETL environment
Maintain common code libraries, so objects can be shared and folders for all Environments (Dev, System Test and Production), Code Check-In/Check-Out procedures and assists in managing all environments and what releases of code are in each
Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests
Able to read Data Models to translate them into ETL or ELT loads into Data Warehouses and Data Marts
Participate in requirements, design, and development reviews Conduct or participate in meetings with owners of key system components to fully understand current data and systems environments Resolve source data issues and refine transformation rules
Analyze source system data to assess data quality Work with technical and business representatives to determine strategies for handling data anomalies that are identified Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes Design, develop, and implement enterprise-class data warehousing solutions
Use the SSIS platform to extract, transform, and load data Develop, Test, Integrate, and Deploy ETL routines using ETL tools and external programming/scripting languages as necessary Write and maintain unit test cases
Provide data analysis and technical documentation for both source and target mappings
Help administer and maintain the ETL environment in a support role with Systems Administrators, including performing configuration management activities related to the ETL environment
Identify problems, develop ideas and propose solutions within differing situations requiring analytical, evaluative or constructive thinking in daily work
Prepare and present ideas and recommendations to colleagues and management
Apply creative thinking to identify possible bottlenecks and reporting solution alternatives
Other duties assigned as needed

Requirements 5 years of business/technology work experience
6 years of hands-on experience with ETL Processes
Possess understanding of modern data warehouse architectures and data warehouse modernization techniques
Good knowledge of BI architecture, data warehousing concepts
Must be able to travel to client locations based on project needs
Data Integration Tools MS SQL Server SSIS
High level of SQL language proficiency with common database platforms such as SQL Server, Oracle, MySQL, and/or DB2 database management systems; Teradata experience is a plus
Knowledge and experience with Informatica products a plus
Knowledge and experience with data modeling is a plus
Bachelors degree in Business, Computer Science, Management Information Systems, Engineering or a related field

Skills

Motivated, demonstrates initiative and leadership
Able to critically think and be solution-oriented
Strong interpersonal skills and able to work easily with client personnel
Works well independently and within a team
Great organizational, time management and problem solving skills
Able to work in fast-paced environment

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Software Services, Internet/Dot com/ISP
Functional Area : IT Software : Software Products & Services
Role : Data Warehousing
Salary : As per Industry Standards
Deadline : 03rd Jun 2020

Key Skills:

Would you like to try out these free online tutorials?

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status