Informatica Senior Applications Developer

Basic Information







Date Published


Job ID


Travel Amount


Description and Requirements

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, Snowflake Cloud Data Warehouse, 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:

o As a Data Engineering developer, you need to be familiar with agile development practice and need to work with BSA, TSS,QA analyst and/or scrum master/Project Managers to define development goals on every 3 week basis.

o You’ll need to update the development status to the team and in Jira on daily basis and discuss issues/risks/blocks with the team and proactively seek help to resolve those and commit to the development goals.

o Need to be expert in SQL and Informatica PowerCenter /IICS ETL mapping design and development, follows best practices for coding and performance tuning and test-driven iterative development approach.

o Able to understand the logical mapping and data models provided and design and develop ETL mappings as per available patterns. 

o Need to develop subject matter expertise through the development exposure and be able to provide level 3 support /enhancement to the existing jobs.

o 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.

o Understand DevOps framework and use it to deploy code to production faster in an automated & repeatable way.

o Create a personal training plan to continuously sharpen skills, both technical and functional, taking at least 80 hours of training annually. 

Required qualifications:

o 6-10  years of Informatica PowerCenter /IICS   ETL  Mapping Design and Development experience in Data Engineering.
o Should demonstrate excellent SQL skills and needs to have aptitude for performance tuning.
o Should have worked at least 2   Data Warehouse projects in the past.
o Exposure to Snowflake and or Python scripting and/or MicroStrategy reports is a plus.
o Working knowledge of new Data integration tools like Talend is must for Data Fabric project.
o Bachelor of Engineering (Computer Science or Electronics and telecommunications)  

Desired (nice-to-have) skills:
o Entrepreneur: self-manages time and tasks with minimal supervision, and proactively seeks help or guidance without hesitation
o Problem-solver: spots issues that others miss, methodically breaks down complex problems to identify root causes, and creatively implements solutions
o Change agent: is passionately interested in where the industry is heading, and innately driven to innovate and embrace change 
o 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.
From core to cloud to edge, BMC delivers the software and services that enable over 10,000 global customers, including 84% of the Forbes Global 100, to thrive in their ongoing evolution to an Autonomous Digital Enterprise.
It is the policy of BMC Software to afford equal opportunity for employment to all individuals regardless of race, color, creed, sex, age, sexual orientation, national origin, disability, ancestry, citizenship status, political affiliation, religion, gender, transgender, gender identity, gender expression, marital status, status as a parent, disabled veteran or status as a protected veteran, genetic information or other factors prohibited by law, and to prohibit harassment or retaliation based on any of these factors.

If you need a reasonable accommodation for any part of the application and hiring process, visit the accommodation request page.