Senior ETL Developer

Basic Information






IND Pune - Business Bay

Date published:


Job ID:


Description and Requirements

Job title:  Sr Applications Developer – India

BMC Software – The Multi Cloud Management Company

Any modern business must do two things really well: serve its customers the best way possible, and introduce market-changing innovation. At BMC we help you run your business as you reinvent it, with open, scalable, modular multi-cloud management solutions that bridge the divide between legacy and new IT. 

92 of the Forbes Global 100 rely on BMC to accelerate their digital initiatives. With more than 35+ years of leadership in IT management solutions and over 10,000+ customers worldwide, BMC provides IT solutions that deliver speed, agility, and efficiency from mainframe to mobile to cloud and beyond.

BU Description:
A high-tech company like BMC demands a modern analytics ecosystem that is secure, reliable, and easy to use. As part of the Information Services & Technology (IS&T) organization, the Enterprise Business Intelligence team enables an information-rich culture for all 6,000+ BMC employees, from executive dashboard users to content owners to departmental data scientists. 

We do this with a modern business intelligence ecosystem that combines the best of a centralized enterprise data warehouse and technologies with departmental data and self-service development. We are aided by industry-leading technologies, including MicroStrategy, Informatica, Netezza, Alteryx, and Data Robot. 

The BI team is comprised of 20+ experts (and growing) in BI application engineering, data engineering, enablement, data science, and data testing. We do the hard work of data integration, schema development, and application architecture, so that business users can spend more time deriving insights from their data. 

Primary Roles and Responsibilities:

1. The developer needs to be familiar with agile development practice and needs to work with BSA, TSS,QA analyst and/or scrum master/Project Managers to define development goals on every 3 week basis.

2. The developer need to update his/her development status to the team and in Rally on daily basis and discuss issues/risks/blocks with the team and proactively seek help to resolve those and commit to the development goals.

3. The developer need to be expert in SQL and Informatica ETL mapping design and development, follows  best practices for coding and performance tuning and test driven iterative development approach.

4. The developer needs to be able to understand the logical mapping and data models provided and design and develop ETL mappings as per available patterns. 

5. The developer needs to develop subject matter expertise through the development exposure and be able to provide level 3 support /enhancement to the existing jobs.

6. The developer need to be willing to learn new trends and technologies in the market like snap logic data extraction tool for the cloud sources or python scripting for data extraction.

7. The developer also needs to understand DevOps framework and use it to deploy code to production faster in an automated & repeatable way.
8. The developer needs to create a personal training plan to continuously sharpen skills, both technical and functional, taking at least 80 hours of training annually. 

The perfect candidate must also demonstrate the following qualities: 
Entrepreneur: self-manages time and tasks with minimal supervision, and proactively seeks help or guidance without hesitation
Problem-solver: spots issues that others miss, methodically breaks down complex problems to identify root causes, and creatively implements solutions
Change agent: is passionately interested in where the industry is heading, and innately driven to innovate and embrace change 
Possibility thinker and go getter -  understands and follows priorities, works with end result in mind and works proactively to remove blocks or starts on alternate options.

Experience/ Qualifications:

8 to 11 years of Informatica Powercenter  ETL  Mapping Design and Development experience.
Should demonstrate excellent SQL skills and needs to have aptitude for performance tuning.
Should have worked on at least 2 Data Warehouse projects in the past.
Exposure to Netezza DW appliance/and or Python scripting and/or MicroStrategy reports is a plus.
Bachelor of Engineering (Computer Science or Electronics and telecommunications)
It is the policy of BMC Software to afford equal opportunity for employment to all individuals regardless of race, color, age, national origin, physical or mental disability, history of disability, ancestry, citizenship status, political affiliation, religion, gender, transgender, gender identity, gender expression, marital status, status as a parent, sexual orientation, veteran status, genetic information or other factors prohibited by law, and to prohibit harassment or retaliation based on any of these factors.