| Role Profile |
| Part I – Role Details |
| Job Designation |
MSBI Developer |
| Part II – Role Responsibilities |
| Role Objective |
This role is primarily responsible to ____ |
| Principal Accountabilities |
- Develop stable, secure, scalable, and highly performing Code /Components which are easy to inspect, test, service, and support.
- Delivery within time commitments adhering to approved designs, Deployment standards and meeting set quality goals confirming to coding standards & best practice with minimal defects.
- Drive customer communication for the project. Participate in regular client meetings that led to useful feedback and create project plans that deliver solutions to client problems.
- Learn to Influence team and stakeholders to proactively resolve issues
- Perform unit/module testing of software to find errors and confirm programs meet specifications.
- Write dev plan covering all scenarios based on information provided by customers and functional specs.
- Provide accurate time and resource estimates result in on-schedule delivery
- Mentor juniors in the team and take accountability for their delivery like reviewing deliverables, providing solutions and providing technical support and training.
- Contribute to solutioning and ensuring solutions adhere to established technological standards
- identify the scenarios/functionality that are missing or do not meet the customer needs or usability and take proper action
- Independently handle component level design
- Analyze and permit impact of change
- Independently handle component level design
- Recognize broader relationships between the solution and customer needs, iron out dependencies and deliver code that produces value
- Designs and implement proof of concept as needed for solutions as an individual contributor
- Expand software engineering knowledge beyond what is needed to complete the work. Learn new technologies/platforms during the spare time and present the learnings to others in the company
- Expertise and execute in Agile & other Delivery methodologies followed in the organization
|
| Part III – Role Requirements |
| Education |
B.E/ B. Tech, MS, M. Tech, MCA |
| Experience |
2-4 Years |
| Primary Skills
|
- Expertise in writing complex SQL queries
- Hands on experience on writing complex SQL queries using joins, aggregate/analytical functions, CTE etc.,
- Hands on experience in fine tuning the long running SQL Queries
- Expertise in developing Database components including creating views, stored procedures, triggers etc.
- Experience on RDBMS systems and concepts
- Extensive Experience in Data validation and Data Profiling
- Decent knowledge of transaction management mechanisms, ACID properties, Exception Handling
- Decent knowledge on data cardinality, Constraints, data quality rules, system level checks like, integrity check, isolation levels, compatibility levels in the system.
- Knowledge and hands-on experience with ETL development
- Hands on experience on implementing different loading strategies like SCD1 and SCD2, Table/ partition refresh, insert update, Swap Patriation etc.
- Experience in Consuming and writing data from and to Flat files, RDMBS systems, MPPS, Jason and XML.
- Ability to automate and build reusable executables for better delivery efficiency
- Ability to provide feasible and scalable Design/architecture for business requirements.
- Hands on experience on implementing efficient SSIS packages
- Experience in handling Operating system, ETL and Job scheduling and orchestration using SSIS
- Create test cases and perform unit testing of ETL Jobs
- Analytical mind with a problem-solving and debugging skills.
- Excellent Communication Skills
- Awareness of Replication, Synchronization and Disaster Management techniques
- Awareness of Data Quality Management
- Hands on experience on creating table partitions, indexes, views, materialized views etc.,
- Hands on experience in implementing data driven ETL designs
- Hands on experience in implementing reusable ETL components as per well-defined standards
- Efficient use of parameter and configuration files in ETL job implementation
- Hands on experience in applying performance tuning techniques on long running ETL Jobs
- Having good knowledge with Jira process.
|
| Secondary Skills
|
- Good to be aware of reporting models, developing dashboards, reports using PowerBI.
- Good to be aware of SSAS modeling and implementation concepts.
- Good to have knowledge of Agile Methodology.
|
| Certification
|
· |
| Knowledge and Competence
|
· . |
