Data Warehouse Architect | FactSet Systems India Private Limited

Company Profile
FactSet Systems India Private Limited
FactSet combines hundreds of databases into a single, powerful information system. It is a one-stop source for financial information and analytics for business analysts, portfolio managers, investment bankers/management firms and other financial professionals to analyze companies, portfolios, markets & economies.

9 - 14 Years

Hyderabad

Job Description
JOB RESPONSIBILITIES
Work with business analysts, to understand business requirements
Design and implement dimensional modelling using Ralph Kimball Methodologies
Write efficient code in Microsoft T-SQL and MDX languages
Design and develop high-quality ETL solution using SSIS
Develop SSAS cubes to provide enhanced analytics and reporting solutions
Understand and adapt to new technologies, tools, methods and processes from industry
Influence the team for right design and technology implementation and provide future architectural direction
Follow modern engineering development practices and workflows such as Agile, Lean etc.
Perform design and code reviews to provide constructive feedback for improving overall quality
Provide production support with occasional after-hours availability
Create, maintain and support scheduled jobs.
Participate in Database and Server migration projects.

REQUIRED SKILLS
Bachelor's degree, preferably in Computer Science or equivalent professional experience
10+ years of experience in enterprise data warehouse design and development
8+ years of experience in Advanced SQL programming working with large data sets
Strong data modelling skills with solid knowledge of industry standards such as dimensional modelling, star schemas etc.
Proficient in designing and operating OLAP databases (Multi dimension/Tabular)
Hands-on development experience in building ETLs
Experience in creating and maintaining Clustered Columnstore tables in SQL Server 2016

PREFERRED SKILLS
Good to have experience in MPP architecture (Azure SQL DW, Redshift, SQL Server PDW, Greenplum, Netezza, Teradata)
Good to have experience in NoSQL or non-relational, distributed column-store database technologies (Apache Cassandra, Hadoop, Spark, HBase, Hive, Kafka, Amazon DynamoDB)
Good to have experience as a DBA or Server Administrator
Good to have experience with cloud technologies like AWS and Azure.
Certifications in domain-specific technologies

Recruiter Name: Sravani Attada

Contact Company:FactSet Systems India Private Limited

Email:sravani.attada@factset.com

Walk in for Walk-In Interview for Data Quality Analyst | Navigant BPM (India) Private Limited

Walk in for Walk-In Interview for Data Quality Analyst

Posted on:
08/07/2019

Walk in Starting on:
11/07/2019

Closing on:
11/07/2019

Time:
10:00 AM To 04:00 PM

Contact email:
bindu.thulasidharan@navigantbpm.com

Brief description :
Essential Job Functions:
Strong analytical, technical and problem-solving skills
Work with limited guidance to analyze mapping issues from the ETL process and source data integrity
Working knowledge of data mapping, SQL coding, ETL, metadata and electronic report development
Work collaboratively with cross-functional areas

Responsibilities:
Identify and correct exceptions, inconsistencies, tolerance levels, business rules, and valid output
Continuously enhance data quality monitoring based on requirements gathered from business units
Present findings of complex data queries necessary to fully understand data quality issue/opportunities
Collaborates with business stakeholders to develop and track metrics necessary to monitor data quality
Log data quality issues on the data quality log and tracking the issue to resolution.
Generate summarized data quality and data warehouse dashboards using Business Intelligence reporting
Validate the data from the host source to the target locations to ensure the ETL specs have been implemented as documented.
Validate post-production changes and ensure tested changes are moved properly to production
Develop and maintain a working relationship with various information support teams to leverage data access and analysis
Work with several cross-functional areas, IT, DBAs, ETL, Data Modeling, BI Administration, Reporting, and data users to research and resolve issues
Complies with all security policies and procedures, to ensure that the highest level of system and data confidentiality, integrity and availability is maintained
Qualifications:
Bachelor's degree in Information Systems, MIS, Statistics, related field or equivalent work experience required
2+ years working with Data Quality processes and teams
2+ years’ experience with querying and analyzing data
2+ years SQL experience required
Intermediate SQL writing skills required
Intermediate knowledge of ETL tools
Aptitude for research and high standards for ensuring quality data for the organization
Strong analytical and database reporting skills required
Strong communication skills ensuring that users are kept updated on the status of their issues
Strong team-oriented interpersonal and communication skills required

