Job | ETL Manager

The sender of this email is registered with Naukri.com as Career Transition Consulting company. To respond back directly to the Employer, please click on Reply button, or send an email to nisha@careertransition.in

Experience required for the Job: 7 - 12 years Annual Salary of the Job: 10.00 - 18.00 Lacs Apply Now    Reply Dear Job Seeker, This opening is for a MNC Company(2000+ employees) in Trivandrum,Kerala  Position Overview  The ETL Manager is responsible for innovative design, development, and implementation of Business Intelligence dashboards and reports using the MS BI stack/Tableau that meets documented business requirements. The TL will be responsible for supporting schema, reports, templates and dashboards implemented in the Navigant environment. Performs at the highest technical level of all phases of ETL development activities. Directs a team of ETL engineers to ensure that assignments align with business priorities. As part of the role they will be responsible for implementing data dashboards to all levels of the organization.  Duties and Responsibilities  • Design and deploy data table structures, forms, reports, and queries  • Query, analyze, and profile data from source to target to assess data integrity gaps are identified in order to meet the business requirements of the reports  • Designs, develops, tests, and implements software programs, interfaces, reports and controls in accordance with best practices.  • Modify and enhance existing reports and dashboards to meet ongoing operational needs.  • Interpret data, analyze results using statistical techniques and provide ongoing reports  • Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality  • Identify, analyze, and interpret trends or patterns in complex data sets  • Manage the data model, data architecture, design & development for availability, upgrades, maintenance, performance and security of the Database infrastructure  • Work collaboratively with business unit partners to assess reporting needs and solutions, and implement a strategy for continuous improvement of the historical reporting, analytics and dashboards  • Analyze large customer data sets using a variety of database query and visualization tools.  • Deploy analytic models within the various self-service reporting systems and environments  • Develop, enhance and maintain large data sets processed through the MS BI stack.  • Design and develop complex ETL packages utilizing MS SSIS.  • Design and develop complex MS SSRS reports/Tableau  • Architect new and enhance existing data models to meet business and technical requirements.  • Create and maintain stored procedures.  • Design and develop MS SSAS cubes.  • Assist with performance tuning especially related to SSIS and SSRS run times.  • Identify inefficiencies in current databases and investigate solutions.  • Functions as technical architect and Subject Matter Expert (SME) on enterprise related Database systems  • Development and maintenance of the database stored procedures, views and functions for applications.  • Creation and maintenance of technical documentation.  • Development and maintenance of Data Warehouse.  • Designs or modifies procedures to solve complex problems considering Database availability, capacity, operating schedules, and business results.  • Developing architectural and logical design documentation and periodically reviewing completeness or response to audit or business requirement changes.  • Build and integrate reporting system (Tableau) for ad-hoc queries and business dashboards  • SSIS Data Flow Error Handling  Troubleshooting  • Stays current with the Database ETL and BI technology advances to enable production support and incident resolution that meets service level agreements.  • Interfaces with IT disciplines, vendors and professional services providers to ensure service level achievement.  Additional Responsibilities  • Provide technical mentorship and coaching for junior members of the ETL team, modeling and instituting ETL development best practices including, but not limited to, source control, test automation, coding standards, documentation standards, etc.  • Create high-quality Business Intelligence dashboards and reports by conducting peer design/code reviews and developing automated test cases.  • Responsible for achieving project budget, schedule and functional objectives.  • Produces work plans in support of project deliverables.  • Responsible for achieving project budget, schedule and functional objectives.  Requirements  • Engineering/Science graduate with 8 to 10 years’ experience as Database Developer  • Expert knowledge of: MSSQL, NoSQL Server.  • Experience extracting and manipulating data from relational databases with advanced SQL stored procedures.  • Experience working in any of the enterprise class BI, ETL and Reporting tools like SQL Server Reporting Services (SSRS)/Tableau/Power BI/SAS BI/ SQL Server Integration Services (SSIS)/ Informatica /Pentaho, etc.  • Experience extracting and manipulating data from relational databases with advanced SQL, stored procedures.  • Experience in coding advanced SQL queries, ETL automation, and stored procedures to support business inquiries  • Good Experience in Tableau Projects. Requirement gathering, data modeling scripting, developing and testing dashboards using Tableau  • Experience with system development lifecycle methodologies, deliverables and controls  • Excellent verbal and written communication skills  • Must have experience working in an MNC with diverse and geographically dispersed team.  • Experience and knowledge of service oriented architecture preferred.  • Microsoft Database certifications  Other Skills/Abilities  • Strong analytical, trouble shooting/problem solving, and time management skills  • Ability to self-direct, prioritize, and manage multiple tasks and demands.  • A solid team communicator with high energy and a strong work ethic  • Dedication, leadership, teamwork, and commitment to quality are essential.  • A strong customer-oriented focus and desire to achieve results  • Ensure continuous learning and development of the team.  • Ability to take ownership of issues and manage through to resolution.  • Strong consulting skills and ability to communicate with individuals at all levels of the organization  The opening is for a US MNC with 2000+ employees in India.  Job Location: Trivandrum  Please share your updated profile with  Current CTC:  Expected CTC:  Notice Period:  Current Location:  Willingness to relocate to trivandrum:  You are receiving this e-mail because your profile contained one or more of the following words that the recruiter searched on: " spotfire ", " tibco ", " ETL " Is this job relevant to you? Yes No Your feedback would help us in sending you the most relevant job opportunities Disclaimer: The sender of this email is registered with naukri.com as Career Transition Consulting (nisha@careertransition.in, B6, 902 ELITA PROMENADE, 101, BEERESHWARA NAGAR, MAIN ROAD NEAR RBI LAYOUT, JP NAGAR 7TH PHASE,, BANGALORE SOUTH 560078, Karnataka - 560031) using Naukri.com services. The responsibility of checking the authenticity of offers/correspondence lies with you. If you consider the content of this email inappropriate or spam, you may: Forward this email to: compliance@naukri.com or you can Block this Company from searching your resume in the database. Please Note: This mail is a private message from the recruiter. We have enabled auto login for your convenience, you are strongly advised not to forward this email to protect your account from unauthorized access. Advisory: Please do not pay any money to anyone who promises to find you a job. This could be in the form of a registration fee or document processing fee or visa charges or any other pretext. The money could be asked for upfront or it could be asked after trust has been built after some correspondence has been exchanged. Also please note that in case you get a job offer or a letter of intent without having been through an interview process it is probably a scam and you should contact compliance@naukri.com for advise. Update Your Resume Now to be on the top of Employer's Resume Search Create your own job alert to receive similar jobs directly in your inbox. Your Resume has only 30 seconds to impress a Recruiter. Get your resume written by Experts. Call 1800-3010-5557 now! (Toll-Free)