!! Immediate Requirement: MSBI Developer at Itasca, IL !!

[Sourav Kumar Mandal]

*Hello Associates,*
*Please go through the below job description and let me know your interest
ASAP*

*Position: MSBI Developer*
*Location: Itasca , IL*
*Duration: 6+ Months*

*Requisition Detail:-*

   - Ability to work closely with Business Analysts and SMEs to understand
   business requirements
   - Define new interface layouts using XML \ APIs for external data
   transfer\export and integrating into the Data warehouse
   - Perform Data profiling and analysis of structured and unstructured data
   - Create Process Flows using Visio
   - Create Dimensional models using Power Designer or other data modeling
   tools
   - Create/maintain design related artifacts i.e. data models , Mapping
   documents, architecture diagrams, data flow diagrams
   - Create source to target mappings and ETL design for integration of
   new/modified data streams into the data warehouse/operational data
   store/data marts
   - Validate the ETL design, solutions, and transformation logic and
   ensure that technical specifications are complete, consistent, concise, and
   achievable.
   - Performance tuning of SSIS ETL processes, SQL Queries on MPP
   architecture
   - Proficient in leading and managing the development resources
   - Well versed with Automation tools like Active Batch or other similar
   products
   - Ability to work in a  matrixed  team environment with distributed
   responsibility across different teams
   - Ability to work  and deliver in a very high paced environment with
   limited information at times to support business needs
   - Experienced in delegating and coordinating development and testing in
   an onsite-offshore delivery model
   - Experienced in  working with sensitive/de-identified data environments
   - Experience in working with  encrypted and secure data transfers
   - Proactive and diligent in identifying and communicating scope, design,
   development issues and recommending potential solutions.
   - Participate in ETL architecture design reviews.
   - Conduct ETL unit testing and code reviews.
   - Participate in system and integration test; identifies and remedies
   solution defects.
   - Create other technical artifacts needed for project implementation
   - Knowledge of end to end  SDLC   from project inception to deployment
   - Experience in different project management methodologies i.e. Agile
   and Waterfall


*Skills:-*

   - Mastery of Microsoft SSIS development, XML
   - 2012 SQL Server Database development
   - Stored procedures, views, triggers, and functions.
   - Exposure to SSAS 2012, SharePoint, and other BI tools, a plus.
   - Knowledge of Data Warehouse Design Principles.
   - Excellent verbal and written communication skills.
   - Create, manage and optimize database in SQL Server 2012.
   - Microsoft BI Certification.



*Thanks & Regards...*...*?*
*Sourav Kumar Mandal*
*ll IT-SCIENT ll *
*ll Phone:* *510-516-7839** lI Fax: 877.701.4872 <877.701.4872> ll*
*ll Gmail: **kumarsourav.itsci...@gmail.com
* * II Web: www.itscient.com
 ll*



 Sent with Mailtrack


-- 
You received this message because you are subscribed to the Google Groups 
"REQSRESUMES" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reqsresumes+unsubscr...@googlegroups.com.
To post to this group, send email to reqsresumes@googlegroups.com.
Visit this group at https://groups.google.com/group/reqsresumes.
For more options, visit https://groups.google.com/d/optout.

!! Immediate Requirement: MSBI Developer at Itasca , IL !!

[Parabjot Kaur]

Hello ALL,
Please go through the below job description,and let me know your interest.
*Reply me at parabjo...@itscient.com
 // parabjot.itsci...@gmail.com
*

*TITLE: MSBI Developer*
*LOCATION: Itasca , IL*
*DURATION: 6+ Months*

*Requisition Details:*

Responsibilities include:

• Ability to work closely with Business Analysts and SMEs to understand
business requirements
• Define new interface layouts using XML \ APIs for external data
transfer\export and integrating into the Data warehouse
• Perform Data profiling and analysis of structured and unstructured data
• Create Process Flows using Visio
• Create Dimensional models using Power Designer or other data modeling
tools
• Create/maintain design related artifacts i.e. data models , Mapping
documents, architecture diagrams, data flow diagrams
• Create source to target mappings and ETL design for integration of
new/modified data streams into the data warehouse/operational data
store/data marts
• Validate the ETL design, solutions, and transformation logic and ensure
that technical specifications are complete, consistent, concise, and
achievable.
• Performance tuning of SSIS ETL processes, SQL Queries on MPP architecture
• Proficient in leading and managing the development resources
• Well versed with Automation tools like Active Batch or other similar
products
• Ability to work in a  matrixed  team environment with distributed
responsibility across different teams
• Ability to work  and deliver in a very high paced environment with
limited information at times to support business needs
• Experienced in delegating and coordinating development and testing in an
onsite-offshore delivery model
• Experienced in  working with sensitive/de-identified data environments
• Experience in working with  encrypted and secure data transfers
• Proactive and diligent in identifying and communicating scope, design,
development issues and recommending potential solutions.
• Participate in ETL architecture design reviews.
• Conduct ETL unit testing and code reviews.
• Participate in system and integration test; identifies and remedies
solution defects.
• Create other technical artifacts needed for project implementation
• Knowledge of end to end  SDLC   from project inception to deployment
• Experience in different project management methodologies i.e. Agile and
Waterfall

*Daily Tasks Performed:*


• Write efficient T-SQL.
• ETL using Bulk Insert, SSIS.
• Performance Tuning and Optimization using native monitoring and
troubleshooting tools.
• Perform other duties as assigned.

*REQUIRED SKILLS/EXPERIENCE: (Resume must reflect this experience)*


• Mastery of Microsoft SSIS development. (7+ years), XML
• 2012 SQL Server Database development
• Stored procedures, views, triggers, and functions.
• Exposure to SSAS 2012, SharePoint, and other BI tools, a plus.
• Knowledge of Data Warehouse Design Principles.
• Excellent verbal and written communication skills.
• Create, manage and optimize database in SQL Server 2012.
• Microsoft BI Certification.

*Preferred/Desired Skills: (Not required)*


• Experience with Microsoft Analytics Platform System (Parallel Data
Warehouse)
• SSRS
• Principles of Data Mining.
• Experience in Insurance Finance industry.
• Experience with Attunity



*​*
*​*


*Thanks & Regards..*


*Parabjot Kaurll IT-SCIENT ll Phone USA: ​510-516-7887 II
Email: parabjo...@itscient.com  ll
Web: www.itscient.com  ll*

-- 
You received this message because you are subscribed to the Google Groups 
"REQSRESUMES" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reqsresumes+unsubscr...@googlegroups.com.
To post to this group, send email to reqsresumes@googlegroups.com.
Visit this group at https://groups.google.com/group/reqsresumes.
For more options, visit https://groups.google.com/d/optout.