Walk in venue
3rd Floor
Bhavani Building
Technopark, Trivandrum

Contact Person: Bindu/Anoop

We are hiring for Hadoop developer with ETL experience

Experience: 5-10 years
Location: Gurgaon

Key Skills:

1. Experience in HADOOP
2. ETL experience with data warehousing, data modeling(Informatica,       IBM Data Stage, Oracle Data Integrator, etc.).
3. Experience with data visualization
4. Experience with Agile methodologies
5. Experience using SQL in a DB2, Oracle or SQL Server

Interested Candidates Can Share Updated CV to sravanthi@squadm.com

Hiring Informatica Developers & ETL Test Engineer Openings in Bangalore

1) Hiring Informatica Developers
Exp: 3 - 9 Years, Location: Bangalore
Post your resume here: https://goo.gl/tyBG3s 

2) Hiring ETL Test Engineers
Exp: 3 - 9 Years, Location: Bangalore
Post your resume here: https://goo.gl/gNsq73

Job | US - Onsite opportunity for IT professionals with Valid H1B Visa/B1 Visa/F1/OPT/CPT to USA

We are hiring Software Professionals for Onsite - US opportunities (Candidates/Consultants with valid H1B visa /Valid B1 Visa with SSN Number/F1/OPT/CPT Etc., to USA, only should apply) 

Promatrix Corp is one among the fastest growing IT companies around the globe, delivering solutions in the field of Information Technology. We deliver unmatched Consulting and Outsourcing solutions for various domains in Information Technology to our clients, located in different geographic regions. We are capable of defining, designing, and presenting technology related business solutions that support global companies.

Job type: Full-time

Please note that these jobs are not based in India but in the USA.

* Big Data (Hadoop).,

* SAP HANA/BO/BODS/BW/PI/BASIS/Solution Manager

* ABAP Developers

* .Net (.Asp Net, C#, Share Point)

* Java/ J2EE Developers/ Architects

* Mobile (Android, IOS) Developers and Testers

* Front-End (PHP, Perl, Javascript, and MySQL)

* Drupal/ Joomla developers

* Data Architects

* ETL Technologies: Abinitio & Informatica

* Modeling

* Data Architects

* Developers with Perl, shell scripting and some networking backgrounD

* Peoplesoft Technical / Functional Consultants

* Salesforce Developers

* Oracle Developers

* Database Administrators (SQL/Oracle/Green Plum)

* Guidewire Developers

We understand the importance of employee satisfaction. We are keen on building long term career partnerships. All our employees can expect to get the following benefits depending on the length of employment:

* Extremely competitive salaries

* Up to 2 weeks paid vacation every year

* Paid overtime

* Health Insurance

* Up to 10 paid holidays

* Performance bonus

* H-1B/ OPT/ CPT visa sponsorship and green card processing

* Travel expenses where applicable

Please fill in the below details and send across ASAP to purohit@promatrixcorp.com along with your updated CV to take your candidature further.

Full Name: 

Email ID:

Phone Numbers:

IT Technologies well versed with:

Availability to travel to the USA:

Hold B1 Visa:(need start date & expiry date)

Hold H1 Visa:(need start date& expiry date)

Travelled to us before:(need dates of travel as well on which visa you had traveled)

Have SSN Number: YES or NO

Lanco Hills Technology Park Pvt. Ltd.

3rd Floor, office 2, LH 99, S.E.Z.,

Manikonda, Hyderabad 89

Cell Num:+91 8309719561

US Num: 732 964 1144 Ext 127

Email: purohit@promatrixcorp.com

Web: www.promatrixcorp.com

 US Office:

825 Georges Road, Suite 4,

North Brunswick, NJ 08902.